Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
Former Member replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question