Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 11:48 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.