Skip to Content
avatar image
Former Member

Start SAP and Oracle database error occured

Dear Gurus,

Again,

My server error occured on SAP console like below after import support package add restart SAP.

Please advise me for solution.

-


SAP-Basis System: Initialization DB-Connect Failed, Return Code 000256

Database: Database error 12518 at CON

Database: > ORA-12518: TNS:listener could not hand off client connection

-


MY System:

SAP Solution Manager 4.0 SP 13

Oracle 10.0.2G

Windows 2003 Server EN

Thank.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 15, 2009 at 07:07 AM

    Hi Witoon,

    I've done some searching online:

    In reference to your platform, there are a few resolutions that may be available for ORA-12518:

    • Try looking in the EventLog to check out network connections and associated errors, as well as the alert log in the database. ORA-12518 can also be thrown along with a database crash.

    • Look in the windows service for your Oracle service status

    o start->run->services.msc

    • The server may be in need of a swap memory to disk as it runs out of memory space. Sometimes, Oracle processes can take up alot of memory. If you think this is causing ORA-12518 in your case, you can try this workaround:

    o set parameter to DIRECT_HANDOFF_TTC_LISTENER=OFF in listener.ora

    o restart listener

    • You may also want to consider making he large_pool_size larger.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 15, 2009 at 07:48 AM

    Hi, Kroone

    Thank for you answer again, Oracle service worst memery 1.3GB.

    I restart server, start sap everthing fine.

    Add comment
    10|10000 characters needed characters exceeded