Oracle Database Discussions

Hi All,

I am on Solaris 10 and Database is 11gR2.

We are getting issue with starting out database. whenever we are giving startuup nomount then its taking ages to startup (Around 45 mins).

Below is alert log file.

Memory on server is 64 GB and database memory_target is 8GB.

any help will highly appriciated.


Thu Sep 06 12:44:38 2012
Adjusting the default value of parameter parallel_max_servers
from 5120 to 485 due to the value of parameter processes (500)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Thu Sep 06 12:44:48 2012
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/11.2.0/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =98
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbs/spfileDSTGEST.ora
System parameters with non-default values:
processes = 500
sessions = 896
memory_target = 8G
memory_max_target = 8G
control_files = "/oradata/DSTGEST/control01.ctl"
control_files = "/oradata/DSTGEST/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/u01/app/oracle/admin/DSTGEST/adump"
audit_trail = "DB"
db_name = "DSTGEST"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Thu Sep 06 12:44:52 2012
PMON started with pid=2, OS id=26639
Thu Sep 06 12:44:53 2012
PSP0 started with pid=3, OS id=26641
Thu Sep 06 12:44:54 2012
VKTM started with pid=4, OS id=26643 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Sep 06 12:44:54 2012
GEN0 started with pid=5, OS id=26648
Thu Sep 06 12:44:54 2012
DIAG started with pid=6, OS id=26650
Thu Sep 06 12:44:54 2012
:$
Thu Sep 06 13:01:52 2012
DBWa started with pid=20, OS id=27177
Thu Sep 06 13:01:54 2012
DBWb started with pid=21, OS id=27179
Thu Sep 06 13:01:55 2012
DBWc started with pid=22, OS id=27181
Thu Sep 06 13:01:57 2012
DBWd started with pid=23, OS id=27185
Thu Sep 06 13:01:59 2012
DBWe started with pid=24, OS id=27189
Thu Sep 06 13:02:01 2012
DBWf started with pid=25, OS id=27191
Thu Sep 06 13:02:02 2012
LGWR started with pid=26, OS id=27193
Thu Sep 06 13:02:03 2012
CKPT started with pid=27, OS id=27195
Thu Sep 06 13:02:03 2012
SMON started with pid=28, OS id=27197
Thu Sep 06 13:02:04 2012
RECO started with pid=29, OS id=27199
Thu Sep 06 13:02:05 2012
MMON started with pid=30, OS id=27201
Thu Sep 06 13:02:06 2012
MMNL started with pid=31, OS id=27203
Thu Sep 06 13:02:06 2012
DISM started, OS id=27205
Thu Sep 06 13:02:34 2012
Time drift detected. Please check VKTM trace file for more details.