ISSUE:

Unable to connect sqlplus after cloning oracle_home

Solution:

OSDBA_GROUP should be mentioned while cloning ORACLE_HOME as mentioned below

$ORACLE_HOME/perl/bin/perl clone.pl ORACLE_BASE=”/scratch/aime/clone”
ORACLE_HOME=”/u01/app/oracle/dbhome” OSDBA_GROUP=dba
OSOPER_GROUP=oper -defaultHomeName

OR

Take Backup of $ORACLE_HOME/rdbms/lib/config.s file , Modify config.s file and Change occurrences of
.string “”
to
.string “dba”

Where “dba” is OSDBA_GROUP

To effect any changes to the groups and to be sure you are using the groups defined in this file relink the Oracle executable. Be sure to shutdown all databases before relinking:

cd $ORACLE_HOME/rdbms/lib
mv config.o config.o.orig
make -f ins_rdbms.mk ioracle

Recent Posts

Start typing and press Enter to search