Oracle Articles:
List Of my articles about Oracle Database 11g, 12c, 18c & 19c, 23c Oracle Grid Infrastructure, RAC, Data Guard, Tuning database, OCFS2 and MySQL…
- Errors while standby_file_management = manual in standby DB
- Oracle Database Server/Client certificate/TCPS (Oracle 19c)
- Create Client Wallet and Certificate (Oracle 19c)
- Create Server Wallet and Certificate (Oracle 19c)
- Reinstate failed for Data Guard: Flashback Database is disabled
- Reinstate for Data Guard succeeded
- Reinstate failed for Data Guard: Flashback Database is disabled
- Physical/Logical Health Monitor check (Oracle 19c)
- Restore/Recover datafile from Standby without database catalog (19c)
- Backup as copy database to an other server with RMAN (Oracle 19c)
- Oracle Database Software Upgrade 19.18 to 19.19 (19c)
- RMAN duplicate to create a clone database READ/Write
- Check/Recover a corrupted Block (Oracle 19c)
- RMAN duplicate Database for Data Guard ( 19c )
- Oracle 23c: Change Database Name FREE to DB23c
- New Features 23c: GROUP BY with Aliases/Position Number
- New Features 23c: Table with EXIST or NOT EXIST Clause
- New Features 23c: Asynchronous Transactions
- New Features 23c: BOOLEAN Column Data Type
- New Features 23c: Table VALUES Constructor
- New Features 23c: Select without DUAL
- Cloud Control Enterprise Manager 13c, Email notifications
- Patch 34765931 – Database Release Update 19.18.0.0.230117 (REL-JAN230131)
- Create our first 23c instance: FREE
- Install 23c Oracle Database: Free Version
- Welcome 23c Oracle Database: Free Version
- Warning: ORA-16714: Some Parameter are inconsistent with the database setting
- Add Oracle database service Naming (tnsnames.ora) 19c
- Register Database services in Listener (Oracle 19c)
- Warning: ORA-16714: Some Parameter are inconsistent with the database setting
- Real-time cascading within Oracle Data Guard 12c
- Deploy OEMCC 13c5 Agent In Silent Mode
- Get OEMCC 13c5 Agent zip file
- Upgrade Oracle Home 19c Software (19.3 to 19.12)
- OPatch 12.2.0.1.27 for DB 19.0.0.0.0
- Convert RAC 19c administrator managed to policy manager
- Convert Oracle RAConeNode to RAC 19c, Database is administrator managed
- Convert Oracle RAC to RAConeNode 19c, Database is administrator managed
- Upgrade Oracle Database RAC 2 nodes CDB, 2 PDBs from 19.3 to 19.9
- Upgrade Oracle Clusterware GI 19c from 19.3 to 19.9
- RMAN-08138: warning: archived log not deleted – must create more backups
- RMAN-08591: warning: invalid archived log deletion policy
- Password-Mode Decryption RMAN Backup
- Password-Mode Encryption RMAN Backup
- Black or White List by IP address SQL NET
- Register Oracle service name on Listener other than 1521
- Upgrade the oracle Opatch
- Check Oracle Clusterware patch release
- Upgrade Oracle Home 19c (19.3 to 19.9)
- Create a Service Naming with NETMGR within Oracle 12.2
- Create a Listener with NETMGR within Oracle 12.2
- [DBT-12510] The database option ‘SAMPLE_SCHEMA’ is not feasible to be installed in the current Oracle home.
- Install Oracle Database 19c Silent Mode On Oracle Linux 8
- [FATAL] [DBT-06103] The port (5,500) is already in use. ACTION: Specify a free port, Oracle 19c
- [WARNING] [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’ 19c on Oracle Linux 8
- Install Oracle Database 19c Silent Mode Software Only
- Install Oracle database 19c prerequisites on Oracle Linux 8
- Install OCI CLI on Oracle Linux 8
- Get prepared for the Oracle Cloud Infrastructure 2019 Certified Architect Professional
- RAC 12cR2 Cluster Bug: HANG DUE TO HIGH GC INDEX OPERATIONS/ENQ: TX ROW LOCK CONTENTION WAITS: Bug resolved via Patch 28023081
- Patch 26609817: DATABASE RELEASE UPDATE 12.2.0.1.170814 (RAC)
- Oracle Cloud Control database Plug-in on the agent in 12cR1
- Bug while creating new administrator manager RAC 12cR1 while we have one
- DevOps/DBA n°2: Oracle database EE 18c on Docker Image based on Oracle Linux 7u7
- DevOps/DBA n°1: Oracle database EE 19c on Docker Image based on Oracle Linux 7u7
- [FATAL] [DBT-11211] 19c DBCA: The AMM option is not allowed while the physical memory is greater than 4GB
- Drop guaranteed restore points: ORA-38781
- Upgrade Oracle database from 12c (12.1.0.2) to 19c (19.3.0.0) using the RMAN backup
- Install Oracle database 12cR1 RAC 3 nodes on Oracle Linux 6u10
- Installing Oracle Grid Infrastructure 12cR1 on 3 nodes
- Check prerequisites before installing Oracle Grid Infrastructure on 3 nodes
- Install Oracle database 19c3 on ASM
- Create a new ASM DiskGoup on 19c3
- Install Oracle Grid Infrastructure Standalone 19c3
- Upgrade OEMCC Agents 12c4 to 13c2
- Upgrade Oracle Enterprise Manager Cloud Control 12.1.0.4 to 13.2.0.0 on Oracle Linux 6.5
- Restore MySQL 5.7 Backup with MySQL Enterprise Backup MEB 4.1.0
- Online full backup of MySQL server 5.7 using the MySQL Enterprise Backup
- Upgrade MySQL Server 5.5 to 5.7 on Oracle Linux 7
- Convert SNAPSHOT STANDBY to PHYSICAL STANDBY 12cR1
- Convert PHYSICAL STANDBY to SNAPSHOT STANDBY 12cR1
- Transportable tablespace from 11gR2 to 12cR1
- Resize RAC 11gR2 Cluster Health Monitor repository
- Upgrade Oracle Database 12cR1 to 12cR2 with RMAN
- Change a PDB Character Set within Oracle database 12cR2 (12.2.0.1) using the DMU tool
- Unplug a pluggable database 12cR2 using DBCA
- Create a pluggable database 12cR2 using DBCA
- Change Oracle database 12cR2 Name with DBNEWID
- Upgrade Oracle Database from 12.1.0.2 to 12.2.0.1 using DBUA
- Dealing with: ORA-01804: failure to initialize timezone information
- Enable Archivelog on Oracle database 12R2
- Install Step by Step Oracle database 12R2 on Oracle Linux 7
- Install prerequisites for Oracle database 12R2 on Oracle Linux 7
- Move audit Trail table to created-user Tablespace with Oracle database 11g & 12c
- Enable HugePages RHEL 7/OL 7 within Oracle Database 12c
- List of Linux physical devices, mapped by ASM disks, using Major & minor number
- Dealing with INVALID status of Oracle database components after upgrade to 12c (12.1.0.2)
- Upgrade Oracle database from 11.2.0.4 to 12c (12.1.0.2) using the RMAN backup
- Upgrade Oracle database from 11.2.0.4 to 12c (12.1.0.2) using the RMAN backup
- Upgrade Oracle database from 11.2.0.1 to 11.2.0.4 using RMAN backup
- Part 2: Upgrade Oracle Grid Infrastructure & Database from 11gR2 to 12C
- Part 1: Install Oracle Grid infrastructure standalone & Oracle Database 11gR2
- Creation of ASM disks on Oracle Linux using ASMLib
- Active Oracle database duplication
- Active-passive High Availability Solution for Oracle Database without Data Guard solution:
- Database SQL; Delete vs Truncate and segment size allocated
- DNS configuration to use the SCAN with Oracle RAC Database
- Mount an OCFS2 while the SELinux status on enforcing mode
- SAN and OCFS2 over IP Multipathing (bonding) on two Ethernet cards
- Set up an automatically Oracle database backup with expdp!
