URGENT: error while starting server "OCIserver attach failed"

[former_member1283182]

Hi every 1,

When ever i am trying to start the MMC, i am getting this log error. Please help me to resolve this issue.

==============================================================================

-

---

trc file: "dev_w10", trc level: 1, release: "620"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Mon Mar 03 09:04:31 2008

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\ERP\SYS\exe\run\dboraslib.dll' ...

B Library 'C:\usr\sap\ERP\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\ERP\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 1476

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc10 1476) [dpxxdisp.c 1016]

I MtxInit: -2 0 0

X

X Mon Mar 03 09:04:32 2008

X EmInit: MmSetImplementation( 2 ).

X <ES> client 10 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Mon Mar 03 09:04:34 2008

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora81 from environment

C

C Mon Mar 03 09:04:47 2008

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C

C Mon Mar 03 09:04:48 2008

C Logon as OPS$-user to get SAPERP's password

C Connecting as /@ERP on connection 0 ...

C Attaching to DB Server ERP (con_hdl=0,svchp=06B5C828,svrhp=06B5C634)

C

C Mon Mar 03 09:04:50 2008

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

[dboci.c 3566]

C *** ERROR => CONNECT failed with sql error '12541'

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPERP/<pwd>@ERP on connection 0 ...

C Attaching to DB Server ERP (con_hdl=0,svchp=06B5C828,svrhp=06B5C440)

C

C Mon Mar 03 09:04:51 2008

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

[dboci.c 3566]

C *** ERROR => CONNECT failed with sql error '12541'

[dboci.c 9536]

B

B Mon Mar 03 09:04:52 2008

B ***LOG BY2=> sql error 12541 performing CON [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY0=> ORA-12541: TNS:no listener [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY2=> sql error 12541 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-12541: TNS:no listener [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1098]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8277]

M

M Info for wp 10

M

M stat = 4

M reqtype = 4

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server ERP_ERP_00 on host ERP (wp 10)

M * ERROR tskh_init: db_connect

M *

M * TIME Mon Mar 03 09:04:52 2008

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8408

M * COUNTER 1

M *

M *****************************************************************************

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 235]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc10 1476) [dpnttool.c 345]

==============================================================================

regards,

satish.

Edited by: satish c on Apr 23, 2008 9:33 AM

[Former Member · Accepted solution]

Hi,

you are facing this because of SQL error as the SAP is not comminicating with your DB. try to stop all the services and start the services related to sap and DB. if it dosent work try to reeboot the server.

Kind Regarsd,

Vamsi.

[JPReyes · Accepted solution]

"ORA-12541: TNS:no listener"

Your listener is not started...

Check that your db is up and runnning and then start the listener using command lsnrctl -start at the command prompt, if you're usins unix, linux or AIX then start the listener with the same command but logon as ora<sid>.

Regards

Juan

[former_member1283182 · Accepted solution]

thanks juan, its working.

i have been facing the same problem frequently could you tell me why i am facing the same issue repeatedly?

regards,

satish.