Sets the total number of characters that SQL*Plus displays on one line before beginning a new line. WINDOW adjusts the linesize and pagesize for the formatted output according to the width and height of the screen. If the output is longer than the screen width, then the output is wrapped accordingly Example To set the […]
All posts by Skant Gupta
Oracle Database 18c and it’s features
Finally, Oracle officially released Oracle Database 18c with Oracle Documentation available on Oracle Public Cloud(OPC). To get more detailed on Oracle 18c release read Oracle Support Document 2285040.1. List of some new features in Oracle 18c: Data Guard Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups Automatic Correction […]
Sosreport on Oracle Linux
The “sosreport” is a tool to collect troubleshooting data on an Oracle Linux system. It generates a compressed tarball of debugging information that gives an overview of the most important logs and configuration of a Linux system, to be sent to Oracle Support. Among other things, the sosreport includes information about the installed rpm versions, […]
TopicWise Interview Question on Oracle Database
Here is some Oracle Listeners Interview Question, hope it will help you. Listener Question: http://clouddba.co/generic-dba/ Here is some Oracle Tablespace Interview Question, hope it will help you. Tablespace Question: http://clouddba.co/generic-dba/ Here is some Oracle EXPDP IMPDP Datapump Interview Question, hope it will help you. EXPDP IMPDP Datapump Question: http://clouddba.co/expdp-impdp-datapump-interview-questions/ Here is some Oracle Database Architecture Interview Question, hope it will help you. Database Architecture Question: http://clouddba.co/database-architecture-interview-questions/ […]
Downgrading Grid Infrastructure from 12.1.0.2 to 11.2.0.4
In the last article, we performed downgrade of Oracle RAC Database from 12c to 11gR2. In this article, we are going to downgrade Oracle Grid Infrastructure from 12c (12.1.0.2) to 11gR2 (11.2.0.4) which contains two nodes ( node 1 & node 2). Before doing CRS downgrade we need to take backup of following files : Take tar […]
Downgrading a RAC database from 12.1.0.2 to 11.2.0.4
In the last article, we performed downgrade of Oracle Standalone Database from 12c to 11gR2. In this article, we can downgrade the 2 node RAC 12.1.0.2 database to 11.2.0.4, downgraded the database only and not the grid home. Assume all commands are being run on node 1, any commands that need to be run on node 2 […]
Downgrade Oracle Database from 12c to 11gR2
We have already upgraded Oracle Database11gR2 to 12c, the whole process is still relatively smooth, although some of the previous version of the upgrade is not the same, but the overall difficulty is not too large, because of too many different features, greatly extended the upgrade time. But for Oracle 12c back to the previous […]
Killable Processes in Oracle Database
A multiprocess Oracle database uses some additional processes called background processes. The background processes perform maintenance tasks required to operate the database and to maximize performance for multiple users. Mandatory Background Processes Optional Background Processes Slave Processes There are few processes which we can kill without terminating the instance. Killable: ARCn: Redo log archivers CJQn: Job […]
Standby with DBCA in Oracle Database 12cR2
In the new features of Oracle Database 12cR2 (12.2.0.1) DBCA can already be used to create dataguard on the standby side. Below is the environment detail: Type Hostname db_unique_name Primary host01 orclpri Standby host02 orclsby Enable force logging on primary. SQL> alter database force logging; Database altered. SQL> select name,force_logging from v$database; NAME FORCE_LOGGING ————————— […]
opatch version – Initial heap size set to a larger value than the maximum heap size
The below issue was faced by my fellow DBA while in checking OPatch version in Grid Home, Interestingly the same OPatch utility works fine in RDBMS Home Issue-OPatch version command failed with below error on GRID_HOME but it was working fine on DB home Error:- opatch version Error occurred during initialization of VM Initial heap […]