Blog | IT Knowledge

When to use startup / shutdown database and alter database command in 12c

Hanh Nguyen

Oct 4, 20152 min read

When to use startup / shutdown database and alter database command in 12c

Before 12c there are only few commands available for startup and shutdown but if we follow that we end up starting and stopping only cdb...

0 views0 comments

Hanh Nguyen

Oct 4, 20152 min read

ORA-12545 TNS: Host or Object Does not Exist

Symptoms When attempting to connect to a RAC service name, the connection intermittently fails with an ORA-12545 error: TNS: Host or...

0 views0 comments

Hanh Nguyen

Oct 4, 20158 min read

Step by Step Guide on converting a database from Windows to AIX

Step by Step example of converting a database on a Windows host to an AIX host See also : http://www.oracle.com/technetwork/database/feat...

0 views0 comments

Hanh Nguyen

Oct 4, 20151 min read

How To Verify Which Database Features are Used

Goal This article explains how you can check which options or features are used in the database. This is particularly useful for...

0 views0 comments

Hanh Nguyen

Oct 4, 20152 min read

How to migrate an existing pre12c database(nonCDB) to 12c CDB database

Solution Migrate to 12c Pluggable database is very simple and easy. You can evaluate and adopt which one best suit for you. Plan A....

1 view0 comments

Hanh Nguyen

Oct 4, 201517 min read

Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)

Purpose This document is created for use as a guideline and checklist when manually upgrading from Oracle 10gR2 (10.2) , Oracle 11gR1...

1 view0 comments

Hanh Nguyen

Oct 4, 20151 min read

How To Restore A Database Back To The Source Release After Upgrading It To Oracle 11gR2 Using DBUA

Solution The following two requirements are needed to restore the source database using the instructions in this article: 1) The source...

0 views0 comments

Hanh Nguyen

Oct 4, 20153 min read

Downgrading Database Without Executing catdwgrd.sql

Goal Using the Flashback Database feature to fall back to the pre-upgrade release without having to run the catdwngrd.sql Flashing back...

0 views0 comments

Hanh Nguyen

Oct 4, 20154 min read

Data Collecting for Troubleshooting Oracle Clusterware (CRS or GI) And Real Application Cluster (RAC

PURPOSE This note lists what to collect for different type of Oracle Clusterware and Real Application Cluster issues, it’s not mandatory...

1 view0 comments

Hanh Nguyen

Oct 4, 201510 min read

Step By Step of Configuring Oracle 11gR2 (11.2.0.1) RAC to RAC Dataguard:

This document explains the step by step process of building the 11g R2 (11.2.0.1) 3-Node RAC primary to 2-Node RAC Physical Standby...

0 views0 comments

Hanh Nguyen

Oct 4, 20153 min read

How to Replace a Corrupt OCR Mirror File

SOLUTION 1. Start with both OCR copies in the correct state: $ ls -l /ora10g/app/oracle/oradata/V10 lrwxrwxrwx 1 oracle dba 14 Jul 25...

0 views0 comments

Hanh Nguyen

Oct 4, 201530 min read

Step By Step Installation of RAC on IBM AIX

Purpose This document will provide the reader with step-by-step instructions on how to install a cluster, install Oracle Real Application...

0 views0 comments

Hanh Nguyen

Oct 4, 201523 min read

Troubleshoot Grid Infrastructure Startup Issues

Scope This document is intended for Clusterware/RAC Database Administrators and Oracle support engineers. Details Start up sequence: In a...

0 views0 comments

Hanh Nguyen

Oct 4, 20152 min read

How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation

SCOPE DBAs and Support Analysts DETAILS 10g and 11.1 RAC: How to Clean Up After a Failed CRS Install ———————————————————— Not cleaning up...

0 views0 comments

Hanh Nguyen

Oct 4, 20153 min read

How to Deconfigure/Reconfigure(Rebuild OCR) or Deinstall Grid Infrastructure

Scope This document is intended for Oracle Clusterware/RAC Database Administrators and Oracle Support engineers. Details Grid...

0 views0 comments

Hanh Nguyen

Oct 4, 20152 min read

How to Reconfigure Oracle Restart After Server Rename

Goal The server (host) with an existing 11gR2 Server Restart (single instance) installation was renamed and rebooted. Now the ASM startup...

0 views0 comments

Hanh Nguyen

Oct 4, 20153 min read

How to Restore CRS after accidentally run localconfig on RAC system

For 10.2 and 11.1 Case I. “$ORACLE_HOME/bin/localconfig delete” has been done on some node(s) but not all of RAC system Symptoms: no...

0 views0 comments

Hanh Nguyen

Oct 4, 20155 min read

How to Modify Public Network Information including VIP in Oracle Clusterware

Purpose The purpose of this note is to illustrate how to change a public hostname, public IP, a Virtual IP Address (VIP), VIP hostname or...

0 views0 comments

Hanh Nguyen

Oct 4, 201510 min read

Vote disk Maintenance Operations

GOAL The goal of this note is to provide steps to add, remove, replace or move an Oracle Cluster Repository (OCR) and/or Voting Disk in...

0 views0 comments

Hanh Nguyen

Oct 4, 201516 min read

Managing Raw Disks in AIX to use with Oracle ASM

Purpose Effective way to manage the raw disks in AIX to be used by ASM. Steps listed in this document will also help prevent data...

3 views0 comments