| Oradim is not creating OracleStartSid services [message #121699] |
Tue, 31 May 2005 10:18  |
lupien1
Messages: 9
Registered: May 2005
|
Junior Member |
|
|
Hi,
Here is my configuration:
Oracle server 8.1.7 on Windows server 2000.
I would like my instance to start automatically when the server is booting.
I use oradim to delete the OracleserviceSID and i use oradim again to create the two services (oracleservicesid and oraclestartsid) but only oracleservicesid is create.
To start the database, i need to use svrmgrl or «oradim -startup ...». those command line work fine, but i would like to automatically start my database at boot-up.
Is there someone who can help me.
|
|
|
|
| Re: Oradim is not creating OracleStartSid services [message #121713 is a reply to message #121699] |
Tue, 31 May 2005 11:32  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Don't know about 8.1.7 on windows, but in 10g, look at the options to the oradim command. One of them is startmode. Set it to auto.
Something like: oradim -edit -sid <sidname> -startmode auto
You can also specify startmode when creating the service.
|
|
|
|
|
|
|
|
|
|
| Re: Oradim is not creating OracleStartSid services [message #121735 is a reply to message #121734] |
Tue, 31 May 2005 14:45 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Check in Services for win2k OS. There will be one Oracle service with name oracleservice<sid>. Make the startup mode "Automatic"
In Registry goto HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
In ORA_<SID>_AUTOSTART make the entry TRUE.
Now everytime OS boots the servie will start and database too will get started.
Also configure the listener to start automatically.
|
|
|
|
| Re: Oradim is not creating OracleStartSid services [message #121848 is a reply to message #121699] |
Wed, 01 June 2005 07:29 |
lupien1
Messages: 9
Registered: May 2005
|
Junior Member |
|
|
Hi Girish,
The OracleService<SID> is start automatically and work perfectly, the ORA_<SID>_AUTOSTART was already to TRUE. My problem is that the OracleStart<SID> is not create when oradim is use with the -new option.
Can someone take a look in the registry (HKEY_LOCAL_MACHINE\system\currentcontrolset\services\oraclestart<SID> and print the content on his reply. Maybe i can use the backdoor to create the service. Also information about oraclestart<SID> in other place in the registry will be appreciate.
thank you and please excuse my english!!!
|
|
|
|
|
|
|
|
|
|
| Re: Oradim is not creating OracleStartSid services [message #122059 is a reply to message #121699] |
Thu, 02 June 2005 10:46 |
lupien1
Messages: 9
Registered: May 2005
|
Junior Member |
|
|
Hi girish,
I found what was my problem. First OracleStartSid does not exist anymore (our previous oracle version was 7.3.4 on NT4). By modifying SQLNET.AUTHENTICATION_SERVICES=(NTS) to SQLNET.AUTHENTICATION_SERVICES=(NONE) in my sqlnet.ora everything is now OK. My database is now starting at boot-up.
I want to thank you for the time you took to help me.
Have a good day!
|
|
|
|
| Re: Oradim is not creating OracleStartSid services [message #125421 is a reply to message #122059] |
Fri, 24 June 2005 18:58 |
bodger
Messages: 3
Registered: June 2005
|
Junior Member |
|
|
Pleased to see you found a solution, but one reason the instance will not start when the OracleService<sid> starts is because the registry value ORA_<sid>_AUTOSTART is not set to TRUE. If it is not TRUE the OracleService will start but the database instance will not and will have to be started separately e.g. with oradim
I am running 8.1.7 on XP Pro with SQLNET.AUTHENTICATION_SERVICES=(NTS) and if ORA_<sid>_AUTOSTART = FALSE then the instance doesn't start when I manually start the service (from Control Panel->Administrative Tools->Services), but it does if ORA_<sid>_AUTOSTART = TRUE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
