Skip to Content
author's profile photo Former Member
Former Member

Database error 12500 at con

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2008 at 03:22 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 01:22 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.