on 07-15-2009 7:52 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Kroone
Thank for you answer again, Oracle service worst memery 1.3GB.
I restart server, start sap everthing fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.