Posted by
tyagi.ankur07 on
Aug 16, 2017; 10:09am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-12547-TNS-lost-contact-tp3202.html
I'm encountering below issue while upgrading my EBS database from 11.1.0.7 to 11.2.0.3 version.
-bash-4.2$ pwd
/u01/oracle/VIS/db/tech_st/11.2.0
-bash-4.2$ cat 11gR2.env
export ORACLE_BASE=/u01/oracle/VIS
export ORACLE_HOME=/u01/oracle/VIS/db/tech_st/11.2.0
export LD_LIBRARY_PATH=/u01/oracle/VIS/db/tech_st/11.2.0/lib
export ORA_NLS10=/u01/oracle/VIS/db/tech_st/11.2.0/nls/data/9idata
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH
export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/lib/site_perl/5.10.0
-bash-4.2$ . 11gR2.env
-bash-4.2$ export ORACLE_SID=VIS
-bash-4.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 16 00:51:47 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
-bash-4.2$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oravis oinstall 0 Oct 21 2011 /u01/oracle/VIS/db/tech_st/11.2.0/bin/oracle
Followed below steps but still getting the same error.
$ cd $ORACLE_HOME/bin
$ chmod 6751 oracle
$ cd $ORACLE_HOME/rdbms/lib
$ mv config.o config.o.bad
$ relink all
Below is the error message while trying to relink all 11203 oracle binaries:
SEVERE: oracle.sysman.oii.oiil.OiilActionException: Error in invoking target 'irman ioracle' of makefile '/u01/oracle/VIS/db/tech_st/11.2.0/rdbms/lib/ins_rdbms.mk'. See '/u01/oracle/VIS/db/tech_st/11.2.0/ins
tall/relinkActions2017-08-16_12-01-53-AM.log' for details.
at oracle.sysman.oii.oiis.OiisMakeDeps.invokeMakefile(OiisMakeDeps.java:544)
at oracle.sysman.oii.oiis.OiisMakeDeps.doRelink(OiisMakeDeps.java:621)
at oracle.sysman.oii.oiis.OiisMakeDeps.doOperation(OiisMakeDeps.java:802)
at oracle.sysman.oii.oiis.OiisMakeDeps.main(OiisMakeDeps.java:812)
Verified all interop. patches are in place.
Log files:
http://www.filedropper.com/opatchlinvhttp://www.filedropper.com/relinkhttp://www.filedropper.com/relinkactions2017-08-1511-57-41-pmEnvironment Details
------------------------
EBS 12.1.3
RDBMS - 11.0.1.7 -> Upgrade to 11.2.0.3
OS: AIX 7.1
Thanks,
Ankur