Oracle 生僻字符集 DBCA建库
很多工作中会发生建立字符集的时候在图形界面寻找的时候找不到，因为数据库版本高了以后，有些旧的字符集会没有，就需要用到脚本建库了
获取建库脚本软件
用oracle用户使用命令DBCA
使用DBCA不是按照图形界面建库是需要输出一个脚本文件
关键的一步
这里不要勾选“create Database” 选择下面的建脚本，记住脚本的路径
建库
可以用more,vi,cat去看脚本，只要运行test.sh,之后的事情顺气自然都帮你一路建好了，可以从test.sh里看到调用脚本的信息
Test.sh中是最基本的建立文件目录，然后最下面一条就掉用了test.sql
这些事test.sql里的内容，基本就是掉用建DB之类的，大家自己查看了，不一一举例了
基本上sh test.sh 除了让你输入sys和sysdba密码之外，其他都是自动的
修改字符集
在脚本CreateDB.sql中
可以修改字符集，修改掉再运行sh test.sh就OK了
删库
使用脚本建库的实例，是不能从DBCA里找到的，实测过2次都是这样，具体你为什么不清楚，所以找到了一条语句删库，比较干净的删库方法
Test就是实例名
[[email protected] scripts]$ dbca -silent -deleteDatabase -sourcedb test
Connecting to database
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/test0.log" for further details.
最后附上一个安装数据库日志的全过程，供参考
[[email protected] trace]$ cat alert_test.log
Tue Oct 16 23:20:00 2018
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 1
Shared memory segment for instance monitoring created
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
NUMA status: non-NUMA system
cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
Grp 0:
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/11.2.0/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: Oracle11g
Release: 2.6.32-431.el6.x86_64
Version: #1 SMP Sun Nov 10 22:19:54 EST 2013
Machine: x86_64
VM name: VMWare Version: 6
Using parameter settings in client-side pfile /u01/app/oracle/admin/test/scripts/init.ora on machine Oracle11g
System parameters with non-default values:
processes = 150
memory_target = 1184M
control_files = "/u01/app/oracle/oradata/test/control01.ctl"
control_files = "/u01/app/oracle/oradata/test/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.4.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/u01/app/oracle/admin/test/adump"
audit_trail = "DB"
db_name = "test"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Tue Oct 16 23:20:02 2018
PMON started with pid=2, OS id=2381
Tue Oct 16 23:20:02 2018
PSP0 started with pid=3, OS id=2383
Tue Oct 16 23:20:04 2018
VKTM started with pid=4, OS id=2386 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Tue Oct 16 23:20:04 2018
GEN0 started with pid=5, OS id=2390
Tue Oct 16 23:20:04 2018
DIAG started with pid=6, OS id=2392
Tue Oct 16 23:20:04 2018
DBRM started with pid=7, OS id=2394
Tue Oct 16 23:20:04 2018
DIA0 started with pid=8, OS id=2396
Tue Oct 16 23:20:04 2018
MMAN started with pid=9, OS id=2398
Tue Oct 16 23:20:04 2018
DBW0 started with pid=10, OS id=2400
Tue Oct 16 23:20:04 2018
LGWR started with pid=11, OS id=2402
Tue Oct 16 23:20:04 2018
CKPT started with pid=12, OS id=2404
Tue Oct 16 23:20:04 2018
SMON started with pid=13, OS id=2406
Tue Oct 16 23:20:04 2018
RECO started with pid=14, OS id=2408
Tue Oct 16 23:20:04 2018
MMON started with pid=15, OS id=2410
ORACLE_BASE from environment = /u01/app/oracle
Tue Oct 16 23:20:04 2018
MMNL started with pid=16, OS id=2412
Tue Oct 16 23:20:04 2018
CREATE DATABASE "test"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/u01/app/oracle/oradata/test/system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/test/sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/oradata/test/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oracle/oradata/test/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/test/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/oradata/test/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/oradata/test/redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY USER SYSTEM IDENTIFIED BY
Database mounted in Exclusive Mode
Lost write protection disabled
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Tue Oct 16 23:20:15 2018
Successful mount of redo thread 1, with mount id 2287825828
Tue Oct 16 23:20:15 2018
Database SCN compatibility initialized to 1
Assigning activation ID 2287825828 (0x885d73a4)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Oct 16 23:20:15 2018
SMON: enabling cache recovery
processing ?/rdbms/admin/dcore.bsq
create tablespace SYSTEM datafile '/u01/app/oracle/oradata/test/system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
Tue Oct 16 23:20:38 2018
Completed: create tablespace SYSTEM datafile '/u01/app/oracle/oradata/test/system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
UNDO_SEG_CRT: Could not find usn tail
Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Undo initialization finished serial:0 start:4294589190 end:4294589190 diff:0 (0 seconds)
processing ?/rdbms/admin/dsqlddl.bsq
processing ?/rdbms/admin/dmanage.bsq
CREATE TABLESPACE sysaux DATAFILE '/u01/app/oracle/oradata/test/sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE
Tue Oct 16 23:20:59 2018
Completed: CREATE TABLESPACE sysaux DATAFILE '/u01/app/oracle/oradata/test/sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE
processing ?/rdbms/admin/dplsql.bsq
processing ?/rdbms/admin/dtxnspc.bsq
CREATE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/app/oracle/oradata/test/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
Tue Oct 16 23:21:10 2018
[2413] Successfully onlined Undo Tablespace 2.
Completed: CREATE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/app/oracle/oradata/test/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CREATE SMALLFILE TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/oradata/test/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: CREATE SMALLFILE TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/oradata/test/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
ALTER DATABASE DEFAULT TABLESPACE SYSTEM
Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM
processing ?/rdbms/admin/dfmap.bsq
processing ?/rdbms/admin/denv.bsq
processing ?/rdbms/admin/drac.bsq
processing ?/rdbms/admin/dsec.bsq
processing ?/rdbms/admin/doptim.bsq
processing ?/rdbms/admin/dobj.bsq
processing ?/rdbms/admin/djava.bsq
processing ?/rdbms/admin/dpart.bsq
processing ?/rdbms/admin/drep.bsq
processing ?/rdbms/admin/daw.bsq
processing ?/rdbms/admin/dsummgt.bsq
processing ?/rdbms/admin/dtools.bsq
processing ?/rdbms/admin/dexttab.bsq
processing ?/rdbms/admin/ddm.bsq
processing ?/rdbms/admin/dlmnr.bsq
processing ?/rdbms/admin/ddst.bsq
Tue Oct 16 23:21:16 2018
SMON: enabling tx recovery
Starting background process SMCO
Tue Oct 16 23:21:16 2018
SMCO started with pid=18, OS id=2429
Tue Oct 16 23:21:24 2018
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue Oct 16 23:21:24 2018
QMNC started with pid=20, OS id=2437
Completed: CREATE DATABASE "test"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/u01/app/oracle/oradata/test/system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/test/sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/oradata/test/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oracle/oradata/test/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/test/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/oradata/test/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/oradata/test/redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY USER SYSTEM IDENTIFIED BY
Tue Oct 16 23:21:24 2018
CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/u01/app/oracle/oradata/test/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 '/u01/app/oracle/oradata/test/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"
Tue Oct 16 23:21:30 2018
Thread 1 advanced to log sequence 2 (LGWR switch)
Current log# 2 seq# 2 mem# 0: /u01/app/oracle/oradata/test/redo02.log
Tue Oct 16 23:21:48 2018
Thread 1 advanced to log sequence 3 (LGWR switch)
Current log# 3 seq# 3 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Tue Oct 16 23:22:06 2018
Thread 1 cannot allocate new log, sequence 4
Checkpoint not complete
Current log# 3 seq# 3 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Thread 1 advanced to log sequence 4 (LGWR switch)
Current log# 1 seq# 4 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Tue Oct 16 23:22:27 2018
Thread 1 cannot allocate new log, sequence 5
Checkpoint not complete
Current log# 1 seq# 4 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Thread 1 advanced to log sequence 5 (LGWR switch)
Current log# 2 seq# 5 mem# 0: /u01/app/oracle/oradata/test/redo02.log
Tue Oct 16 23:22:46 2018
Create Relation IPS_PACKAGE_UNPACK_HISTORY
Tue Oct 16 23:22:48 2018
Thread 1 advanced to log sequence 6 (LGWR switch)
Current log# 3 seq# 6 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Tue Oct 16 23:23:03 2018
Thread 1 cannot allocate new log, sequence 7
Checkpoint not complete
Current log# 3 seq# 6 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Thread 1 advanced to log sequence 7 (LGWR switch)
Current log# 1 seq# 7 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Tue Oct 16 23:23:21 2018
Thread 1 advanced to log sequence 8 (LGWR switch)
Current log# 2 seq# 8 mem# 0: /u01/app/oracle/oradata/test/redo02.log
Tue Oct 16 23:23:36 2018
Thread 1 cannot allocate new log, sequence 9
Checkpoint not complete
Current log# 2 seq# 8 mem# 0: /u01/app/oracle/oradata/test/redo02.log
Thread 1 advanced to log sequence 9 (LGWR switch)
Current log# 3 seq# 9 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Tue Oct 16 23:24:54 2018
Thread 1 cannot allocate new log, sequence 10
Checkpoint not complete
Current log# 3 seq# 9 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Thread 1 advanced to log sequence 10 (LGWR switch)
Current log# 1 seq# 10 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Tue Oct 16 23:25:18 2018
Thread 1 cannot allocate new log, sequence 11
Checkpoint not complete
Current log# 1 seq# 10 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Thread 1 advanced to log sequence 11 (LGWR switch)
Current log# 2 seq# 11 mem# 0: /u01/app/oracle/oradata/test/redo02.log
Tue Oct 16 23:26:00 2018
Thread 1 cannot allocate new log, sequence 12
Checkpoint not complete
Current log# 2 seq# 11 mem# 0: /u01/app/oracle/oradata/test/redo02.log
Thread 1 advanced to log sequence 12 (LGWR switch)
Current log# 3 seq# 12 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Tue Oct 16 23:26:39 2018
Thread 1 cannot allocate new log, sequence 13
Checkpoint not complete
Current log# 3 seq# 12 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Thread 1 advanced to log sequence 13 (LGWR switch)
Current log# 1 seq# 13 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Tue Oct 16 23:26:57 2018
Thread 1 cannot allocate new log, sequence 14
Checkpoint not complete
Current log# 1 seq# 13 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Tue Oct 16 23:26:58 2018
Starting background process CJQ0
Tue Oct 16 23:26:58 2018
CJQ0 started with pid=32, OS id=2500
Thread 1 advanced to log sequence 14 (LGWR switch)
Current log# 2 seq# 14 mem# 0: /u01/app/oracle/oradata/test/redo02.log
Tue Oct 16 23:27:18 2018
SERVER COMPONENT id=CATPROC: timestamp=2018-10-16 23:27:18
Tue Oct 16 23:27:18 2018
Thread 1 cannot allocate new log, sequence 15
Checkpoint not complete
Current log# 2 seq# 14 mem# 0: /u01/app/oracle/oradata/test/redo02.log
Thread 1 advanced to log sequence 15 (LGWR switch)
Current log# 3 seq# 15 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Tue Oct 16 23:27:42 2018
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Tue Oct 16 23:28:00 2018
Stopping background process QMNC
Tue Oct 16 23:28:00 2018
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
ALTER DATABASE CLOSE NORMAL
Tue Oct 16 23:28:03 2018
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Oct 16 23:28:03 2018
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 15
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Tue Oct 16 23:28:04 2018
Stopping background process VKTM
Tue Oct 16 23:28:06 2018
Instance shutdown complete
Tue Oct 16 23:28:07 2018
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 1
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
NUMA status: non-NUMA system
cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
Grp 0:
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/11.2.0/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: Oracle11g
Release: 2.6.32-431.el6.x86_64
Version: #1 SMP Sun Nov 10 22:19:54 EST 2013
Machine: x86_64
VM name: VMWare Version: 6
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/db_1/dbs/spfiletest.ora
System parameters with non-default values:
processes = 150
memory_target = 1184M
control_files = "/u01/app/oracle/oradata/test/control01.ctl"
control_files = "/u01/app/oracle/oradata/test/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.4.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/u01/app/oracle/admin/test/adump"
audit_trail = "DB"
db_name = "test"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Tue Oct 16 23:28:08 2018
PMON started with pid=2, OS id=2520
Tue Oct 16 23:28:08 2018
PSP0 started with pid=3, OS id=2522
Tue Oct 16 23:28:09 2018
VKTM started with pid=4, OS id=2524 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Tue Oct 16 23:28:09 2018
GEN0 started with pid=5, OS id=2528
Tue Oct 16 23:28:09 2018
DIAG started with pid=6, OS id=2530
Tue Oct 16 23:28:09 2018
DBRM started with pid=7, OS id=2532
Tue Oct 16 23:28:09 2018
DIA0 started with pid=8, OS id=2534
Tue Oct 16 23:28:09 2018
MMAN started with pid=9, OS id=2536
Tue Oct 16 23:28:09 2018
DBW0 started with pid=10, OS id=2538
Tue Oct 16 23:28:09 2018
LGWR started with pid=11, OS id=2540
Tue Oct 16 23:28:09 2018
CKPT started with pid=12, OS id=2542
Tue Oct 16 23:28:09 2018
SMON started with pid=13, OS id=2544
Tue Oct 16 23:28:10 2018
RECO started with pid=14, OS id=2546
Tue Oct 16 23:28:10 2018
MMON started with pid=15, OS id=2548
ORACLE_BASE from environment = /u01/app/oracle
Tue Oct 16 23:28:10 2018
MMNL started with pid=16, OS id=2550
Tue Oct 16 23:28:10 2018
ALTER DATABASE MOUNT
Changing di2dbun from to test
Successful mount of redo thread 1, with mount id 2287840394
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Oct 16 23:28:14 2018
ALTER DATABASE OPEN
Thread 1 opened at log sequence 15
Current log# 3 seq# 15 mem# 0: /u01/app/oracle/oradata/test/redo03.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
[2556] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:77944 end:77964 diff:20 (0 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue Oct 16 23:28:15 2018
QMNC started with pid=18, OS id=2558
Completed: ALTER DATABASE OPEN
Starting background process CJQ0
Tue Oct 16 23:28:15 2018
CJQ0 started with pid=17, OS id=2570
Tue Oct 16 23:33:15 2018
Starting background process SMCO
Tue Oct 16 23:33:15 2018
SMCO started with pid=19, OS id=2618