Created
March 30, 2018 08:14
-
-
Save tthtlc/8e0a04ff958e0d0a12b6395195579a1c to your computer and use it in GitHub Desktop.
Oracle database in docker - starting up
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
docker run -it 49712d6a0946 | |
ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: anZERbg7P9k=1 | |
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 30-MAR-2018 08:03:44 | |
Copyright (c) 1991, 2016, Oracle. All rights reserved. | |
Starting /opt/oracle/product/12.2.0.1/dbhome_1/bin/tnslsnr: please wait... | |
TNSLSNR for Linux: Version 12.2.0.1.0 - Production | |
System parameter file is /opt/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora | |
Log messages written to /opt/oracle/diag/tnslsnr/8f14eca8ba12/listener/alert/log.xml | |
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) | |
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) | |
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) | |
STATUS of the LISTENER | |
------------------------ | |
Alias LISTENER | |
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production | |
Start Date 30-MAR-2018 08:03:46 | |
Uptime 0 days 0 hr. 0 min. 2 sec | |
Trace Level off | |
Security ON: Local OS Authentication | |
SNMP OFF | |
Listener Parameter File /opt/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora | |
Listener Log File /opt/oracle/diag/tnslsnr/8f14eca8ba12/listener/alert/log.xml | |
Listening Endpoints Summary... | |
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) | |
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) | |
The listener supports no services | |
The command completed successfully | |
[WARNING] [DBT-10102] The listener configuration is not selected for the database. EM DB Express URL will not be accessible. | |
CAUSE: The database should be registered with a listener in order to access the EM DB Express URL. | |
ACTION: Select a listener to be registered or created with the database. | |
Copying database files | |
1% complete | |
13% complete | |
25% complete | |
Creating and starting Oracle instance | |
26% complete | |
30% complete | |
31% complete | |
35% complete | |
38% complete | |
39% complete | |
41% complete | |
Completing Database Creation | |
42% complete | |
43% complete | |
44% complete | |
46% complete | |
47% complete | |
50% complete | |
Creating Pluggable Databases | |
55% complete | |
75% complete | |
Executing Post Configuration Actions | |
100% complete | |
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details. | |
SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 30 08:12:45 2018 | |
Copyright (c) 1982, 2016, Oracle. All rights reserved. | |
Connected to: | |
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production | |
SQL> | |
System altered. | |
SQL> | |
Pluggable database altered. | |
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production | |
The Oracle base remains unchanged with value /opt/oracle | |
######################### | |
DATABASE IS READY TO USE! | |
######################### | |
The following output is now a tail of the alert.log: | |
Completed: alter pluggable database ORCLPDB1 open | |
2018-03-30T08:12:44.880857+00:00 | |
ORCLPDB1(3):CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO | |
ORCLPDB1(3):Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO | |
ORCLPDB1(3):ALTER DATABASE DEFAULT TABLESPACE "USERS" | |
ORCLPDB1(3):Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS" | |
2018-03-30T08:12:46.060453+00:00 | |
ALTER SYSTEM SET control_files='/opt/oracle/oradata/ORCLCDB/control01.ctl' SCOPE=SPFILE; | |
ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE | |
Completed: ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment