OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » shutdown/startup

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

shutdown/startup [message #172835]

Thu, 18 May 2006 04:20

anandhi
Messages: 31
Registered: April 2006
Location: Chennai

Member

hi

how to shutdown/startup database without SQL*PLUS windows

ie using operating system commands how to start/shutdown the database?

Thanks
Anandhi

Report message to a moderator

Re: shutdown/startup [message #172852 is a reply to message #172835]

Thu, 18 May 2006 06:16

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

look at the oradim utility in the documentation

Report message to a moderator

Re: shutdown/startup [message #174351 is a reply to message #172835]

Sun, 28 May 2006 07:26

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Unplug the server's power cord??

Report message to a moderator

Re: shutdown/startup [message #174415 is a reply to message #174351]

Mon, 29 May 2006 04:01

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

@anandhi

Which OS?
IN case of windows, you can use windows services & their respective registry settings for this purpose. & also, yes, oradim is one of the options, but it again start/stop the windows service only.

@JS

There's no oradim in unix.

--Girish

Report message to a moderator

Re: shutdown/startup [message #174428 is a reply to message #174415]

Mon, 29 May 2006 04:16

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

@girish
I don't recall saying that there was.

Report message to a moderator

Re: shutdown/startup [message #174442 is a reply to message #174428]

Mon, 29 May 2006 04:33

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

@JS

oops.... ya true.. u never said that.
Actually I mistook it as a generalized statement as no OS info was mentioned in the 1st thread.

--Girish

Report message to a moderator

Re: shutdown/startup [message #174447 is a reply to message #174442]

Mon, 29 May 2006 04:37

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

LOL, It was a while ago that I made th post, but I reckon I probably stated ORADIM specifically because the OS was not mentioned. It's like when someone asks a SQL question, (If I ever get to answer in time) I tend to point to the most recent SQL version (using analytics for eg) when the OP (invariably) posts back that he / she gets an error, it lets you point out that that is the reason why posting version is so important. It's a bit anal but hey Wink

never mind.

Jim

Report message to a moderator

Re: shutdown/startup [message #174449 is a reply to message #174447]

Mon, 29 May 2006 04:40

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

@JS

Again sorry Razz

... I didn't saw the date of posting as well.

Actually, ImMyself logged it after a long while.

--Girish

Report message to a moderator

Re: shutdown/startup [message #174451 is a reply to message #174449]

Mon, 29 May 2006 04:42

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Girish, absolutely no apology is necessary at all Smile

Report message to a moderator

Re: shutdown/startup [message #175601 is a reply to message #174451]

Sat, 03 June 2006 04:01

animesh303
Messages: 12
Registered: June 2006

Junior Member

Hi

Shutdown/Startup in UNIX

1. Login to the Server using the oracle user.i.e. The unix dba user used to install the database.

2. Check the environment variables for Oracle Database of the user is set or not by issueing commmand:

$ env

Note: Look for ORACLE_HOME variable.

If Oracle Server variable are not set than set them by executing the <SID>_<HOST_NAME>.env file present in Oracle Home directory.

3. Login to the database as sysdba:

$ sqlplus "/ as sysdba"

4. Startup or shutdown as below

SQL> shutdown immediate

SQL> startup open

5. To bring down listener use the command from prompt:

$ lsnrctl stop <SID>

Shutdown/Startup in Windows

1. Login to the Windows System using the DBA user.

2. Open command prompt and use the following commands:

C:\> sqlplus "/ as sysdba"

sql> shutdown immediate

sql> startup open

3. To stop listener use the command from command prompt:

C:\> lsnrctl stop <sid>

Hope this might be helpful for you.

Thanks and Regards
Animesh

Report message to a moderator

Re: shutdown/startup [message #175604 is a reply to message #175601]

Sat, 03 June 2006 04:13

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

Senior Member
Account Moderator

@Animesh
OP was asking for
>> how to shutdown/startup database without SQL*PLUS windows
And did you even care to read for what Girish/JSI2001 had already said?

Report message to a moderator

Re: shutdown/startup [message #175612 is a reply to message #175604]

Sat, 03 June 2006 05:40

animesh303
Messages: 12
Registered: June 2006

Junior Member

Oh Dear!!!

LOL!!! I missed the actual meaning of the question.

Anyway, as far as I know, the database can be brought down in Windows by simply shutting/restarting the Windows. It will automatically stop all services.

Or, if you know the Service name from Windows Services, then bring down the services using the command line:

C:\>net stop <service-name>

In Unix,
I feel there is no way other than killing the connection processes first (identified by 'grep' ing the LOCAL=NO processess) and then background processess.
This might be similar to shutdown abort which will take hell lot of time to come up after during startup.

But the above thing is extremely dangerous. I am not sure but this might corrupt the database.

It is always better to go conventional way of shutdown or startup.
Laughing

Thanks and Regards
Animesh

Report message to a moderator

Re: shutdown/startup [message #175721 is a reply to message #175612]

Mon, 05 June 2006 02:37

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

@Animesh

Anyway, as far as I know, the database can be brought down in Windows by simply shutting/restarting the Windows. It will automatically stop all services.

NOt necessarily. You need to check the registry values (a number of them.. like shutdown type, wait time etc.) for that oracle service.
SHutting down oracle this way (without specifying correct registry settings), by restarting windows may casue instance to abort & database getting corrupted.

C:\>net stop <service-name>

It is always better to go conventional way of shutdown or startup.

Yes, IMHO that should be the way.

--Girish

Report message to a moderator

Previous Topic:	problem during installation on Sun Solaris
Next Topic:	list partitioning error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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