Archive for the ‘ORACLE Database’ Category

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

Oracle Database – Hausputz für Einsteiger oder Datenbank Reorganisation und mehr

Montag, Juni 1st, 2020

Oracle Database – Hausputz für Einsteiger oder Datenbank Reorganisation und mehr

Wireshark – can provide additional Oracle monitoring troubleshooting information to determine what part of the connection attempt is having issues

Montag, Juni 1st, 2020

Filter on the listener port in my example I am using port ‚1521‘ (e.g. tcp.port == 1521) once filtered make sure to decode the information on port ‚1521‘a s TNS to do this right-click on one of the packets and select ‚Decode As‘ set port ‚1521‘ to TNS

Oracle Lifetime Support Policies – April, 2020 for Database Releases

Mittwoch, Mai 6th, 2020