OraFAQ Forum: Server Administration » my database does not start automatically

Home » RDBMS Server » Server Administration » my database does not start automatically

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

my database does not start automatically [message #172377]

Tue, 16 May 2006 04:29

viplove
Messages: 9
Registered: May 2006

Junior Member

I am using windows 2000 server and oracle 9.0.1, my database does not start automatically when i am booting the system.

in regedit autostart is there, my service is getting started automatically and i used startmode auto in my oradim command but still i have to manually log in to start the database, PLS help!!!

another issue is that i want to startup/shutdown the database using other than sysdba, pls tell which permission shud i grant as dba, connect, resource permissions are not doing the required job

Report message to a moderator

Re: my database does not start automatically [message #172388 is a reply to message #172377]

Tue, 16 May 2006 05:07

harman_deep
Messages: 8
Registered: August 2005
Location: Amritsar

Junior Member

For 1st question I dont know

but for 2nd I know u need sydba/syoper privileges to start stop databases. DBA role is not for this purpose...

Grant this privilege to any other user and then he can do this database start/stop

Report message to a moderator

Re: my database does not start automatically [message #172392 is a reply to message #172377]

Tue, 16 May 2006 05:20

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You may want to delete your current Windows service and create a new one with ORADIM and then test the startup/shutdown abilities of the service. Also, check the event viewer and see if there are any messages as to why the service isn't starting the database.

Report message to a moderator

Re: my database does not start automatically [message #172404 is a reply to message #172377]

Tue, 16 May 2006 06:27

viplove
Messages: 9
Registered: May 2006

Junior Member

folks i got the solution of my own problem.

actually problem was with my spfile so i created spfile from my pfile and now database is automatically up

viplove

Report message to a moderator

Re: my database does not start automatically [message #172768 is a reply to message #172404]

Thu, 18 May 2006 00:04

viplove
Messages: 9
Registered: May 2006

Junior Member

sorry guys, my problem is still there. i am still not able to open my database automatically.

when i tried create spfile from pfile, it worked but as soon as i restarted the machine database again had to be started manually.

Report message to a moderator

Re: my database does not start automatically [message #172847 is a reply to message #172768]

Thu, 18 May 2006 05:49

ebrian
Messages: 2794
Registered: April 2006

Senior Member

As was mentioned above...you need to become familiar with ORADIM

Report message to a moderator

Re: my database does not start automatically [message #173890 is a reply to message #172377]

Thu, 25 May 2006 02:21

viplove
Messages: 9
Registered: May 2006

Junior Member

i think i'm using oradim correctly.

oradim -sid hodb -intpwd tac -startmode auto -pfile'e:\oracle\admin\tac\pfile\init.ora'

what is wrong with that???

viplove

Report message to a moderator

Re: my database does not start automatically [message #173892 is a reply to message #172377]

Thu, 25 May 2006 02:43

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Try the following.

Goto the window registry...

HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\HOME0
Check for value for entry
ORA_<SID>_AUTOSTART.

Modify the entry & put the value as TRUE.

Report message to a moderator

Re: my database does not start automatically [message #173908 is a reply to message #173892]

Thu, 25 May 2006 03:58

viplove
Messages: 9
Registered: May 2006

Junior Member

it is set to TRUE, my services are getting up automatically, using oradim i gave startmode as auto

Report message to a moderator

Previous Topic:	conversion from dictionary managed tablespace to Local
Next Topic:	Using operator IN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:35:14 CDT 2024