Sunday, April 26, 2015

Installing Oracle 12c Release 1 RAC on Linux 7

This article explains how to install a 2 nodes Oracle 12cR1 Real Application Cluster (RAC) on Oracle Linux 7. I did this installation on Oracle Virtual Box by creating 2 virtual machines with shared storage. OS platform I used is Oracle Enterprise Linux 7 (update 1), and Oracle GI and RDBMS version is Same installation guide should work for Redhat Linux 7 also.

Wednesday, April 15, 2015

Configuring SSH for Oracle RAC installation

User equivalence is required on all nodes during Oracle RAC installation which provides OUI to log into all remote notes to perform copy/install the software and perform other configuration tasks. We can use different approaches to setup the passwordless ssh connectivity.

Monday, April 13, 2015

Using Cluster Verification Utility (cluvfy)

While installing RAC, cluster verification utility (cluvfy) is used to check whether all required prerequisites have been met, before proceeding to the Grid Infrastructure for RAC installation. 
We also use it after the installation to check if everything is working fine after the installation.

Sunday, March 29, 2015

ORA-01157: cannot identify/lock data file

While starting up a database, you may face following error messages which would not allow you to open the database.

ORA-01157: cannot identify/lock data file <file#> - see DBWR trace file
ORA-01110: data file <file#>: <file_name>

Tuesday, March 24, 2015

Manual upgrading Oracle database 11g to 12c

If you want to know how we upgrade an 11g database to 12c using DBUA, click here
For upgrading to using DBUA, click here.

This article explains how to upgrade and above, and to manually.
For details of each step, take a look at official 12c

Wednesday, March 18, 2015

ORACLE.EXE (SHAD) Processes Keep Increasing

On Windows based Oracle installations, if you hit an issue whereby you see that processes/sessions keep increasing unabated, and you keep receiving “ORA-00020: maximum number of processes exceeded” error while connecting to the database and increasing the value of parameter “processes” remains insufficient always,

ORA-00020: maximum number of processes exceeded

You may face this error message while connecting to the database instance which will also hinder you from connecting with the database instance. The reason of this error is the value of init parameter “processes” which requires to be increased to allow Oracle instance to span a new process for new session request. For example, if value of this parameter is set to 100,

Tuesday, March 17, 2015

The OracleService service terminated unexpectedly

On Windows platform, the OS level service which has a name like “OracleService<SID>”, needs to be running for the database to work. If this service stops, database also stops. You may be in a situation where you receive complaints about database sudden crash, which requires DBA intervention to start this service and database.

Monday, March 16, 2015

ORA-06553: PLS-801: internal error [56319]

You will face this error while connecting to a database which has word size (32-bit or 64-bit) different than the actual installation binaries (32-bit or 64-bit). It means that if database was created (and running) on a 64-bit platform and then you move/restore same database to a 32-bit platform, or vice versa, you will be facing this problem.

Tuesday, March 10, 2015

OEM Database Control Setup fails with ACCESS DENIED error

On Windows platform, if OEM Database Control configuration fails with “SEVERE: Error instantiating EM configuration files” message, this could be because of permission issue of the OS user doing the OEM configuration. See bellow

C:\Users>emca -config dbcontrol db -repos create

Popular Posts - All Times