OraFAQ Forum: Server Administration » ora-01034 Automatic starting multiple instance / db's

Home » RDBMS Server » Server Administration » ora-01034 Automatic starting multiple instance / db's

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-01034 Automatic starting multiple instance / db's [message #56697]

Thu, 17 April 2003 04:10

Leonard Wolters
Messages: 3
Registered: October 2002

Junior Member

Ok,

When I have only one db, this db perfectly starts after rebooting the windows nt server. However, installing / creating a second db on the same server results in both db's not being automatically started.

I read a lot of information about this ora-01034 error. Please notice that i:

- checked all registry settings.
For each DB the ORA_sid_AUTOSTART=TRUE and the locations to the pfile's are correct
- Am able to start a db manual by using svrgrml, connect internal/oracle, startup.

The only question i have is how to start multiple db's automatically on a winnt server. Anyone any suggestions / tips ?

T.i.a.

Leonard

Report message to a moderator

Re: ora-01034 Automatic starting multiple instance / db's [message #56698 is a reply to message #56697]

Thu, 17 April 2003 05:59

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

goto control panel / services and change the properties of the concerned instances and listeners to 
autostart.
if there is no such service,
create a new one using ORADIM

Report message to a moderator

Re: ora-01034 Automatic starting multiple instance / db's [message #56720 is a reply to message #56697]

Fri, 18 April 2003 15:08

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

yes,
Exactly!
in services u will find the service name of Both databases and u can set their Autostart property to true..

sai

Report message to a moderator

Previous Topic:	using IPC
Next Topic:	installation of oracle 8i and forms 6

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:47:59 CDT 2024