Starting ORACLE instance (normal) Sun Nov 29 22:01:13 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:12400M/16262M, Ph+PgF:24916M/32522M Using parameter settings in client-side pfile C:\APP\ORACLE\CFGTOOLLOGS\DBCA\ORCL\INITORCLTEMPOMF.ORA on machine ALEXEY-PC System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\CFGTOOLLOGS\DBCA\ORCL\TEMPCONTROL.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "seeddata" db_unique_name = "orcl" open_cursors = 300 diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=392 Starting background process PSP0 PSP0 started with pid=3, OS id=2956 Starting background process VKTM VKTM started with pid=4, OS id=2624 at elevated priority Starting background process GEN0 Sun Nov 29 22:01:16 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=4152 Starting background process MMAN MMAN started with pid=6, OS id=4532 Starting background process DIAG DIAG started with pid=8, OS id=2736 Starting background process DBRM DBRM started with pid=9, OS id=3972 Starting background process DIA0 DIA0 started with pid=10, OS id=4140 Starting background process DBW0 DBW0 started with pid=11, OS id=1516 Starting background process LGWR LGWR started with pid=12, OS id=2892 Starting background process CKPT CKPT started with pid=13, OS id=1920 Starting background process SMON SMON started with pid=15, OS id=2664 Starting background process RECO RECO started with pid=17, OS id=4084 Starting background process LREG LREG started with pid=18, OS id=5060 Starting background process MMON MMON started with pid=19, OS id=3708 Starting background process MMNL MMNL started with pid=20, OS id=3952 Sun Nov 29 22:01:16 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle ALTER DATABASE MOUNT Sun Nov 29 22:01:19 2015 Using default pga_aggregate_limit of 5216 MB Sun Nov 29 22:01:20 2015 Set as converted control file due to db_unique_name mismatch Changing di2dbun from seeddata to orcl Sun Nov 29 22:01:20 2015 Successful mount of redo thread 1, with mount id 4225773934 Sun Nov 29 22:01:20 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Create Relation IPS_PACKAGE_UNPACK_HISTORY Completed: ALTER DATABASE MOUNT Checker run found 5 new persistent data failures Sun Nov 29 22:02:06 2015 Full restore complete of datafile 3 to datafile copy C:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF. Elapsed time: 0:00:44 checkpoint is 2255671 last deallocation scn is 1838865 Sun Nov 29 22:02:54 2015 Full restore complete of datafile 1 to datafile copy C:\APP\ORACLE\ORADATA\ORCL\SYSTEM01.DBF. Elapsed time: 0:00:47 checkpoint is 2255671 last deallocation scn is 2186309 Undo Optimization current scn is 1836140 Full restore complete of datafile 6 to datafile copy C:\APP\ORACLE\ORADATA\ORCL\USERS01.DBF. Elapsed time: 0:00:00 checkpoint is 2255671 last deallocation scn is 3 Sun Nov 29 22:03:45 2015 Full restore complete of datafile 5 to datafile copy C:\APP\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF. Elapsed time: 0:00:42 checkpoint is 2255671 last deallocation scn is 2136603 Undo Optimization current scn is 1836140 Shutting down instance (abort) License high water mark = 4 Sun Nov 29 22:03:48 2015 USER (ospid: 3964): terminating the instance Sun Nov 29 22:04:07 2015 Instance terminated by USER, pid = 3964 Instance shutdown complete Starting ORACLE instance (normal) Sun Nov 29 22:04:17 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:12831M/16262M, Ph+PgF:25336M/32522M Using parameter settings in client-side pfile C:\APP\ORACLE\ADMIN\ORCL\PFILE\INIT.ORA on machine ALEXEY-PC System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=3980 Starting background process PSP0 Starting background process VKTM PSP0 started with pid=3, OS id=4408 VKTM started with pid=4, OS id=3040 at elevated priority Starting background process GEN0 Sun Nov 29 22:04:20 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms Starting background process MMAN GEN0 started with pid=5, OS id=3684 MMAN started with pid=6, OS id=4284 Starting background process DIAG DIAG started with pid=8, OS id=5008 Starting background process DBRM DBRM started with pid=9, OS id=2944 Starting background process DIA0 DIA0 started with pid=10, OS id=4752 Starting background process DBW0 DBW0 started with pid=11, OS id=4336 Starting background process LGWR LGWR started with pid=12, OS id=4468 Starting background process CKPT CKPT started with pid=13, OS id=3816 Starting background process SMON SMON started with pid=15, OS id=436 Starting background process RECO RECO started with pid=17, OS id=1412 Starting background process LREG LREG started with pid=18, OS id=160 Starting background process MMON MMON started with pid=19, OS id=936 Starting background process MMNL MMNL started with pid=20, OS id=156 Sun Nov 29 22:04:20 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle Create controlfile reuse set database "orcl" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 Datafile 'C:\APP\ORACLE\ORADATA\ORCL\SYSTEM01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\USERS01.DBF' LOGFILE GROUP 1 ('C:\app\oracle\oradata\orcl\redo01.log') SIZE 50M, GROUP 2 ('C:\app\oracle\oradata\orcl\redo02.log') SIZE 50M, GROUP 3 ('C:\app\oracle\oradata\orcl\redo03.log') SIZE 50M RESETLOGS Sun Nov 29 22:04:20 2015 WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command Default Temporary Tablespace will be necessary for a locally managed database in future release Sun Nov 29 22:04:21 2015 Successful mount of redo thread 1, with mount id 1424856295 Completed: Create controlfile reuse set database "orcl" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 Datafile 'C:\APP\ORACLE\ORADATA\ORCL\SYSTEM01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\USERS01.DBF' LOGFILE GROUP 1 ('C:\app\oracle\oradata\orcl\redo01.log') SIZE 50M, GROUP 2 ('C:\app\oracle\oradata\orcl\redo02.log') SIZE 50M, GROUP 3 ('C:\app\oracle\oradata\orcl\redo03.log') SIZE 50M RESETLOGS Shutting down instance (immediate) Shutting down instance: further logons disabled Stopping background process MMNL Stopping background process MMON License high water mark = 1 Sun Nov 29 22:04:23 2015 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL Stopping Emon pool 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 Sun Nov 29 22:04:23 2015 Using default pga_aggregate_limit of 5216 MB Sun Nov 29 22:04:25 2015 ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Sun Nov 29 22:04:25 2015 Stopping background process VKTM Archiving is disabled Instance shutdown complete Starting ORACLE instance (normal) Sun Nov 29 22:04:37 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:12829M/16262M, Ph+PgF:25335M/32522M Using parameter settings in client-side pfile C:\APP\ORACLE\CFGTOOLLOGS\DBCA\ORCL\INITORCLTEMP.ORA on machine ALEXEY-PC System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M _no_recovery_through_resetlogs= TRUE undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 _enable_automatic_maintenance= 0 diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=4112 Starting background process PSP0 Starting background process VKTM PSP0 started with pid=3, OS id=4108 VKTM started with pid=4, OS id=3552 at elevated priority Starting background process GEN0 Sun Nov 29 22:04:40 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=4280 Starting background process MMAN MMAN started with pid=6, OS id=1992 Starting background process DIAG DIAG started with pid=8, OS id=4516 Starting background process DBRM DBRM started with pid=9, OS id=2608 Starting background process DIA0 DIA0 started with pid=10, OS id=2676 Starting background process DBW0 DBW0 started with pid=11, OS id=4252 Starting background process LGWR LGWR started with pid=12, OS id=2024 Starting background process CKPT CKPT started with pid=13, OS id=2032 Starting background process SMON SMON started with pid=15, OS id=4296 Starting background process RECO RECO started with pid=17, OS id=4148 Starting background process LREG LREG started with pid=18, OS id=4260 Starting background process MMON MMON started with pid=19, OS id=656 Starting background process MMNL MMNL started with pid=20, OS id=612 Sun Nov 29 22:04:40 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle Create controlfile reuse set database "orcl" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 Datafile 'C:\APP\ORACLE\ORADATA\ORCL\SYSTEM01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\USERS01.DBF' LOGFILE GROUP 1 ('C:\app\oracle\oradata\orcl\redo01.log') SIZE 50M, GROUP 2 ('C:\app\oracle\oradata\orcl\redo02.log') SIZE 50M, GROUP 3 ('C:\app\oracle\oradata\orcl\redo03.log') SIZE 50M RESETLOGS Sun Nov 29 22:04:40 2015 WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command Default Temporary Tablespace will be necessary for a locally managed database in future release Sun Nov 29 22:04:40 2015 Successful mount of redo thread 1, with mount id 1424893179 Completed: Create controlfile reuse set database "orcl" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 Datafile 'C:\APP\ORACLE\ORADATA\ORCL\SYSTEM01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\USERS01.DBF' LOGFILE GROUP 1 ('C:\app\oracle\oradata\orcl\redo01.log') SIZE 50M, GROUP 2 ('C:\app\oracle\oradata\orcl\redo02.log') SIZE 50M, GROUP 3 ('C:\app\oracle\oradata\orcl\redo03.log') SIZE 50M RESETLOGS Stopping background process MMNL Stopping background process MMON Starting background process MMON Starting background process MMNL MMNL started with pid=19, OS id=3840 Sun Nov 29 22:04:42 2015 Stopping Emon pool Sun Nov 29 22:04:42 2015 ALTER SYSTEM enable restricted session; alter database "orcl" open resetlogs RESETLOGS after incomplete recovery UNTIL CHANGE 2255671 Sun Nov 29 22:04:42 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1404.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) Не удается найти указанный файл. Clearing online redo logfile 1 C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Clearing online log 1 of thread 1 sequence number 0 Sun Nov 29 22:04:42 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1404.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) Не удается найти указанный файл. Sun Nov 29 22:04:42 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1404.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) Не удается найти указанный файл. Clearing online redo logfile 1 complete Sun Nov 29 22:04:42 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1404.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: 'C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) Не удается найти указанный файл. Clearing online redo logfile 2 C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG Clearing online log 2 of thread 1 sequence number 0 Sun Nov 29 22:04:42 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1404.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: 'C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) Не удается найти указанный файл. Sun Nov 29 22:04:42 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1404.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: 'C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) Не удается найти указанный файл. Clearing online redo logfile 2 complete Sun Nov 29 22:04:42 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1404.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) Не удается найти указанный файл. Clearing online redo logfile 3 C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG Clearing online log 3 of thread 1 sequence number 0 Sun Nov 29 22:04:42 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1404.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) Не удается найти указанный файл. Sun Nov 29 22:04:42 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1404.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) Не удается найти указанный файл. Clearing online redo logfile 3 complete Online log C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG: Thread 1 Group 1 was previously cleared Online log C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG: Thread 1 Group 2 was previously cleared Online log C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG: Thread 1 Group 3 was previously cleared Sun Nov 29 22:04:43 2015 Setting recovery target incarnation to 2 Sun Nov 29 22:04:43 2015 Using SCN growth rate of 16384 per second Sun Nov 29 22:04:43 2015 Using default pga_aggregate_limit of 5216 MB Sun Nov 29 22:04:43 2015 Assigning activation ID 1424893179 (0x54ee24fb) Starting background process TMON TMON started with pid=20, OS id=4520 Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Successful open of redo thread 1 Sun Nov 29 22:04:43 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Nov 29 22:04:43 2015 SMON: enabling cache recovery Sun Nov 29 22:04:43 2015 [1404] Successfully onlined Undo Tablespace 2. MMON started with pid=7, OS id=1708 Undo initialization finished serial:0 start:593225 end:593318 diff:93 ms (0.1 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 Sun Nov 29 22:04:43 2015 SMON: enabling tx recovery Sun Nov 29 22:04:43 2015 ********************************************************************* WARNING: The following temporary tablespaces in container(CDB$ROOT) 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 ADD TEMPFILE Alternatively, if these temporary tablespaces are no longer needed, then they can be dropped. Empty temporary tablespace: TEMP ********************************************************************* Starting background process SMCO SMCO started with pid=26, OS id=4796 Database Characterset is US7ASCII Checker run found 2 new persistent data failures 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) AQ Processes can not start in restrict mode LOGSTDBY: Validating controlfile with logical metadata LOGSTDBY: Validation complete Global Name changed to ORCL Starting background process CJQ0 CJQ0 started with pid=25, OS id=1192 Completed: alter database "orcl" open resetlogs alter database rename global_name to "orcl" Completed: alter database rename global_name to "orcl" ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\app\oracle\oradata\orcl\TEMP01.DBF' SIZE 65536K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\app\oracle\oradata\orcl\TEMP01.DBF' SIZE 65536K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED ALTER DATABASE DEFAULT TABLESPACE "USERS" Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS" Sun Nov 29 22:05:05 2015 Full restore complete of datafile 2 to datafile copy C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF. Elapsed time: 0:00:10 checkpoint is 2234509 last deallocation scn is 2190278 Undo Optimization current scn is 1836140 Full restore complete of datafile 4 to datafile copy C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSAUX01.DBF. Elapsed time: 0:00:19 checkpoint is 2234509 last deallocation scn is 1886529 create pluggable database PDB$SEED as clone using 'C:\app\oracle\product\12.1.0\dbhome_1\assistants\dbca\templates\\pdbseed.xml' source_file_name_convert = ('C:\ADE\AIME_V\ORACLE\ORADATA\SEEDDATA\PDBSEED\TEMP01.DBF','C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\pdbseed_temp01.dbf', 'C:\ADE\AIME_V\ORACLE\ORADATA\SEEDDATA\PDBSEED\SYSTEM01.DBF','C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF', 'C:\ADE\AIME_V\ORACLE\ORADATA\SEEDDATA\PDBSEED\SYSAUX01.DBF','C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSAUX01.DBF') NOCOPY Sun Nov 29 22:05:21 2015 **************************************************************** Pluggable Database PDB$SEED with pdb id - 2 is created as UNUSABLE. If any errors are encountered before the pdb is marked as NEW, then the pdb must be dropped **************************************************************** Database Characterset is US7ASCII Deleting old file#2 from file$ Deleting old file#4 from file$ Adding new file#2 to file$(old file#2) Adding new file#4 to file$(old file#4) ALTER SYSTEM: Flushing buffer cache inst=0 container=2 local **************************************************************** Post plug operations are now complete. Pluggable database PDB$SEED with pdb id - 2 is now marked as NEW. **************************************************************** Completed: create pluggable database PDB$SEED as clone using 'C:\app\oracle\product\12.1.0\dbhome_1\assistants\dbca\templates\\pdbseed.xml' source_file_name_convert = ('C:\ADE\AIME_V\ORACLE\ORADATA\SEEDDATA\PDBSEED\TEMP01.DBF','C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\pdbseed_temp01.dbf', 'C:\ADE\AIME_V\ORACLE\ORADATA\SEEDDATA\PDBSEED\SYSTEM01.DBF','C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF', 'C:\ADE\AIME_V\ORACLE\ORADATA\SEEDDATA\PDBSEED\SYSAUX01.DBF','C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSAUX01.DBF') NOCOPY alter pluggable database PDB$SEED open restricted Pluggable database PDB$SEED dictionary check beginning Pluggable Database PDB$SEED Dictionary check complete Database Characterset is US7ASCII Opening pdb PDB$SEED (2) with no Resource Manager plan active XDB installed. XDB initialized. Pluggable database PDB$SEED opened read write Completed: alter pluggable database PDB$SEED open restricted Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Stopping background process MMNL Stopping background process CJQ0 Stopping background process MMON License high water mark = 4 Sun Nov 29 22:05:25 2015 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL Sun Nov 29 22:05:25 2015 SMON: disabling tx recovery Sun Nov 29 22:05:25 2015 Stopping Emon pool Stopping Emon pool Sun Nov 29 22:05:25 2015 SMON: disabling cache recovery Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sun Nov 29 22:05:25 2015 Thread 1 closed at log sequence 1 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 Sun Nov 29 22:05:26 2015 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 Sun Nov 29 22:05:27 2015 Stopping background process VKTM Instance shutdown complete Starting ORACLE instance (restrict) Sun Nov 29 22:05:43 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:12820M/16262M, Ph+PgF:25350M/32522M Using parameter settings in client-side pfile C:\APP\ORACLE\CFGTOOLLOGS\DBCA\ORCL\INITORCLTEMP.ORA on machine ALEXEY-PC System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M _no_recovery_through_resetlogs= TRUE undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 _enable_automatic_maintenance= 0 diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=1444 Starting background process PSP0 PSP0 started with pid=3, OS id=2840 Starting background process VKTM Starting background process GEN0 Starting background process MMAN MMAN started with pid=6, OS id=2912 Starting background process DIAG DIAG started with pid=7, OS id=2240 Starting background process DBRM DBRM started with pid=8, OS id=3160 Starting background process DIA0 DIA0 started with pid=9, OS id=4616 Starting background process DBW0 DBW0 started with pid=10, OS id=1980 Starting background process LGWR LGWR started with pid=11, OS id=760 Starting background process CKPT CKPT started with pid=12, OS id=3860 Starting background process SMON SMON started with pid=15, OS id=3372 Starting background process RECO RECO started with pid=16, OS id=2936 Starting background process LREG LREG started with pid=17, OS id=2660 Starting background process MMON MMON started with pid=18, OS id=5100 Starting background process MMNL MMNL started with pid=19, OS id=3000 Sun Nov 29 22:05:46 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... VKTM started with pid=4, OS id=2492 at elevated priority Sun Nov 29 22:05:46 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=664 ORACLE_BASE from environment = C:\app\oracle ALTER DATABASE MOUNT Sun Nov 29 22:05:49 2015 Using default pga_aggregate_limit of 5216 MB Sun Nov 29 22:05:51 2015 Changing di2dbun from to orcl Sun Nov 29 22:05:51 2015 Successful mount of redo thread 1, with mount id 1424880189 Sun Nov 29 22:05:51 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: ALTER DATABASE MOUNT ALTER DATABASE OPEN Starting background process TMON TMON started with pid=23, OS id=2620 Sun Nov 29 22:05:51 2015 Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Successful open of redo thread 1 Sun Nov 29 22:05:51 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Nov 29 22:05:51 2015 SMON: enabling cache recovery Sun Nov 29 22:05:51 2015 [1056] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:661179 end:661241 diff:62 ms (0.1 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Sun Nov 29 22:05:51 2015 SMON: enabling tx recovery Starting background process SMCO Sun Nov 29 22:05:51 2015 Database Characterset is US7ASCII SMCO started with pid=25, OS id=348 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) AQ Processes can not start in restrict mode Database Characterset is US7ASCII Opening pdb PDB$SEED (2) with no Resource Manager plan active Starting background process CJQ0 CJQ0 started with pid=27, OS id=4396 Completed: ALTER DATABASE OPEN alter database character set INTERNAL_CONVERT CL8MSWIN1251 Sun Nov 29 22:06:02 2015 Updating character set in controlfile to CL8MSWIN1251 Synchronizing connection with database character set information Refreshing type attributes with new character set information Sun Nov 29 22:06:03 2015 Thread 1 advanced to log sequence 2 (LGWR switch) Current log# 2 seq# 2 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG Completed: alter database character set INTERNAL_CONVERT CL8MSWIN1251 Sun Nov 29 22:06:04 2015 ALTER SYSTEM disable restricted session; Starting background process AQPC AQPC started with pid=31, OS id=936 WARNING: AQ 12C time manager not started, no enabled queue alter pluggable database PDB$SEED CLOSE IMMEDIATE Sun Nov 29 22:06:04 2015 ALTER SYSTEM: Flushing buffer cache inst=0 container=2 local Pluggable database PDB$SEED closed Completed: alter pluggable database PDB$SEED CLOSE IMMEDIATE alter pluggable database PDB$SEED OPEN Database Characterset is US7ASCII Sun Nov 29 22:06:05 2015 db_recovery_file_dest_size of 6930 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. Sun Nov 29 22:06:07 2015 Thread 1 cannot allocate new log, sequence 3 Private strand flush not complete Current log# 2 seq# 2 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG Sun Nov 29 22:06:07 2015 Refreshing type attributes with new character set information TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P188 (2159) VALUES LESS THAN (TO_DATE(' 2015-11-30 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P189 (2159) VALUES LESS THAN (TO_DATE(' 2015-11-30 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P192 (2158) VALUES LESS THAN (TO_DATE(' 2015-11-29 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) Sun Nov 29 22:06:07 2015 Thread 1 advanced to log sequence 3 (LGWR switch) Current log# 3 seq# 3 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG Sun Nov 29 22:06:08 2015 Opening pdb PDB$SEED (2) with no Resource Manager plan active Pluggable database PDB$SEED opened read write Completed: alter pluggable database PDB$SEED OPEN Sun Nov 29 22:06:38 2015 SERVER COMPONENT id=UTLRP_BGN: timestamp=2015-11-29 22:06:38 TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P193 (42336) VALUES LESS THAN (TO_DATE(' 2015-11-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SERVER COMPONENT id=UTLRP_END: timestamp=2015-11-29 22:06:39 XDB installed. XDB initialized. Sun Nov 29 22:06:46 2015 Thread 1 cannot allocate new log, sequence 4 Checkpoint not complete Current log# 3 seq# 3 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG Sun Nov 29 22:06:46 2015 SERVER COMPONENT id=UTLRP_BGN: timestamp=2015-11-29 22:06:46 TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P201 (42336) VALUES LESS THAN (TO_DATE(' 2015-11-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SERVER COMPONENT id=UTLRP_END: timestamp=2015-11-29 22:06:48 Sun Nov 29 22:06:49 2015 Thread 1 advanced to log sequence 4 (LGWR switch) Current log# 1 seq# 4 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Sun Nov 29 22:06:50 2015 XDB installed. XDB initialized. Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Stopping background process CJQ0 Stopping background process MMNL Stopping background process MMON License high water mark = 37 Sun Nov 29 22:06:59 2015 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL Sun Nov 29 22:06:59 2015 SMON: disabling tx recovery Sun Nov 29 22:06:59 2015 Stopping Emon pool Stopping Emon pool Sun Nov 29 22:07:00 2015 SMON: disabling cache recovery Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sun Nov 29 22:07:00 2015 Thread 1 closed at log sequence 4 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 Sun Nov 29 22:07:01 2015 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 Sun Nov 29 22:07:03 2015 Stopping background process VKTM Instance shutdown complete WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Sun Nov 29 22:07:24 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:13423M/16262M, Ph+PgF:25539M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=3256 Starting background process PSP0 PSP0 started with pid=3, OS id=1916 Starting background process VKTM Starting background process GEN0 Starting background process MMAN GEN0 started with pid=5, OS id=4932 MMAN started with pid=6, OS id=1312 Starting background process DIAG Starting background process DBRM DIAG started with pid=8, OS id=3164 Starting background process DIA0 DBRM started with pid=9, OS id=1248 Starting background process DBW0 DIA0 started with pid=10, OS id=5088 DBW0 started with pid=11, OS id=2768 Starting background process LGWR LGWR started with pid=12, OS id=2340 Starting background process CKPT CKPT started with pid=13, OS id=4520 Starting background process SMON SMON started with pid=15, OS id=2952 Starting background process RECO RECO started with pid=17, OS id=5044 Starting background process LREG LREG started with pid=18, OS id=840 Starting background process MMON MMON started with pid=19, OS id=920 Starting background process MMNL MMNL started with pid=20, OS id=3260 Sun Nov 29 22:07:26 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle ALTER DATABASE MOUNT VKTM started with pid=4, OS id=4580 at elevated priority Sun Nov 29 22:07:27 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms Sun Nov 29 22:07:29 2015 Using default pga_aggregate_limit of 5216 MB Sun Nov 29 22:07:30 2015 Successful mount of redo thread 1, with mount id 1424898976 Sun Nov 29 22:07:30 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: ALTER DATABASE MOUNT ALTER DATABASE OPEN Starting background process TMON TMON started with pid=23, OS id=4556 Sun Nov 29 22:07:30 2015 Thread 1 opened at log sequence 4 Current log# 1 seq# 4 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Successful open of redo thread 1 Sun Nov 29 22:07:30 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Nov 29 22:07:30 2015 SMON: enabling cache recovery Sun Nov 29 22:07:30 2015 [956] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:760504 end:760567 diff:63 ms (0.1 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Sun Nov 29 22:07:30 2015 SMON: enabling tx recovery Starting background process SMCO Sun Nov 29 22:07:30 2015 Database Characterset is CL8MSWIN1251 SMCO started with pid=25, OS id=5112 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC AQPC started with pid=26, OS id=1332 Opening pdb PDB$SEED (2) with no Resource Manager plan active Sun Nov 29 22:07:39 2015 db_recovery_file_dest_size of 6930 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. Starting background process CJQ0 CJQ0 started with pid=28, OS id=2608 Completed: ALTER DATABASE OPEN Sun Nov 29 22:07:40 2015 XDB installed. XDB initialized. Sun Nov 29 22:07:41 2015 Thread 1 advanced to log sequence 5 (LGWR switch) Current log# 2 seq# 5 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG CREATE PLUGGABLE DATABASE pdborcl ADMIN USER PDBADMIN IDENTIFIED BY * ROLES=(CONNECT) file_name_convert=('C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF','C:\APP\ORACLE\ORADATA\ORCL\pdborcl\SYSTEM01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSAUX01.DBF','C:\APP\ORACLE\ORADATA\ORCL\pdborcl\SYSAUX01.DBF','C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\PDBSEED_TEMP01.DBF','C:\APP\ORACLE\ORADATA\ORCL\pdborcl\PDBSEED_TEMP01.DBF') Sun Nov 29 22:07:49 2015 **************************************************************** Pluggable Database PDBORCL with pdb id - 3 is created as UNUSABLE. If any errors are encountered before the pdb is marked as NEW, then the pdb must be dropped **************************************************************** Deleting old file#2 from file$ Deleting old file#4 from file$ Adding new file#7 to file$(old file#2) Adding new file#8 to file$(old file#4) Successfully created internal service pdborcl at open ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local **************************************************************** Post plug operations are now complete. Pluggable database PDBORCL with pdb id - 3 is now marked as NEW. **************************************************************** Completed: CREATE PLUGGABLE DATABASE pdborcl ADMIN USER PDBADMIN IDENTIFIED BY * ROLES=(CONNECT) file_name_convert=('C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF','C:\APP\ORACLE\ORADATA\ORCL\pdborcl\SYSTEM01.DBF', 'C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\SYSAUX01.DBF','C:\APP\ORACLE\ORADATA\ORCL\pdborcl\SYSAUX01.DBF','C:\APP\ORACLE\ORADATA\ORCL\PDBSEED\PDBSEED_TEMP01.DBF','C:\APP\ORACLE\ORADATA\ORCL\pdborcl\PDBSEED_TEMP01.DBF') alter pluggable database pdborcl open Pluggable database PDBORCL dictionary check beginning Pluggable Database PDBORCL Dictionary check complete Opening pdb PDBORCL (3) with no Resource Manager plan active XDB installed. XDB initialized. Pluggable database PDBORCL opened read write Completed: alter pluggable database pdborcl open CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE 'C:\APP\ORACLE\ORADATA\ORCL\pdborcl\pdborcl_users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE 'C:\APP\ORACLE\ORADATA\ORCL\pdborcl\pdborcl_users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ALTER DATABASE DEFAULT TABLESPACE "USERS" Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS" WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Sun Nov 29 22:10:33 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:14375M/16262M, Ph+PgF:26725M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=3260 Starting background process PSP0 Starting background process VKTM PSP0 started with pid=3, OS id=3264 VKTM started with pid=4, OS id=3288 at elevated priority Starting background process GEN0 Sun Nov 29 22:10:35 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=3292 Starting background process MMAN MMAN started with pid=6, OS id=3296 Starting background process DIAG DIAG started with pid=8, OS id=3304 Starting background process DBRM DBRM started with pid=9, OS id=3308 Starting background process DIA0 DIA0 started with pid=10, OS id=3312 Starting background process DBW0 DBW0 started with pid=11, OS id=3316 Starting background process LGWR LGWR started with pid=12, OS id=3320 Starting background process CKPT CKPT started with pid=15, OS id=3332 Starting background process SMON SMON started with pid=16, OS id=3336 Starting background process RECO Starting background process LREG RECO started with pid=17, OS id=3340 Starting background process MMON LREG started with pid=18, OS id=3344 Starting background process MMNL MMON started with pid=19, OS id=3348 Sun Nov 29 22:10:35 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=20, OS id=3352 starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle alter database mount exclusive Sun Nov 29 22:10:38 2015 Using default pga_aggregate_limit of 5216 MB Sun Nov 29 22:10:39 2015 Successful mount of redo thread 1, with mount id 1424849757 Sun Nov 29 22:10:39 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: alter database mount exclusive alter database open Sun Nov 29 22:10:39 2015 Beginning crash recovery of 1 threads parallel recovery started with 3 processes Sun Nov 29 22:10:39 2015 Started redo scan Sun Nov 29 22:10:40 2015 Completed redo scan read 19581 KB redo, 2461 data blocks need recovery Sun Nov 29 22:10:40 2015 Started redo application at Thread 1: logseq 4, block 28554 Sun Nov 29 22:10:40 2015 Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0 Mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Sun Nov 29 22:10:40 2015 Recovery of Online Redo Log: Thread 1 Group 2 Seq 5 Reading mem 0 Mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG Sun Nov 29 22:10:40 2015 Completed redo application of 16.74MB Sun Nov 29 22:10:40 2015 Completed crash recovery at Thread 1: logseq 5, block 3569, scn 2272784 2461 data blocks read, 2461 data blocks written, 19581 redo k-bytes read Starting background process TMON TMON started with pid=26, OS id=3404 Sun Nov 29 22:10:40 2015 Thread 1 advanced to log sequence 6 (thread open) Thread 1 opened at log sequence 6 Current log# 3 seq# 6 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG Successful open of redo thread 1 Sun Nov 29 22:10:40 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Nov 29 22:10:40 2015 SMON: enabling cache recovery Sun Nov 29 22:10:40 2015 [3372] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:20389 end:20498 diff:109 ms (0.1 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Sun Nov 29 22:10:40 2015 SMON: enabling tx recovery Starting background process SMCO Sun Nov 29 22:10:40 2015 Database Characterset is CL8MSWIN1251 SMCO started with pid=28, OS id=3456 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC AQPC started with pid=29, OS id=3468 Opening pdb PDB$SEED (2) with no Resource Manager plan active Sun Nov 29 22:10:49 2015 db_recovery_file_dest_size of 6930 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. Starting background process CJQ0 CJQ0 started with pid=31, OS id=3588 Completed: alter database open Sun Nov 29 22:16:38 2015 ALTER SYSTEM SET max_string_size='extended' SCOPE=SPFILE; Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Stopping background process CJQ0 Stopping background process MMNL Stopping background process MMON License high water mark = 6 Sun Nov 29 22:16:41 2015 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL Sun Nov 29 22:16:41 2015 SMON: disabling tx recovery Sun Nov 29 22:16:41 2015 Stopping Emon pool Stopping Emon pool Sun Nov 29 22:16:41 2015 SMON: disabling cache recovery Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sun Nov 29 22:16:41 2015 Thread 1 closed at log sequence 6 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 Sun Nov 29 22:16:42 2015 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 Sun Nov 29 22:16:44 2015 Stopping background process VKTM Instance shutdown complete WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Sun Nov 29 22:16:56 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:13168M/16262M, Ph+PgF:25898M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 max_string_size = "EXTENDED" diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=5064 Starting background process PSP0 PSP0 started with pid=3, OS id=4992 Starting background process VKTM VKTM started with pid=4, OS id=3876 at elevated priority Starting background process GEN0 Sun Nov 29 22:16:58 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=3020 Starting background process MMAN MMAN started with pid=6, OS id=984 Starting background process DIAG DIAG started with pid=8, OS id=1804 Starting background process DBRM DBRM started with pid=9, OS id=1296 Starting background process DIA0 DIA0 started with pid=10, OS id=2840 Starting background process DBW0 DBW0 started with pid=11, OS id=4000 Starting background process LGWR LGWR started with pid=12, OS id=3952 Starting background process CKPT CKPT started with pid=15, OS id=3540 Starting background process SMON SMON started with pid=16, OS id=2396 Starting background process RECO RECO started with pid=17, OS id=4216 Starting background process LREG LREG started with pid=18, OS id=4940 Starting background process MMON Starting background process MMNL MMON started with pid=19, OS id=4732 MMNL started with pid=20, OS id=480 Sun Nov 29 22:16:58 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle ALTER DATABASE MOUNT Sun Nov 29 22:17:01 2015 Using default pga_aggregate_limit of 5216 MB Sun Nov 29 22:17:02 2015 Successful mount of redo thread 1, with mount id 1424879068 Sun Nov 29 22:17:02 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: ALTER DATABASE MOUNT ALTER DATABASE OPEN MIGRATE Starting background process TMON TMON started with pid=23, OS id=4672 Sun Nov 29 22:17:02 2015 Thread 1 opened at log sequence 6 Current log# 3 seq# 6 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG Successful open of redo thread 1 Sun Nov 29 22:17:02 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Nov 29 22:17:02 2015 SMON: enabling cache recovery Sun Nov 29 22:17:02 2015 [5112] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:402622 end:402654 diff:32 ms (0.0 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Sun Nov 29 22:17:02 2015 SMON: enabling tx recovery Sun Nov 29 22:17:02 2015 Database Characterset is CL8MSWIN1251 Stopping background process MMNL Stopping background process MMON Starting background process MMON MMON started with pid=19, OS id=4528 Starting background process MMNL MMNL started with pid=20, OS id=5040 Stopping Emon pool Sun Nov 29 22:17:05 2015 ALTER SYSTEM enable restricted session; Sun Nov 29 22:17:05 2015 ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; Autotune of undo retention is turned off. Sun Nov 29 22:17:05 2015 ALTER SYSTEM SET _undo_autotune=FALSE SCOPE=MEMORY; Sun Nov 29 22:17:05 2015 ALTER SYSTEM SET undo_retention=900 SCOPE=MEMORY; Sun Nov 29 22:17:05 2015 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; Sun Nov 29 22:17:05 2015 ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=MEMORY; Resource Manager disabled during database migration: plan '' not set Sun Nov 29 22:17:05 2015 ALTER SYSTEM SET resource_manager_plan= SCOPE=MEMORY; Sun Nov 29 22:17:05 2015 ALTER SYSTEM SET recyclebin='OFF' DEFERRED SCOPE=MEMORY; Resource Manager disabled during database migration replication_dependency_tracking turned off (no async multimaster replication found) AQ Processes can not start in restrict mode Starting background process CJQ0 CJQ0 started with pid=25, OS id=4476 Completed: ALTER DATABASE OPEN MIGRATE SERVER COMPONENT id=UTLRP_BGN: timestamp=2015-11-29 22:17:14 Sun Nov 29 22:17:15 2015 SERVER COMPONENT id=UTLRP_END: timestamp=2015-11-29 22:17:15 XDB installed. XDB initialized. SERVER COMPONENT id=UTLRP_BGN: timestamp=2015-11-29 22:17:22 SERVER COMPONENT id=UTLRP_END: timestamp=2015-11-29 22:17:23 XDB installed. XDB initialized. Sun Nov 29 22:17:28 2015 Thread 1 advanced to log sequence 7 (LGWR switch) Current log# 1 seq# 7 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Shutting down instance (immediate) Shutting down instance: further logons disabled Stopping background process CJQ0 Stopping background process MMNL Stopping background process MMON License high water mark = 17 Sun Nov 29 22:17:32 2015 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL Sun Nov 29 22:17:32 2015 SMON: disabling tx recovery Sun Nov 29 22:17:32 2015 Stopping Emon pool Stopping Emon pool Sun Nov 29 22:17:33 2015 SMON: disabling cache recovery Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sun Nov 29 22:17:33 2015 Thread 1 closed at log sequence 7 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 Sun Nov 29 22:17:34 2015 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 Sun Nov 29 22:17:36 2015 Stopping background process VKTM Instance shutdown complete WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Sun Nov 29 22:17:47 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:13228M/16262M, Ph+PgF:25908M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 max_string_size = "EXTENDED" diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON Starting background process PSP0 PMON started with pid=2, OS id=2000 PSP0 started with pid=3, OS id=4812 Starting background process VKTM VKTM started with pid=4, OS id=1284 at elevated priority Starting background process GEN0 Sun Nov 29 22:17:49 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=4708 Starting background process MMAN MMAN started with pid=6, OS id=2024 Starting background process DIAG DIAG started with pid=8, OS id=4644 Starting background process DBRM DBRM started with pid=9, OS id=3232 Starting background process DIA0 DIA0 started with pid=10, OS id=4712 Starting background process DBW0 DBW0 started with pid=11, OS id=4384 Starting background process LGWR LGWR started with pid=12, OS id=364 Starting background process CKPT CKPT started with pid=13, OS id=3636 Starting background process SMON SMON started with pid=15, OS id=4784 Starting background process RECO Starting background process LREG RECO started with pid=17, OS id=4080 LREG started with pid=18, OS id=2624 Starting background process MMON MMON started with pid=19, OS id=4328 Starting background process MMNL MMNL started with pid=20, OS id=1944 Sun Nov 29 22:17:49 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle ALTER DATABASE MOUNT Sun Nov 29 22:17:52 2015 Using default pga_aggregate_limit of 5216 MB Sun Nov 29 22:17:54 2015 Successful mount of redo thread 1, with mount id 1424873998 Sun Nov 29 22:17:54 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: ALTER DATABASE MOUNT ALTER DATABASE OPEN Starting background process TMON TMON started with pid=23, OS id=2020 Sun Nov 29 22:17:54 2015 Thread 1 opened at log sequence 7 Current log# 1 seq# 7 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Successful open of redo thread 1 Sun Nov 29 22:17:54 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Nov 29 22:17:54 2015 SMON: enabling cache recovery Sun Nov 29 22:17:54 2015 [3192] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:454009 end:454072 diff:63 ms (0.1 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Sun Nov 29 22:17:54 2015 SMON: enabling tx recovery Starting background process SMCO Sun Nov 29 22:17:54 2015 Database Characterset is CL8MSWIN1251 SMCO started with pid=25, OS id=468 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC AQPC started with pid=26, OS id=3932 Opening pdb PDB$SEED (2) with no Resource Manager plan active Sun Nov 29 22:18:03 2015 db_recovery_file_dest_size of 6930 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. Starting background process CJQ0 CJQ0 started with pid=28, OS id=4636 Completed: ALTER DATABASE OPEN create pluggable database ULTIMA2C using 'c:\app\oracle\oradata\ultima2c\ultima2c_win.xml' nocopy tempfile reuse Sun Nov 29 22:18:03 2015 **************************************************************** Pluggable Database ULTIMA2C with pdb id - 4 is created as UNUSABLE. If any errors are encountered before the pdb is marked as NEW, then the pdb must be dropped **************************************************************** Sun Nov 29 22:18:03 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_5088.trc: ORA-00900: invalid SQL statement Pluggable database ULTIMA2C hit error 704 during open read write and will be closed. ALTER SYSTEM: Flushing buffer cache inst=0 container=4 local ORA-704 signalled during: create pluggable database ULTIMA2C using 'c:\app\oracle\oradata\ultima2c\ultima2c_win.xml' nocopy tempfile reuse... alter pluggable database ULTIMA2C open ORA-65104 signalled during: alter pluggable database ULTIMA2C open... WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Sun Nov 29 22:22:28 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:14377M/16262M, Ph+PgF:26728M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 max_string_size = "EXTENDED" diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=3268 Starting background process PSP0 PSP0 started with pid=3, OS id=3272 Starting background process VKTM VKTM started with pid=4, OS id=3284 at elevated priority Starting background process GEN0 Sun Nov 29 22:22:30 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=3288 Starting background process MMAN MMAN started with pid=6, OS id=3292 Starting background process DIAG DIAG started with pid=8, OS id=3300 Starting background process DBRM DBRM started with pid=9, OS id=3304 Starting background process DIA0 DIA0 started with pid=10, OS id=3308 Starting background process DBW0 DBW0 started with pid=11, OS id=3312 Starting background process LGWR LGWR started with pid=12, OS id=3316 Starting background process CKPT CKPT started with pid=15, OS id=3328 Starting background process SMON SMON started with pid=16, OS id=3332 Starting background process RECO RECO started with pid=17, OS id=3336 Starting background process LREG LREG started with pid=18, OS id=3340 Starting background process MMON MMON started with pid=19, OS id=3344 Starting background process MMNL MMNL started with pid=20, OS id=3348 Sun Nov 29 22:22:30 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle alter database mount exclusive Sun Nov 29 22:22:33 2015 Using default pga_aggregate_limit of 5216 MB Sun Nov 29 22:22:34 2015 Successful mount of redo thread 1, with mount id 1424878120 Sun Nov 29 22:22:34 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: alter database mount exclusive alter database open Sun Nov 29 22:22:34 2015 Beginning crash recovery of 1 threads parallel recovery started with 3 processes Sun Nov 29 22:22:34 2015 Started redo scan Sun Nov 29 22:22:34 2015 Completed redo scan read 322 KB redo, 136 data blocks need recovery Sun Nov 29 22:22:34 2015 Started redo application at Thread 1: logseq 7, block 11439 Sun Nov 29 22:22:34 2015 Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0 Mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Sun Nov 29 22:22:34 2015 Completed redo application of 0.24MB Sun Nov 29 22:22:34 2015 Completed crash recovery at Thread 1: logseq 7, block 12084, scn 2045111954 136 data blocks read, 136 data blocks written, 322 redo k-bytes read Starting background process TMON TMON started with pid=26, OS id=3412 Sun Nov 29 22:22:34 2015 Thread 1 advanced to log sequence 8 (thread open) Thread 1 opened at log sequence 8 Current log# 2 seq# 8 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG Successful open of redo thread 1 Sun Nov 29 22:22:34 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Nov 29 22:22:34 2015 SMON: enabling cache recovery Sun Nov 29 22:22:35 2015 [3368] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:19281 end:19375 diff:94 ms (0.1 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Sun Nov 29 22:22:35 2015 SMON: enabling tx recovery Starting background process SMCO Sun Nov 29 22:22:35 2015 Database Characterset is CL8MSWIN1251 SMCO started with pid=28, OS id=3420 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC AQPC started with pid=29, OS id=3468 Opening pdb PDB$SEED (2) with no Resource Manager plan active Sun Nov 29 22:22:44 2015 db_recovery_file_dest_size of 6930 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. ALTER PLUGGABLE DATABASE ALL OPEN Sun Nov 29 22:22:44 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p001_3404.trc: ORA-65104: cannot open or close the pluggable database Sun Nov 29 22:22:45 2015 Pluggable database PDBORCL hit error 14694 during open read write and will be closed. ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local Sun Nov 29 22:22:45 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p000_3400.trc: ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-14694 signalled during: ALTER PLUGGABLE DATABASE ALL OPEN... Sun Nov 29 22:22:45 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_3368.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-06512: at line 2 Starting background process CJQ0 CJQ0 started with pid=52, OS id=3628 Completed: alter database open Sun Nov 29 23:00:25 2015 Shared IO Pool defaulting to 208MB. Trying to get it from Buffer Cache for process 4364. Mon Nov 30 04:22:54 2015 TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P208 (2160) VALUES LESS THAN (TO_DATE(' 2015-12-01 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P209 (2160) VALUES LESS THAN (TO_DATE(' 2015-12-01 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P212 (2159) VALUES LESS THAN (TO_DATE(' 2015-11-30 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) Mon Nov 30 06:00:23 2015 Thread 1 advanced to log sequence 9 (LGWR switch) Current log# 3 seq# 9 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG Mon Nov 30 08:00:55 2015 TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P213 (42337) VALUES LESS THAN (TO_DATE(' 2015-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) Mon Nov 30 08:02:32 2015 Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Mon Nov 30 08:02:34 2015 Stopping background process CJQ0 Stopping background process MMNL Stopping background process MMON License high water mark = 9 Mon Nov 30 08:02:36 2015 All dispatchers and shared servers shutdown alter database close normal Mon Nov 30 08:02:42 2015 Stopping Emon pool Mon Nov 30 08:02:42 2015 SMON: disabling tx recovery Stopping Emon pool Mon Nov 30 08:02:42 2015 SMON: disabling cache recovery Mon Nov 30 08:02:42 2015 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Mon Nov 30 08:02:42 2015 Thread 1 closed at log sequence 9 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 Mon Nov 30 08:02:43 2015 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 Mon Nov 30 08:02:45 2015 Stopping background process VKTM Archiving is disabled Mon Nov 30 08:02:47 2015 Instance shutdown complete Mon Nov 30 08:02:55 2015 WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Mon Nov 30 08:02:55 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:10294M/16262M, Ph+PgF:22534M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 max_string_size = "EXTENDED" diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON Mon Nov 30 08:02:56 2015 PMON started with pid=2, OS id=2636 Starting background process PSP0 Mon Nov 30 08:02:56 2015 PSP0 started with pid=3, OS id=5556 Starting background process VKTM Mon Nov 30 08:02:57 2015 VKTM started with pid=4, OS id=4484 at elevated priority Starting background process GEN0 Mon Nov 30 08:02:57 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms Mon Nov 30 08:02:57 2015 GEN0 started with pid=5, OS id=6056 Starting background process MMAN Mon Nov 30 08:02:57 2015 MMAN started with pid=6, OS id=5204 Starting background process DIAG Mon Nov 30 08:02:57 2015 DIAG started with pid=8, OS id=2748 Starting background process DBRM Mon Nov 30 08:02:57 2015 DBRM started with pid=9, OS id=156 Starting background process DIA0 Mon Nov 30 08:02:57 2015 DIA0 started with pid=10, OS id=3424 Starting background process DBW0 Mon Nov 30 08:02:57 2015 DBW0 started with pid=11, OS id=4628 Starting background process LGWR Mon Nov 30 08:02:57 2015 LGWR started with pid=12, OS id=1128 Starting background process CKPT Mon Nov 30 08:02:57 2015 CKPT started with pid=13, OS id=5128 Starting background process SMON Mon Nov 30 08:02:57 2015 SMON started with pid=15, OS id=2728 Starting background process RECO Mon Nov 30 08:02:57 2015 RECO started with pid=17, OS id=5348 Starting background process LREG Mon Nov 30 08:02:57 2015 LREG started with pid=18, OS id=3032 Starting background process MMON Mon Nov 30 08:02:57 2015 MMON started with pid=19, OS id=1908 Starting background process MMNL Mon Nov 30 08:02:57 2015 MMNL started with pid=20, OS id=2472 Mon Nov 30 08:02:57 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle Mon Nov 30 08:02:57 2015 alter database mount exclusive Mon Nov 30 08:03:00 2015 Using default pga_aggregate_limit of 5216 MB Mon Nov 30 08:03:01 2015 Successful mount of redo thread 1, with mount id 1424841010 Mon Nov 30 08:03:01 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: alter database mount exclusive alter database open Starting background process TMON Mon Nov 30 08:03:01 2015 TMON started with pid=7, OS id=4908 Mon Nov 30 08:03:01 2015 Thread 1 opened at log sequence 9 Current log# 3 seq# 9 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG Successful open of redo thread 1 Mon Nov 30 08:03:01 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Nov 30 08:03:01 2015 SMON: enabling cache recovery Mon Nov 30 08:03:01 2015 [1880] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:34846052 end:34846114 diff:62 ms (0.1 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Mon Nov 30 08:03:01 2015 SMON: enabling tx recovery Starting background process SMCO Mon Nov 30 08:03:01 2015 Database Characterset is CL8MSWIN1251 Mon Nov 30 08:03:01 2015 SMCO started with pid=25, OS id=1648 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC Mon Nov 30 08:03:02 2015 AQPC started with pid=26, OS id=4832 Opening pdb PDB$SEED (2) with no Resource Manager plan active Mon Nov 30 08:03:10 2015 db_recovery_file_dest_size of 6930 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. ALTER PLUGGABLE DATABASE ALL OPEN Mon Nov 30 08:03:11 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p001_5564.trc: ORA-65104: cannot open or close the pluggable database Mon Nov 30 08:03:11 2015 Pluggable database PDBORCL hit error 14694 during open read write and will be closed. ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local Mon Nov 30 08:03:11 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p000_5008.trc: ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-14694 signalled during: ALTER PLUGGABLE DATABASE ALL OPEN... Mon Nov 30 08:03:11 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1880.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-06512: at line 2 Starting background process CJQ0 Mon Nov 30 08:03:11 2015 CJQ0 started with pid=47, OS id=984 Completed: alter database open Mon Nov 30 08:16:28 2015 Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Stopping background process CJQ0 Stopping background process MMNL Stopping background process MMON License high water mark = 7 Mon Nov 30 08:16:31 2015 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL Mon Nov 30 08:16:31 2015 SMON: disabling tx recovery Mon Nov 30 08:16:31 2015 Stopping Emon pool Stopping Emon pool Mon Nov 30 08:16:31 2015 SMON: disabling cache recovery Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Mon Nov 30 08:16:31 2015 Thread 1 closed at log sequence 9 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 Mon Nov 30 08:16:32 2015 ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Mon Nov 30 08:16:34 2015 Stopping background process VKTM Mon Nov 30 08:16:34 2015 ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Mon Nov 30 08:16:37 2015 Instance shutdown complete Mon Nov 30 08:16:48 2015 WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Mon Nov 30 08:16:48 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:10277M/16262M, Ph+PgF:22418M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 max_string_size = "EXTENDED" diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON Mon Nov 30 08:16:49 2015 PMON started with pid=2, OS id=5452 Starting background process PSP0 Mon Nov 30 08:16:49 2015 PSP0 started with pid=3, OS id=4108 Starting background process VKTM Mon Nov 30 08:16:50 2015 VKTM started with pid=4, OS id=1172 at elevated priority Starting background process GEN0 Mon Nov 30 08:16:50 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms Mon Nov 30 08:16:50 2015 GEN0 started with pid=5, OS id=5892 Starting background process MMAN Mon Nov 30 08:16:50 2015 MMAN started with pid=6, OS id=1288 Starting background process DIAG Mon Nov 30 08:16:50 2015 DIAG started with pid=8, OS id=5836 Starting background process DBRM Mon Nov 30 08:16:50 2015 DBRM started with pid=9, OS id=6124 Starting background process DIA0 Mon Nov 30 08:16:50 2015 DIA0 started with pid=10, OS id=4884 Starting background process DBW0 Mon Nov 30 08:16:50 2015 DBW0 started with pid=11, OS id=6104 Starting background process LGWR Mon Nov 30 08:16:50 2015 LGWR started with pid=12, OS id=1700 Starting background process CKPT Mon Nov 30 08:16:50 2015 CKPT started with pid=13, OS id=5316 Starting background process SMON Mon Nov 30 08:16:50 2015 SMON started with pid=16, OS id=3596 Starting background process RECO Mon Nov 30 08:16:50 2015 RECO started with pid=17, OS id=5464 Starting background process LREG Mon Nov 30 08:16:50 2015 LREG started with pid=18, OS id=4524 Starting background process MMON Mon Nov 30 08:16:50 2015 MMON started with pid=19, OS id=5684 Starting background process MMNL Mon Nov 30 08:16:51 2015 MMNL started with pid=7, OS id=5888 Mon Nov 30 08:16:51 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle Mon Nov 30 08:16:51 2015 ALTER DATABASE MOUNT Mon Nov 30 08:16:53 2015 Using default pga_aggregate_limit of 5216 MB Mon Nov 30 08:16:56 2015 Successful mount of redo thread 1, with mount id 1424844149 Mon Nov 30 08:16:56 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: ALTER DATABASE MOUNT Mon Nov 30 08:16:56 2015 ALTER DATABASE OPEN Starting background process TMON Mon Nov 30 08:16:56 2015 TMON started with pid=23, OS id=2740 Mon Nov 30 08:16:56 2015 Thread 1 opened at log sequence 9 Current log# 3 seq# 9 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG Successful open of redo thread 1 Mon Nov 30 08:16:56 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Nov 30 08:16:56 2015 SMON: enabling cache recovery Mon Nov 30 08:16:56 2015 [2000] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:35680392 end:35680455 diff:63 ms (0.1 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Mon Nov 30 08:16:56 2015 SMON: enabling tx recovery Starting background process SMCO Mon Nov 30 08:16:56 2015 Database Characterset is CL8MSWIN1251 Mon Nov 30 08:16:56 2015 SMCO started with pid=25, OS id=4592 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC Mon Nov 30 08:16:56 2015 AQPC started with pid=26, OS id=4668 Opening pdb PDB$SEED (2) with no Resource Manager plan active Mon Nov 30 08:17:05 2015 db_recovery_file_dest_size of 6930 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. ALTER PLUGGABLE DATABASE ALL OPEN Mon Nov 30 08:17:05 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p001_3472.trc: ORA-65104: cannot open or close the pluggable database Mon Nov 30 08:17:05 2015 Pluggable database PDBORCL hit error 14694 during open read write and will be closed. ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local Mon Nov 30 08:17:06 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p000_3316.trc: ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-14694 signalled during: ALTER PLUGGABLE DATABASE ALL OPEN... Mon Nov 30 08:17:06 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_2000.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-06512: at line 2 Starting background process CJQ0 Mon Nov 30 08:17:06 2015 CJQ0 started with pid=51, OS id=3488 Completed: ALTER DATABASE OPEN Mon Nov 30 08:27:07 2015 ALTER SYSTEM SET max_string_size='extended' SCOPE=SPFILE; Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Stopping background process MMNL Stopping background process CJQ0 Stopping background process MMON License high water mark = 7 Mon Nov 30 08:27:10 2015 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL Mon Nov 30 08:27:16 2015 SMON: disabling tx recovery Mon Nov 30 08:27:16 2015 Stopping Emon pool Stopping Emon pool Mon Nov 30 08:27:16 2015 SMON: disabling cache recovery Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Mon Nov 30 08:27:16 2015 Thread 1 closed at log sequence 9 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 Mon Nov 30 08:27:16 2015 ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Mon Nov 30 08:27:18 2015 Stopping background process VKTM Mon Nov 30 08:27:18 2015 ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Mon Nov 30 08:27:21 2015 Instance shutdown complete Mon Nov 30 08:27:30 2015 WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Mon Nov 30 08:27:30 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:10187M/16262M, Ph+PgF:22341M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 max_string_size = "EXTENDED" diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON Starting background process PSP0 Mon Nov 30 08:27:31 2015 PMON started with pid=2, OS id=3832 Mon Nov 30 08:27:31 2015 PSP0 started with pid=3, OS id=3800 Starting background process VKTM Mon Nov 30 08:27:32 2015 VKTM started with pid=4, OS id=744 at elevated priority Starting background process GEN0 Mon Nov 30 08:27:32 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms Mon Nov 30 08:27:32 2015 GEN0 started with pid=5, OS id=5956 Starting background process MMAN Mon Nov 30 08:27:32 2015 MMAN started with pid=6, OS id=4136 Starting background process DIAG Mon Nov 30 08:27:32 2015 DIAG started with pid=8, OS id=5036 Starting background process DBRM Mon Nov 30 08:27:32 2015 DBRM started with pid=9, OS id=3332 Starting background process DIA0 Mon Nov 30 08:27:32 2015 DIA0 started with pid=10, OS id=5948 Starting background process DBW0 Mon Nov 30 08:27:32 2015 DBW0 started with pid=11, OS id=5148 Starting background process LGWR Mon Nov 30 08:27:32 2015 LGWR started with pid=12, OS id=2012 Starting background process CKPT Mon Nov 30 08:27:32 2015 CKPT started with pid=13, OS id=5368 Starting background process SMON Mon Nov 30 08:27:32 2015 SMON started with pid=15, OS id=1320 Starting background process RECO Mon Nov 30 08:27:32 2015 RECO started with pid=17, OS id=3664 Starting background process LREG Mon Nov 30 08:27:32 2015 LREG started with pid=18, OS id=3520 Starting background process MMON Starting background process MMNL Mon Nov 30 08:27:32 2015 MMON started with pid=19, OS id=1384 Mon Nov 30 08:27:32 2015 MMNL started with pid=20, OS id=5008 Mon Nov 30 08:27:32 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle Mon Nov 30 08:27:32 2015 ALTER DATABASE MOUNT Mon Nov 30 08:27:35 2015 Using default pga_aggregate_limit of 5216 MB Mon Nov 30 08:27:36 2015 Successful mount of redo thread 1, with mount id 1424894454 Mon Nov 30 08:27:36 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: ALTER DATABASE MOUNT Mon Nov 30 08:27:36 2015 ALTER DATABASE OPEN MIGRATE Starting background process TMON Mon Nov 30 08:27:36 2015 TMON started with pid=23, OS id=3700 Mon Nov 30 08:27:36 2015 Thread 1 opened at log sequence 9 Current log# 3 seq# 9 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG Successful open of redo thread 1 Mon Nov 30 08:27:36 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Nov 30 08:27:36 2015 SMON: enabling cache recovery Mon Nov 30 08:27:36 2015 [3616] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:36321026 end:36321057 diff:31 ms (0.0 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Mon Nov 30 08:27:36 2015 SMON: enabling tx recovery Mon Nov 30 08:27:36 2015 Database Characterset is CL8MSWIN1251 Stopping background process MMNL Stopping background process MMON Starting background process MMON Mon Nov 30 08:27:39 2015 MMON started with pid=19, OS id=5824 Starting background process MMNL Mon Nov 30 08:27:39 2015 MMNL started with pid=20, OS id=568 Stopping Emon pool Mon Nov 30 08:27:39 2015 ALTER SYSTEM enable restricted session; Mon Nov 30 08:27:39 2015 ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; Autotune of undo retention is turned off. Mon Nov 30 08:27:39 2015 ALTER SYSTEM SET _undo_autotune=FALSE SCOPE=MEMORY; Mon Nov 30 08:27:39 2015 ALTER SYSTEM SET undo_retention=900 SCOPE=MEMORY; Mon Nov 30 08:27:39 2015 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; Mon Nov 30 08:27:39 2015 ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=MEMORY; Resource Manager disabled during database migration: plan '' not set Mon Nov 30 08:27:39 2015 ALTER SYSTEM SET resource_manager_plan= SCOPE=MEMORY; Mon Nov 30 08:27:39 2015 ALTER SYSTEM SET recyclebin='OFF' DEFERRED SCOPE=MEMORY; Resource Manager disabled during database migration replication_dependency_tracking turned off (no async multimaster replication found) AQ Processes can not start in restrict mode Starting background process CJQ0 Mon Nov 30 08:27:47 2015 CJQ0 started with pid=25, OS id=1880 Completed: ALTER DATABASE OPEN MIGRATE SERVER COMPONENT id=UTLRP_BGN: timestamp=2015-11-30 08:27:48 Mon Nov 30 08:27:49 2015 SERVER COMPONENT id=UTLRP_END: timestamp=2015-11-30 08:27:49 XDB installed. XDB initialized. SERVER COMPONENT id=UTLRP_BGN: timestamp=2015-11-30 08:27:56 TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P221 (42337) VALUES LESS THAN (TO_DATE(' 2015-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) Mon Nov 30 08:27:56 2015 Thread 1 advanced to log sequence 10 (LGWR switch) Current log# 1 seq# 10 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Mon Nov 30 08:27:57 2015 SERVER COMPONENT id=UTLRP_END: timestamp=2015-11-30 08:27:57 XDB installed. XDB initialized. Shutting down instance (immediate) Shutting down instance: further logons disabled Stopping background process CJQ0 Stopping background process MMNL Stopping background process MMON License high water mark = 17 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL Mon Nov 30 08:28:06 2015 Stopping Emon pool Stopping Emon pool Mon Nov 30 08:28:06 2015 SMON: disabling tx recovery Mon Nov 30 08:28:07 2015 SMON: disabling cache recovery Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Mon Nov 30 08:28:07 2015 Thread 1 closed at log sequence 10 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 Mon Nov 30 08:28:08 2015 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 Nov 30 08:28:10 2015 Stopping background process VKTM Mon Nov 30 08:28:12 2015 Instance shutdown complete Mon Nov 30 08:28:21 2015 WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Mon Nov 30 08:28:21 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:10182M/16262M, Ph+PgF:22344M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 max_string_size = "EXTENDED" diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON Mon Nov 30 08:28:22 2015 PMON started with pid=2, OS id=5512 Starting background process PSP0 Starting background process VKTM Mon Nov 30 08:28:23 2015 PSP0 started with pid=3, OS id=6012 Mon Nov 30 08:28:24 2015 VKTM started with pid=4, OS id=956 at elevated priority Starting background process GEN0 Mon Nov 30 08:28:24 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms Mon Nov 30 08:28:24 2015 GEN0 started with pid=5, OS id=4788 Starting background process MMAN Mon Nov 30 08:28:24 2015 MMAN started with pid=6, OS id=3044 Starting background process DIAG Mon Nov 30 08:28:24 2015 DIAG started with pid=8, OS id=5344 Starting background process DBRM Mon Nov 30 08:28:24 2015 DBRM started with pid=9, OS id=1876 Starting background process DIA0 Mon Nov 30 08:28:24 2015 DIA0 started with pid=10, OS id=5232 Starting background process DBW0 Mon Nov 30 08:28:24 2015 DBW0 started with pid=11, OS id=5324 Starting background process LGWR Mon Nov 30 08:28:24 2015 LGWR started with pid=12, OS id=3012 Starting background process CKPT Mon Nov 30 08:28:24 2015 CKPT started with pid=13, OS id=2036 Starting background process SMON Mon Nov 30 08:28:24 2015 SMON started with pid=16, OS id=3536 Starting background process RECO Mon Nov 30 08:28:25 2015 RECO started with pid=7, OS id=684 Starting background process LREG Mon Nov 30 08:28:25 2015 LREG started with pid=17, OS id=5612 Starting background process MMON Mon Nov 30 08:28:25 2015 MMON started with pid=18, OS id=4796 Starting background process MMNL Mon Nov 30 08:28:25 2015 MMNL started with pid=19, OS id=4528 Mon Nov 30 08:28:25 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle Mon Nov 30 08:28:25 2015 ALTER DATABASE MOUNT Mon Nov 30 08:28:27 2015 Using default pga_aggregate_limit of 5216 MB Mon Nov 30 08:28:29 2015 Successful mount of redo thread 1, with mount id 1424840235 Mon Nov 30 08:28:29 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: ALTER DATABASE MOUNT Mon Nov 30 08:28:30 2015 ALTER DATABASE OPEN Starting background process TMON Mon Nov 30 08:28:30 2015 TMON started with pid=23, OS id=3716 Mon Nov 30 08:28:30 2015 Thread 1 opened at log sequence 10 Current log# 1 seq# 10 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Successful open of redo thread 1 Mon Nov 30 08:28:30 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Nov 30 08:28:30 2015 SMON: enabling cache recovery Mon Nov 30 08:28:30 2015 [5484] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:36374378 end:36374441 diff:63 ms (0.1 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Mon Nov 30 08:28:30 2015 SMON: enabling tx recovery Starting background process SMCO Mon Nov 30 08:28:30 2015 Database Characterset is CL8MSWIN1251 Mon Nov 30 08:28:30 2015 SMCO started with pid=25, OS id=4248 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC Mon Nov 30 08:28:30 2015 AQPC started with pid=26, OS id=5460 Opening pdb PDB$SEED (2) with no Resource Manager plan active Mon Nov 30 08:28:39 2015 db_recovery_file_dest_size of 6930 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. ALTER PLUGGABLE DATABASE ALL OPEN Mon Nov 30 08:28:39 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p001_3200.trc: ORA-65104: cannot open or close the pluggable database Mon Nov 30 08:28:39 2015 Pluggable database PDBORCL hit error 14694 during open read write and will be closed. ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local Mon Nov 30 08:28:40 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p000_784.trc: ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-14694 signalled during: ALTER PLUGGABLE DATABASE ALL OPEN... Mon Nov 30 08:28:40 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_5484.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-06512: at line 2 Starting background process CJQ0 Mon Nov 30 08:28:40 2015 CJQ0 started with pid=51, OS id=5504 Completed: ALTER DATABASE OPEN Mon Nov 30 08:28:40 2015 create pluggable database ULTIMA2C using 'c:\app\oracle\oradata\ultima2c\ultima2c_win.xml' nocopy tempfile reuse ORA-65012 signalled during: create pluggable database ULTIMA2C using 'c:\app\oracle\oradata\ultima2c\ultima2c_win.xml' nocopy tempfile reuse... alter pluggable database ULTIMA2C open ORA-65104 signalled during: alter pluggable database ULTIMA2C open... Mon Nov 30 08:43:06 2015 alter pluggable database ultima2c open ORA-65104 signalled during: alter pluggable database ultima2c open... Mon Nov 30 09:00:35 2015 Shared IO Pool defaulting to 192MB. Trying to get it from Buffer Cache for process 3016. Mon Nov 30 09:10:30 2015 alter pluggable database ultima2c open ORA-65104 signalled during: alter pluggable database ultima2c open... Mon Nov 30 10:25:23 2015 alter pluggable database ultima2c open ORA-65104 signalled during: alter pluggable database ultima2c open... alter pluggable database all open Mon Nov 30 10:25:35 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p001_3200.trc: ORA-65104: cannot open or close the pluggable database Mon Nov 30 10:25:36 2015 Pluggable database PDBORCL hit error 14694 during open read write and will be closed. ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local Mon Nov 30 10:25:36 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p000_784.trc: ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-14694 signalled during: alter pluggable database all open... Mon Nov 30 12:13:27 2015 alter pluggable database all open Mon Nov 30 12:13:27 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p001_3200.trc: ORA-65104: cannot open or close the pluggable database Mon Nov 30 12:13:28 2015 Pluggable database PDBORCL hit error 14694 during open read write and will be closed. Immediate Kill Session#: 14, Serial#: 3 Immediate Kill Session: sess: 00000002DEC5F570 OS pid: 6136 Mon Nov 30 12:13:28 2015 opidrv aborting process J007 ospid (6136) as a result of ORA-28 Mon Nov 30 12:13:28 2015 ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local Mon Nov 30 12:13:28 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p000_784.trc: ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-14694 signalled during: alter pluggable database all open... alter pluggable database ultima2c open ORA-65104 signalled during: alter pluggable database ultima2c open... Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Mon Nov 30 12:13:49 2015 Stopping background process CJQ0 Stopping background process MMNL Stopping background process MMON License high water mark = 19 Mon Nov 30 12:13:51 2015 Stopping Job queue slave processes, flags = 7 Mon Nov 30 12:13:51 2015 Job queue slave processes stopped All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL Mon Nov 30 12:13:51 2015 Stopping Emon pool Mon Nov 30 12:13:51 2015 SMON: disabling tx recovery Stopping Emon pool Mon Nov 30 12:13:51 2015 SMON: disabling cache recovery Mon Nov 30 12:13:51 2015 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Mon Nov 30 12:13:51 2015 Thread 1 closed at log sequence 10 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 Mon Nov 30 12:13:52 2015 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 Nov 30 12:13:54 2015 Stopping background process VKTM Mon Nov 30 12:13:56 2015 Instance shutdown complete Mon Nov 30 12:14:13 2015 WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD) Starting ORACLE instance (normal) Mon Nov 30 12:14:13 2015 CLI notifier numLatches:7 maxDescs:519 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 4 Number of processor cores in the system is 2 Number of processor sockets in the system is 1 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting up: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1 Service Pack 1 CPU : 4 - type 8664, 2 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:9919M/16262M, Ph+PgF:22063M/32522M Using parameter settings in server-side spfile C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILEORCL.ORA System parameters with non-default values: processes = 300 memory_target = 6512M control_files = "C:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL" control_files = "C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL" db_block_size = 8192 compatible = "12.1.0.0.0" db_recovery_file_dest = "C:\app\oracle\fast_recovery_area" db_recovery_file_dest_size= 6930M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "C:\APP\ORACLE\ADMIN\ORCL\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 max_string_size = "EXTENDED" diagnostic_dest = "C:\APP\ORACLE" enable_pluggable_database= TRUE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON Mon Nov 30 12:14:14 2015 PMON started with pid=2, OS id=5164 Starting background process PSP0 Mon Nov 30 12:14:14 2015 PSP0 started with pid=3, OS id=5284 Starting background process VKTM Mon Nov 30 12:14:15 2015 VKTM started with pid=4, OS id=3896 at elevated priority Starting background process GEN0 Mon Nov 30 12:14:15 2015 VKTM running at (10)millisec precision with DBRM quantum (100)ms Mon Nov 30 12:14:15 2015 GEN0 started with pid=5, OS id=4416 Starting background process MMAN Mon Nov 30 12:14:15 2015 MMAN started with pid=6, OS id=2204 Starting background process DIAG Starting background process DBRM Mon Nov 30 12:14:16 2015 DIAG started with pid=8, OS id=5332 Mon Nov 30 12:14:16 2015 DBRM started with pid=9, OS id=1416 Starting background process DIA0 Starting background process DBW0 Mon Nov 30 12:14:16 2015 DIA0 started with pid=10, OS id=5236 Starting background process LGWR Mon Nov 30 12:14:16 2015 DBW0 started with pid=11, OS id=700 Mon Nov 30 12:14:16 2015 LGWR started with pid=12, OS id=3168 Starting background process CKPT Mon Nov 30 12:14:16 2015 CKPT started with pid=13, OS id=3708 Starting background process SMON Mon Nov 30 12:14:16 2015 SMON started with pid=15, OS id=3948 Starting background process RECO Mon Nov 30 12:14:16 2015 RECO started with pid=17, OS id=5524 Starting background process LREG Starting background process MMON Mon Nov 30 12:14:16 2015 LREG started with pid=18, OS id=6124 Mon Nov 30 12:14:16 2015 MMON started with pid=19, OS id=1360 Starting background process MMNL Mon Nov 30 12:14:16 2015 MMNL started with pid=20, OS id=5552 Mon Nov 30 12:14:16 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = C:\app\oracle Mon Nov 30 12:14:16 2015 ALTER DATABASE MOUNT Mon Nov 30 12:14:19 2015 Using default pga_aggregate_limit of 5216 MB Mon Nov 30 12:14:20 2015 Successful mount of redo thread 1, with mount id 1424913434 Mon Nov 30 12:14:20 2015 Database mounted in Exclusive Mode Lost write protection disabled Ping without log force is disabled. Completed: ALTER DATABASE MOUNT Mon Nov 30 12:14:20 2015 ALTER DATABASE OPEN Starting background process TMON Mon Nov 30 12:14:20 2015 TMON started with pid=23, OS id=4668 Mon Nov 30 12:14:20 2015 Thread 1 opened at log sequence 10 Current log# 1 seq# 10 mem# 0: C:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG Successful open of redo thread 1 Mon Nov 30 12:14:20 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Nov 30 12:14:20 2015 SMON: enabling cache recovery Mon Nov 30 12:14:21 2015 [5316] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:49925218 end:49925265 diff:47 ms (0.0 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Mon Nov 30 12:14:21 2015 SMON: enabling tx recovery Starting background process SMCO Mon Nov 30 12:14:21 2015 SMCO started with pid=25, OS id=616 Mon Nov 30 12:14:21 2015 Database Characterset is CL8MSWIN1251 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC Mon Nov 30 12:14:21 2015 AQPC started with pid=26, OS id=3660 Opening pdb PDB$SEED (2) with no Resource Manager plan active Mon Nov 30 12:14:30 2015 db_recovery_file_dest_size of 6930 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. ALTER PLUGGABLE DATABASE ALL OPEN Mon Nov 30 12:14:30 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p001_5140.trc: ORA-65104: cannot open or close the pluggable database Mon Nov 30 12:14:30 2015 Pluggable database PDBORCL hit error 14694 during open read write and will be closed. ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local Mon Nov 30 12:14:31 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_p000_1332.trc: ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-14694 signalled during: ALTER PLUGGABLE DATABASE ALL OPEN... Mon Nov 30 12:14:31 2015 Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_5316.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-14694: database must in UPGRADE mode to begin MAX_STRING_SIZE migration ORA-06512: at line 2 Starting background process CJQ0 Mon Nov 30 12:14:31 2015 CJQ0 started with pid=52, OS id=5944 Completed: ALTER DATABASE OPEN alter pluggable database ultima2c open ORA-65104 signalled during: alter pluggable database ultima2c open...