Code Monkey home page Code Monkey logo

oracle19c-docker's Issues

Getting following error on M1 Mackbook

zainzafar@Zains-MacBook-Pro dockerfiles % sudo ./buildContainerImage.sh -v 19.3.0 -e
Checking Docker version.
Checking if required packages are present and valid...
LINUX.X64_193000_db_home.zip: OK

Container runtime info:
Client:
Context: default
Debug Mode: false
Plugins:
buildx: Docker Buildx (Docker Inc., v0.10.0)
compose: Docker Compose (Docker Inc., v2.15.1)
dev: Docker Dev Environments (Docker Inc., v0.0.5)
extension: Manages Docker extensions (Docker Inc., v0.2.17)
sbom: View the packaged-based Software Bill Of Materials (SBOM) for an image (Anchore Inc., 0.6.0)
scan: Docker Scan (Docker Inc., v0.23.0)

Server:
Containers: 0
Running: 0
Paused: 0
Stopped: 0
Images: 1
Server Version: 20.10.22
Storage Driver: overlay2
Backing Filesystem: extfs
Supports d_type: true
Native Overlay Diff: true
userxattr: false
Logging Driver: json-file
Cgroup Driver: cgroupfs
Cgroup Version: 2
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Log: awslogs fluentd gcplogs gelf journald json-file local logentries splunk syslog
Swarm: inactive
Runtimes: io.containerd.runc.v2 io.containerd.runtime.v1.linux runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9ba4b250366a5ddde94bb7c9d1def331423aa323
runc version: v1.1.4-0-g5fd4c4d
init version: de40ad0
Security Options:
seccomp
Profile: default
cgroupns
Kernel Version: 5.15.49-linuxkit
Operating System: Docker Desktop
OSType: linux
Architecture: aarch64
CPUs: 4
Total Memory: 3.841GiB
Name: docker-desktop
ID: S25S:V4DY:OY4B:6RW4:76SW:RNUN:WFCN:SYSG:A3RC:OJJN:SEQJ:DAAT
Docker Root Dir: /var/lib/docker
Debug Mode: false
HTTP Proxy: http.docker.internal:3128
HTTPS Proxy: http.docker.internal:3128
No Proxy: hubproxy.docker.internal
Registry: https://index.docker.io/v1/
Labels:
Experimental: false
Insecure Registries:
hubproxy.docker.internal:5000
127.0.0.0/8
Live Restore Enabled: false

==========================
Building image 'oracle/database:19.3.0-ee' ...
[+] Building 0.0s (0/1)
[+] Building 0.3s (2/3)
=> [internal] load build definition from Dockerfile 0.0s
[+] Building 0.4s (3/3) FINISHED
=> [internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 37B 0.0s
=> [internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> ERROR [internal] load metadata for docker.io/library/oraclelinux:7-slim 0.4s

[internal] load metadata for docker.io/library/oraclelinux:7-slim:

failed to solve with frontend dockerfile.v0: failed to create LLB definition: rpc error: code = Unknown desc = error getting credentials - err: exit status 1, out: ``

ERROR: Oracle Database container image was NOT successfully created.
ERROR: Check the output and correct any reported problems with the build operation.

Upon restart, it says installation was not successful

Successful install and could connect. Restarted and got these errors:

ORACLE_SID: orcl
ORACLE_PDB: ORCLPDB1
ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: password
ORACLE_CDB: false
ORACLE_PDB_NUM: 0
ORACLE_MEM: 4000
2019-08-01T03:08:58.510558522Z 
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 01-AUG-2019 03:08:58
2019-08-01T03:08:58.510598886Z 
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
2019-08-01T03:08:58.510608052Z 
Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...
2019-08-01T03:08:58.591851965Z 
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/56099cd8ad74/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)))
2019-08-01T03:08:58.971212234Z 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                01-AUG-2019 03:08:58
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/56099cd8ad74/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-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/orcl.
Database Information:
Global Database Name:orcl
System Identifier(SID):orcl
Look at the log file "/opt/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.
2019-08-01T03:18:06.499051076Z 
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 1 03:18:06 2019
Version 19.3.0.0.0
2019-08-01T03:18:06.499080417Z 
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
2019-08-01T03:18:06.499095805Z 
2019-08-01T03:18:06.522773466Z 
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
2019-08-01T03:18:06.522802683Z 
SQL> 
System altered.
2019-08-01T03:18:06.529415579Z 
SQL> 
System altered.
2019-08-01T03:18:06.538810436Z 
SQL>    ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
*
ERROR at line 1:
ORA-65090: operation only allowed in a container database
2019-08-01T03:18:06.549303343Z 
2019-08-01T03:18:06.549305639Z 
SQL> 
PL/SQL procedure successfully completed.
2019-08-01T03:18:06.604587925Z 
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
The Oracle base remains unchanged with value /opt/oracle
#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################
The following output is now a tail of the alert.log:
29170717,29173618,29181568,29182920,29183298,29186091,29191827,29201143,
29201695,29209545,29210577,29210610,29210624,29210683,29213641,29219627,
29224294,29225861,29229839,29235934,29242906,29243749,29244495,29244766,
29244968,29248723,29249583,29251564,29255616,29260224,29261695,29271019,
29273360,29282090,29282666,29285453,29285621,29290235,29292232,29293806,
29294753,29299830,29307090,29307109,29311336,29329675,29330791,29339299,
29357821,29360467,29360775,29367971,29368725,29379299,29379381,29380527,
29381000,29382296,29391301,29393649,29402110,29411931,29413360,29457319,
29465047
===========================================================
2019-08-01T03:18:08.740558+00:00
Resize operation completed for file# 4, old size 337920K, new size 343040K
Resize operation completed for file# 4, old size 343040K, new size 348160K
2019-08-01T04:00:37.868908+00:00
Resize operation completed for file# 3, old size 512000K, new size 522240K
2019-08-01T04:00:38.547269+00:00
Resize operation completed for file# 3, old size 522240K, new size 542720K
2019-08-01T04:12:58.902581+00:00
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
2019-08-01T04:15:18.283173+00:00
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
2019-08-01T04:15:34.460247+00:00
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
2019-08-01T04:15:38.364843+00:00
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
JIT: pid 3924 requesting full stop
2019-08-01T06:07:08.412371+00:00
Warning: VKTM detected a forward time drift. 
Please see the VKTM trace file for more details:
/opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_vktm_2119.trc
Stopping container.
SIGTERM received, shutting down database!
ORACLE_SID: orcl
ORACLE_PDB: ORCLPDB1
ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: password
ORACLE_CDB: false
ORACLE_PDB_NUM: 0
ORACLE_MEM: 4000
2019-09-08T23:49:57.944354400Z 
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-SEP-2019 23:49:57
2019-09-08T23:49:57.944456100Z 
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
2019-09-08T23:49:57.944498300Z 
Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...
2019-09-08T23:49:59.635241300Z 
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/56099cd8ad74/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)))
2019-09-08T23:49:59.915542400Z 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                08-SEP-2019 23:49:59
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/56099cd8ad74/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-10328] Specified GDB Name (orcl) may have a potential conflict with an already existing database on the system.
   ACTION: Specify a different GDB Name that does not conflict with existing databases on the system.
[FATAL] [DBT-10317] Specified SID Name (orcl) already exists.
   ACTION: Specify a different SID Name that does not already exist.
[ 2019-08-01 03:10:05.746 UTC ] [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
[ 2019-08-01 03:10:05.746 UTC ] [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
[ 2019-08-01 03:10:27.598 UTC ] Prepare for db operation
DBCA_PROGRESS : 10%
[ 2019-08-01 03:10:27.717 UTC ] Copying database files
DBCA_PROGRESS : 40%
[ 2019-08-01 03:11:51.402 UTC ] Creating and starting Oracle instance
DBCA_PROGRESS : 42%
DBCA_PROGRESS : 46%
DBCA_PROGRESS : 50%
DBCA_PROGRESS : 54%
DBCA_PROGRESS : 60%
[ 2019-08-01 03:15:41.722 UTC ] Completing Database Creation
DBCA_PROGRESS : 66%
DBCA_PROGRESS : 70%
[ 2019-08-01 03:18:06.091 UTC ] Executing Post Configuration Actions
DBCA_PROGRESS : 100%
[ 2019-08-01 03:18:06.092 UTC ] Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/orcl.
Database Information:
Global Database Name:orcl
System Identifier(SID):orcl
2019-09-08T23:50:09.298739700Z 
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Sep 8 23:50:09 2019
Version 19.3.0.0.0
2019-09-08T23:50:09.298866400Z 
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
2019-09-08T23:50:09.298922600Z 
Connected to an idle instance.
2019-09-08T23:50:10.728515300Z 
SQL>    ALTER SYSTEM SET control_files='/opt/oracle/oradata/orcl/control01.ctl' scope=spfile
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
2019-09-08T23:50:10.731639500Z 
2019-09-08T23:50:10.731662100Z 
SQL>    ALTER SYSTEM SET local_listener=''
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
2019-09-08T23:50:10.732491100Z 
2019-09-08T23:50:10.732511100Z 
SQL>    ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
2019-09-08T23:50:10.733408900Z 
2019-09-08T23:50:10.733427400Z 
SQL> BEGIN DBMS_XDB_CONFIG.SETGLOBALPORTENABLED (TRUE); END;
2019-09-08T23:50:10.734147100Z 
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
2019-09-08T23:50:10.734318100Z 
2019-09-08T23:50:10.734345200Z 
SQL> Disconnected
mv: cannot stat '/opt/oracle/product/19c/dbhome_1/dbs/spfileorcl.ora': No such file or directory
mv: cannot stat '/opt/oracle/product/19c/dbhome_1/dbs/orapworcl': No such file or directory
The Oracle base remains unchanged with value /opt/oracle
#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################

How to connect to it using SQLPlus in the docker itself?

I created the default docker image with default parameters that you specified. But i have no idea on how to connect to it via sqlplus on a docker image itself:
I tried:
sudo docker exec -ti oracle19c sqlplus /nolog

then I got:
SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 7 12:27:29 2022
Version 19.3.0.0.0

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

SQL>

Then I entered:
connect sys as sysdba

And I got this error:
ORA-12162: TNS:net service name is incorrectly specified

What can I do?

FAILED CONNECTION ON INTELLIJ IDEA

Installed my docker Oracle container and it runs successfully. The challenge is connecting it to database tools for query purposes.

Used this command... --name oracle19c
-p 1521:1521
-p 5500:5500
-e ORACLE_PDB=bencon
-e ORACLE_PWD=admin@123
-e INIT_SGA_SIZE=6000
-e INIT_PGA_SIZE=2000
-c 4
-d
oracle/database:19.3.0-ee
...
Screenshot 2024-04-01 at 01 15 12
... What could be wrong?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.