Overview For Oracle Database Gateway

Gateway Installation You can install Oracle Database Gateway in either of the following configurations: ■ On the same computer as an existing Oracle database but in a different Oracle home. ■ On a system with no Oracle database. ■ On the same computer as the Oracle database and in the same Oracle home directory. Note that in this […]

Read More

Steps for Create RAC Database Manually

Manual Creation of Database is a big task for DBA. This is the initial steps for setup the IT project. We know that we can create the database in two ways one is DBCA and another is  Manual. Creation of Database in RAC environment different from the Standalone database. In this post we are going have look on […]

Read More

Compatibility Matrix for Oracle Database

Upgrade Compatibility Matrix for Upgrading to 12.2.x Minimum Version of the database that can be directly upgraded to Oracle Database 12c Release 2            Source Database                         Destination Database                                  11.2.0.3 / 11.2.0.4                                  12.2.x                                  12.1.0.1 / 12.1.0.2                                  12.2.x The following […]

Read More

Tuning the locks of SGA

This post describes some deep knowledge of SGA. LOCK_SGA is used to make sure that the contents from the SGA are not flushed, i.e data from the DB buffer cache not written back to disc. It is like to pin the contents of SGA. SGA_LOCK  locks the entire SGA into physical memory. It is usually advisable to […]

Read More

Schema and Non-Schema Objects in Oracle Database

Oracle database contains schema objects like views, tables, triggers etc., and several other types of objects which are also stored in the database but are not contained in a schema. A schema is a collection of logical structures of data, or schema objects which is owned by a database user and has the same name […]

Read More

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

I am getting ORA-32004 error while starting the database but all the parameters in spfile are fine. This issue came after upgrade the database from 10g to 11.2.0.4.0 SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance How to fix the ORA-32004 error? Cause: ORA-32004 causes because one or more obsolete parameters were specified […]

Read More

VI editor shows the error Terminal too wide within Solaris

You may receive the following error when using VI editor within Solaris. I got this error when I was adding tns entry in tnsnames.ora file. $ vi tnsnames.ora Terminal too wide Here, VI will not allow to edit files. For editing you must increase the number of columns as shown below. To resolve this increase […]

Read More

Error in Process orapwd.exe and unable to find error file opw.msb

I was trying to install Oracle 11g R2(64bit) on Windows 7 64 bit OS. But While Creating Database using DBCA i got this error. Below is the screenshot. Error in Process: %ORACLE_HOME%\server\bin\orapwd.exe Unable to find error file %ORACLE_HOME%\RDBMS\opw<lang>.msb Resolution: Set proper Home and Path using cmd and launch the dbca. C:\Users\skant>set ORACLE_HOME=C:\Oracle\app\oracle\product\11.2.0\dbhome_1 C:\Users\skant>set PATH=C:\Oracle\app\oracle\product\11.2.0\dbhome_1\server\bin:$PATH:. C:\Users\skant> […]

Read More

Using the Remote Diagnostic Agent (RDA)

The Remote Diagnostic Agent (RDA) is an Oracle-provided diagnostic tool that captures data about your database environment and packages it into a web page report. When submitting a Service Request to Oracle Support, you will often be asked to run the Remote Diagnostic Agent (RDA) and upload the results.  This allows the support analyst to review […]

Read More