windows Services not responding to startup/shutdown
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
Last edited by Oracle9iNewbie; 02-06-2006 at 01:35 PM.
I looked at the Oradim.log and i saw this error message...
ORA-12560: TNSrotocol 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: TNSrotocol 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 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)?
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman