Database not connecting

[Former Member]

Hi gurus,

I have a server on which oracle 10g & 9i installed. ECC6.0 installed on 10g & trying to install SAP4.7 on 9i but giving error.

Checked to r3trans command.

giving error as :

C:\Documents and Settings\devadm>r3trans -d

This is r3trans version 6.09 (release 620 - 13.08.03 - 15:59:00).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_

ra_tnsname = 'DEV'"

r3trans finished (0012).

Help me to solve this.

Regards,

Darshan...

[former_member227600]

Hi,

4 ETW000 http://dboci.c ,00000 *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12500

4 ETW000 15563 0.080898

4 ETW000 http://dboci.c ,00000 *** ERROR => CONNECT failed with sql error '12500'

4 ETW000 29 0.080927

For error ora 12500 please refer to note:-403004

[https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=403004]

And please also check oracle services & listner service in servives file

Karan

Edited by: karan Singh on Aug 14, 2008 7:37 AM

[Former Member]

Hi Darshan,

Please paste trans.log and only then we can figure out what is the issue

Regards,

Ershad Ahmed

[Former Member]

Hi gurus,

Pls Check the trans.log

4 ETW000 r3trans version 6.09 (release 620 - 13.08.03 - 15:59:00).

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

4 ETW000

4 ETW000 date&time : 13.08.2008 - 17:32:01

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] Wed Aug 13 17:32:04 2008 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

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

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 10925 0.010925

4 ETW000 [dev trc ,00000] using "D:\usr\sap\DEV\SYS\exe\run\dboraslib.dll"

4 ETW000 34 0.010959

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 16 0.010975

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 26 0.011001

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "620.02", patchlevel (0.876)

4 ETW000 118 0.011119

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 24 0.011143

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 41 0.011184

4 ETW000 [dev trc ,00000] New connection 0 created 30 0.011214

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

4 ETW000 27 0.011241

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

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

4 ETW000 21 0.011279

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 24 0.011303

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=F:\oracle932\DEV\902 from environment

4 ETW000 235 0.011538

4 ETW000 [dev trc ,00000] -->oci_initialize 19 0.011557

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 32757 0.044314

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDEV's password 86 0.044400

4 ETW000 [dev trc ,00000] Connecting as /@DEV on connection 0 ... 18 0.044418

4 ETW000 [dev trc ,00000] Allocating service context handle 23 0.044441

4 ETW000 [dev trc ,00000] Allocating server context handle 23 0.044464

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=0035E96C,svrhp=03D4496C)

4 ETW000 51 0.044515

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

4 ETW000 20609 0.065124

4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '12500'

4 ETW000 33 0.065157

4 ETW000 [dev trc ,00000] Try to connect with default password 22 0.065179

4 ETW000 [dev trc ,00000] Connecting as SAPDEV/<pwd>@DEV on connection 0 ...

4 ETW000 101 0.065280

4 ETW000 [dev trc ,00000] Allocating server context handle 17 0.065297

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=0035E96C,svrhp=03D48A28)

4 ETW000 38 0.065335

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

4 ETW000 15563 0.080898

4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '12500'

4 ETW000 29 0.080927

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12500 performing CON [dblink#1 @ 419]

4 ETW000 59 0.080986

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12500: TNS:listener failed to start a dedicated server process [dblink#1 @ 419]

4 ETW000 26 0.081012

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

Regards,

Darshan..

[Former Member]

Hi Darshan,

This is due to multiple oracle listener.

Below note will help you.

sap note - 153835

Regards

Ashok

[Former Member]

This Due to Multipe Oracle home of different version on One system.

check listner status cmd - lsnrctl status

change the path of environment verialble as required to connect the respective data base.

[Former Member]

Recommend:

make a different partition at OS level l for oracle 9i & SAP 4.7 and try.

Regards

nilanchal

[markus_doehr2]

> Checked to r3trans command.

>

> giving error as :

>

> C:\Documents and Settings\devadm>r3trans -d

> This is r3trans version 6.09 (release 620 - 13.08.03 - 15:59:00).

> 2EETW169 no connect possible: "DBMS = ORACLE --- dbs_

> ra_tnsname = 'DEV'"

> r3trans finished (0012).

What's the output of the resulting "trans.log"?

Markus