Some quick notes on removing Oracle Nodeapps in a cluster. Take a note of current config of node using:  srvctl config nodeapps -n nodename -a To remove nodeapps:  srvctl remove nodeapps -n o2hp113 To re-create:  srvctl add nodeapps -n nodename -o $ORACLE_HOME -A xxx.xxx.xxx.xxx/255.255.255.0/laninterface .

Oracle OCR 101: ocrcheck – Status of Oracle Cluster Registry ocrdump –  The ocrdump command can be used to dump the OCR, by default it will output to a text file in the current directory. ocrconfig -showbackup – will show the current status of the automatic OCR backups and location. ocrconfig -restore FILENAME – will…

Oracle DBNEWID change DBID *  Backup the database. *  Mount the database after a clean shutdown: SHUTDOWN IMMEDIATE STARTUP MOUNT * Invoke the DBNEWID utility (nid) specifying the new DBNAME from the command line using a user with SYSDBA privilege: nid TARGET=sys/password@currentdatabase DBNAME=newdatabase Assuming the validation is successful the utility prompts for confirmation before performing…

Full list of Oracle parameters: col name format a35 col value format a35 SELECT name, value FROM v$parameter ORDER BY 1; List modified Oracle Parameters: col name format a35 col value format a35 SELECT name, value FROM v$parameter WHERE isdefault = ‘FALSE’ ORDER BY 1; List unsupported Oracle parameters: set pagesize 0 set linesize 100…

The flash recovery area location and size are specified by the initialization parameters DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE. To change the flash recovery area location and size: Using SQL Command Line, log in and connect to the database as SYSDBA. To change the size of the flash recovery area, enter the following command at the SQL Command…