| unable to start oracle using w2k and 8i (OS Err 997) [message #128478] |
Mon, 18 July 2005 19:04  |
dtsmith500
Messages: 1
Registered: July 2005
|
Junior Member |
|
|
Oracle 8.1.6 databases fail to start stopping the
Oracle<SID> service and restarting.
The service hangs on startup, and oradim.log reports: ORA-01109: database not open ORA-01034: ORACLE not available DIM-00011: The service does not exists O/S-Error: (OS 997) Overlapped I/O operation is in progress. DIM-00011: The service does not exists O/S-Error: (OS 997) Overlapped I/O operation is in progress.
Any help is greatly appriciated.
|
|
|
|
|
|
| Re: unable to start oracle using w2k and 8i (OS Err 997) [message #129161 is a reply to message #128594] |
Fri, 22 July 2005 04:36  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
please see below how to create service and delete for oracle database.
There is a utility called ORADIM with the help of this we are going to create service.
· From command prompt type
· D:\> ORADIM
note:-(ORADIM is utility which create service and password file)
·--->How to delete service?
D:\> ORADIM –delete -sid sun
Then press F5
note :-(sun is service name)
.--->Creation of service
D:\> ORADIM –new -sid star intpwd star –maxuser 5 –pfile
d:\oracle\ora81\database\initstar.ora
Explanation of creation of service.
===================================
Intpwd à Internal password is star
In 9i password of sys.
Default location of init.ora
d:\oracle\ora81\database\initstar.ora
How many users can be added to password file? That can know from maxuser 5 which has privilege of DBA i.e. (Internal user in 8i and sys user in 9i).
This way service star is created with name oracleservicestar
--->On dos prompt
D :\> set oracle_sid = star
This should be same as it is in the service (i.e. star)
I hope this much is enough regarding service ..
From :- sunil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
