I am using Oracle 10g on Windows XP. The following eight services are listed in the Services: OracleSCService OracleDBConsole<SID> OracleJobScheduler<SID> OracleOraDb10g_home1iSQL*Plus OracleOraDb10g_home1SNMPPeerEncapsulator OracleOraDb10g_home1SNMPPeerMasterAgent OracleOraDb10g_home1TNSListener OracleService<SID>
Post installation, I'd set the start-up status to manual for all these services. Now I am not able to start-up the database instance at all. The following three, from the list of above, are required: OracleService<SID> OracleOraDb10g_home1TNSListener OracleDBConsole<SID>
Of which I am not able to get OracleDBConsole<SID> started, although the other two required ones are up and running. Any clues?
By the way the sqlnet.log displayed below seems to be giving a better direction, if at all. Does this make any sense at all?
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) (CONNECT_DATA=(SID=ABC)(CID=(PROGRAM=C:\oracle10g\bin\emagent.exe) (HOST=Windows NT PC)(USER=OraUser))))
VERSION INFORMATION: TNS for 32-bit Windows: Version 10.1.0.2.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.1.0.2.0 - Production Time: 25-JAN-2006 05:31:27 Tracing not turned on. Tns error struct: ns main err code: 12545 TNS-12545: Connect failed because target host or object does not exist ns secondary err code: 12560 nt main err code: 515 TNS-00515: Connect failed because target host or object does not exist nt secondary err code: 14 nt OS err code: 0
[ February 02, 2006: Message edited by: Saket Barve ]
Joined: Dec 19, 2002
This issue is solved though I am not sure I got it fully. Needed to modify:
SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES= (NONE)
in sqlnet.ora before restarting the server. [ February 12, 2006: Message edited by: Saket Barve ]