Oracle database is having of one or more logical storage units called tablespaces, which collectively store all of the database’s data. Every tablespace at Oracle database having one or more files called datafiles, which can be find at the operating system in which Oracle is running. This article will guide you for managing tablespaces with […]
Managing Tablespaces | Tablespace Administration Read More »
Tablespace management in an Oracle database is very much needed and something a DBA needs to do act on it very frequently. It’s DBA job to maintain enough space in the tablespaces in order to have smooth functioning of application and database. This tablespace query can be very helpful when you are trying to understand
Tablespace Utilization in Oracle | How to Check Oracle Database Tablespace Utilization Read More »
This article is about vi editor in Linux, it will cover below mentioned things : Describe vi Editor List different modes of vi Editor Manipulate (insert, delete and change) text within vi Navigate within the vi Editor Search text from the document Save files and quit from vi Summarize vi commands Print documents Overview of
This article is about users, groups and permissions in Linux. Post reading of this article, you will be able to: Manage users and groups Change permissions on files and folders for users, groups and others Managing Users and Groups First, you will learn about the process of logging in and logging out of the Linux system.
Post completing this article, you will be able to: Use redirection in the command line Use standard input Use standard output Use pipes At first glance, many people think the Unix Shell is a more cryptic version of the MS-Windows / DOS command prompt. However, the Unix shell can do much more than launch programs and
Standard Input / Output Redirection & Pipes in Linux Read More »
OPatch failed with following error. Prerequisite check “CheckSystemCommandAvailable” failed. The details are: Missing command :fuser UtilSession failed: Prerequisite check “CheckSystemCommandAvailable” failed. Error Description Oracle Interim Patch Installer version 12.2.0.1.27 Copyright (c) 2022, Oracle Corporation. All rights reserved. Oracle Home: /d01/oracle/product/19.13.0/dbhome_1 Central Inventory : /home/oracle/oraInventory from: /d01/oracle/product/19.13.0/dbhome_1/oraInst.loc OPatch version: 12.2.0.1.27 OUI version: 12.2.0.7.0 Log file
The DBMS_DST package was proposed to streamline the process of upgrading the database time zone file, along with the time zone data based on new time zone file. Problems Countries sometimes change their time zones, or alter the way they handle daylight saving time (DST). From Oracle 11gR2 onward, new time zone files are shipped
Upgrade the Database Time Zone File Using the DBMS_DST Package | ORA-56920 Read More »
Post completing this, you will be able to: • Describe the bash shell and its utilities • Use command line shortcuts and expansion • Describe history tricks • Describe and use gnome terminal bash Introduction What is a bash? Bash is the shell, or command language interpreter, for the GNU operating system. The name is an
This document will give you an overview of Red Hat Enterprise Linux. After completing this, you will be able to: List the features of Red Hat enterprise Linux Use some basic commands of Linux Describe the Linux file system hierarchy History Red Hat Linux is one of the most popular Linux distributions, assembled by Red
After going through this document you will have a basic overview of Linux and you will be able to – Describe the history of Unix List the principles of Unix on which the OS runs Define General Public License (GNU) Explain the reasons of preferring Linux over other operating systems UNIX History Linux is a freely
