Start SAP and Oracle database error occured
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
SAP Solution Manager 4.0 SP 13
Windows 2003 Server EN
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
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.