Home » RDBMS Server » Server Administration » it takes so much time to shutdown the Database (oracle, 10.2.0.1, Sun Solaries (spark))
it takes so much time to shutdown the Database [message #353074] Fri, 10 October 2008 23:41 Go to next message
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.
Re: it takes so much time to shutdown the Database [message #353080 is a reply to message #353074] Sat, 11 October 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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
Re: it takes so much time to shutdown the Database [message #353105 is a reply to message #353074] Sat, 11 October 2008 07:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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


Re: it takes so much time to shutdown the Database [message #353140 is a reply to message #353105] Sat, 11 October 2008 22:22 Go to previous message
halim
Messages: 100
Registered: September 2008
Senior Member

Thanks Mahesh Rajendran

I will try it now .

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


Current Time: Fri Dec 09 00:17:20 CST 2016

Total time taken to generate the page: 0.23630 seconds