DBA Maestro - Helpful DBA tips

Here are the majority of the steps for creating a clone 11gR2 database. 1.  Either configure your listener under the ORACLE_HOME for the standby (typically using NETCA) or if you are using 11gR2 RAC, you can use the Grid Infrastructure listener.ora to add your entries.  Configure listener.ora with your clone SID and reload listener. (example) SID_LIST_LISTENER =     (SID_DESC =       (GLOBAL_DBNAME = clone)       (SID_NAME = clone)       (ORACLE_HOME = <ORACLE_HOME>)     )   )     lsnrctl reload  LISTENER 3. Modify tnsnames.ora in $TNS_ADMIN on both primary and standby locations to include both your standby database TNS entry and the primary database TNS entry.   (example)     clone =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = <   standby _hostname>)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = clone)     )   ) trgtdb =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = <primary_hostna

It's a been a while since my last post.  As you may know, I normally blog about solutions that are hard to find that haven't already been blogged about.  Here's my latest encounter... I was receiving this error when trying to login via "sqlplus / as sysdba" after completing an Oracle 11gR2 binary install using the "database home clone" methodology.  I checked that the binary permissions were set correctly, which they were.  Then finally I stumbled across someone else that had had this problem where the $ORACLE_HOME/rdbms/lib/config.c file wasn't configured properly.  Copyright (c) 1982, 2011, Oracle.  All rights reserved. ERROR: ORA-01031: insufficient privileges So I did the following: cd <ORACLE_HOME>/rdbms/lib cp -p config.c config.c.bak vi config.c (with below changes) relink oracle config.c before changes: /*  SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access.  */ /*  Refer to the Inst