OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database Shutdown (Oracle 10g Release 10.1.0.3.0 )

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

Database Shutdown [message #507813]

Wed, 18 May 2011 02:17

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Dear friends,

I have a script to shutdown the Linux Oracle database server.

ORACLE_SID=orcl
export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/OraHome_1
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export PATH

sqlplus -S sys/manager1 as sysdba << EOF

shutdown immediate;
exit;
EOF
lsnrctl stop
emctl stop dbconsole
exit

echo "Over"

The Statement emctl stop dbconsole is not working. It is showing
error message as failed.

Can anyone help me pls?

Regards,
Paules

Report message to a moderator

Re: Database Shutdown [message #507817 is a reply to message #507813]

Wed, 18 May 2011 02:36

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

It is showingerror message as failed.

Maybe it could help if you show us.

Regards
Michel

Report message to a moderator

Re: Database Shutdown [message #509465 is a reply to message #507817]

Sat, 28 May 2011 02:11

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Dear Mr.Michel,

Attahed the error message file. Kindly check it.

Regards,
Paules.

Attachment: shut_err.JPG
(Size: 76.95KB, Downloaded 1001 times)

[Updated on: Sat, 28 May 2011 02:12]

Report message to a moderator

Re: Database Shutdown [message #509466 is a reply to message #509465]

Sat, 28 May 2011 02:31

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I can't download files.
How many times will we have to tell you?

COPY AND PASTE in text mode inside your post.
I bet this a DOS or shell session (too bad you didn't follow the guide and posted your OS), so nothing prevent you from posting it in text, and don't forget to FORMAT and USE CODE TAGS.

Regards
Michel

[Updated on: Sat, 28 May 2011 02:32]

Report message to a moderator

Re: Database Shutdown [message #509467 is a reply to message #509466]

Sat, 28 May 2011 02:40

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

[oracle@serverdb~]$ bash shutdown.sh
database closed.
database dismounted.
ORACLE  instance shut down.

LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 28-MAY-2011 07:02:27
Copyright (c) 1991 , 2004 , , Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed sucessfully
TZ set to Asia/Dubai
oracle Enterprise Manager 10g Database Control Release 10.1.0.3.0
Copyright (c) 1996,2004 Oracle Corporation.All rights reserved.
http://serverdb:5500/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Databse Control...
---Failed to shutdown DBConsole Gracefully---
failed.
[oracle@serverdb~]$

Regards,
Paules.

Report message to a moderator

Re: Database Shutdown [message #509473 is a reply to message #509467]

Sat, 28 May 2011 03:22

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

You should stop db console first and then database

Babu

Report message to a moderator

Re: Database Shutdown [message #509474 is a reply to message #509467]

Sat, 28 May 2011 03:52

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And next post the content of the script, are we suppposed to guess what is inside?

Or better add "set -x" at the beginning (of the script and each procedure) and post the execution of the script with this option.

Regards
Michel

Report message to a moderator

Re: Database Shutdown [message #509476 is a reply to message #509474]

Sat, 28 May 2011 05:00

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

This is the Script.

ORACLE_SID=orcl
export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/OraHome_1
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export PATH

sqlplus -S sys/manager1 as sysdba << EOF

shutdown immediate;
exit;
EOF
lsnrctl stop
emctl stop dbconsole
exit

echo "Over"

Regards,
Paules

Report message to a moderator

Re: Database Shutdown [message #509494 is a reply to message #509476]

Sat, 28 May 2011 09:46

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As Babu said: stop the console before the database.

Regards
Michel

Report message to a moderator

Previous Topic:	user management
Next Topic:	ORA-04021:

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:44:49 CST 2024