Oracle Database identifier in short DBID is an internal, unique identifier for an Oracle database. Database administrator must note down the DBID in safe place, so that any miss-happening to the database could be easily identified and recovered. In case it is required to recover SPFILE or control file from autobackup, such as disaster recovery, […]
Monthly Archives: October 2017
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 […]
FINDING SCHEMA SIZE FOR A ORACLE DATABASE
SQL> BREAK ON REPORT SQL> COMPUTE SUM LABEL TOTAL OF “Size of Each Segment in MB” ON REPORT SQL> select segment_type, sum(bytes/1024/1024) “Size of Each Segment in MB” from dba_segments where owner=’SYS’ group by segment_type order by 1;
ORA-00245: Control File Backup Failed; Target is Likely on a Local File System
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 […]
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> […]
Multiplex control file in 11gR2 RAC ASM
After creating 11gR2 RAC database, we wanted to enable multiplexing for the control files. Oracle recommends multiplexing the control files . We are using ASM for the storage of control files. At the time of creating the database by dbca we can do multiplexing or we can also do later manually as described below. Goal:- […]
Steps to Apply Database Patch From OEM Cloud Control
Being a Core DBA we have deep knowledge about patching.On the internet we have lots of knowledge is available about patching.This patching is different from the normal one. In this article, we are going to have look on steps which use to Apply Database Patch From OEM Cloud Control. With help of OEM cloud control, […]
How to check hidden parameter in Oracle
Check hidden parameter in Oracle set lines 200 col name for a50 col value for a40 select ksppinm name , ksppstvl value from x$ksppi a, x$ksppsv b where a.indx=b.indx and substr(ksppinm,1,1) = ‘_’;