如何获得一个单实例Oracle数据库(从Oracle Container Reg( 二 )


最后一行Done ! Theis ready for use .表示数据库就绪了 。可以看到这段时间用了219秒 。
当然后面还有一段日志,可以参考一下:
# ===========================================================================# == Add below entries to your tnsnames.ora to access this database server ==# ====================== from external host =================================ORCLCDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=http://www.kingceram.com/post/(SERVER=DEDICATED)(SERVICE_NAME=ORCLCDB.localdomain)))ORCLPDB1=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=http://www.kingceram.com/post/(SERVER=DEDICATED)(SERVICE_NAME=ORCLPDB1.localdomain)))##ip-address : IP address of the host where the container is running.#port: Host Port that is mapped to the port 1521 of the container.## The mapped port can be obtained from running"docker port "# ===========================================================================Thread 1 advanced to log sequence 5 (LGWR switch)Current log# 2 seq# 5 mem# 0: /u04/app/oracle/redo/redo002.log2019-11-10T00:05:44.378849+00:00ORCLPDB1(3):Opening pdb with no Resource Manager plan activePluggable database ORCLPDB1 opened read writeCompleted:alter pluggable database ORCLPDB1 openalter pluggable database all save stateCompleted:alter pluggable database all save state2019-11-10T00:05:44.861897+00:00ALTER SYSTEM SET encrypt_new_tablespaces='DDL' SCOPE=BOTH;2019-11-10T00:05:46.157969+00:00TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P287 (3600) VALUES LESS THAN (TO_DATE(' 2019-11-10 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P288 (3600) VALUES LESS THAN (TO_DATE(' 2019-11-10 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))2019-11-10T00:05:46.198517+00:00Shared IO Pool defaulting to 64MB. Trying to get it from Buffer Cache for process 486.TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P291 (3600) VALUES LESS THAN (TO_DATE(' 2019-11-10 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
可以登录到容器中:
docker exec -it odbee12201 bash
或者直接登录数据库:
docker exec -it odbee12201 bash -c "source /home/oracle/.bashrc; sqlplus /nolog"
数据库版本为12.2.0.1,实例名为,带一个可插拔数据库 。
参考