• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

Starting database instance  RSS feed

 
Ranch Hand
Posts: 231
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Look at the alter log, what does it say?
[ January 31, 2006: Message edited by: alan wamser ]
 
Saket Barve
Ranch Hand
Posts: 231
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 231
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!