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