Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-12547 in sqlplus upgrading from 11.2.0.1. to 11.2.0.3

Hello,

I've struck an issue while trying to upgrade my SolMan Dev system from 11.2.0.1 to 11.2.0.3.

I'm using the Upgrade Guide dated 2011-12-20 version 3.00.

What I’ve done: installed the 11.2.0.3 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

SQL> @?/sapbundle/SAP_112031_201202/catsbp.sql

But when I attempt to login to sqlplus, I get:

sapsmd01:orasmd 162% sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 9 08:49:33 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:

ORA-12547: TNS:lost contact

The ORACLE_HOME is set to the 11203 version, so I was surprised to see SQLPLUS is still 11.2.0.1. 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?

Cheers...John

Former Member replied

Hello John,

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 11.2.0.1 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 11.2.0.1 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 11.2.0.3 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:

./sqlplus

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 11.2.0.1 sqlplus will be started.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question