Hi Guys,
I am sort stuck in a process where my DB is starting but after a few seconds its starts shutting down all the processes. The system was running perfectly before but after todays restart this is all happening.
the following is the log from the startup to shutdown. Can any one help to figure out what is causing this issue.
This is ORACLE 11G on Enterprise LINUX._
Mon Aug 13 13:12:28 2012
Starting ORACLE instance (normal)
****************** Large Pages Information *****************
Total Shared Global Region in Large Pages = 0 KB (0%)
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB) (alloc incr 16 MB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
RECOMMENDATION:
Total Shared Global Region size is 4098 MB. For optimal performance,
prior to the next instance restart increase the number
of unused Large Pages by atleast 2049 2048 KB Large Pages (4098 MB)
system wide to get 100% of the Shared
Global Region allocated with Large pages
***********************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =28
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production.
ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/db_1
System name: Linux
Node name: OM5000
Release: 2.6.18-308.el5
Version: #1 SMP Fri Jan 27 17:17:51 EST 2012
Machine: x86_64
Using parameter settings in client-side pfile /u01/app/oracle/admin/OML5K/pfile/init.ora on machine OM5000
System parameters with non-default values:
processes = 150
nls_language = "ENGLISH"
nls_territory = "AUSTRALIA"
sga_target = 4G
control_files = "/u01/app/oracle/oradata/OML5K/control01.ctl"
control_files = "/u01/app/oracle/fast_recovery_area/OML5K/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/u01/app/oracle/fast_recovery_area"
db_recovery_file_dest_size= 50000M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=OML5KXDB)"
audit_file_dest = "/u01/app/oracle/admin/OML5K/adump"
audit_trail = "DB"
db_name = "OML5K"
open_cursors = 300
pga_aggregate_target = 34558M
diagnostic_dest = "/u01/app/oracle"
Mon Aug 13 13:12:28 2012
PMON started with pid=2, OS id=21976
Mon Aug 13 13:12:28 2012
PSP0 started with pid=3, OS id=21978
Mon Aug 13 13:12:29 2012
VKTM started with pid=4, OS id=21980 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Mon Aug 13 13:12:29 2012
GEN0 started with pid=5, OS id=21984
Mon Aug 13 13:12:29 2012
DIAG started with pid=6, OS id=21986
Mon Aug 13 13:12:29 2012
DBRM started with pid=7, OS id=21988
Mon Aug 13 13:12:29 2012
DIA0 started with pid=8, OS id=21990
Mon Aug 13 13:12:29 2012
MMAN started with pid=9, OS id=21992
Mon Aug 13 13:12:29 2012
DBW0 started with pid=10, OS id=21994
Mon Aug 13 13:12:30 2012
DBW1 started with pid=11, OS id=21996
Mon Aug 13 13:12:30 2012
DBW2 started with pid=12, OS id=21998
Mon Aug 13 13:12:30 2012
DBW3 started with pid=13, OS id=22000
Mon Aug 13 13:12:30 2012
LGWR started with pid=14, OS id=22002
Mon Aug 13 13:12:30 2012
CKPT started with pid=15, OS id=22004
Mon Aug 13 13:12:30 2012
SMON started with pid=16, OS id=22006
Mon Aug 13 13:12:30 2012
RECO started with pid=17, OS id=22008
Mon Aug 13 13:12:30 2012
MMON started with pid=18, OS id=22010
Mon Aug 13 13:12:30 2012
MMNL started with pid=19, OS id=22012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Mon Aug 13 13:12:30 2012
kcbztek_populate_tbskey: db key in controlfile and datafile 1 is inconsistent..
Full restore complete of datafile 4 to datafile copy /u01/app/oracle/oradata/OML5K/users01.dbf. Elapsed time: 0:00:00
checkpoint is 995547
last deallocation scn is 3
Full restore complete of datafile 3 to datafile copy /u01/app/oracle/oradata/OML5K/undotbs01.dbf. Elapsed time: 0:00:00
checkpoint is 995547
last deallocation scn is 3
Mon Aug 13 13:13:00 2012
Full restore complete of datafile 2 to datafile copy /u01/app/oracle/oradata/OML5K/sysaux01.dbf. Elapsed time: 0:00:30
checkpoint is 995547
last deallocation scn is 995211
Full restore complete of datafile 1 to datafile copy /u01/app/oracle/oradata/OML5K/system01.dbf. Elapsed time: 0:00:38
checkpoint is 995547
last deallocation scn is 993074
Mon Aug 13 13:13:08 2012
Create controlfile reuse set database "OML5K"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/u01/app/oracle/oradata/OML5K/system01.dbf',
'/u01/app/oracle/oradata/OML5K/sysaux01.dbf',
'/u01/app/oracle/oradata/OML5K/undotbs01.dbf',
'/u01/app/oracle/oradata/OML5K/users01.dbf'
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/OML5K/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/oradata/OML5K/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/oradata/OML5K/redo03.log') SIZE 51200K RESETLOGS
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Mon Aug 13 13:13:08 2012
Successful mount of redo thread 1, with mount id 3547719972
Completed: Create controlfile reuse set database "OML5K"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/u01/app/oracle/oradata/OML5K/system01.dbf',
'/u01/app/oracle/oradata/OML5K/sysaux01.dbf',
'/u01/app/oracle/oradata/OML5K/undotbs01.dbf',
'/u01/app/oracle/oradata/OML5K/users01.dbf'
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/OML5K/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/oradata/OML5K/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/oradata/OML5K/redo03.log') SIZE 51200K RESETLOGS
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Mon Aug 13 13:13:11 2012
Stopping background process VKTM
Mon Aug 13 13:13:13 2012
Instance shutdown complete
Mon Aug 13 13:13:13 2012
Starting ORACLE instance (normal)
****************** Large Pages Information *****************
Total Shared Global Region in Large Pages = 0 KB (0%)
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB) (alloc incr 16 MB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
RECOMMENDATION:
Total Shared Global Region size is 4098 MB. For optimal performance,
prior to the next instance restart increase the number
of unused Large Pages by atleast 2049 2048 KB Large Pages (4098 MB)
system wide to get 100% of the Shared
Global Region allocated with Large pages
***********************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =28
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production.
ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/db_1
System name: Linux
Node name: OM5000
Release: 2.6.18-308.el5
Version: #1 SMP Fri Jan 27 17:17:51 EST 2012
Machine: x86_64
Using parameter settings in client-side pfile /u01/app/oracle/cfgtoollogs/dbca/OML5K/initOML5KTemp.ora on machine OM5000
System parameters with non-default values:
processes = 150
nls_language = "ENGLISH"
nls_territory = "AUSTRALIA"
sga_target = 4G
control_files = "/u01/app/oracle/oradata/OML5K/control01.ctl"
control_files = "/u01/app/oracle/fast_recovery_area/OML5K/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/u01/app/oracle/fast_recovery_area"
db_recovery_file_dest_size= 50000M
norecovery_through_resetlogs= TRUE
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=OML5KXDB)"
audit_file_dest = "/u01/app/oracle/admin/OML5K/adump"
audit_trail = "DB"
db_name = "OML5K"
open_cursors = 300
pga_aggregate_target = 34558M
diagnostic_dest = "/u01/app/oracle"
Mon Aug 13 13:13:14 2012
PMON started with pid=2, OS id=22030
Mon Aug 13 13:13:14 2012
PSP0 started with pid=3, OS id=22032
Mon Aug 13 13:13:15 2012
VKTM started with pid=4, OS id=22034 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Mon Aug 13 13:13:15 2012
GEN0 started with pid=5, OS id=22038
Mon Aug 13 13:13:15 2012
DIAG started with pid=6, OS id=22040
Mon Aug 13 13:13:15 2012
DBRM started with pid=7, OS id=22042
Mon Aug 13 13:13:15 2012
DIA0 started with pid=8, OS id=22044
Mon Aug 13 13:13:15 2012
MMAN started with pid=9, OS id=22046
Mon Aug 13 13:13:15 2012
DBW0 started with pid=10, OS id=22048
Mon Aug 13 13:13:15 2012
DBW1 started with pid=11, OS id=22050
Mon Aug 13 13:13:15 2012
DBW2 started with pid=12, OS id=22052
Mon Aug 13 13:13:15 2012
DBW3 started with pid=13, OS id=22054
Mon Aug 13 13:13:15 2012
LGWR started with pid=14, OS id=22056
Mon Aug 13 13:13:15 2012
CKPT started with pid=15, OS id=22058
Mon Aug 13 13:13:15 2012
SMON started with pid=16, OS id=22060
Mon Aug 13 13:13:15 2012
RECO started with pid=17, OS id=22062
Mon Aug 13 13:13:15 2012
MMON started with pid=18, OS id=22064
Mon Aug 13 13:13:15 2012
MMNL started with pid=19, OS id=22066
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Mon Aug 13 13:13:15 2012
Create controlfile reuse set database "OML5K"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/u01/app/oracle/oradata/OML5K/system01.dbf',
'/u01/app/oracle/oradata/OML5K/sysaux01.dbf',
'/u01/app/oracle/oradata/OML5K/undotbs01.dbf',
'/u01/app/oracle/oradata/OML5K/users01.dbf'
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/OML5K/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/oradata/OML5K/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/oradata/OML5K/redo03.log') SIZE 51200K RESETLOGS
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Successful mount of redo thread 1, with mount id 3547724076
Completed: Create controlfile reuse set database "OML5K"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/u01/app/oracle/oradata/OML5K/system01.dbf',
'/u01/app/oracle/oradata/OML5K/sysaux01.dbf',
'/u01/app/oracle/oradata/OML5K/undotbs01.dbf',
'/u01/app/oracle/oradata/OML5K/users01.dbf'
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/OML5K/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/oradata/OML5K/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/oradata/OML5K/redo03.log') SIZE 51200K RESETLOGS
Stopping background process MMNL
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
Mon Aug 13 13:13:18 2012
MMON started with pid=18, OS id=22077
Mon Aug 13 13:13:18 2012
MMNL started with pid=19, OS id=22079
ALTER SYSTEM enable restricted session;
alter database "OML5K" open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 995547
Errors in file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22071.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/OML5K/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 /u01/app/oracle/oradata/OML5K/redo01.log
Clearing online log 1 of thread 1 sequence number 0
Errors in file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22071.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/OML5K/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22071.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/OML5K/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Mon Aug 13 13:13:18 2012
Checker run found 1 new persistent data failures
Clearing online redo logfile 1 complete
Errors in file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22071.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/OML5K/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 /u01/app/oracle/oradata/OML5K/redo02.log
Clearing online log 2 of thread 1 sequence number 0
Errors in file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22071.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/OML5K/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22071.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/OML5K/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 complete
Errors in file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22071.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/OML5K/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 /u01/app/oracle/oradata/OML5K/redo03.log
Clearing online log 3 of thread 1 sequence number 0
Errors in file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22071.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/OML5K/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22071.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/OML5K/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 complete
Online log /u01/app/oracle/oradata/OML5K/redo01.log: Thread 1 Group 1 was previously cleared
Online log /u01/app/oracle/oradata/OML5K/redo02.log: Thread 1 Group 2 was previously cleared
Online log /u01/app/oracle/oradata/OML5K/redo03.log: Thread 1 Group 3 was previously cleared
Setting recovery target incarnation to 2
Assigning activation ID 3547724076 (0xd375f92c)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/OML5K/redo01.log
Successful open of redo thread 1
SMON: enabling cache recovery
[22071] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:256557774 end:256557834 diff:60 (0 seconds)
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
Create Relation IPS_PACKAGE_UNPACK_HISTORY
No Resource Manager plan active
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
If files cannot be cataloged, then manually delete them
using OS command.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Mon Aug 13 13:13:20 2012
QMNC started with pid=24, OS id=22087
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Global Name changed to OML5K
Completed: alter database "OML5K" open resetlogs
alter database rename global_name to "OML5K"
Completed: alter database rename global_name to "OML5K"
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/OML5K/temp01.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/OML5K/temp01.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
alter database character set INTERNAL_CONVERT ZHS16GBK
Starting background process CJQ0
Mon Aug 13 13:13:22 2012
CJQ0 started with pid=23, OS id=22089
Mon Aug 13 13:13:23 2012
db_recovery_file_dest_size of 50000 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.
Mon Aug 13 13:13:27 2012
Thread 1 advanced to log sequence 2 (LGWR switch)
Current log# 2 seq# 2 mem# 0: /u01/app/oracle/oradata/OML5K/redo02.log
Mon Aug 13 13:13:30 2012
Updating character set in controlfile to ZHS16GBK
Synchronizing connection with database character set information
SYS.RULE$ (CONDITION) - CLOB representation altered
SYS.SCHEDULER$_EVENT_LOG (ADDITIONAL_INFO) - CLOB representation altered
SYS.SNAP$ (REL_QUERY) - CLOB representation altered
SYS.SNAP$ (ALIAS_TXT) - CLOB representation altered
SYS.WRI$_ADV_OBJECTS (ATTR4) - CLOB representation altered
SYS.WRI$_ADV_OBJECTS (OTHER) - CLOB representation altered
SYS.WRI$_ADV_DIRECTIVE_META (DATA) - CLOB representation altered
SYS.WRI$_DBU_FEATURE_METADATA (INST_CHK_LOGIC) - CLOB representation altered
SYS.WRI$_DBU_FEATURE_METADATA (USG_DET_LOGIC) - CLOB representation altered
SYS.WRI$_DBU_HWM_METADATA (LOGIC) - CLOB representation altered
SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY (EXPRESSION) - CLOB representation altered
Mon Aug 13 13:13:30 2012
Starting background process SMCO
Mon Aug 13 13:13:30 2012
SMCO started with pid=27, OS id=22098
SYS.WRI$_REPT_FILES (SYS_NC00005$) - CLOB representation altered
SYS.SUM$ (SRC_STMT) - CLOB representation altered
SYS.SUM$ (DEST_STMT) - CLOB representation altered
SYS.ATTRIBUTE_TRANSFORMATIONS$ (XSL_TRANSFORMATION) - CLOB representation altered
SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
XDB.XDB$XDB_READY (DATA) - CLOB representation altered
XDB.XDB$DXPTAB (SYS_NC00006$) - CLOB representation altered
MDSYS.SDO_XML_SCHEMAS (XMLSCHEMA) - CLOB representation altered
Thread 1 advanced to log sequence 3 (LGWR switch)
Current log# 3 seq# 3 mem# 0: /u01/app/oracle/oradata/OML5K/redo03.log
Mon Aug 13 13:13:43 2012
MDSYS.SDO_COORD_OP_PARAM_VALS (PARAM_VALUE_FILE) - CLOB representation altered
MDSYS.SDO_GEOR_XMLSCHEMA_TABLE (XMLSCHEMA) - CLOB representation altered
MDSYS.SDO_STYLES_TABLE (DEFINITION) - CLOB representation altered
SYSMAN.MGMT_IP_ELEM_DEFAULT_PARAMS (VALUE) - CLOB representation altered
SYSMAN.MGMT_IP_REPORT_ELEM_PARAMS (VALUE) - CLOB representation altered
SYSMAN.MGMT_IP_SQL_STATEMENTS (SQL_STATEMENT) - CLOB representation altered
SYSMAN.MGMT_JOB_LARGE_PARAMS (PARAM_VALUE) - CLOB representation altered
SYSMAN.MGMT_SEC_INFO (B64_LOCAL_CA) - CLOB representation altered
SYSMAN.MGMT_SEC_INFO (B64_INTERNET_CA) - CLOB representation altered
APEX_030200.WWV_FLOW_FLASH_CHARTS (CHART_XML) - CLOB representation altered
APEX_030200.WWV_FLOW_FLASH_CHART_SERIES (SERIES_QUERY) - CLOB representation altered
APEX_030200.WWV_FLOW_SHORTCUTS (SHORTCUT) - CLOB representation altered
APEX_030200.WWV_FLOW_STEPS (HELP_TEXT) - CLOB representation altered
APEX_030200.WWV_FLOW_STEPS (HTML_PAGE_HEADER) - CLOB representation altered
APEX_030200.WWV_FLOW_STEP_PROCESSING (PROCESS_SQL_CLOB) - CLOB representation altered
APEX_030200.WWV_FLOW_PAGE_GENERIC_ATTR (ATTRIBUTE_VALUE) - CLOB representation altered
APEX_030200.WWV_FLOW_TEMPLATES (HEADER_TEMPLATE) - CLOB representation altered
APEX_030200.WWV_FLOW_TEMPLATES (FOOTER_TEMPLATE) - CLOB representation altered
APEX_030200.WWV_FLOW_TEMPLATES (BOX) - CLOB representation altered
Mon Aug 13 13:13:54 2012
Thread 1 cannot allocate new log, sequence 4
Checkpoint not complete
Current log# 3 seq# 3 mem# 0: /u01/app/oracle/oradata/OML5K/redo03.log
Mon Aug 13 13:13:57 2012
APEX_030200.WWV_FLOW_PAGE_PLUGS (PLUG_SOURCE) - CLOB representation altered
Thread 1 advanced to log sequence 4 (LGWR switch)
Current log# 1 seq# 4 mem# 0: /u01/app/oracle/oradata/OML5K/redo01.log
APEX_030200.WWV_FLOW_PAGE_PLUGS (CUSTOM_ITEM_LAYOUT) - CLOB representation altered
APEX_030200.WWV_FLOW_PAGE_PLUG_TEMPLATES (TEMPLATE) - CLOB representation altered
APEX_030200.WWV_FLOW_PAGE_PLUG_TEMPLATES (TEMPLATE2) - CLOB representation altered
APEX_030200.WWV_FLOW_PAGE_PLUG_TEMPLATES (TEMPLATE3) - CLOB representation altered
APEX_030200.WWV_FLOW_PROCESSING (PROCESS_SQL_CLOB) - CLOB representation altered
APEX_030200.WWV_FLOW_REGION_REPORT_COLUMN (PK_COL_SOURCE) - CLOB representation altered
APEX_030200.WWV_FLOW_ROW_TEMPLATES (ROW_TEMPLATE1) - CLOB representation altered
APEX_030200.WWV_FLOW_ROW_TEMPLATES (ROW_TEMPLATE2) - CLOB representation altered
APEX_030200.WWV_FLOW_ROW_TEMPLATES (ROW_TEMPLATE3) - CLOB representation altered
APEX_030200.WWV_FLOW_ROW_TEMPLATES (ROW_TEMPLATE4) - CLOB representation altered
APEX_030200.WWV_FLOW_BANNER (BANNER) - CLOB representation altered
APEX_030200.WWV_FLOW_BUTTON_TEMPLATES (TEMPLATE) - CLOB representation altered
APEX_030200.WWV_FLOW_INSTALL (DEINSTALL_SCRIPT) - CLOB representation altered
APEX_030200.WWV_FLOW_LIST_TEMPLATES (LIST_TEMPLATE_CURRENT) - CLOB representation altered
APEX_030200.WWV_FLOW_LIST_TEMPLATES (LIST_TEMPLATE_NONCURRENT) - CLOB representation altered
APEX_030200.WWV_FLOW_LIST_TEMPLATES (SUB_LIST_ITEM_CURRENT) - CLOB representation altered
APEX_030200.WWV_FLOW_LIST_TEMPLATES (SUB_LIST_ITEM_NONCURRENT) - CLOB representation altered
APEX_030200.WWV_FLOW_LIST_TEMPLATES (ITEM_TEMPLATE_CURR_W_CHILD) - CLOB representation altered
APEX_030200.WWV_FLOW_LIST_TEMPLATES (ITEM_TEMPLATE_NONCURR_W_CHILD) - CLOB representation altered
APEX_030200.WWV_FLOW_LIST_TEMPLATES (SUB_TEMPLATE_CURR_W_CHILD) - CLOB representation altered
APEX_030200.WWV_FLOW_LIST_TEMPLATES (SUB_TEMPLATE_NONCURR_W_CHILD) - CLOB representation altered
APEX_030200.WWV_FLOW_WORKSHEETS (SQL_QUERY) - CLOB representation altered
Mon Aug 13 13:14:08 2012
APEX_030200.WWV_FLOW_CUSTOM_AUTH_SETUPS (PAGE_SENTRY_FUNCTION) - CLOB representation altered
APEX_030200.WWV_FLOW_CUSTOM_AUTH_SETUPS (SESS_VERIFY_FUNCTION) - CLOB representation altered
APEX_030200.WWV_FLOW_CUSTOM_AUTH_SETUPS (PRE_AUTH_PROCESS) - CLOB representation altered
APEX_030200.WWV_FLOW_CUSTOM_AUTH_SETUPS (AUTH_FUNCTION) - CLOB representation altered
APEX_030200.WWV_FLOW_CUSTOM_AUTH_SETUPS (POST_AUTH_PROCESS) - CLOB representation altered
Refreshing type attributes with new character set information
Completed: alter database character set INTERNAL_CONVERT ZHS16GBK
Mon Aug 13 13:14:11 2012
ALTER SYSTEM disable restricted session;
Mon Aug 13 13:14:12 2012
Thread 1 advanced to log sequence 5 (LGWR switch)
Current log# 2 seq# 5 mem# 0: /u01/app/oracle/oradata/OML5K/redo02.log
Mon Aug 13 13:14:28 2012
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Mon Aug 13 13:14:29 2012
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 14
Stopping Job queue slave processes, flags = 7
Job queue slave processes stopped
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Mon Aug 13 13:14:33 2012
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Aug 13 13:14:33 2012
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 5
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Mon Aug 13 13:14:34 2012
Stopping background process VKTM
System State dumped to trace file /u01/app/oracle/diag/rdbms/oml5k/OML5K/trace/OML5K_ora_22163.trc
Mon Aug 13 13:14:36 2012
Instance shutdown complete
Mon Aug 13 13:14:37 2012
Starting ORACLE instance (normal)