Oracle 11g DB startup and shutdown

$ sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Aug 15 18:24:17 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 849530880 bytes
Fixed Size 1303216 bytes
Variable Size 503319888 bytes
Database Buffers 339738624 bytes
Redo Buffers 5169152 bytes
Database mounted.
Database opened.
SQL>


Default dump directory paths have changed from $ORACLE_HOME/admin/*dump to:

SQL> show parameter dump

NAME TYPE VALUE
------------------------------------ ------------------------------
background_core_dump string partial
background_dump_dest string /home/oracle/app/oracle/diag/rdbms/eleveng
/eleveng/trace
core_dump_dest string /home/oracle/app/oracle/diag/r
dbms/eleveng/eleveng/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /home/oracle/app/oracle/diag/r
dbms/eleveng/eleveng/trace
SQL>

A peek inside the alert log:

Shutdown log:

Wed Aug 15 18:24:28 2007
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Stopping background process QMNC
Wed Aug 15 18:24:30 2007
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
Shutting down instance (immediate)
License high water mark = 16
Wed Aug 15 18:24:34 2007
ORA-1089 : opidrv aborting process unknown ospid (17409_3086890688)
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Wed Aug 15 18:24:35 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Aug 15 18:24:35 2007
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 8
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Aug 15 18:24:35 2007
Stopping background process VKTM:
Wed Aug 15 18:24:38 2007
Instance shutdown complete


Startup log:

Wed Aug 15 18:24:38 2007
Instance shutdown complete
Wed Aug 15 18:24:41 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as /home/oracle/app/oracle/product/11.1.0/db_1/dbs/arch
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile /home/oracle/app/oracle/product/11.1.0/db_1/dbs/spfileeleveng.ora
System parameters with non-default values:
processes = 150
memory_target = 812M
control_files = "/home/oracle/app/oracle/oradata/eleveng/control01.ctl"
control_files = "/home/oracle/app/oracle/oradata/eleveng/control02.ctl"
control_files = "/home/oracle/app/oracle/oradata/eleveng/control03.ctl"
db_block_size = 8192
compatible = "11.1.0.0.0"
db_recovery_file_dest = "/home/oracle/app/oracle/flash_recovery_area"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=elevengXDB)"
audit_file_dest = "/home/oracle/app/oracle/admin/eleveng/adump"
audit_trail = "DB"
db_name = "eleveng"
open_cursors = 300
diagnostic_dest = "/home/oracle/app/oracle"
Wed Aug 15 18:24:43 2007
PMON started with pid=2, OS id=26498
Wed Aug 15 18:24:43 2007
VKTM started with pid=3, OS id=26500
VKTM running at (100ms) precision
Wed Aug 15 18:24:43 2007
DIAG started with pid=4, OS id=26504
Wed Aug 15 18:24:43 2007
DBRM started with pid=5, OS id=26506
Wed Aug 15 18:24:43 2007
PSP0 started with pid=6, OS id=26508
Wed Aug 15 18:24:43 2007
DSKM started with pid=7, OS id=26510
Wed Aug 15 18:24:43 2007
DIA0 started with pid=8, OS id=26512
Wed Aug 15 18:24:43 2007
MMAN started with pid=7, OS id=26514
Wed Aug 15 18:24:43 2007
DBW0 started with pid=9, OS id=26516
Wed Aug 15 18:24:43 2007
LGWR started with pid=10, OS id=26518
Wed Aug 15 18:24:43 2007
CKPT started with pid=11, OS id=26520
Wed Aug 15 18:24:43 2007
SMON started with pid=12, OS id=26522
Wed Aug 15 18:24:43 2007
RECO started with pid=13, OS id=26524
Wed Aug 15 18:24:43 2007
MMON started with pid=14, OS id=26526
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Aug 15 18:24:43 2007
MMNL started with pid=15, OS id=26528
starting up 1 shared server(s) ...
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Reusing ORACLE_BASE from an earlier startup = /home/oracle/app/oracle
Wed Aug 15 18:24:44 2007
ALTER DATABASE MOUNT
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 343942063
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Wed Aug 15 18:24:51 2007
ALTER DATABASE OPEN
Thread 1 opened at log sequence 8
Current log# 2 seq# 8 mem# 0: /home/oracle/app/oracle/oradata/eleveng/redo02.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
Opening with internal Resource Manager plan
Starting background process SMCO
Wed Aug 15 18:24:52 2007
SMCO started with pid=19, OS id=26548
Starting background process FBDA
Wed Aug 15 18:24:52 2007
FBDA started with pid=20, OS id=26550
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed Aug 15 18:24:53 2007
QMNC started with pid=21, OS id=26552
Wed Aug 15 18:24:56 2007
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 15 18:25:07 2007
Completed: ALTER DATABASE OPEN
Wed Aug 15 18:29:48 2007
Starting background process CJQ0
Wed Aug 15 18:29:48 2007
CJQ0 started with pid=33, OS id=26826


The alert log is also being created in xml format in /home/oracle/app/oracle/diag/rdbms/eleveng/eleveng/alert/log.xml