| Author |
Starting database instance
|
Saket Barve
Ranch Hand
Joined: Dec 19, 2002
Posts: 224
|
|
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
Ranch Hand
Joined: Jan 30, 2006
Posts: 41
|
|
Look at the alter log, what does it say? [ January 31, 2006: Message edited by: alan wamser ]
|
 |
Saket Barve
Ranch Hand
Joined: Dec 19, 2002
Posts: 224
|
|
Here is what the event log has to say, Alan. The link there wasn't too helpful either.
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
Ranch Hand
Joined: Dec 19, 2002
Posts: 224
|
|
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 ]
|
 |
 |
|
|
subject: Starting database instance
|
|
|