Bob:
Let's try the simple solution first. How about using the Services utility
in Control Panel to check the service for startup ="AUTO". Then specify
the parameters that are
to be used for startup, like "pfile=xxxxxx". Specify the userid that is
supposed to start the database, preferably not the Administrator userid,
but Oracle or a derivative of it.
This method has been known to work.
RWB
"Bob Metelsky" <[EMAIL PROTECTED]>@fatcity.com on 11/13/2002 09:18:55 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
All
Ive finally returned to my desk from the server room/user
desktop trenches ;-)
with hopefully some time to pose this autostarting problem to the list.
I have about 12 oracle database(services) running on windows 2k server,
I believe by starting the service should start the instance and stopping
the service should shutdown the database.
This not happening on the server, so the databases are not starting up
automatically. I have to force start then using a batch file as such
svrmgrl.exe command='@C:\db_startup\initdb8i.sql'
C:\sleep 3
...
<initdb8i.sql>
connect internal/pw@db8i
startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora
exit
I have tried to delete the service via oradim and recreating but doing
that does not affect the auto starting problem. Here is an example of my
use of oradim
F:\ORA817\bin\ORADIM -delete -SID db8i
F:\ORA817\bin\ORADIM -NEW -SID db8i -INTPWD pw -STARTMODE auto -PFILE
R:\OR_8I\ADMIN\DB8I\pfile\init.ora -SHUTMODE i -SHUTTYPE srvc,inst
-TIMEOUT 60
One other issue is once I delete the service and create a new service,
then try to delete again. win2k informs me "the service is currently
marked for deletion" so you cant do anything else with the instance, a
reboot to clear the marked service is necessary.
I've checked the registry entries in the oracle home and it corresponds
exactly to what is specified in the oradim statement and the path to the
oracle.exe in the service is correct.
Overall history: this server was NT 40, now "upgraded" to win2k server
this server has oracle 7.3.4, 8.0.5, 8.1.6, 8.1.7.3
currently the default home is set to 8.1.7
The server is running aproc 12 8.1.6 instances and 10 8.1.7 databases
I have tried to
1. delete and recreate the sid using oradim
2. "migrating" an 8.1.6 to 8.1.7 using the migration wizard
3. Building a new database using 8.1.7
None of the databases will auto start!
I have win2k pro with 8.1.6 on my machine and stopping and starting the
service starts and stops the database....
Any suggestions for getting my db's to start upon boot up. I have
deleted the service with oradim then recreated, as above then rebooted
and the db does not start. This whole problem started whn the server was
"upgraded" to win2k server.
thanks
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
