Creating a PDB with the XE 18c Database Assistant Configuration for Windows, the wizard marks 53% for more than an hour.
Check the file xe_vktm_6796.trc and this is its content:
Trace file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_vktm_6796.trc
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Build label: RDBMS_18.4.0.0.0DBRU_WINDOWS.X64_190202.XE
Windows NT Version V6.2
ORACLE_HOME = C:\app\ROBERTO\product\18.0.0\dbhomeXE
Node name : DESKTOP-804DEDA
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:5788M/7647M, Ph+PgF:6989M/11615M
Instance name: xe
Redo thread mounted by this instance: 0 <none>
Oracle process number: 5
Windows thread id: 6796, image: ORACLE.EXE (VKTM)
*** 2019-02-22T22:06:58.743978-05:00 (CDB$ROOT(1))
*** SESSION ID:(127.11392) 2019-02-22T22:06:58.743978-05:00
*** CLIENT ID:() 2019-02-22T22:06:58.743978-05:00
*** SERVICE NAME:() 2019-02-22T22:06:58.743978-05:00
*** MODULE NAME:() 2019-02-22T22:06:58.743978-05:00
*** ACTION NAME:() 2019-02-22T22:06:58.743978-05:00
*** CLIENT DRIVER:() 2019-02-22T22:06:58.743978-05:00
*** CONTAINER ID:(1) 2019-02-22T22:06:58.743978-05:00
kstmmainvktm: succeeded in setting elevated priority
highres_enabled
VKTM running at (5)millisec precision with DBRM quantum (100)ms
[Start] HighResTick = 176885920
kstmrmtickcnt = 0 : ksudbrmseccnt[0] = 1550891218
*** 2019-02-22T22:20:05.779470-05:00 (CDB$ROOT(1))
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (6126504)usec at (969905259) whereas (1000000) is allowed
*** 2019-02-22T22:43:17.515368-05:00 (CDB$ROOT(1))
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (1391736097)usec at (2361641358) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (6580362)usec at (7929858145) whereas (1000000) is allowed
*** 2019-02-23T08:45:58.202133-05:00 (CDB$ROOT(1))
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (30598844520)usec at (38528702667) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (917722984)usec at (44842027358) whereas (1000000) is allowed
kstmchkdrift (kstmhighrestimecntkeeper:highres): Time jumped forward by (3081143)usec at (44846113299) whereas (1000000) is allowed
The alert_xe say:
2019-02-21T21:45:50.909280-05:00
Adjusting the requested value of parameter parallel_max_servers
from 0 to 1 due to running in CDB mode
Starting ORACLE instance (normal) (OS id: 3980)
2019-02-21T21:45:52.690618-05:00
All SGA segments were allocated at startup
2019-02-21T21:45:56.331138-05:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2019-02-21T21:45:56.581012-05:00
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 1
Shared memory segment for instance monitoring created
Capability Type : Network
capabilities requested : 1 detected : 0 Simulated : 0
Capability Type : Runtime Environment
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems
capabilities requested : 3 detected : 0 Simulated : 0
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\app\ROBERTO\product\18.0.0\dbhomeXE\RDBMS
2019-02-21T21:45:57.471740-05:00
Autotune of undo retention is turned on.
IMODE=BR
ILAT =55
LICENSE_MAX_USERS = 0
SYS auditing is enabled
2019-02-21T21:45:58.331025-05:00
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-02-21T21:46:04.284108-05:00
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0.
Windows NT Version V6.2
ORACLE_HOME = C:\app\ROBERTO\product\18.0.0\dbhomeXE
Node name : DESKTOP-804DEDA
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:4751M/7647M, P
Using parameter settings in client-side pfile C:\APP\ROBERTO\PRODUCT\18.0.0\CFGTOOLLOGS\DBCA\XE\INITXETEMPOMF.ORA on machine DESKTOP-804DEDA
System parameters with non-default values:
processes = 320
nls_language = "AMERICAN"
nls_territory = "AMERICA"
sga_target = 1536M
control_files = "C:\APP\ROBERTO\PRODUCT\18.0.0\CFGTOOLLOGS\DBCA\XE\TEMPCONTROL.CTL"
db_block_size = 8192
compatible = "18.0.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
local_listener = "LISTENER_XE"
audit_file_dest = "C:\APP\ROBERTO\PRODUCT\18.0.0\ADMIN\XE\ADUMP"
audit_trail = "DB"
db_name = "xe"
db_unique_name = "XE"
open_cursors = 300
pga_aggregate_target = 512M
_diag_hm_rc_enabled = FALSE
diagnostic_dest = "C:\APP\ROBERTO\PRODUCT\18.0.0"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-02-21T21:46:05.752884-05:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================
2019-02-21T21:46:41.519255-05:00
Starting background process PMON
2019-02-21T21:46:41.566134-05:00
PMON started with pid=2, OS id=1224
Starting background process CLMN
2019-02-21T21:46:41.628648-05:00
CLMN started with pid=3, OS id=2656
Starting background process PSP0
2019-02-21T21:46:41.659890-05:00
PSP0 started with pid=4, OS id=7820
2019-02-21T21:46:42.675664-05:00
Starting background process VKTM
Starting background process GEN0
Starting background process MMAN
2019-02-21T21:46:42.894314-05:00
MMAN started with pid=7, OS id=4680
Starting background process GEN1
Starting background process DIAG
2019-02-21T21:46:42.956816-05:00
DIAG started with pid=9, OS id=10084
2019-02-21T21:46:43.753728-05:00
VKTM started with pid=5, OS id=3692 at elevated (Time Critical) priority
2019-02-21T21:46:43.753728-05:00
VKTM running at (5)millisec precision with DBRM quantum (100)ms
2019-02-21T21:46:43.878736-05:00
GEN0 started with pid=6, OS id=8604
2019-02-21T21:46:43.941240-05:00
GEN1 started with pid=8, OS id=9340
2019-02-21T21:46:43.972588-05:00
Starting background process DBRM
2019-02-21T21:46:43.988119-05:00
DBRM started with pid=10, OS id=4716
Starting background process VKRM
2019-02-21T21:46:44.066247-05:00
VKRM started with pid=12, OS id=2876
2019-02-21T21:46:45.081945-05:00
Starting background process SVCB
Starting background process PMAN
2019-02-21T21:46:45.144446-05:00
PMAN started with pid=14, OS id=5312
2019-02-21T21:46:46.128960-05:00
SVCB started with pid=13, OS id=10144
2019-02-21T21:46:46.160199-05:00
Starting background process DIA0
2019-02-21T21:46:46.191348-05:00
DIA0 started with pid=15, OS id=5348
2019-02-21T21:46:47.128969-05:00
Using default pga_aggregate_limit of 2048 MB
2019-02-21T21:46:47.206974-05:00
Starting background process DBW0
2019-02-21T21:46:47.253852-05:00
DBW0 started with pid=11, OS id=5764
2019-02-21T21:46:48.269456-05:00
Starting background process LGWR
2019-02-21T21:46:48.285083-05:00
LGWR started with pid=16, OS id=7596
2019-02-21T21:46:49.300675-05:00
Starting background process CKPT
2019-02-21T21:46:49.316305-05:00
CKPT started with pid=17, OS id=9820
Starting background process SMON
2019-02-21T21:46:49.503806-05:00
SMON started with pid=19, OS id=2144
2019-02-21T21:46:50.363301-05:00
LGWR slave LG00 created with pid=18, OS pid=888
2019-02-21T21:46:50.378917-05:00
Starting background process SMCO
2019-02-21T21:46:50.410054-05:00
SMCO started with pid=20, OS id=8692
Starting background process RECO
2019-02-21T21:46:50.472560-05:00
RECO started with pid=22, OS id=9440
2019-02-21T21:46:51.457047-05:00
LGWR slave LG01 created with pid=21, OS pid=7952
2019-02-21T21:46:51.472560-05:00
Starting background process LREG
2019-02-21T21:46:51.503810-05:00
LREG started with pid=23, OS id=4332
Starting background process PXMN
2019-02-21T21:46:51.581940-05:00
PXMN started with pid=25, OS id=4388
Starting background process FENC
2019-02-21T21:46:51.675693-05:00
FENC started with pid=27, OS id=4392
2019-02-21T21:46:52.675778-05:00
Starting background process MMON
Starting background process MMNL
2019-02-21T21:46:52.738167-05:00
MMNL started with pid=29, OS id=6592
2019-02-21T21:46:53.722631-05:00
MMON started with pid=28, OS id=8176
2019-02-21T21:46:53.738153-05:00
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Starting background process TMON
2019-02-21T21:46:53.910095-05:00
TMON started with pid=32, OS id=4968
ORACLE_BASE from environment = C:\app\ROBERTO\product\18.0.0
2019-02-21T21:47:00.878617-05:00
ALTER DATABASE MOUNT
2019-02-21T21:47:05.191089-05:00
Set as converted control file due to db_unique_name mismatch
Changing di2dbun from xe to XE
.... (PID:9792): Redo network throttle feature is disabled at mount time
2019-02-21T21:47:05.815969-05:00
Successful mount of redo thread 1, with mount id 2881971860
2019-02-21T21:47:05.831709-05:00
Database mounted in Exclusive Mode
Lost write protection disabled
.... (PID:9792): Using STANDBY_ARCHIVE_DEST parameter default value as C:\app\ROBERTO\product\18.0.0\dbhomeXE\RDBMS [krsd.c:17717]
2019-02-21T21:47:06.675360-05:00
Create Relation IPS_PACKAGE_UNPACK_HISTORY
2019-02-21T21:47:08.175410-05:00
Completed: ALTER DATABASE MOUNT
2019-02-21T21:48:14.866883-05:00
Full restore complete of datafile 1 to datafile copy C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSTEM01.DBF. Elapsed time: 0:00:54
checkpoint is 1427274
last deallocation scn is 1426589
Undo Optimization current scn is 1168379
2019-02-21T21:48:46.238150-05:00
Full restore complete of datafile 3 to datafile copy C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSAUX01.DBF. Elapsed time: 0:00:30
checkpoint is 1427274
last deallocation scn is 1426579
2019-02-21T21:48:52.550517-05:00
Full restore complete of datafile 4 to datafile copy C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\UNDOTBS01.DBF. Elapsed time: 0:00:01
checkpoint is 1427274
last deallocation scn is 3
2019-02-21T21:48:53.831805-05:00
Full restore complete of datafile 7 to datafile copy C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\USERS01.DBF. Elapsed time: 0:00:00
checkpoint is 1427274
last deallocation scn is 3
2019-02-21T21:48:54.722431-05:00
Shutting down instance (abort) (OS id: 9976)
License high water mark = 4
2019-02-21T21:48:54.769191-05:00
USER (ospid: 9976): terminating the instance
2019-02-21T21:49:14.394797-05:00
Instance terminated by USER, pid = 9976
2019-02-21T21:49:14.972829-05:00
Instance shutdown complete (OS id: 9976)
2019-02-21T21:49:27.003630-05:00
Adjusting the requested value of parameter parallel_max_servers
from 0 to 1 due to running in CDB mode
Starting ORACLE instance (normal) (OS id: 9008)
2019-02-21T21:49:27.581755-05:00
All SGA segments were allocated at startup
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 1
Capability Type : Network
capabilities requested : 1 detected : 0 Simulated : 0
Capability Type : Runtime Environment
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems
capabilities requested : 3 detected : 0 Simulated : 0
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\app\ROBERTO\product\18.0.0\dbhomeXE\RDBMS
2019-02-21T21:49:28.097399-05:00
Autotune of undo retention is turned on.
IMODE=BR
ILAT =55
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-02-21T21:49:32.691118-05:00
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0.
Windows NT Version V6.2
ORACLE_HOME = C:\app\ROBERTO\product\18.0.0\dbhomeXE
Node name : DESKTOP-804DEDA
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:4761M/7647M, P
Using parameter settings in client-side pfile C:\APP\ROBERTO\PRODUCT\18.0.0\ADMIN\XE\PFILE\INIT.ORA on machine DESKTOP-804DEDA
System parameters with non-default values:
processes = 320
nls_language = "AMERICAN"
nls_territory = "AMERICA"
sga_target = 1536M
control_files = "C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\CONTROL01.CTL"
control_files = "C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\CONTROL02.CTL"
db_block_size = 8192
compatible = "18.0.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
local_listener = "LISTENER_XE"
audit_file_dest = "C:\APP\ROBERTO\PRODUCT\18.0.0\ADMIN\XE\ADUMP"
audit_trail = "DB"
db_name = "XE"
open_cursors = 300
pga_aggregate_target = 512M
diagnostic_dest = "C:\APP\ROBERTO\PRODUCT\18.0.0"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-02-21T21:49:32.847259-05:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================
2019-02-21T21:50:01.113615-05:00
Starting background process PMON
2019-02-21T21:50:01.144865-05:00
PMON started with pid=2, OS id=5624
Starting background process CLMN
2019-02-21T21:50:01.191679-05:00
CLMN started with pid=3, OS id=5012
Starting background process PSP0
2019-02-21T21:50:01.222995-05:00
PSP0 started with pid=4, OS id=10012
2019-02-21T21:50:02.254258-05:00
Starting background process VKTM
Starting background process GEN0
2019-02-21T21:50:02.347906-05:00
GEN0 started with pid=6, OS id=8144
2019-02-21T21:50:03.316742-05:00
VKTM started with pid=5, OS id=9436 at elevated (Time Critical) priority
2019-02-21T21:50:03.332252-05:00
VKTM running at (5)millisec precision with DBRM quantum (100)ms
2019-02-21T21:50:03.347991-05:00
Starting background process MMAN
2019-02-21T21:50:03.394753-05:00
MMAN started with pid=7, OS id=7164
Starting background process GEN1
2019-02-21T21:50:03.441629-05:00
GEN1 started with pid=9, OS id=1804
2019-02-21T21:50:04.457380-05:00
Starting background process DIAG
2019-02-21T21:50:04.488565-05:00
DIAG started with pid=10, OS id=3800
2019-02-21T21:50:05.504192-05:00
Starting background process DBRM
2019-02-21T21:50:05.535455-05:00
DBRM started with pid=8, OS id=9532
2019-02-21T21:50:06.551085-05:00
Starting background process VKRM
2019-02-21T21:50:06.613571-05:00
VKRM started with pid=11, OS id=2636
2019-02-21T21:50:07.613638-05:00
Starting background process SVCB
Starting background process PMAN
2019-02-21T21:50:07.707286-05:00
PMAN started with pid=13, OS id=2992
2019-02-21T21:50:08.551025-05:00
Using default pga_aggregate_limit of 2048 MB
2019-02-21T21:50:08.676152-05:00
SVCB started with pid=12, OS id=7400
2019-02-21T21:50:08.722997-05:00
Starting background process DIA0
Starting background process DBW0
2019-02-21T21:50:08.785394-05:00
DBW0 started with pid=15, OS id=9728
2019-02-21T21:50:09.769855-05:00
DIA0 started with pid=14, OS id=10028
2019-02-21T21:50:09.863607-05:00
Starting background process LGWR
Starting background process CKPT
2019-02-21T21:50:09.941629-05:00
CKPT started with pid=17, OS id=4904
2019-02-21T21:50:10.910478-05:00
LGWR started with pid=16, OS id=4316
2019-02-21T21:50:10.941733-05:00
Starting background process SMON
2019-02-21T21:50:10.972857-05:00
SMON started with pid=18, OS id=9936
2019-02-21T21:50:10.988482-05:00
LGWR slave LG00 created with pid=19, OS pid=9288
2019-02-21T21:50:12.004210-05:00
Starting background process SMCO
2019-02-21T21:50:12.035351-05:00
SMCO started with pid=20, OS id=4296
2019-02-21T21:50:12.066592-05:00
LGWR slave LG01 created with pid=21, OS pid=6764
2019-02-21T21:50:13.076962-05:00
Starting background process RECO
2019-02-21T21:50:13.108102-05:00
RECO started with pid=22, OS id=8096
Starting background process LREG
2019-02-21T21:50:13.154981-05:00
LREG started with pid=24, OS id=2716
Starting background process PXMN
2019-02-21T21:50:13.311251-05:00
PXMN started with pid=26, OS id=3996
2019-02-21T21:50:14.327049-05:00
Starting background process FENC
2019-02-21T21:50:14.358191-05:00
FENC started with pid=27, OS id=9944
2019-02-21T21:50:15.376894-05:00
Starting background process MMON
Starting background process MMNL
2019-02-21T21:50:15.439295-05:00
MMNL started with pid=29, OS id=9020
2019-02-21T21:50:16.423767-05:00
MMON started with pid=28, OS id=4252
2019-02-21T21:50:16.455022-05:00
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Starting background process TMON
2019-02-21T21:50:16.533037-05:00
TMON started with pid=32, OS id=8592
2019-02-21T21:50:17.548631-05:00
ORACLE_BASE from environment = C:\app\ROBERTO\product\18.0.0
2019-02-21T21:50:21.894521-05:00
Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
Datafile
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSAUX01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSTEM01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\UNDOTBS01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\USERS01.DBF'
LOGFILE GROUP 1 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo01.log') SIZE 200M,
GROUP 2 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo02.log') SIZE 200M,
GROUP 3 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo03.log') SIZE 200M RESETLOGS
2019-02-21T21:50:21.910144-05:00
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
2019-02-21T21:50:23.347642-05:00
Expanded controlfile section 32 from 31 to 128 records
Requested to grow by 97 records; added 3 blocks of records
.... (PID:1524): Redo network throttle feature is disabled at mount time
2019-02-21T21:50:23.581952-05:00
Successful mount of redo thread 1, with mount id 2881939293
Completed: Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
Datafile
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSAUX01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSTEM01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\UNDOTBS01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\USERS01.DBF'
LOGFILE GROUP 1 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo01.log') SIZE 200M,
GROUP 2 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo02.log') SIZE 200M,
GROUP 3 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo03.log') SIZE 200M RESETLOGS
2019-02-21T21:50:23.722575-05:00
zeroing database id of data file (0): C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSTEM01.DBF
zeroing database id of data file (0): C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSAUX01.DBF
zeroing database id of data file (0): C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\UNDOTBS01.DBF
zeroing database id of data file (0): C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\USERS01.DBF
2019-02-21T21:50:28.378737-05:00
Shutting down instance (immediate) (OS id: 1524)
Stopping background process SMCO
2019-02-21T21:50:29.488208-05:00
Shutting down instance: further logons disabled
Stopping background process MMNL
2019-02-21T21:50:30.597567-05:00
Stopping background process MMON
2019-02-21T21:50:32.675622-05:00
License high water mark = 1
2019-02-21T21:50:32.878645-05:00
Dispatchers and shared servers shutdown
Data Pump shutdown on PDB: 1 in progress
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
.... (PID:1524): Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
2019-02-21T21:50:34.566245-05:00
IM on ADG: Start of Empty Journal
IM on ADG: End of Empty Journal
JIT: pid 10172 requesting stop
.... (PID:1524): Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
2019-02-21T21:50:34.769272-05:00
JIT: pid 10172 requesting stop
2019-02-21T21:50:35.644373-05:00
Stopping background process VKTM
2019-02-21T21:50:46.690870-05:00
Instance shutdown complete (OS id: 1524)
2019-02-21T21:51:02.737541-05:00
Adjusting the requested value of parameter parallel_max_servers
from 0 to 1 due to running in CDB mode
Starting ORACLE instance (normal) (OS id: 5272)
2019-02-21T21:51:02.768683-05:00
All SGA segments were allocated at startup
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 1
Capability Type : Network
capabilities requested : 1 detected : 0 Simulated : 0
Capability Type : Runtime Environment
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems
capabilities requested : 3 detected : 0 Simulated : 0
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\app\ROBERTO\product\18.0.0\dbhomeXE\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =55
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-02-21T21:51:07.815594-05:00
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0.
Windows NT Version V6.2
ORACLE_HOME = C:\app\ROBERTO\product\18.0.0\dbhomeXE
Node name : DESKTOP-804DEDA
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:4755M/7647M, P
Using parameter settings in client-side pfile C:\APP\ROBERTO\PRODUCT\18.0.0\CFGTOOLLOGS\DBCA\XE\INITXETEMP.ORA on machine DESKTOP-804DEDA
System parameters with non-default values:
processes = 320
nls_language = "AMERICAN"
nls_territory = "AMERICA"
sga_target = 1536M
control_files = "C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\CONTROL01.CTL"
control_files = "C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\CONTROL02.CTL"
db_block_size = 8192
compatible = "18.0.0"
_no_recovery_through_resetlogs= TRUE
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
local_listener = "LISTENER_XE"
job_queue_processes = 0
audit_file_dest = "C:\APP\ROBERTO\PRODUCT\18.0.0\ADMIN\XE\ADUMP"
audit_trail = "DB"
db_name = "XE"
open_cursors = 300
pga_aggregate_target = 512M
aq_tm_processes = 0
_enable_automatic_maintenance= 0
_diag_hm_rc_enabled = FALSE
diagnostic_dest = "C:\APP\ROBERTO\PRODUCT\18.0.0"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-02-21T21:51:07.971729-05:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================
2019-02-21T21:51:38.097159-05:00
Starting background process PMON
2019-02-21T21:51:38.128412-05:00
PMON started with pid=2, OS id=1444
Starting background process CLMN
2019-02-21T21:51:38.159663-05:00
CLMN started with pid=3, OS id=1904
Starting background process PSP0
2019-02-21T21:51:38.190920-05:00
PSP0 started with pid=4, OS id=6348
2019-02-21T21:51:39.206516-05:00
Starting background process VKTM
2019-02-21T21:51:39.284711-05:00
VKTM started with pid=5, OS id=2348 at elevated (Time Critical) priority
2019-02-21T21:51:39.300339-05:00
VKTM running at (5)millisec precision with DBRM quantum (100)ms
2019-02-21T21:51:40.284717-05:00
Starting background process GEN0
2019-02-21T21:51:40.347107-05:00
GEN0 started with pid=6, OS id=6224
2019-02-21T21:51:41.347197-05:00
Starting background process MMAN
2019-02-21T21:51:41.393962-05:00
MMAN started with pid=7, OS id=6248
Starting background process GEN1
2019-02-21T21:51:41.472093-05:00
GEN1 started with pid=9, OS id=2796
2019-02-21T21:51:42.487804-05:00
Starting background process DIAG
2019-02-21T21:51:42.503395-05:00
DIAG started with pid=8, OS id=1900
2019-02-21T21:51:43.519110-05:00
Starting background process DBRM
Starting background process VKRM
Starting background process SVCB
Starting background process PMAN
Starting background process DIA0
2019-02-21T21:51:43.628379-05:00
DIA0 started with pid=14, OS id=2072
2019-02-21T21:51:44.565974-05:00
DBRM started with pid=10, OS id=1328
2019-02-21T21:51:44.581492-05:00
VKRM started with pid=11, OS id=1396
2019-02-21T21:51:44.612838-05:00
SVCB started with pid=12, OS id=1800
2019-02-21T21:51:44.628482-05:00
PMAN started with pid=13, OS id=2340
2019-02-21T21:51:44.644103-05:00
Starting background process DBW0
2019-02-21T21:51:44.675248-05:00
DBW0 started with pid=15, OS id=1980
2019-02-21T21:51:45.690943-05:00
Starting background process LGWR
Starting background process CKPT
Starting background process SMON
2019-02-21T21:51:45.784580-05:00
SMON started with pid=18, OS id=7392
2019-02-21T21:51:46.737788-05:00
LGWR started with pid=16, OS id=2060
2019-02-21T21:51:46.769045-05:00
CKPT started with pid=17, OS id=1916
2019-02-21T21:51:46.800279-05:00
Starting background process SMCO
2019-02-21T21:51:46.831436-05:00
SMCO started with pid=19, OS id=10120
2019-02-21T21:51:46.847062-05:00
LGWR slave LG00 created with pid=20, OS pid=2292
2019-02-21T21:51:47.581426-05:00
Using default pga_aggregate_limit of 2048 MB
2019-02-21T21:51:47.862788-05:00
Starting background process RECO
2019-02-21T21:51:47.893918-05:00
RECO started with pid=21, OS id=2220
Starting background process LREG
2019-02-21T21:51:47.956514-05:00
LREG started with pid=23, OS id=2184
Starting background process PXMN
2019-02-21T21:51:48.034552-05:00
PXMN started with pid=25, OS id=2376
Starting background process FENC
2019-02-21T21:51:48.065800-05:00
FENC started with pid=27, OS id=1836
2019-02-21T21:51:49.019010-05:00
LGWR slave LG01 created with pid=24, OS pid=3236
2019-02-21T21:51:49.081401-05:00
Starting background process MMON
Starting background process MMNL
2019-02-21T21:51:49.143909-05:00
MMNL started with pid=29, OS id=2152
2019-02-21T21:51:50.112749-05:00
MMON started with pid=28, OS id=6508
2019-02-21T21:51:50.159608-05:00
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Starting background process TMON
2019-02-21T21:51:50.253252-05:00
TMON started with pid=32, OS id=5240
2019-02-21T21:51:51.253337-05:00
ORACLE_BASE from environment = C:\app\ROBERTO\product\18.0.0
2019-02-21T21:51:55.628129-05:00
Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
Datafile
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSAUX01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSTEM01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\UNDOTBS01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\USERS01.DBF'
LOGFILE GROUP 1 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo01.log') SIZE 200M,
GROUP 2 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo02.log') SIZE 200M,
GROUP 3 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo03.log') SIZE 200M RESETLOGS
2019-02-21T21:51:55.628129-05:00
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
2019-02-21T21:51:57.065645-05:00
Expanded controlfile section 32 from 31 to 128 records
Requested to grow by 97 records; added 3 blocks of records
.... (PID:2240): Redo network throttle feature is disabled at mount time
2019-02-21T21:51:57.331383-05:00
Successful mount of redo thread 1, with mount id 2881978299
Completed: Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
Datafile
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSAUX01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\SYSTEM01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\UNDOTBS01.DBF',
'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\USERS01.DBF'
LOGFILE GROUP 1 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo01.log') SIZE 200M,
GROUP 2 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo02.log') SIZE 200M,
GROUP 3 ('C:\app\ROBERTO\product\18.0.0\oradata\XE\redo03.log') SIZE 200M RESETLOGS
Stopping background process MMNL
2019-02-21T21:51:58.425108-05:00
Stopping background process MMON
2019-02-21T21:52:00.456308-05:00
Starting background process MMNL
Starting background process MMON
2019-02-21T21:52:00.518702-05:00
Stopping Emon pool
2019-02-21T21:52:00.518702-05:00
ALTER SYSTEM enable restricted session;
alter database "XE" open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 1427274 time 02/04/2019 07:08:35
2019-02-21T21:52:00.862565-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
2019-02-21T21:52:00.878073-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
.... (PID:2240): Clearing online redo logfile 1 C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO01.LOG
2019-02-21T21:52:00.893698-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
2019-02-21T21:52:00.909324-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
.... (PID:2240): Clearing online redo logfile 2 C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO02.LOG
2019-02-21T21:52:00.924951-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
2019-02-21T21:52:00.924951-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
.... (PID:2240): Clearing online redo logfile 3 C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO03.LOG
Clearing online log 1 of thread 1 sequence number 0
2019-02-21T21:52:00.956200-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
2019-02-21T21:52:00.956200-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Clearing online log 2 of thread 1 sequence number 0
2019-02-21T21:52:00.971827-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
2019-02-21T21:52:00.987451-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Clearing online log 3 of thread 1 sequence number 0
2019-02-21T21:52:00.987451-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
2019-02-21T21:52:01.003077-05:00
Errors in file C:\APP\ROBERTO\PRODUCT\18.0.0\diag\rdbms\xe\xe\trace\xe_ora_2240.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
2019-02-21T21:52:01.549992-05:00
MMNL started with pid=27, OS id=2368
2019-02-21T21:52:02.550156-05:00
MMON started with pid=28, OS id=2128
2019-02-21T21:52:13.472678-05:00
.... (PID:2240): Clearing online redo logfile 1 complete
.... (PID:2240): Clearing online redo logfile 2 complete
.... (PID:2240): Clearing online redo logfile 3 complete
Online log C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO01.LOG: Thread 1 Group 1 was previously cleared
Online log C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO02.LOG: Thread 1 Group 2 was previously cleared
Online log C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO03.LOG: Thread 1 Group 3 was previously cleared
2019-02-21T21:52:14.175794-05:00
Setting recovery target incarnation to 2
2019-02-21T21:52:14.644543-05:00
Ping without log force is disabled:
instance mounted in exclusive mode.
Initializing SCN for created control file
Database SCN compatibility initialized to 1
Endian type of dictionary set to little
2019-02-21T21:52:15.003917-05:00
Assigning activation ID 2881978299 (0xabc77fbb)
2019-02-21T21:52:15.019552-05:00
TT00 (PID:2816): Gap Manager starting
2019-02-21T21:52:15.285169-05:00
Redo log for group 1, sequence 1 is not located on DAX storage
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO01.LOG
Successful open of redo thread 1
2019-02-21T21:52:15.691425-05:00
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
stopping change tracking
2019-02-21T21:52:15.925916-05:00
TT03 (PID:1408): Sleep 5 seconds and then try to clear SRLs in 2 time(s)
2019-02-21T21:52:19.754063-05:00
Undo initialization recovery: err:0 start: 1524515 end: 1524593 diff: 78 ms (0.1 seconds)
2019-02-21T21:52:20.972794-05:00
[2240] Successfully onlined Undo Tablespace 2.
Undo initialization online undo segments: err:0 start: 1524593 end: 1525812 diff: 1219 ms (1.2 seconds)
2019-02-21T21:52:20.988306-05:00
TT03 (PID:1408): Sleep 10 seconds and then try to clear SRLs in 3 time(s)
2019-02-21T21:52:21.035307-05:00
Undo initialization finished serial:0 start:1524515 end:1525875 diff:1360 ms (1.4 seconds)
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Verifying minimum file header compatibility for tablespace encryption for pdb 1..
Verifying file header compatibility for tablespace encryption completed for pdb 1
*********************************************************************
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 \<tablespace\_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
2019-02-21T21:52:23.425993-05:00
Opening with Resource Manager plan: DEFAULT_CDB_PLAN
2019-02-21T21:52:27.191532-05:00
replication_dependency_tracking turned off (no async multimaster replication found)
2019-02-21T21:52:28.894813-05:00
AQ Processes can not start in restrict mode
2019-02-21T21:52:30.113504-05:00
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
2019-02-21T21:52:31.207207-05:00
Global Name changed to XE
2019-02-21T21:52:33.847995-05:00
Starting background process CJQ0
2019-02-21T21:52:33.879122-05:00
CJQ0 started with pid=40, OS id=3508
Completed: alter database "XE" open resetlogs
alter database rename global_name to "XE"
Completed: alter database rename global_name to "XE"
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\app\ROBERTO\product\18.0.0\oradata\XE\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
2019-02-21T21:52:35.248766-05:00
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\app\ROBERTO\product\18.0.0\oradata\XE\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
2019-02-21T21:52:37.471924-05:00
TABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P181 (56) VALUES LESS THAN (TIMESTAMP' 2019-03-01 00:00:00')
2019-02-21T21:52:56.955249-05:00
QPI : Found directory objects and ORACLE_HOME out of sync
QPI : Trying to patch with the current ORACLE_HOME
QPI: ------QPI Old Directories -------
QPI: OPATCH_SCRIPT_DIR:c:\ade\aime_v\oracle\QOpatch
QPI: OPATCH_LOG_DIR:c:\ade\aime_v\oracle\rdbms\log
QPI: OPATCH_INST_DIR:c:\ade\aime_v\oracle\OPatch
QPI: op_scpt_path C:\app\ROBERTO\product\18.0.0\dbhomeXE\QOpatch
2019-02-21T21:52:58.267769-05:00
QPI: Found QPI install at :C:\app\ROBERTO\product\18.0.0\dbhomeXE\QOpatch
QPI: Self adjusting the directories
QPI: ------QPI New Directories-------
QPI: OPATCH_SCRIPT_DIR:C:\app\ROBERTO\product\18.0.0\dbhomeXE\QOpatch
QPI: OPATCH_LOG_DIR:C:\app\ROBERTO\product\18.0.0\dbhomeXE\rdbms\log
QPI: OPATCH_INST_DIR:C:\app\ROBERTO\product\18.0.0\dbhomeXE\OPatch
QPI: opatch file present, opatch.bat
QPI: qopiprep.bat file present
2019-02-21T21:53:13.111601-05:00
Shared IO Pool defaulting to 80MB. Trying to get it from Buffer Cache for process 5508.
2019-02-21T21:53:16.471122-05:00
ALTER SYSTEM SET _catalog_foreign_restore=TRUE SCOPE=MEMORY;
2019-02-21T21:53:16.486643-05:00
ALTER SYSTEM SET _restore_create_directory=TRUE SCOPE=MEMORY;
2019-02-21T21:53:36.847286-05:00
Full restore complete of datafile 9 to datafile copy C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\UNDOTBS01.DBF. Elapsed time: 0:00:12
checkpoint is 1425401
2019-02-21T21:53:48.801076-05:00
Full restore complete of datafile 2 to datafile copy C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\SYSTEM01.DBF. Elapsed time: 0:00:25
checkpoint is 1425401
2019-02-21T21:53:50.019998-05:00
Full restore complete of datafile 4 to datafile copy C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\SYSAUX01.DBF. Elapsed time: 0:00:26
checkpoint is 1425401
2019-02-21T21:54:04.082360-05:00
ALTER SYSTEM SET _catalog_foreign_restore=FALSE SCOPE=MEMORY;
2019-02-21T21:54:04.097986-05:00
ALTER SYSTEM SET _restore_create_directory=FALSE SCOPE=MEMORY;
CREATE PLUGGABLE DATABASE PDB$SEED AS CLONE USING 'C:\app\ROBERTO\product\18.0.0\dbhomeXE\assistants\dbca\templates\pdbseed.xml' source_file_name_convert = ('C:\ADE\AIME_V\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF','C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\SYSTEM01.DBF',
'C:\ADE\AIME_V\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF','C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\SYSAUX01.DBF',
'C:\ADE\AIME_V\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF','C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\UNDOTBS01.DBF',
'C:\ADE\AIME_V\ORACLE\ORADATA\XE\PDBSEED\TEMP01.DBF','C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\temp012019-02-21_21-54-04-113-PM.dbf') NOCOPY STORAGE ( MAXSIZE UNLIMITED MAX_SHARED_TEMP_SIZE UNLIMITED)
2019-02-21T21:54:05.098098-05:00
PDB$SEED(2):Endian type of dictionary set to little
****************************************************************
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
local undo-1, localundoscn-0x0000000000000109
****************************************************************
2019-02-21T21:54:07.863647-05:00
PDB$SEED(2):Autotune of undo retention is turned on.
2019-02-21T21:54:09.035551-05:00
PDB$SEED(2):Undo initialization recovery: err:0 start: 1633843 end: 1633875 diff: 32 ms (0.0 seconds)
PDB$SEED(2):[6236] Successfully onlined Undo Tablespace 2.
PDB$SEED(2):Undo initialization online undo segments: err:0 start: 1633875 end: 1634140 diff: 265 ms (0.3 seconds)
PDB$SEED(2):Undo initialization finished serial:0 start:1633843 end:1634156 diff:313 ms (0.3 seconds)
PDB$SEED(2):Database Characterset for PDB$SEED is US7ASCII
PDB$SEED(2):JIT: pid 10172 requesting stop
PDB$SEED(2):Buffer Cache flush started: 2
PDB$SEED(2):Buffer Cache flush finished: 2
2019-02-21T21:54:11.004326-05:00
Completed: CREATE PLUGGABLE DATABASE PDB$SEED AS CLONE USING 'C:\app\ROBERTO\product\18.0.0\dbhomeXE\assistants\dbca\templates\pdbseed.xml' source_file_name_convert = ('C:\ADE\AIME_V\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF','C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\SYSTEM01.DBF',
'C:\ADE\AIME_V\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF','C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\SYSAUX01.DBF',
'C:\ADE\AIME_V\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF','C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\UNDOTBS01.DBF',
'C:\ADE\AIME_V\ORACLE\ORADATA\XE\PDBSEED\TEMP01.DBF','C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\PDBSEED\temp012019-02-21_21-54-04-113-PM.dbf') NOCOPY STORAGE ( MAXSIZE UNLIMITED MAX_SHARED_TEMP_SIZE UNLIMITED)
alter pluggable database PDB$SEED open restricted
PDB$SEED(2):Autotune of undo retention is turned on.
2019-02-21T21:54:12.207482-05:00
PDB$SEED(2):Endian type of dictionary set to little
PDB$SEED(2):Undo initialization recovery: err:0 start: 1637453 end: 1637468 diff: 15 ms (0.0 seconds)
2019-02-21T21:54:13.223130-05:00
PDB$SEED(2):[6236] Successfully onlined Undo Tablespace 2.
PDB$SEED(2):Undo initialization online undo segments: err:0 start: 1637484 end: 1638062 diff: 578 ms (0.6 seconds)
PDB$SEED(2):Undo initialization finished serial:0 start:1637453 end:1638093 diff:640 ms (0.6 seconds)
PDB$SEED(2):Deleting old file#2 from file$
PDB$SEED(2):Deleting old file#4 from file$
PDB$SEED(2):Deleting old file#6 from file$
PDB$SEED(2):Deleting old file#8 from file$
PDB$SEED(2):Deleting old file#9 from file$
PDB$SEED(2):Adding new file#5 to file$(old file#2). fopr-0, newblks-32000, oldblks-19200
PDB$SEED(2):Adding new file#6 to file$(old file#4). fopr-0, newblks-37120, oldblks-15360
PDB$SEED(2):Adding new file#8 to file$(old file#9). fopr-0, newblks-12800, oldblks-12800
2019-02-21T21:54:14.316955-05:00
****************************************************************
Post plug operations are now complete.
Pluggable database PDB$SEED with pdb id - 2 is now marked as NEW.
****************************************************************
PDB$SEED(2):Database Characterset for PDB$SEED is US7ASCII
2019-02-21T21:56:01.878102-05:00
PDB$SEED(2):Opening pdb with Resource Manager plan: DEFAULT_PLAN
Pluggable database PDB$SEED opened read write
Completed: alter pluggable database PDB$SEED open restricted
2019-02-21T21:56:07.127996-05:00
Shutting down instance (immediate) (OS id: 8816)
Stopping background process SMCO
2019-02-21T21:56:08.206207-05:00
Shutting down instance: further logons disabled
Stopping background process MMNL
2019-02-21T21:56:10.096863-05:00
Stopping background process CJQ0
2019-02-21T21:56:11.112478-05:00
Stopping background process MMON
2019-02-21T21:56:12.128067-05:00
alter pluggable database all close immediate
Completed: alter pluggable database all close immediate
2019-02-21T21:56:12.237321-05:00
PDB$SEED(2):JIT: pid 10172 requesting stop
PDB$SEED(2):Buffer Cache flush deferred for PDB 2
2019-02-21T21:56:13.846818-05:00
License high water mark = 7
2019-02-21T21:56:14.034285-05:00
Dispatchers and shared servers shutdown
Data Pump shutdown on PDB: 1 in progress
ALTER DATABASE CLOSE NORMAL
Stopping Emon pool
alter pluggable database all close immediate
Completed: alter pluggable database all close immediate
IM on ADG: Start of Empty Journal
IM on ADG: End of Empty Journal
Stopping Emon pool
stopping change tracking
2019-02-21T21:56:15.049942-05:00
Shutting down archive processes
2019-02-21T21:56:15.049942-05:00
TT00 (PID:2816): Gap Manager exiting
2019-02-21T21:56:16.065438-05:00
Archiving is disabled
2019-02-21T21:56:16.127939-05:00
Thread 1 closed at log sequence 1
Successful close of redo thread 1
2019-02-21T21:56:16.331069-05:00
Buffer Cache invalidation for all PDBs started
Buffer Cache invalidation for all PDBs complete
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
.... (PID:8816): Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
2019-02-21T21:56:17.721683-05:00
JIT: pid 10172 requesting stop
2019-02-21T21:56:17.737310-05:00
Stopping background process VKTM
2019-02-21T21:56:17.877945-05:00
.... (PID:8816): Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
JIT: pid 10172 requesting stop
2019-02-21T21:56:29.643293-05:00
Instance shutdown complete (OS id: 8816)
2019-02-21T21:56:51.096236-05:00
Adjusting the requested value of parameter parallel_max_servers
from 0 to 1 due to running in CDB mode
Starting ORACLE instance (restrict) (OS id: 5660)
2019-02-21T21:56:51.142994-05:00
All SGA segments were allocated at startup
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 1
Capability Type : Network
capabilities requested : 1 detected : 0 Simulated : 0
Capability Type : Runtime Environment
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems
capabilities requested : 3 detected : 0 Simulated : 0
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\app\ROBERTO\product\18.0.0\dbhomeXE\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =55
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-02-21T21:56:56.221131-05:00
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0.
Windows NT Version V6.2
ORACLE_HOME = C:\app\ROBERTO\product\18.0.0\dbhomeXE
Node name : DESKTOP-804DEDA
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:4719M/7647M, P
Using parameter settings in client-side pfile C:\APP\ROBERTO\PRODUCT\18.0.0\CFGTOOLLOGS\DBCA\XE\INITXETEMP.ORA on machine DESKTOP-804DEDA
System parameters with non-default values:
processes = 320
nls_language = "AMERICAN"
nls_territory = "AMERICA"
sga_target = 1536M
control_files = "C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\CONTROL01.CTL"
control_files = "C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\CONTROL02.CTL"
db_block_size = 8192
compatible = "18.0.0"
_no_recovery_through_resetlogs= TRUE
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
local_listener = "LISTENER_XE"
job_queue_processes = 0
audit_file_dest = "C:\APP\ROBERTO\PRODUCT\18.0.0\ADMIN\XE\ADUMP"
audit_trail = "DB"
db_name = "XE"
open_cursors = 300
pga_aggregate_target = 512M
aq_tm_processes = 0
_enable_automatic_maintenance= 0
_diag_hm_rc_enabled = FALSE
diagnostic_dest = "C:\APP\ROBERTO\PRODUCT\18.0.0"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2019-02-21T21:56:56.439781-05:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================
2019-02-21T21:57:25.049511-05:00
Starting background process PMON
2019-02-21T21:57:25.080764-05:00
PMON started with pid=2, OS id=7120
Starting background process CLMN
2019-02-21T21:57:25.127640-05:00
CLMN started with pid=3, OS id=748
Starting background process PSP0
2019-02-21T21:57:25.174519-05:00
PSP0 started with pid=4, OS id=7892
2019-02-21T21:57:26.190237-05:00
Starting background process VKTM
2019-02-21T21:57:26.252639-05:00
VKTM started with pid=5, OS id=3260 at elevated (Time Critical) priority
2019-02-21T21:57:26.330752-05:00
VKTM running at (5)millisec precision with DBRM quantum (100)ms
2019-02-21T21:57:27.268353-05:00
Starting background process GEN0
2019-02-21T21:57:27.330737-05:00
GEN0 started with pid=6, OS id=2288
2019-02-21T21:57:28.330811-05:00
Starting background process MMAN
2019-02-21T21:57:28.393245-05:00
MMAN started with pid=7, OS id=2964
Starting background process GEN1
2019-02-21T21:57:28.440124-05:00
GEN1 started with pid=9, OS id=2180
2019-02-21T21:57:29.455897-05:00
Starting background process DIAG
2019-02-21T21:57:29.471436-05:00
DIAG started with pid=10, OS id=8868
2019-02-21T21:57:30.487158-05:00
Starting background process DBRM
Starting background process VKRM
2019-02-21T21:57:30.580787-05:00
VKRM started with pid=11, OS id=9812
2019-02-21T21:57:31.549633-05:00
DBRM started with pid=8, OS id=4332
2019-02-21T21:57:31.596398-05:00
Starting background process SVCB
2019-02-21T21:57:31.627651-05:00
SVCB started with pid=12, OS id=9316
2019-02-21T21:57:32.643367-05:00
Starting background process PMAN
Starting background process DIA0
Starting background process DBW0
2019-02-21T21:57:32.752635-05:00
DBW0 started with pid=15, OS id=2792
2019-02-21T21:57:33.690225-05:00
PMAN started with pid=13, OS id=952
2019-02-21T21:57:33.721469-05:00
DIA0 started with pid=14, OS id=8176
2019-02-21T21:57:33.752604-05:00
Starting background process LGWR
2019-02-21T21:57:33.799548-05:00
LGWR started with pid=16, OS id=5252
2019-02-21T21:57:34.565075-05:00
Using default pga_aggregate_limit of 2048 MB
2019-02-21T21:57:34.815179-05:00
Starting background process CKPT
2019-02-21T21:57:34.846331-05:00
CKPT started with pid=17, OS id=8488
2019-02-21T21:57:34.877584-05:00
LGWR slave LG00 created with pid=18, OS pid=5664
2019-02-21T21:57:35.893271-05:00
Starting background process SMON
2019-02-21T21:57:35.924418-05:00
SMON started with pid=19, OS id=1268
Starting background process SMCO
2019-02-21T21:57:35.986923-05:00
SMCO started with pid=21, OS id=2344
2019-02-21T21:57:36.971378-05:00
LGWR slave LG01 created with pid=20, OS pid=716
2019-02-21T21:57:37.049381-05:00
Starting background process RECO
2019-02-21T21:57:37.080642-05:00
RECO started with pid=22, OS id=5256
Starting background process LREG
2019-02-21T21:57:37.143146-05:00
LREG started with pid=24, OS id=1828
Starting background process PXMN
2019-02-21T21:57:37.205643-05:00
PXMN started with pid=26, OS id=5348
2019-02-21T21:57:38.221271-05:00
Starting background process FENC
2019-02-21T21:57:38.252528-05:00
FENC started with pid=27, OS id=10144
2019-02-21T21:57:39.268245-05:00
Starting background process MMON
2019-02-21T21:57:39.330632-05:00
MMON started with pid=28, OS id=9360
2019-02-21T21:57:40.315102-05:00
Starting background process MMNL
2019-02-21T21:57:40.346243-05:00
MMNL started with pid=29, OS id=1224
2019-02-21T21:57:41.361959-05:00
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Starting background process TMON
2019-02-21T21:57:41.440051-05:00
TMON started with pid=32, OS id=3160
2019-02-21T21:57:42.455584-05:00
ORACLE_BASE from environment = C:\app\ROBERTO\product\18.0.0
2019-02-21T21:57:46.783596-05:00
ALTER DATABASE MOUNT
2019-02-21T21:57:51.002227-05:00
.... (PID:3264): Redo network throttle feature is disabled at mount time
2019-02-21T21:57:51.236597-05:00
Successful mount of redo thread 1, with mount id 2881957658
2019-02-21T21:57:51.252217-05:00
Database mounted in Exclusive Mode
Lost write protection disabled
.... (PID:3264): Using STANDBY_ARCHIVE_DEST parameter default value as C:\app\ROBERTO\product\18.0.0\dbhomeXE\RDBMS [krsd.c:17717]
2019-02-21T21:57:53.361713-05:00
Completed: ALTER DATABASE MOUNT
2019-02-21T21:57:53.455458-05:00
ALTER DATABASE OPEN
2019-02-21T21:57:53.627402-05:00
Ping without log force is disabled:
instance mounted in exclusive mode.
2019-02-21T21:57:53.658698-05:00
Crash Recovery excluding pdb 2 which was cleanly closed.
Endian type of dictionary set to little
2019-02-21T21:57:53.830466-05:00
TT00 (PID:5308): Gap Manager starting
2019-02-21T21:57:54.017969-05:00
Redo log for group 1, sequence 1 is not located on DAX storage
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: C:\APP\ROBERTO\PRODUCT\18.0.0\ORADATA\XE\REDO01.LOG
Successful open of redo thread 1
2019-02-21T21:57:54.392967-05:00
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
stopping change tracking
2019-02-21T21:57:55.564889-05:00
Undo initialization recovery: err:0 start: 1860375 end: 1860390 diff: 15 ms (0.0 seconds)
[8380] Successfully onlined Undo Tablespace 2.
Undo initialization online undo segments: err:0 start: 1860406 end: 1860828 diff: 422 ms (0.4 seconds)
Undo initialization finished serial:0 start:1860375 end:1860859 diff:484 ms (0.5 seconds)
Verifying minimum file header compatibility for tablespace encryption for pdb 1..
Verifying file header compatibility for tablespace encryption completed for pdb 1
Database Characterset is US7ASCII
Opening with Resource Manager plan: DEFAULT_CDB_PLAN
2019-02-21T21:57:58.533701-05:00
replication_dependency_tracking turned off (no async multimaster replication found)
2019-02-21T21:57:59.611848-05:00
AQ Processes can not start in restrict mode
2019-02-21T21:58:01.565024-05:00
PDB$SEED(2):Autotune of undo retention is turned on.
2019-02-21T21:58:01.815026-05:00
PDB$SEED(2):Endian type of dictionary set to little
PDB$SEED(2):Undo initialization finished serial:0 start:1867171 end:1867171 diff:0 ms (0.0 seconds)
PDB$SEED(