Skip to content
This repository has been archived by the owner on Sep 26, 2021. It is now read-only.

Totally NOOB question... #55

Open
vahr76 opened this issue Feb 23, 2020 · 0 comments
Open

Totally NOOB question... #55

vahr76 opened this issue Feb 23, 2020 · 0 comments

Comments

@vahr76
Copy link

vahr76 commented Feb 23, 2020

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant