In the aler_orcl.log file, I have this-
Tue Feb 05 22:09:57 2013
PMON started with pid=2, OS id=14288
Tue Feb 05 22:09:57 2013
VKTM started with pid=3, OS id=13112 at elevated priority
VKTM running at (20)ms precision
Tue Feb 05 22:09:57 2013
DIAG started with pid=4, OS id=13768
Tue Feb 05 22:09:57 2013
DBRM started with pid=5, OS id=11476
Tue Feb 05 22:09:57 2013
PSP0 started with pid=6, OS id=12344
Tue Feb 05 22:09:57 2013
DSKM started with pid=7, OS id=13276
Tue Feb 05 22:09:57 2013
DIA0 started with pid=8, OS id=5368
Tue Feb 05 22:09:57 2013
MMAN started with pid=7, OS id=11232
Tue Feb 05 22:09:57 2013
DBW0 started with pid=9, OS id=12992
Tue Feb 05 22:09:57 2013
LGWR started with pid=10, OS id=14140
Tue Feb 05 22:09:57 2013
CKPT started with pid=11, OS id=2964
Tue Feb 05 22:09:57 2013
SMON started with pid=12, OS id=4444
Tue Feb 05 22:09:57 2013
RECO started with pid=13, OS id=13660
Tue Feb 05 22:09:57 2013
MMON started with pid=14, OS id=10596
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment =
\app\rjamal
Tue Feb 05 22:09:57 2013
ALTER DATABASE MOUNT
Tue Feb 05 22:09:57 2013
MMNL started with pid=15, OS id=13392
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 1334447288
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Feb 05 22:10:04 2013
ALTER DATABASE OPEN
Thread 1 opened at log sequence 1400
Current log# 2 seq# 1400 mem# 0:
\APP\RJAMAL\ORADATA\ORCL\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 FBDA
Starting background process SMCO
Tue Feb 05 22:10:06 2013
SMCO started with pid=20, OS id=13828
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue Feb 05 22:10:07 2013
QMNC started with pid=21, OS id=2640
Tue Feb 05 22:10:06 2013
FBDA started with pid=18, OS id=13760
Tue Feb 05 22:10:11 2013
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.
Tue Feb 05 22:10:17 2013
Completed: ALTER DATABASE OPEN
Tue Feb 05 22:13:20 2013
ALTER SYSTEM SET processes=10000 SCOPE=SPFILE;
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
Tue Feb 05 22:13:30 2013
Shutting down instance (immediate)
License high water mark = 7
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Tue Feb 05 22:13:33 2013
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Feb 05 22:13:34 2013
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1400
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
Tue Feb 05 22:13:35 2013
Stopping background process VKTM:
Tue Feb 05 22:13:37 2013
Instance shutdown complete
Tue Feb 05 22:13:44 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as
\app\rjamal\product\11.1.0\db_1\RDBMS
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =1210
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
\APP\RJAMAL\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes = 10000
memory_target = 9856M
control_files = "D:\APP\RJAMAL\ORADATA\ORCL\CONTROL01.CTL"
control_files = "D:\APP\RJAMAL\ORADATA\ORCL\CONTROL02.CTL"
control_files = "D:\APP\RJAMAL\ORADATA\ORCL\CONTROL03.CTL"
db_block_size = 8192
compatible = "11.1.0.0.0"
db_recovery_file_dest = "D:\app\rjamal\flash_recovery_area"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "D:\APP\RJAMAL\ADMIN\ORCL\ADUMP"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "D:\APP\RJAMAL"
Tue Feb 05 22:13:45 2013
PMON started with pid=2, OS id=3744
Tue Feb 05 22:13:45 2013
VKTM started with pid=3, OS id=12620 at elevated priority
VKTM running at (20)ms precision
Tue Feb 05 22:13:45 2013
DIAG started with pid=4, OS id=13356
Tue Feb 05 22:13:45 2013
DBRM started with pid=5, OS id=1036
Tue Feb 05 22:13:45 2013
PSP0 started with pid=6, OS id=11528
Tue Feb 05 22:13:45 2013
DSKM started with pid=7, OS id=14160
Tue Feb 05 22:13:45 2013
DIA0 started with pid=8, OS id=13856
Tue Feb 05 22:13:45 2013
MMAN started with pid=7, OS id=6740
Tue Feb 05 22:13:45 2013
DBW0 started with pid=9, OS id=13044
Tue Feb 05 22:13:45 2013
LGWR started with pid=10, OS id=14068
Tue Feb 05 22:13:45 2013
CKPT started with pid=11, OS id=13788
Tue Feb 05 22:13:45 2013
SMON started with pid=12, OS id=14036
Tue Feb 05 22:13:45 2013
RECO started with pid=13, OS id=12132
Tue Feb 05 22:13:45 2013
MMON started with pid=14, OS id=12404
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment =
\app\rjamal
Tue Feb 05 22:13:45 2013
ALTER DATABASE MOUNT
Tue Feb 05 22:13:45 2013
MMNL started with pid=15, OS id=4560
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 1334401436
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Feb 05 22:13:52 2013
ALTER DATABASE OPEN
Thread 1 opened at log sequence 1400
Current log# 2 seq# 1400 mem# 0:
\APP\RJAMAL\ORADATA\ORCL\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 FBDA
Starting background process SMCO
Tue Feb 05 22:13:54 2013
FBDA started with pid=18, OS id=4684
Tue Feb 05 22:13:54 2013
SMCO started with pid=20, OS id=11544
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue Feb 05 22:13:55 2013
QMNC started with pid=21, OS id=10872
Tue Feb 05 22:14:00 2013
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.
Tue Feb 05 22:14:06 2013
Completed: ALTER DATABASE OPEN
Tue Feb 05 22:15:05 2013
Thread 1 advanced to log sequence 1401
Current log# 3 seq# 1401 mem# 0:
\APP\RJAMAL\ORADATA\ORCL\REDO03.LOG
Tue Feb 05 22:18:49 2013
Starting background process CJQ0
Tue Feb 05 22:18:49 2013
CJQ0 started with pid=26, OS id=11732
Setting Resource Manager plan SCHEDULER[0x2C0A]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Tue Feb 05 22:25:04 2013
ALTER SYSTEM SET processes=10000000 SCOPE=SPFILE;
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Tue Feb 05 22:25:11 2013
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
Tue Feb 05 22:25:14 2013
Shutting down instance (immediate)
License high water mark = 7
Stopping Job queue slave processes, flags = 7
Tue Feb 05 22:25:14 2013
ORA-1089 : opidrv aborting process J000 ospid (1016_13040)
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Tue Feb 05 22:25:17 2013
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Feb 05 22:25:17 2013
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1401
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
Tue Feb 05 22:25:19 2013
Stopping background process VKTM:
Tue Feb 05 22:25:22 2013
Instance shutdown complete
Tue Feb 05 22:25:28 2013
Starting ORACLE instance (normal)
Wed Feb 06 11:53:59 2013
Starting ORACLE instance (normal)
Wed Feb 06 11:56:01 2013
Starting ORACLE instance (normal)
And I don't know where I should look for process trace file?