sap application not getting up after system copy

[Former Member]

Dear Experts,

We had perform system copy in our landscape but after system copy our Q system (dispatcher is not getting up) is not getting up while database ha open sucessfully.Pls guide us

Pls go through trans.log for detailed error :-

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 : 13.09.2010 - 06:54: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 Sep 13 06:54:09 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 4915 0.004915

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

4 ETW000 28 0.004943

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 13 0.004956

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

4 ETW000 20 0.004976

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

4 ETW000 72 0.005048

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

4 ETW000 19 0.005067

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

4 ETW000 27 0.005094

4 ETW000 [dev trc ,00000] New connection 0 created 19 0.005113

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 28 0.005141

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

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

4 ETW000 19 0.005176

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 25 0.005201

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=D:\oracle\ora92 from environment

4 ETW000 172 0.005373

4 ETW000 [dev trc ,00000] -->oci_initialize 13 0.005386

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 15501 0.020887

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPCAT's password 39 0.020926

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

4 ETW000 [dev trc ,00000] Allocating service context handle 21 0.020965

4 ETW000 [dev trc ,00000] Allocating server context handle 16 0.020981

4 ETW000 [dev trc ,00000] Attaching to DB Server CAT (con_hdl=0,svchp=01DD3A0C,svrhp=01DD459C)

4 ETW000 35 0.021016

4 ETW000 [dev trc ,00000] Mon Sep 13 06:54:10 2010 895546 0.916562

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

4 ETW000 29 0.916591

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

4 ETW000 72 0.916663

4 ETW000 [dev trc ,00000] Try to connect with default password 130 0.916793

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

4 ETW000 19 0.916812

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=01DD459C) 17 0.916829

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=01DD3A0C,srvhp=01DD459C)

4 ETW000 19 0.916848

4 ETW000 [dev trc ,00000] Deallocating server context handle 01DD459C 17 0.916865

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

4 ETW000 [dev trc ,00000] Attaching to DB Server CAT (con_hdl=0,svchp=01DD3A0C,svrhp=01DD459C)

4 ETW000 33 0.916915

4 ETW000 [dev trc ,00000] Mon Sep 13 06:54:11 2010 983938 1.900853

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

4 ETW000 30 1.900883

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

4 ETW000 21 1.900904

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

4 ETW000 165 1.901069

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#1 @ 419]

4 ETW000 19 1.901088

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

[markus_doehr2]

> We had perform system copy in our landscape

How did you do that system copy?

> 4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

I highly recommend updating your kernel - it's almost 5 years old...

Markus

[Former Member]

Hi,

Check the "tnsping SID" from command prompt. Also check the hostname and port numbers in listener and tnsnames files.

Regards,

Ranjith

[Former Member]

Check you listner as suggested above, but also try to connect to database manually via sqlplus.

[Former Member]

Hi,

ERROR => CONNECT failed with sql error '12541' 
ORA-12541: TNS:no listener

Please See the below note.

[Note 609332 - Composite note: ORA-12541/ORA-12224|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=609332]

Thanks,

Shambo

[anindya_bose]

Hi

Check two files in your system ..tnsnames.ora and listener.ora ..do they contain wrong entries? [entry of the system from which you have copied]

[Former Member]

Is the listener service running ??

Restart the listener service and double check

Pravin

[Former Member]

Hi,

LOG-->ORA-12541: TNS:no listener

Is the listener up? Can you check this.

Thanks,

Prasanna

Edited by: Prasanna K on Sep 15, 2009 11:48 AM