Solved: Oracle Client Upgrade From 9.2.0.6 to 9.2.0.8

Hi All,

I was upgradin the oracle client From 9.2.0.6 to 9.2.0.8 as this is a prerequiste for upgrading to ECC 6.0.

I have upgraded by going through SAP Note 964783.

But when i am checking that it still showing the same client verison.

And also i am not able to start the SAP . it states that Oracle is down. But oracle is running and also Oracle listner..

Please Guide me ..

Thanks,

Mahesh

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Check ORACLE_HOME

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Scott,

Sorry to ask you,

What to check in ORACLE_HOME..

Thanks,

Mahesh

you have to check the value for the environment variable ORACLE_HOME...what does it say?

how did you check for oracle client version?

plz try

> r3trans -d (as user <sid>adm)

and review file trans.log (which is written in the same directory the command was issued)

GreetZ, AH

Can you say your OS for example. That you see after execute "startsap" or in SAPMMC in windows. ? Execute "R3trans -d" under "sid"adm user, and check trans.log

Regards.

HI,

OS is Sunsolaris . Pls find the Trans.log

For this error i have checked one of the SAP Note 393620, 566051, 180430, 539922.

4 ETW000 R3trans version 6.13 (release 640 - 28.11.06 - 18:05:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 21.07.2008 - 18:57:09

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Jul 21 18:57:09 2008 346 0.000346

4 ETW000 [dev trc ,00000] db_con_init called 45 0.000391

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 150 0.000541

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/ES1/SYS/exe/run/dboraslib.so' ...

4 ETW000 117 0.000658

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/ES1/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 56265 0.056923

4 ETW000 [dev trc ,00000] Library '/usr/sap/ES1/SYS/exe/run/dboraslib.so' loaded

4 ETW000 98 0.057021

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/ES1/SYS/exe/run/dboraslib.so

4 ETW000 63 0.057084

4 ETW000 [dev trc ,00000] Version of '/usr/sap/ES1/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.32)

4 ETW000 296 0.057380

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/ES1/SYS/exe/run/dboraslib.so

4 ETW000 56 0.057436

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/ES1/SYS/exe/run/dboraslib.so

4 ETW000 109 0.057545

4 ETW000 [dev trc ,00000] New connection 0 created 98 0.057643

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 68 0.057711

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 82 0.057793

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 51 0.057844

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 53 0.057897

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/ES1/920_64 from environment

4 ETW000 1115 0.059012

4 ETW000 [dev trc ,00000] -->oci_initialize 54 0.059066

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIInitialize' failed: rc = -1

4 ETW000 4995 0.064061

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIErrorGet' failed: rc = -2

4 ETW000 73 0.064134

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error -1 performing CON [dblink#3 @ 428]

4 ETW000 247 0.064381

4 ETW000 [dblink ,00428] ***LOG BY0=>Cannot get Oracle error text. [dblink#3 @ 428]

4 ETW000 48 0.064429

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'ES1'"

Please check the log file and guide me how i can proceed.

Thanks

Mahesh

HI,

ORACLE_HOME=/oracle/ES1/920_64,

I have checked by running SQLPLUS there we can get the information of the SQL* version and Client ..

Is that right? Please correct me if i am wrong.

and for the trans.log..

i have attached the log file. please check this and guide me.

Thanks,

Mahesh

Hi,

Please find the env variables for user SIDadm

SAPSYSTEMNAME=ES1

DIR_LIBRARY=/usr/sap/ES1/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/ES1/SYS/exe/run:/usr/sap/ES1/SYS/exe/runU

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=ES1

dbs_ora_schema=SAPES1

ORACLE_PSRV=ES1

ORACLE_SID=ES1

DB_SID=ES1

ORACLE_HOME=/oracle/ES1/920_64

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/ES1

for ORAsid

DIR_LIBRARY=/usr/sap/ES1/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/ES1/SYS/exe/run:/usr/sap/ES1/SYS/exe/runU

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=ES1

dbs_ora_schema=SAPES1

ORACLE_PSRV=ES1

ORACLE_SID=ES1

DB_SID=ES1

ORACLE_HOME=/oracle/ES1/920_64

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/ES1/920_64/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/ES1

Please let me know the prob is with these env variables.

Thanks,

Mahesh

Answers (2)

This has been solved...

Thanks to all..

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Mahesh,

Before doing client upgrade you should stopsap and listner.

R u using another instance in same mechine??

please go through the Note 1017418 .also pls send me the <.dbenv_Hostname>.csh file.

Rgards

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

HI,

Sorry i am upgrading client from 9.2.0.6 to 9.2.0.7, yes there are multiple SAP instances are there.

OS Sun Solaris 5.9

Please find the .dbenv_<hostname>.csh

Oracle RDBMS Environment

setenv THREAD NOPS

if ( $THREAD == NOPS ) then

set DBSID = ES1

else

if ( $THREAD != "001" ) then

set DBSID = ES1_$

else

set DBSID = ES1

endif

setenv dbms_type ORA

setenv dbs_ora_tnsname $DBSID

setenv dbs_ora_schema SAPES1

setenv ORACLE_PSRV ES1

setenv ORACLE_SID $DBSID

setenv DB_SID ES1

setenv ORACLE_HOME /oracle/ES1/920_64

setenv ORACLE_BASE /oracle

setenv ORA_NLS33 /oracle/client/92x_64/ocommon/nls/admin/data

setenv NLS_LANG AMERICAN_AMERICA.UTF8

setenv SAPDATA_HOME /oracle/ES1

setenv DIR_LIBRARY /usr/sap/ES1/SYS/exe/run

foreach d ( $ORACLE_HOME/bin )

set i=0

foreach p ( $path )

if ( "$p" == "$d" ) then

set i=1

break

endif

end

if ( $i == 0 ) then

set path = ( $d $path )

endif

end

switch (`uname`)

case AIX*:

if ( ! $?LIBPATH ) then

setenv LIBPATH /usr/lib:/lib:/usr/sap/ES1/SYS/exe/run

else

foreach d ( /usr/sap/ES1/SYS/exe/run )

set i=0

foreach p ( `echo $LIBPATH | sed 's/:/ /g'` )

if ( "$p" == "$d" ) then

set i=1

break

endif

end

if ( $i == 0 ) then

setenv LIBPATH $:$d

endif

end

endif

breaksw

case HP*:

if ( ! $?SHLIB_PATH ) then

setenv SHLIB_PATH /usr/sap/ES1/SYS/exe/run

else

foreach d ( /usr/sap/ES1/SYS/exe/run )

set i=0

foreach p ( `echo $SHLIB_PATH | sed 's/:/ /g'` )

if ( "$p" == "$d" ) then

set i=1

break

endif

end

if ( $i == 0 ) then

setenv SHLIB_PATH $:$d

endif

end

endif

breaksw

case SIN*:

case Reliant*:

case Linux*:

if ( ! $?LD_LIBRARY_PATH ) then

setenv LD_LIBRARY_PATH /usr/sap/ES1/SYS/exe/run:$ORACLE_HOME/lib

else

foreach d ( /usr/sap/ES1/SYS/exe/run $ORACLE_HOME/lib )

set i=0

foreach p ( `echo $LD_LIBRARY_PATH | sed 's/:/ /g'` )

if ( "$p" == "$d" ) then

set i=1

break

endif

end

if ( $i == 0 ) then

setenv LD_LIBRARY_PATH $:$d endif end endif breaksw case OSF*: if ( ! $?LD_LIBRARY_PATH ) then setenv LD_LIBRARY_PATH /usr/sap/ES1/SYS/exe/run:/oracle/client/92x_64/lib:$ORACLE_HOME/lib else foreach d ( /usr/sap/ES1/SYS/exe/run /oracle/client/92x_64/lib $ORACLE_HOME/lib ) set i=0 foreach p ( `echo $LD_LIBRARY_PATH | sed 's/:/ /g'` ) if ( "$p" == "$d" ) then set i=1 break endif end if ( $i == 0 ) then setenv LD_LIBRARY_PATH $:$d

endif

end

endif

breaksw

default:

if ( ! $?LD_LIBRARY_PATH ) then

setenv LD_LIBRARY_PATH /usr/sap/ES1/SYS/exe/run

else

foreach d ( /usr/sap/ES1/SYS/exe/run )

set i=0

foreach p ( `echo $LD_LIBRARY_PATH | sed 's/:/ /g'` )

if ( "$p" == "$d" ) then

set i=1

break

endif

end

if ( $i == 0 ) then

setenv LD_LIBRARY_PATH $:$d

endif

end

endif

breaksw

endsw

end Oracle RDBMS Environment

And also when i am executing R3trans -d its showing that ORA-12541: TNS:no listener

When iam checking the services i can c that listner is running.Please guide me .

Thanks,

Mahesh

Ask a Question

Top Q&A Solution Author

User

Count

Oracle Client Upgrade From 9.2.0.6 to 9.2.0.8

Accepted Solutions (1)

Accepted Solutions (1)

Answers (2)

Answers (2)

Re: How to get SOA Manager Logical Port configurat...

Issue of new PB

Re: Trigger Basic Idoc from scratch

How to get Binary Value from Partner Directory via...

Re: ABAP2XLSX in an old Abap version