Installing Oracle 12c R1 Database Software on Linux 7

This document explains how to install Oracle 12c Database software on Oracle Linux 6. At the time of writing this document, latest 12c version is 12.1.0.2 which can be downloaded from My Oracle Support using patch search for patch 17694377 (Disk 1 and Disk 2 are needed for Oracle Database software). Otherwise you can also download 12.1.0.1 from www.oracle.com.

Installing Oracle 12c R1 Database Software on Linux 6

This document explains how to install Oracle 12cR1 Database software on Oracle Linux 6. At the time of writing this document, latest 12c version is 12.1.0.2 which can be downloaded from My Oracle Support using patch search for patch 17694377 (Disk 1 and Disk 2 are needed for Oracle Database software). Otherwise you can also download 12.1.0.1 from www.oracle.com

Creating Oracle Database Using dbca for 12c R1

Database Configuration Assistant (dbca) is an Oracle provided tool to create a new database. In this document I would explain how to create a new 12c R1 database using dbca. For database creation steps for Oracle 12c R2, follow this document. Steps and screens are almost same for other Oracle database versions and different OS platforms.

Changing Listener and SCAN Listener Ports

In this article I will explain how we modify Listener and SCAN Listener ports in RAC environment. For this article, in a 2 nodes RAC on Windows, my database listeners are listening ports 1521 and scan listeners are running on port 1522. I will change listeners’ ports to 1531 and scan listeners’ ports to 1532.

ORA-01017: invalid username/password - While Starting Instance using srvctl

If you face ORA-01017, following could be the reasons of this error.

• Username has been specified wrongly – check the username.
• Password has been specified wrongly – check the password.
• If you see this error while logging in as user SYS, check if password file exists. If not, re-create the password file or enable OS authentication.

Starting and Stopping Oracle Cluster (RAC)

In this article I will explain how to start and stop a cluster (RAC). To find out hot to start and stop High Availability Services (HAS) and other Grid Infrastructure resources in a standalone GI installation, check this article.
We can either use “crsctl stop/start cluster” command or “cractl start/stop crs” command to accomplish this task. The difference between both method is as follows

CRS-4563: Insufficient user privileges

[grid@dbnode1 ~]$ crsctl start crs CRS-4563: Insufficient user privileges. CRS-4000: Command Start failed, or completed with errors.

CRS-4535: Cannot communicate with Cluster Ready Services

If checking status of CRS (and other RAC resources) returns you this error, it means that CRS is not running.

[grid@dbnode1 ]$ crsctl stat res -t CRS-4535: Cannot communicate with Cluster Ready Services CRS-4000: Command Status failed, or completed with errors.

OEM Database Control Configuration gets Stuck

I encountered a situation where I was trying to configure OEM Database Control (11.2.0.4) on Windows based system using command similar to the following

emca -config dbcontrol db -repos recreate

ORA-00221: error on write to controlfile

Reason of this error (and probably instance crash) is that some other process has locked the controlfile and oracle process is not able to get hold of a lock on the controlfile before it could write in it. Most probable reason for this is some third party backup solution that might be copying oracle related files in backup process and hence holding a lock while copying.