The recovery catalog contains information about both RMAN backups and the target database. More specifically, the recovery catalog contains the following: You can create the recovery catalog in a target database that…
Finding Undocumented ( Hidden ) Parameter with their details
Finding Undocumented ( Hidden ) Parameter with their details : Below given script will provide you, the list of all the Undocumented ( Hidden ) initialization parameters present in your database along with…
Finding Undocumented ( Hidden ) Parameter
Finding Undocumented ( Hidden ) Parameter in your database: These parameters can be easily obtained by giving the following command on the sql prompt as shown below: [oracle@airydba ~]$ sqlplus / as…
Undocumented ( Hidden ) Parameters in Oracle 11g
Undocumented ( Hidden ) Parameters in Oracle 11g: Some times ago , one of my junior queried about hidden parameters in Oracle 11g to me and which is the cause because ,…
BIND_AWARE and NO_BIND_AWARE Hints
BIND_AWARE and NO_BIND_AWARE Hints: From 11.1.0.7 onward it is possible to skip the monitoring that is required to detect bind-sensitive queries by using the BIND_AWARE hint. In the following example, the presence of the…
Adaptive Cursor Sharing in Oracle Database 11g R1
Adaptive Cursor Sharing in Oracle Database 11g Release 1: Adaptive Cursor Sharing (ACS) has been introduced in Oracle 11g Release1 to address the potential threat of cursor sharing and bind variables: The…
Listener Password Deprecated in Oracle 11g Release 2
Listener Password Deprecated in Oracle 11g Release 2 : Remember setting the password for listener? Up to just prior to Oracle Database 10g, setting this password was a must for any security…
Automatic Secure Configuration in Oracle 11g
Automatic Secure Configuration: When you create a new database, you can use Database Configuration Assistant (DBCA) to automatically create a more secure configuration than in previous releases of Oracle Database. You can…
Secure Password Support in Oracle 11g
Secure Password Support in Oracle 11g : Oracle 11g secure passwords and implementing good password policies are by far the most important defense for protecting against password based security threats. Oracle recommends…
Shared Storage Creation for RAC
Shared Storage Creation for Oracle 11g R2-RAC Installation: Now Copy ClusterStorage Directory from Linux O/S CD on your storage Machine to the location /u01. [root@paw-racstorage-dns ~]# cd /u01/ClusterStorage/ [root@paw-racstorage-dns ClusterStorage]# pwd [root@paw-racstorage-dns…