Dialog instance not starting...

[Former Member]

Hi,

One of our dialog instance is not starting. dev_w0 shows the below error:

C

C Sat Sep 5 00:04:12 2009

C Client NLS settings:

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

C Connecting as /@ERQ on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 105c3b360 105c42e00 105c467a8

C Detaching from DB Server (con_hdl=0,svchp=105c43ad8,srvhp=105c48a08)

C Attaching to DB Server ERQ (con_hdl=0,svchp=105c43ad8,srvhp=105c48a08)

C *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12514

[dboci.c 4313]

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

[dbsloci.c 11145]

C Try to connect with default password

C Connecting as SAPR3/<pwd>@ERQ on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 105c3b360 105c42e00 105c467a8

C Detaching from DB Server (con_hdl=0,svchp=105c43ad8,srvhp=105c48a08)

C Attaching to DB Server ERQ (con_hdl=0,svchp=105c43ad8,srvhp=105c48a08)

C *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12514

[dboci.c 4313]

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

[dbsloci.c 11145]

C

C Sat Sep 5 00:04:17 2009

C Client NLS settings:

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

C Connecting as /@ERQ on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 105c3b360 105c42e00 105c467a8

C Detaching from DB Server (con_hdl=0,svchp=105c43ad8,srvhp=105c48a08)

C Attaching to DB Server ERQ (con_hdl=0,svchp=105c43ad8,srvhp=105c48a08)

C Attaching to DB Server ERQ (con_hdl=0,svchp=105c43ad8,srvhp=105c48a08)

C *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12514

[dboci.c 4313]

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

[dbsloci.c 11145]

C Try to connect with default password

C Connecting as SAPR3/<pwd>@ERQ on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 105c3b360 105c42e00 105c467a8

C Detaching from DB Server (con_hdl=0,svchp=105c43ad8,srvhp=105c48a08)

C Attaching to DB Server ERQ (con_hdl=0,svchp=105c43ad8,srvhp=105c48a08)

C *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12514

[dboci.c 4313]

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

[dbsloci.c 11145]

B Reconnect failed for connection:

We checked the listner service at DB/central instance side and its running.

Please advise what might be the problem.

Thanks,

Rohan

[Former Member · Accepted solution]

Hi ,

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Check which services are currently known by the listener by executing: lsnrctl services <listener name>

Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.

If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.

Check for an event in the listener.log file.

Thanks..

Mohit

[Former Member · Accepted solution]

Thanks. But we solved it. In our case shared memory was not avaliable.

So we shutdown the instance, cleared shared memory and then started the instance.

Regards,

Rohan