cancel
Showing results for 
Search instead for 
Did you mean: 

Database error 12500 at con

Former Member
0 Kudos

Hello All,

I am getting the following error message in the SM21 system logs. The users are getting disconnected whilst working on SAP.

Error message is:

14:24:28 BTC 19 BY2 Database error 12500 at CON

14:24:28 BTC 19 BY0 > ORA-12500: TNS:listener failed to start a dedicated server

14:24:28 BTC 19 BY0 > process

14:24:28 BTC 19 R19 Initialization DB-Connect Failed, Return Code 000256

I am using ECC 5.0 with Kernal 640 patch level 170, databse Oracle 9.2.0.8,

Please let me know, how to proceed to stop this message.

Thanks,

Kalyan.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

Is there any errors in the work process trace (dev_w19*), listener.log or Oracle alert log?

I would also recommend you to update to SAP kernel 6.40 patch level 196 and above to solve a bug as described in note 1076804.

Former Member
0 Kudos

Hi!

Here's the explanation taken from Oracle Online Help for 10.2:

ORA-12500: TNS:listener failed to start a dedicated server process

Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly.

Action: Turn on tracing at the ADMIN level and reexecute the operation. Verify that the ORACLE Server executable is present and has execute permissions enabled. Ensure that the ORACLE environment is specified correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being called may not be installed on the local hard drive. Please check that the correct Protocol Adapter are successfully linked. If error persists, contact Oracle Customer Support.

Hope this helps!

Regards,

Volker