OraFAQ Forum: Server Administration » Error during stoping of service

Home » RDBMS Server » Server Administration » Error during stoping of service

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

Error during stoping of service [message #138990]

Mon, 26 September 2005 04:36

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

hi all,
when i wnat to stop my data base service from control panel of my win-2003 server i could not stop it properly ,its showing a status stoping .And is not stopped for a long time so i have to restart the machine to restart the service.
i am using 9.2.0.6.

Thanks and regds
dinesh

Report message to a moderator

Re: Error during stoping of service [message #138992 is a reply to message #138990]

Mon, 26 September 2005 04:50

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

Senior Member
Account Moderator

Did you try manually?
login to sqlplus as sysdba and shutdown?

Report message to a moderator

Re: Error during stoping of service [message #138999 is a reply to message #138992]

Mon, 26 September 2005 05:06

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

No i had only tried through control panel ->services.

Report message to a moderator

Re: Error during stoping of service [message #139004 is a reply to message #138999]

Mon, 26 September 2005 05:10

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Always better to shutdown the database first before closing the service .

( steps to shutdown )

1. Connect as sysdba

SQL> conn sys/paswd as sysdba

2. shutdown ( if no other user is connected to the database )

SQL> shutdown

regards,
tarun

Report message to a moderator

Re: Error during stoping of service [message #139007 is a reply to message #139004]

Mon, 26 September 2005 05:12

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

First shutdown the database then shutdown the service.
Or i think shutdown will do both the work.

Regds
dinesh Idea

Report message to a moderator

Re: Error during stoping of service [message #139010 is a reply to message #139007]

Mon, 26 September 2005 05:15

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

No, Shutdown will not stop the service. It will just take the database down.

Mean to say SGA will be deallocated but the service will keep on running.

regards,
tarun

Report message to a moderator

Re: Error during stoping of service [message #139606 is a reply to message #138990]

Wed, 28 September 2005 15:39

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

I blv,
you need to comment the line of NTS_AUTHENTICATION line in sqlnet.ora file so that from services it will allow you to shutdown ..

-Sai Jeedigunta

Report message to a moderator

Previous Topic:	release lock..??
Next Topic:	Invalid objects in SYS schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 10:12:37 CST 2025