[sap-basis] CONNECT failed with sql error '12541
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by devenderkumar (SAP Basis Administrator) on Feb 17 at 11:16 PM |
Hi experts, I am using ecc5 ,os is win 2003 server oracle is 9i
I am facing this error while running r3trans -d at command prompt.
CONNECT failed with sql error '12541
-----------------------------------------------
My trans .log
4 ETW000 r3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).
4 ETW000 unicode enabled version
4 ETW000 ==============================================4 ETW000
4 ETW000 date&time : 10.02.2010 - 19:21:21
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Wed Feb 10 19:21:23 2010 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 8432 0.008432
4 ETW000 [dev trc ,00000] using "C:\usr\sap\DEV\SYS\exe\run\dboraslib.dll"
4 ETW000 52 0.008484
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 23 0.008507
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 40 0.008547
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.39)
4 ETW000 105 0.008652
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 39 0.008691
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 48 0.008739
4 ETW000 [dev trc ,00000] New connection 0 created 32 0.008771
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 49 0.008820
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 31 0.008851
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 38 0.008889
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 46 0.008935
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=C:\oracle\ora92 from environment
4 ETW000 252 0.009187
4 ETW000 [dev trc ,00000] -->oci_initialize 25 0.009212
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 21314 0.030526
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDEV's password 62 0.030588
4 ETW000 [dev trc ,00000] Connecting as /@DEV on connection 0 ... 32 0.030620
4 ETW000 [dev trc ,00000] Allocating service context handle 34 0.030654
4 ETW000 [dev trc ,00000] Allocating server context handle 29 0.030683
4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=026D2A44,svrhp=026D35D4)
4 ETW000 63 0.030746
4 ETW000 [dev trc ,00000] Wed Feb 10 19:21:24 2010 981052 1.011798
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
4 ETW000 53 1.011851
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 193 1.012044
4 ETW000 [dev trc ,00000] Try to connect with default password 175 1.012219
4 ETW000 [dev trc ,00000] Connecting as SAPDEV/<pwd>@DEV on connection 0 ...
4 ETW000 37 1.012256
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=026D35D4) 31 1.012287
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=026D2A44,srvhp=026D35D4)
4 ETW000 39 1.012326
4 ETW000 [dev trc ,00000] Deallocating server context handle 026D35D4 30 1.012356
4 ETW000 [dev trc ,00000] Allocating server context handle 32 1.012388
4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=026D2A44,svrhp=026D35D4)
4 ETW000 65 1.012453
4 ETW000 [dev trc ,00000] Wed Feb 10 19:21:25 2010 1015080 2.027533
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
4 ETW000 52 2.027585
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 39 2.027624
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12541 performing CON [dblink#1 @ 419]
4 ETW000 228 2.027852
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#1 @ 419]
4 ETW000 38 2.027890
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"
__.____._ I am facing this error while running r3trans -d at command prompt.
CONNECT failed with sql error '12541
-----------------------------------------------
My trans .log
4 ETW000 r3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).
4 ETW000 unicode enabled version
4 ETW000 ==============================================4 ETW000
4 ETW000 date&time : 10.02.2010 - 19:21:21
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Wed Feb 10 19:21:23 2010 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 8432 0.008432
4 ETW000 [dev trc ,00000] using "C:\usr\sap\DEV\SYS\exe\run\dboraslib.dll"
4 ETW000 52 0.008484
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 23 0.008507
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 40 0.008547
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.39)
4 ETW000 105 0.008652
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 39 0.008691
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 48 0.008739
4 ETW000 [dev trc ,00000] New connection 0 created 32 0.008771
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 49 0.008820
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 31 0.008851
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 38 0.008889
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 46 0.008935
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=C:\oracle\ora92 from environment
4 ETW000 252 0.009187
4 ETW000 [dev trc ,00000] -->oci_initialize 25 0.009212
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 21314 0.030526
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDEV's password 62 0.030588
4 ETW000 [dev trc ,00000] Connecting as /@DEV on connection 0 ... 32 0.030620
4 ETW000 [dev trc ,00000] Allocating service context handle 34 0.030654
4 ETW000 [dev trc ,00000] Allocating server context handle 29 0.030683
4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=026D2A44,svrhp=026D35D4)
4 ETW000 63 0.030746
4 ETW000 [dev trc ,00000] Wed Feb 10 19:21:24 2010 981052 1.011798
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
4 ETW000 53 1.011851
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 193 1.012044
4 ETW000 [dev trc ,00000] Try to connect with default password 175 1.012219
4 ETW000 [dev trc ,00000] Connecting as SAPDEV/<pwd>@DEV on connection 0 ...
4 ETW000 37 1.012256
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=026D35D4) 31 1.012287
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=026D2A44,srvhp=026D35D4)
4 ETW000 39 1.012326
4 ETW000 [dev trc ,00000] Deallocating server context handle 026D35D4 30 1.012356
4 ETW000 [dev trc ,00000] Allocating server context handle 32 1.012388
4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=026D2A44,svrhp=026D35D4)
4 ETW000 65 1.012453
4 ETW000 [dev trc ,00000] Wed Feb 10 19:21:25 2010 1015080 2.027533
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
4 ETW000 52 2.027585
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 39 2.027624
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12541 performing CON [dblink#1 @ 419]
4 ETW000 228 2.027852
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#1 @ 419]
4 ETW000 38 2.027890
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
