search

fuzziebrain / docker-oracle-xe

Docker build for Oracle Database 18c Express Edition (XE). This project is now archived with the release of version 21c.
MIT License
273 stars 127 forks source link

Totally NOOB question... #55

Open vahr76 opened 4 years ago

vahr76 commented 4 years ago

New to docker containers

I am currently stuck here

Running Custom Scripts 100% complete Database creation complete. For details check the logfiles at: /opt/oracle/cfgtoollogs/dbca/XE. Database Information: Global Database Name:XE System Identifier(SID):XE Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.

Connect to Oracle Database using one of the connect strings: Pluggable database: be061a20d4d9/XEPDB1 Multitenant container database: be061a20d4d9 Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE The Oracle base remains unchanged with value /opt/oracle Enabling XDB for external access

SQL*Plus: Release 18.0.0.0.0 - Production on Sun Feb 23 18:19:56 2020 Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0

SQL> PL/SQL procedure successfully completed.

SQL> PL/SQL procedure successfully completed.

SQL> Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 The following output is now a tail of the alert.log: XEPDB1(3):Resize operation completed for file# 10, old size 358400K, new size 368640K 2020-02-23T18:19:52.829359+00:00 XEPDB1(3):CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/opt/oracle/oradata/XE/XEPDB1/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO 2020-02-23T18:19:54.919553+00:00 XEPDB1(3):Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/opt/oracle/oradata/XE/XEPDB1/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO XEPDB1(3):ALTER DATABASE DEFAULT TABLESPACE "USERS" XEPDB1(3):Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS" 2020-02-23T18:19:55.648034+00:00 ALTER PLUGGABLE DATABASE XEPDB1 SAVE STATE Completed: ALTER PLUGGABLE DATABASE XEPDB1 SAVE STATE root@ntbvahr:/docker-oracle-xe# root@ntbvahr:/docker-oracle-xe# root@ntbvahr:/docker-oracle-xe# root@ntbvahr:/docker-oracle-xe# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES be061a20d4d9 oracle-xe:18c "/bin/sh -c 'exec ${…" 15 minutes ago Up 15 minutes (healthy) 0.0.0.0:32118->1521/tcp, 0.0.0.0:35518->5500/tcp oracle-xe root@ntbvahr:/docker-oracle-xe# docker start oracle-xe oracle-xe root@ntbvahr:/docker-oracle-xe# root@ntbvahr:/docker-oracle-xe# root@ntbvahr:/docker-oracle-xe# root@ntbvahr:/docker-oracle-xe# sqlcl sys/Oracle18@localhost:32118/XE as sysdba

Orden «sqlcl» no encontrada. Quizá quiso decir:

la orden «sqlc» del paquete snap «sqlc (1.0.0)»

Consulte «snap info » para ver más versiones.

root@ntbvahr:/docker-oracle-xe# sqlplus sys/Oracle18@localhost:32118/XE as sysdba sqlplus: orden no encontrada root@ntbvahr:/docker-oracle-xe# sqlcl sys/Oracle18@localhost:32118/XEPDB2 as sysdba

Orden «sqlcl» no encontrada. Quizá quiso decir:

la orden «sqlc» del paquete snap «sqlc (1.0.0)»

Consulte «snap info » para ver más versiones.

root@ntbvahr:/docker-oracle-xe#

I need help to acces to SqlCl or SQLPlus... thank you very much

Running elementary OS 5.1