Having bounced the Windows 2003 server (64 bit) the instance and listener started up automatically as set in the "services" but the Agent (which WAS running fine)would not start automatically so I tried to manuall start it in the services...a pop up message states it could not start service and to look in event log for details...
find this in event log:
The description for Event ID ( 4 ) in Source ( Oracleagent10gAgent ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 03/13/08 13:52:14 agent exited with retCode 55..
find this in the agent.trc:
2008-03-13 10:49:45 Thread-6956 ERROR vpxoci: Error on dequeue from SYS.ALERT_QUE: ORA-03135: connection lost contact
2008-03-13 10:49:46 Thread-6956 ERROR vpxoci: Error on dequeue from SYS.ALERT_QUE: ORA-03114: not connected to ORACLE
2008-03-13 10:49:46 Thread-6956 WARN vpxoci: OCI Error -- ErrorCode(12518): ORA-12518: TNS:listener could not hand off client connection
SQL = " OCIServerAttach"...
LOGIN = sys/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cic-svr-app1.Landacorp.local)(PORT=1521))(CONNECT_DATA=(SID=loadtest)))
2008-03-13 10:49:46 Thread-6956 ERROR vpxoci: ORA-12518: TNS:listener could not hand off client connection
2008-03-13 10:50:01 Thread-6956 WARN vpxoci: OCI Error -- ErrorCode(12518): ORA-12518: TNS:listener could not hand off client connection
SQL = " OCIServerAttach"...
LOGIN = sys/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cic-svr-app1.Landacorp.local)(PORT=1521))(CONNECT_DATA=(SID=loadtest)))
2008-03-13 10:50:01 Thread-6956 ERROR vpxoci: ORA-12518: TNS:listener could not hand off client connection
Any ideas? Is there something simple to do or should I try re-install the agent?