Printable View
On Win2003, the Oracle services are not responding to startup/shutdown. I installed 9206 Enterprise edition. When I stop or start the oracle services the db doesnt respond. I am attaching a zipped bmp file for your viewing.
Thre is a SPFILE created as well as IFILE pointed from e:\oracle\ora92\DATABASE directory to pfile directory.
I tried Oradim to re-create the services but no luck.The only way I can start the db is via sqlplus. Oracle support is choppy. Any help is appreciated.
thanks
Post the error you get when you do startup/shutdown.
dbasan:
the only error messages i get in my alert.log is the instant recovery error message when i start the oracle database via sqlplus....
what happens you reboot your system?Quote:
Originally Posted by Oracle9iNewbie
I looked at the Oradim.log and i saw this error message...
ORA-12560: TNS:protocol adapter error
and in sqlnet.log
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracledocprd12)(ARGS='(DESCRIPTION=(LOCAL =YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=docprd12)(CID=(PROGRAM=E:\oracle\ora92\bin\oradi m.exe)(HOST=bart)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.6.0 - Production
Time: 07-FEB-2006 09:29:47
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0
When I reboot the server, the services are set to automatic but db doesnt come up. oracle.exe is present in the task manager.
Do the Windows services really start?
Do they respond to:
net start OracleOra92TNSListener
net start OracleServiceTEST
and
net stop OracleServiceTEST
net stop OracleOra92TNSListener
(At the command prompt. Change service names to match yours)?