In alert log I got an issue ORA-00245: control file backup failed; target is likely on a local file system. Regarding this issue, I checked the snapshot control file location on rman prompt and observed that it was on local file system. In RAC environment, Snapshot control file backup location should be on a shared […]
Category: ORACLE DATABASE
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 […]
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 […]
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> […]
KST tracing in Oracle
KST tracing is an in-memory tracing feature for Oracle RDBMS Database Server, this is similar to on-disk (KSD) tracing except it is stored in SGA. For on-disk tracing, we have many events like 10046 (sql_trace), 10053 (sql_optimizer), etc. Different to these on-disk tracing, KST tracing use a cyclic buffer in the SGA and we won’t […]
11g Dynamic v$ Performance Views
In this post, we are gonna have look on some important views of Oracle Database. The follow v$ views are used by the new 11g result cache: v$result_cache_statistics v$result_cache_memory v$result_cache_objects v$result_cache_dependency v$client_result_cache_stats The Oracle 11g RAT suite includes database replay and the following v$ view provides details on usage and status for this key new […]
Data Dictionary Architecture in Oracle Database
Till today date normally we all know about Oracle Database Architecture. As we take one step forward in Oracle world we get introduces new terms and technology in Oracle. In this post let’s have a look on data dictionary architecture. Which might be new for you but I am sure it will be more interesting as Oracle Database architecture. […]
Fundamental of Data Dictionary in oracle database
Today let’s have look on the basic question of Oracle database. It will add some good knowledge in Oracle’s knowledge treasure. Normally in any interviews some of the questions ask for this topic example What is the difference between data dictionary views and dynamic performance views?, What do you mean by data dictionary views? Let’s have look […]
Oracle Licenses
Despite reams of legalese and countless blog/forum posts, basic Oracle RDBMS licensing still remains a mystery to many. While I won’t even begin to discuss components like Oracle Apps, hopefully this post may help you attain a basic understanding of Oracle, what you can license, and what it costs. Editions The first and most important […]
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 […]