Starting database instance

[Saket Barve]

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?

Thanks,
Saket

[alan wamser]

Look at the alter log, what does it say?
[ January 31, 2006: Message edited by: alan wamser ]

[Saket Barve]

Here is what the event log has to say, Alan. The link there wasn't too helpful either.

The OracleDBConsoleexamples service terminated with service-specific error 2 (0x2).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

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 ]

[Saket Barve]

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 ]