ORA-12547 in sqlplus upgrading from 220.127.116.11. to 18.104.22.168
I've struck an issue while trying to upgrade my SolMan Dev system from 22.214.171.124 to 126.96.36.199.
I'm using the Upgrade Guide dated 2011-12-20 version 3.00.
What I’ve done: installed the 188.8.131.52 software in a new ORACLE_HOME, /oracle/<SID>/11203
Applied the SAP Bundle Patch (SBP) – basically a number of patches using MOPatch. The link at the end of this worked OK.
I haven't adjusted the listener or tnsnames yet as that comes later in the process.
As part of the SBP post-install, I need to run the following (the ORACLE_HOME of my user is set to the new ORACLE_HOME):
$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus / as sysdba
But when I attempt to login to sqlplus, I get:
sapsmd01:orasmd 162% sqlplus / as sysdba
SQL*Plus: Release 184.108.40.206.0 Production on Fri Mar 9 08:49:33 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ORA-12547: TNS:lost contact
The ORACLE_HOME is set to the 11203 version, so I was surprised to see SQLPLUS is still 220.127.116.11. This is also the case if I go into /oracle/SMD/11203/bin and run it from there.
I have found a couple of entries on forums which seem to indicate that this issue could be caused by the O/S being too low a level. We have upgraded the O/S over the weekend, but the error still remains.
Has anyone else encountered this or have any other suggestions as to what may be causing the problem?
you are beeing mistaken with running catsbp before database upgrade, you can not run this sql when DB is not yet running. Correct sequence is to 1) install 11203 software 2) install SBP with Mopatch 3) upgrade database 4) on 11203 run catsbp
As you have 18.104.22.168 db, ORACLE_HOME is set to /oracle/SID/112_64. When you install 11203 you set your ORACLE_HOME to /oracle/SID/11203, with the same ORACLE_HOME you run Mopatch, then with 22.214.171.124 ORACLE_HOME you'll run DB upgrade with SAP wrapper script (usually this script recognizes that you've applied SBP and runs catsbp as custom script with others like sapuprof.sql etc. during the upgrade). After this you have DB on version 126.96.36.199 and you should rename 112_64 to 11201 and create link 112_64 -> 11203
For the sqlplus, as you did not pasted full PATH variable. When you go to /oracle/SID/11203/bin, you start sqlplus like this:
as current directory . might not part of your PATH variable so if you start it just sqlplus, it will still run /oracle/SID/112_64/bin/sqlplus, also if . is part of your PATH variable but it's preceeded by /oracle/SID/112_64/bin, again 188.8.131.52 sqlplus will be started.