Archive for the ‘ORACLE Database’ Category

Установка Oracle 19 Enterprise Edition (EE) в Docker – Installieren von Oracle 19 Enterprise Edition (EE) in Docker

Samstag, Februar 13th, 2021

   https://github.com/oracle/docker-images/blob/main/OracleDatabase/SingleInstance/README.md

The requirements are you must have 2 CPUs / 6 GByte of the memory / 15 GByte of free storage

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# git clone https://github.com/oracle/docker-images.git
Klone nach ‚docker-images‘ …
remote: Enumerating objects: 18, done.
remote: Counting objects: 100% (18/18), done.
remote: Compressing objects: 100% (17/17), done.
remote: Total 13652 (delta 1), reused 4 (delta 0), pack-reused 13634
Empfange Objekte: 100% (13652/13652), 9.83 MiB | 5.03 MiB/s, fertig.
Löse Unterschiede auf: 100% (7995/7995), fertig.
┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# cd docker-images/OracleDatabase/SingleInstance/dockerfiles/19.3.0
┌──(root💀vm-iot-jsho-docker-02)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─#
┌──(root💀vm-iot-jsho-docker-02)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# mv /tmp/LINUX.X64_193000_db_home.zip .
┌──(root💀vm-iot-jsho-docker-02)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# cd ..
┌──(root💀vm-iot-jsho-docker-02)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -h
Usage: buildContainerImage.sh -v [version] [-e | -s | -x] [-i] [-o] [container build option]
Builds a container image for Oracle Database.
Parameters:
-v: version to build
Choose one of: 11.2.0.2 12.1.0.2 12.2.0.1 18.3.0 18.4.0 19.3.0
-e: creates image based on ‚Enterprise Edition‘
-s: creates image based on ‚Standard Edition 2‘
-x: creates image based on ‚Express Edition‘
-i: ignores the MD5 checksums
-o: passes on container build option
* select one edition only: -e, -s, or -x
LICENSE UPL 1.0
Copyright (c) 2014,2021 Oracle and/or its affiliates.
┌──(root💀vm-iot-jsho-docker-02)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -v 19.3.0 -e
Oracle Database container image for ‚ee‘ version 19.3.0 is ready to be extended:
–> oracle/database:19.3.0-ee
Build completed in 653 seconds.
┌──(root💀vm-iot-jsho-docker-02)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─#
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
oracle/database 19.3.0-ee 28f2ce0e86dc 15 minutes ago 6.67GB
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#
# docker run –name <container name> \
-p <host port>:1521 -p <host port>:5500 \
-e ORACLE_SID=<your SID> \
-e ORACLE_PDB=<your PDB name> \
-e ORACLE_PWD=<your database passwords> \
-e INIT_SGA_SIZE=<your database SGA memory in MB> \
-e INIT_PGA_SIZE=<your database PGA memory in MB> \
-e ORACLE_EDITION=<your database edition> \
-e ORACLE_CHARACTERSET=<your character set> \
-v [<host mount point>:]/opt/oracle/oradata \
oracle/database:19.3.0-ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker run -d -it –name oracle19ee –hostname oracle19ee -p 1521:1521 -p 5500:5500 -e ORACLE_PWD=<password> oracle/database:19.3.0-ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker logs -f oracle19ee
ORACLE EDITION: ENTERPRISE
ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN:<password>
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 12-FEB-2021 08:33:21
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait…
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/oracle19ee/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 19.0.0.0.0 – Production
Start Date 12-FEB-2021 08:33:21
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/oracle19ee/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
.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file „/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log“ for further details.
SQL*Plus: Release 19.0.0.0.0 – Production on Fri Feb 12 08:50:20 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL>
System altered.
SQL>
System altered.
SQL>
Pluggable database altered.
SQL>
PL/SQL procedure successfully completed.
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
#########################
DATABASE IS READY TO USE!
#########################
The following output is now a tail of the alert.log:
ORCLPDB1(3):ALTER DATABASE DEFAULT TABLESPACE „USERS“
ORCLPDB1(3):Completed: ALTER DATABASE DEFAULT TABLESPACE „USERS“
2021-02-12T08:50:20.389852+00:00
ALTER SYSTEM SET control_files=’/opt/oracle/oradata/ORCLCDB/control01.ctl‘ SCOPE=SPFILE;
2021-02-12T08:50:20.395466+00:00
ALTER SYSTEM SET local_listener=“ SCOPE=BOTH;
ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
Completed: ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
XDB initialized.
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker exec -it oracle19ee /bin/bash
[oracle@oracle19ee ~]$
Oracle Enterprise Manager Database Express
https://127.0.0.1:5500/em/login​
system <password> orclpdb1

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
ecb493fec6e5 oracle/database:19.3.0-ee „/bin/sh -c ‚exec $O…“ 28 hours ago Up 18 hours (healthy) 0.0.0.0:1521->1521/tcp, 0.0.0.0:5500->5500/tcp oracle19ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker stop -t 30 oracle19ee
oracle19ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker start oracle19ee
oracle19ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker exec -it oracle19ee /bin/bash
[oracle@oracle19ee ~]$
[oracle@oracle19ee ~]$ sqlplus pdbadmin@orclpdb1
SQL*Plus: Release 19.0.0.0.0 – Production on Sat Feb 13 17:04:15 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter password: <password>
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL>

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker commit -p oracle19ee oracle19ee.backup.20210213
sha256:ec89f8aa5c9b69a63f96aa43c433f2d34a82eebd2b699379077f49ff05179290
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
oracle19ee.backup.20210213 latest ec89f8aa5c9b 14 minutes ago 11.5GB
oracle/database 19.3.0-ee 28f2ce0e86dc 2 days ago 6.67GB
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker save -o /tmp/oracle19ee.backup.20210213.tar oracle19ee.backup.20210213
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#

Установка Oracle 18 Express Edition (XE) в Docker – Installieren von Oracle 18 Express Edition (XE) in Docker

Donnerstag, Februar 11th, 2021

Docker Official Images – Oracle Database 12c Enterprise Edition and the ‚Migration‘ to Oracle Database 19c Standard Edition 2

Donnerstag, Februar 11th, 2021

https://hub.docker.com/_/oracle-database-enterprise-edition

┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# docker login
┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# docker pull store/oracle/database-enterprise:12.2.0.1
12.2.0.1: Pulling from store/oracle/database-enterprise
4ce27fe12c04: Pull complete
9d3556e8e792: Pull complete
fc60a1a28025: Pull complete
0c32e4ed872e: Pull complete
b465d9b6e399: Pull complete
Digest: sha256:40760ac70dba2c4c70d0c542e42e082e8b04d9040d91688d63f728af764a2f5d
Status: Downloaded newer image for store/oracle/database-enterprise:12.2.0.1
docker.io/store/oracle/database-enterprise:12.2.0.1

 

https://github.com/oracle/docker-images

┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# git clone https://github.com/oracle/docker-images.git 128 ⨯
Klone nach ‚docker-images‘ …
remote: Enumerating objects: 18, done.
remote: Counting objects: 100% (18/18), done.
remote: Compressing objects: 100% (17/17), done.
remote: Total 13652 (delta 1), reused 4 (delta 0), pack-reused 13634
Empfange Objekte: 100% (13652/13652), 9.83 MiB | 5.03 MiB/s, fertig.
Löse Unterschiede auf: 100% (7995/7995), fertig.
┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# cd docker-images/OracleDatabase/SingleInstance/dockerfiles
┌──(root💀vm-iot-jsho-docker-01)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─#
┌──(root💀vm-iot-jsho-docker-01)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -h
Usage: buildContainerImage.sh -v [version] [-e | -s | -x] [-i] [-o] [container build option]
Builds a container image for Oracle Database.
Parameters:
-v: version to build
Choose one of: 11.2.0.2 12.1.0.2 12.2.0.1 18.3.0 18.4.0 19.3.0
-e: creates image based on ‚Enterprise Edition‘
-s: creates image based on ‚Standard Edition 2‘
-x: creates image based on ‚Express Edition‘
-i: ignores the MD5 checksums
-o: passes on container build option
* select one edition only: -e, -s, or -x
LICENSE UPL 1.0
Copyright (c) 2014,2021 Oracle and/or its affiliates.

┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# cd docker-images/OracleDatabase/SingleInstance/dockerfiles/19.3.0
┌──(root💀vm-iot-jsho-docker-01)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─#
┌──(root💀vm-iot-jsho-docker-01)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# mv /tmp/LINUX.X64_193000_db_home.zip .
┌──(root💀vm-iot-jsho-docker-01)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─#
┌──(root💀vm-iot-jsho-docker-01)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# cd ..
┌──(root💀vm-iot-jsho-docker-01)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -h
Usage: buildContainerImage.sh -v [version] [-e | -s | -x] [-i] [-o] [container build option]
Builds a container image for Oracle Database.
Parameters:
-v: version to build
Choose one of: 11.2.0.2 12.1.0.2 12.2.0.1 18.3.0 18.4.0 19.3.0
-e: creates image based on ‚Enterprise Edition‘
-s: creates image based on ‚Standard Edition 2‘
-x: creates image based on ‚Express Edition‘
-i: ignores the MD5 checksums
-o: passes on container build option
* select one edition only: -e, -s, or -x
LICENSE UPL 1.0
Copyright (c) 2014,2021 Oracle and/or its affiliates.
┌──(root💀vm-iot-jsho-docker-01)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─#
# ./buildContainerImage.sh -v 19.3.0 -s

Oracle Linux Oracle Container Runtime for Docker – verify readiness of Database switchover using Data Guard Validate command

Mittwoch, Februar 10th, 2021

   Oracle Data Guard ensures high availability, data protection, and disaster recovery for Oracle database. Data Guard provides a comprehensive set of services for DR solution. The services can be used to create, maintain, manage, monitor one or more standby databases, and validate the database for the readiness of role switch. Data Guard can switch any standby database manually or automatically in case the production database becomes unavailable due to a planned or unplanned outage. Data Guard minimizes the downtime associated with the outage. Oracle Data Guard is included with the Enterprise Edition and Personal Edition of the Oracle database software

Docker Container: ora19cp, ora19cs
Oracle Database version: 19.3.0.0
Oracle Database Edition: Oracle Database 19c Enterprise Edition
Container database: False

docker run -i -t -d –privileged -v /home/dps/Docker/shared:/shared -p 15219:1521 –hostname ora19c_primary –name ora19cp dps/oracle19c
docker run -i -t -d –privileged -v /home/dps/Docker/shared:/shared -p 15220:1521 –hostname ora19c_standby –name ora19cs dps/oracle19c

Oracle Database – ’spfile‘ in einem Single-Instance-System & für einen Parameter mehrere Einträge

Montag, Februar 8th, 2021

   Oracle Database – ’spfile‘ in einem Single-Instance-System & für einen Parameter mehrere Einträge

DEMODB@> select sid,name,value from v$spparameter where name=’optimizer_index_cost_adj‘
2 ;
SID NAME VALUE
———- —————————— ——————————
* optimizer_index_cost_adj 100
DEMODB optimizer_index_cost_adj 110
2 rows selected.

Oracle Critical Patch Update Advisory – January 2021

Samstag, Februar 6th, 2021

Oracle Database 21c – the latest Innovation release of the world’s most popular database

Donnerstag, Januar 14th, 2021

Oracle Real Application Cluster (RAC) – Support on VMware Clouds

Montag, Dezember 14th, 2020

As of December 9th 2020 VMware recommends that anyone currently running OR planning to run, an Oracle Real Application Cluster (RAC) in a VMware Cloud environment reach out to Oracle Corporation for any Oracle support related matters with RAC on our cloud platform

Key points to keep in mind …

1) This guidance does NOT relate to or affect the technical feasibility of running Oracle RAC or the licensing of Oracle RAC in a VMware Cloud environment

2) This guidance does NOT pertain to running Oracle RAC in an on-premises VMware Software Defined Data Center as that remains unaffected. More on the Oracle on VMware Support Metalink Note 249212.1 can be found here

3) This guidance is based on recent changes to the “Oracle Real Application Clusters (RAC) Support on Third-Party Clouds – An Overview and Clarification – Revision 2020.06.14” Oracle document

Oracle Lifetime Support Policies – August, 2020 for Database Releases

Samstag, September 12th, 2020

VMware vSphere 7.0 – on demand scaling up resources for Oracle production workloads with ‚Hot Add CPU‘ and ‚Hot Add Memory‘

Samstag, August 22nd, 2020

VMware vSphere 7.0 – on demand hot extend Oracle Disks online without downtime with ‚Hot Extend Disks‘

Samstag, August 22nd, 2020

Oracle Machine Learning – consists of complementary components supporting scalable machine learning algorithms for in-database and big data environments, notebook technology, SQL and R APIs, and Hadoop/Spark environments

Donnerstag, August 20th, 2020

Red Hat Enterprise Linux 8 – use this checklist to check minimum operating system requirements for Oracle Database 19c

Dienstag, Juli 14th, 2020

Operating System General Checklist for Oracle Database 19c (19.7 or 19.6 with patches ) on Linux – Red Hat Enterprise Linux 8 ( 4.18.0-80.el8.x86_64 or later ) is supported

Oracle Lifetime Support Policies – June, 2020 for Database Releases

Samstag, Juli 11th, 2020

Oracle Database – client interoperability matrix

Dienstag, Juni 2nd, 2020