OraFAQ Forum: Server Administration » Why the Oracle should be start every time?

Home » RDBMS Server » Server Administration » Why the Oracle should be start every time?

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

Why the Oracle should be start every time? [message #61268]

Thu, 08 April 2004 17:23

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

When I restart the computer, I have to start the oracle by DBA Studio.

Why the computer could not start oracle auto?

Thanks!

Report message to a moderator

Re: Why the Oracle should be start every time? [message #61270 is a reply to message #61268]

Thu, 08 April 2004 21:54

Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas

Senior Member

Hi,

It means ur oracle services are not autostartable. To auto start ur oracle services go to services and change the property of oracle services to auto. Mainly Listener and DB services.

Daljit Singh.

Report message to a moderator

Re: Why the Oracle should be start every time? [message #61272 is a reply to message #61270]

Fri, 09 April 2004 01:12

Eric
Messages: 78
Registered: April 1999

Member

hi all. i have the same problem. but i'm sure that i have the service autostart. but each time i restart the comp and try to use sql plus, it always say oracle not ready. then i have to shutdown all processes of oracle, restart it back from the DB admin tool, then only can use sql plus. btw, i'm using winxp with service pack and using oracle 8i.

another problem is, i've keyed in the content for a table and the next day when went thru all the hassle restarting oracle services, my table content ALL gone!
anyone have any idea? direct mailing to my mail is welcomed! thx in advance!

Report message to a moderator

Re: Why the Oracle should be start every time? [message #61276 is a reply to message #61270]

Sat, 10 April 2004 02:27

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

Could you tell me how to set the property of oracle services to auto?
The Oracle version is 817.

Report message to a moderator

Re: Why the Oracle should be start every time? [message #61277 is a reply to message #61270]

Sat, 10 April 2004 02:40

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

I found that in Win2000 server service the OracleServiceSID has started.
However, the database could not be visit until I start the DB in DBA Studio manually.

Report message to a moderator

Re: Why the Oracle should be start every time? [message #61281 is a reply to message #61270]

Sun, 11 April 2004 02:59

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

I found that the instance is not startup.
If connect internal and startup, the database is OK.
However, how to setting the property?

Report message to a moderator

Previous Topic:	startup database
Next Topic:	Table Script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 22:23:45 CST 2025