OraFAQ Forum: Server Administration » it takes so much time to shutdown the Database

Home » RDBMS Server » Server Administration » it takes so much time to shutdown the Database (oracle, 10.2.0.1, Sun Solaries (spark))

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

it takes so much time to shutdown the Database [message #353074]

Fri, 10 October 2008 23:41

halim
Messages: 100
Registered: September 2008

Senior Member

Hello dears
Please give me a solution.

My problem is-
it takes so much time to shutdown the Database from previous two month.In last week we wait about 2.30 hours after execute
the command -
SQL> SHUTDOWN IMMEDIATE

At last I kill the oracle process then down the Database.

My server machine is 'sun T5240'.
OS is sun solaries (spark).
OLTP Database size is about 50 GB .
we use EMC storage solution from previous two months including
Syncronizing with remote DR site.

Report message to a moderator

Re: it takes so much time to shutdown the Database [message #353080 is a reply to message #353074]

Sat, 11 October 2008 01:02

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Database Administrator's Guide
Chapter 3 Starting Up and Shutting Down
Section Shutting Down a Database
Paragraph Shutting Down with the IMMEDIATE Clause

Quote:

Any uncommitted transactions are rolled back. (If long uncommitted transactions exist, this method of shutdown might not complete quickly, despite its name.)

Regards
Michel

Report message to a moderator

Re: it takes so much time to shutdown the Database [message #353105 is a reply to message #353074]

Sat, 11 October 2008 07:20

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

Senior Member
Account Moderator

Could be a known issue with this specific distribution (10R2,SunSPARC).
Left me crazy for a while.
Just make sure LD_LIBRARY_PATH is first referenced in your profile / environment.
Something like this.

-bash-3.00$ cat .profile
export ORACLE_HOME=/u01/home
export ORACLE_BASE=/u01/base
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:/bin:/usr/ccs/bin:/usr/openwin/bin:/usr/bin:/usr/local/bin:.:$ORACLE_HOME/bin
#all the rest
#all the rest

Report message to a moderator

Re: it takes so much time to shutdown the Database [message #353140 is a reply to message #353105]

Sat, 11 October 2008 22:22

halim
Messages: 100
Registered: September 2008

Senior Member

Thanks Mahesh Rajendran

I will try it now .

Report message to a moderator

Previous Topic:	oracle10g rel 2
Next Topic:	Database cloning !

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 00:15:38 CDT 2024