Author: Howie Jiang

How to install 18c Grid Infrastructure in Silent Mode on Linux 7

This blog post will show you how to install 18c Grid and upgrade to 18.6.0.0. 1. Download the 18c binairy and Apr, 2019 PSU: 18c Grid: https://download.oracle.com/otn/linux/oracle18c/180000/LINUX.X64_180000_grid_home.zip Apr 2019 PSU: https://updates.oracle.com/Orion/Services/download/p29251992_180000_Linux-x86-64.zip?aru=22869122&patch_file=p29251992_180000_Linux-x86-64.zip OPatch 12.2.0.1.17: https://updates.oracle.com/Orion/Services/download/p6880880_180000_Linux-x86-64.zip?aru=22870225&patch_file=p6880880_180000_Linux-x86-64.zip 2. Prepare OS for Oracle installation,…

Read More >

Upgrading grid infrastructure from 12.1 to 12.2 in Exadata

1 Pre-requisites / preparation 12.2 Grid Infrastructure and Database Upgrade steps for Exadata Database Machine running 11.2.0.3 and later on Oracle Linux (Doc ID 2111010.1) Patches to apply before upgrading Oracle GI and DB to 12.2.0.1 (Doc ID 2180188.1) 1.1…

Read More >

Log rotation for Oracle database

Most of you may already know how to configure the log rotation for your database alert log or the listener log etc,. As root, you can manually create a configuration file as below, and put it into /etc/logrotate.d/. /u01/app/oracle/diag/rdbms/test1/TEST1/trace/alert_TEST1.log {…

Read More >

How to troubleshoot an ORA-28030 error

ORA-28030: Server encountered problems accessing LDAP directory service. Cause: Unable to access LDAP directory service. Action: Please contact your system administrator.   There are many reasons for causing this error when you are trying to login to the database with…

Read More >

How to migrate a Database using GoldenGate

There are many ways to migrate a database from A server to B server like Datapump, RMAN,etc. Using the combination of datapump and GoldenGate to migrate your database on cross-platform will minimize your down-time to even three minutes. This method…

Read More >

12c: How to Restore/Recover a Small Table in a Large Database

As a DBA, you will receive requests from developers or users, indicating that they deleted some data in a small table in a large database a few hours prior. They will probably want you to recover the data as soon as possible, and it…

Read More >