sql error 12705 performing CON (Upgrade on Oracle10.2.0.2)

[Former Member]

Hello,

I'm following the Oracle Upgrade Guide_211 for Oracle upgrade to 10.2.0.2 of our test system. It's SAP R/3 4.6C with 4.6D_EXT supp. pack 2271, HP-UX 11.11 and Oracle 9.2.0.5

I'm almost done with the upgrade (just startup of SAP instance)

Now I tested R3trans -d and it failed

<b>This is R3trans version 6.05 (release 46D - 12.07.06 - 16:40:00).

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

R3trans finished (0012).</b>

In the trans.log:

cat trans.log

4 ETW000 R3trans version 6.05 (release 46D - 12.07.06 - 16:40:00).

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

4 ETW000

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 date&time : 26.04.2007 - 12:56:34

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

4 ETW000 [developertra,00000] Thu Apr 26 12:56:34 2007 778 0.000778

4 ETW000 [developertra,00000] db_con_init called 39 0.000817

4 ETW000 [developertra,00000] create_con (con_name=R/3) 39 0.000856

4 ETW000 [developertra,00000] Loading DB library '/usr/sap/TST/SYS/exe/run/dboraslib.sl' ...

4 ETW000 150 0.001006

4 ETW000 [developertra,00000] load shared library (/usr/sap/TST/SYS/exe/run/dboraslib.sl), hdl 0

4 ETW000 46480 0.047486

4 ETW000 [developertra,00000] Library '/usr/sap/TST/SYS/exe/run/dboraslib.sl' loaded

4 ETW000 51 0.047537

4 ETW000 [developertra,00000] function DbSlExpFuns loaded from library /usr/sap/TST/SYS/exe/run/dboraslib.sl

4 ETW000 79 0.047616

4 ETW000 [developertra,00000] Version of library '/usr/sap/TST/SYS/exe/run/dboraslib.sl' is "46D.00", patchlevel (0.2311)

4 ETW000 579 0.048195

4 ETW000 [developertra,00000] function dsql_db_init loaded from library /usr/sap/TST/SYS/exe/run/dboraslib.sl

4 ETW000 56 0.048251

4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from library /usr/sap/TST/SYS/exe/run/dboraslib.sl

4 ETW000 83 0.048334

4 ETW000 [developertra,00000] New connection 0 created 51 0.048385

4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 346 0.048731

4 ETW000 [developertra,00000] find_con found the following connection for reuse:

4 ETW000 48 0.048779

4 ETW000 [developertra,00000] Got ORACLE_HOME=/oracle/TST/102_64 from environment

4 ETW000 1255 0.050034

4 ETW000 [developertra,00000] -->oci_initialize 41 0.050075

4 ETW000 [developertra,00000] Got ORACLE_SID=TST from environment 103 0.050178

4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 79 0.050257

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 29 0.050286

4 ETW000 [developertra,00000] Connecting as /@TST on connection 0 ... 40 0.050326

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='TST') 64 0.050390

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1019 4272 0.054662

4 ETW000 [dbsloci. ,00000] *** ERROR => <b>CONNECT failed with sql error '1019'</b>4 ETW000 74 0.054736

4 ETW000 [developertra,00000] Try to connect with default password 31 0.054767

4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@TST on connection 0 ...

4 ETW000 45 0.054812

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='TST')

4 ETW000 42 0.054854

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12705 160083 0.214937

4 ETW000 [dbsloci. ,00000] *** ERROR => <b>CONNECT failed with sql error '12705'</b>4 ETW000 106 0.215043

4 ETW000 [developertra,00000] Got ORACLE_SID=TST from environment 208 0.215251

4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 48 0.215299

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 27 0.215326

4 ETW000 [developertra,00000] Connecting as /@TST on connection 0 ... 30 0.215356

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='TST') 30 0.215386

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12705 144873 0.360259

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 79 0.360338

4 ETW000 [developertra,00000] Try to connect with default password 32 0.360370

4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@TST on connection 0 ...

4 ETW000 43 0.360413

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='TST')

4 ETW000 42 0.360455

4 ETW000 [developertra,00000] Thu Apr 26 12:56:35 2007 147148 0.507603

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12705 93 0.507696

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 58 0.507754

4 ETW000 [dblink ,00627] ***LOG BY2=>sql error 12705 performing CON 439 0.508193

4 ETW000 [dblink ,00627] ***LOG BY0=> 38 0.508231

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

For the sidadm user I didnot set the NLS10 variable:

<i>Ensure that the environment variable ORA_NLS10 is NOT SET for the sidadm user. Setting ORA_NLS10 for the sidadm has resulted in strange system behaviour.!!!!!</i>

Do ypu have any idea what is the problem how I can start the SAP with my successfully upgraded DB from 9.2.0.5 into 10.2.0.2????

Many regards,

Ruzica

[Former Member]

Hi Ruzica.

Did you delete the ORA_NSL33 variable? It's still needed (but modifying 920_64 to 102_64 at the path) to connect to oracle client.

Best Regards,

JC Llanes.

[Former Member]

Hi Juan,

Yes I've commented the ORA_NSL33 variable because it uses the old ORACLE_HOME and the path:

setenv ORA_NLS33 /oracle/TST/920_64/ocommon/nls/admin/data

Should I change it to point to /oracle/TST/102_64/nls/data like:

setenv ORA_NLS33 /oracle/TST/102_64/nls/data

not ORANLS10

?

Best regards,

Ruzica

[Former Member]

Yes, you're right.

Don't use the ORA_NLS10 with sidadm, but you must still use the old ORA_NLS33. Change and uncomment it.

Best Regards,

JC Llanes.

[Former Member]

Hello Juan,

I uncomented and put

setenv ORA_NLS33 /oracle/TST/102_64/nls/data

for the user tstadm

and again

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

Regards,

Ruzica

[Former Member]

Hello,

Have you changed all the entries on sidadm profiles containing the old ORACLE_HOME with the new one? I mean, substitute every occurrence of 902_64 with 120_64 at every user sidadm profile.

Best Regards,

JC Llanes.

[Former Member]

Hello,

For the user tstadm:

1. env

HOME=/home/tstadm

PATH=/oracle/TST/102_64/bin:.:/home/tstadm:/usr/sap/TST/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/resmon/bin:/opt/netscape:/opt/scr/bin:/opt/mx/bin:/opt/gnome/bin:/opt/ignite/bin:/opt/graphics/common/bin:/usr/sbin/diag/contrib:/opt/sec_mgmt/spc/bin:/sbin/fs/vxfs3.5/bin

LOGNAME=tstadm

SHELL=/usr/bin/csh

TERM=xterm

COLUMNS=158

LINES=60

MANPATH=/usr/share/man/%L:/usr/share/man/fs/vxfs3.5:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/mx/share/man:/usr/dt/share/man:/opt/samba/man:/opt/resmon/share/man:/opt/scr/share/man:/opt/gnome/man:/opt/graphics/common/man:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/sec_mgmt/share/man/%L:/opt/sec_mgmt/share/man:/opt/ssh/share/man:/opt/EMCpower/share

TZ=MET-1METDST

SAPSYSTEMNAME=TST

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

SHLIB_PATH=/usr/sap/TST/SYS/exe/run:/oracle/client/10x_64/instantclient

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=TST

ORACLE_PSRV=TST

ORACLE_SID=TST

ORACLE_HOME=/oracle/TST/102_64

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/TST/102_64/nls/data

SAPDATA_HOME=/oracle/TST

LD_LIBRARY_PATH=/oracle/TST/102_64/lib:/usr/sap/TST/SYS/exe/run

and for the user oratst:

1. env

HOME=/oracle/TST

PATH=/oracle/TST/102_64/OPatch:/opt/java1.4/bin:/usr/sbin:/oracle/TST/102_64/bin:/oracle/TST/102_64/OPatch:/opt/java1.4/bin:/usr/sbin:.:/oracle/TST:/usr/sap/TST/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/resmon/bin:/opt/netscape:/opt/scr/bin:/opt/mx/bin:/opt/gnome/bin:/opt/ignite/bin:/opt/graphics/common/bin:/usr/sbin/diag/contrib:/opt/sec_mgmt/spc/bin:/sbin/fs/vxfs3.5/bin

LOGNAME=oratst

SHELL=/usr/bin/csh

TERM=xterm

COLUMNS=158

LINES=60

MANPATH=/usr/share/man/%L:/usr/share/man/fs/vxfs3.5:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/mx/share/man:/usr/dt/share/man:/opt/samba/man:/opt/resmon/share/man:/opt/scr/share/man:/opt/gnome/man:/opt/graphics/common/man:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/sec_mgmt/share/man/%L:/opt/sec_mgmt/share/man:/opt/ssh/share/man:/opt/EMCpower/share

TZ=MET-1METDST

SAPSYSTEMNAME=TST

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

ORACLE_HOME=/oracle/TST/102_64

SHLIB_PATH=/oracle/TST/102_64/lib:/usr/sap/TST/SYS/exe/run

THREAD=NOPS

ACTIVE_STATE_PERL=TRUE

dbms_type=ORA

dbs_ora_tnsname=TST

ORACLE_PSRV=TST

ORACLE_SID=TST

ORACLE_BASE=/oracle

NLS_LANG=AMERICAN_AMERICA.WE8DEC

ORA_NLS10=/oracle/TST/102_64/nls/data

SAPDATA_HOME=/oracle/TST

SAPARCH=/oracle/TST/sapbackup

LD_LIBRARY_PATH=/oracle/TST/102_64/lib64

Many regards,

Ruzica

[Former Member]

Hi Ruzica,

Everything seems ok with the users env's. Be sure to change the paths at the Instance profiles too (DEFAULT.PFL & SID_DVEBM..._hostname).

Can you run a R3trans -x and attach here the trans.log?

Regards,

JC Llanes.

[Former Member]

Hello,

The problem is solved.

I read again the notes especialy the Note 964783 - Updating Oracle client on host with multiple SAP systems, because I use on the same server one SAP instance with Oracle 9205 and the other is the one I just upgraded to 10.2.0.2.

Now I changed the setting for setenv ORA_NLS33 /oracle/client/9207/ocommon/nls/admin/data

and started SAP Ok.

Thanks Juan,

Many regards,

Ruzica

[Former Member]

You completed this for the <SID>adm user's profile? Or both <SID>adm as well as ora<SID>?