This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Starting database instance Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Products » Oracle/OAS
Reply Bookmark "Starting database instance " Watch "Starting database instance " New topic
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.


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
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 ]
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Starting database instance
 
Similar Threads
runtime expression ${mode} is not working
xsd for complex element structure
BAD_CERTIFICATE alert
getting error ORA-125 : TNS :no listener while try to login toad
Urgent !!! Entity bean JDBC connection Problem !!!