cancel
Showing results for 
Search instead for 
Did you mean: 

Start SAP and Oracle database error occured

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi, Kroone

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

I restart server, start sap everthing fine.