Monthly Archives: May 2015

ASMB terminating , communication failure with ASM instance, ORA-03113:end-of-file


Wed May 27 20:43:53 2015 Database Instance crashes , and database instance it will be automatically shutdown. ORA-15064: communication failure with ASM instance ORA-03113: end-of-file on communication channel Process ID: Session ID: 728 Serial number: 17031 Private Interface ‘bge1:1′ configured from GPnP for use as a private interconnect. [name=’bge1:1’, type=1, ip=169.254.123.80, mac=00-21-28-a4-85-ef-00-00-00-00-00-00-00-00-00-00-00-2f-ff-ff, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62] […]

Oracle RAC Environment CRSCTL Commands


crsctl add category crsctl add crs administrator crsctl add css votedisk crsctl add policy crsctl add serverpool crsctl check cluster crsctl check crs crsctl check resource crsctl check ctss crsctl config crs crsctl create policyset crsctl delete category crsctl delete crs administrator crsctl delete css votedisk crsctl delete node crsctl delete policy crsctl delete serverpool […]

for metadata expdp & impdp


take export of metadata of schema only using expdp >expdp directory=exp_dp dumpfile=j.dmp content=metadata_only schemas=<schema_name> after that create sqlfile using impdp – >impdp directory=exp_dp dumpfile=j.dmp logfile=imp_j.log sqlfile=j.sql include=view You can filter the views only like above, you can get everything in the schema as follows: >impdp directory=exp_dp dumpfile=j.dmp logfile=imp_j.log sqlfile=j.sql

RMAN backup in noarchivelog mode


RMAN> run { 2> backup database format ‘/u01/stage/db_%U’; 3> backup current controlfile format ‘/u01/stage/cntrl_%U’; 4> backup spfile format ‘/u01/stage/spfile_%U’; 4> sql “alter database backup controlfile to ”/u01/stage/control.ctl” reuse”; 4> sql “alter database backup controlfile to trace as ”/u01/stage/control.trc” reuse”; 4> sql “create pfile=”/u01/stage/pfile.ora” from spfile”; 5> }  

ORA-02429: cannot drop index used for enforcement of unique/primary key


==================================== —when I execute SQL> drop index IND_ON_ANAR_TEST ; —-its reply ORA-02429: cannot drop index used for enforcement of unique/primary key If it is an unique index that enforces unique constraint you cannot simply drop it You have to drop unique constraint BY alter table tablename drop constraint constraintname; ======================================= Hands on Example ====================================== SQL*Plus: […]

How to Calculate IOPS in Exadata


Exadata Document Available Publicly


Oracle Exadata Documentation http://docs.oracle.com/cd/E50790_01/welcome.html 

Calculate Network Bandwidth On Exadata Database Servers


We have two database node on Exadata bakuexa1dbadm01 bakuexa1dbadm02 Step 1 Download nc-1.84-10.fc6.x86_64.rpm and copy on the nodes where you want to carry out the bandwidth test. Step 2 Install RPM on both nodes. [root@bakuexa1dbadm01 ~]# rpm -ivh nc-1.84-10.fc6.x86_64.rpm Preparing… ################################# [100%] 1:nc ################################# [100%] [root@bakuexa1dbadm02 ~]# rpm -ivh nc-1.84-10.fc6.x86_64.rpm Preparing… ################################## [100%] 1:nc ################################## […]

Upgrade the RDBMS DST version in 11gR2 (11.2.0.1 and up) using DBMS_DST


$ sqlplus sys as sysdba SQL> shutdown immediate SQL> startup upgrade ORACLE instance started. Total System Global Area 627732480 bytes Fixed Size 1345992 bytes Variable Size 184550968 bytes Database Buffers 436207616 bytes Redo Buffers 5627904 bytes Database mounted. Database opened. SQL> SELECT version FROM v$timezone_file; VERSION ———- 4 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value […]

Exadata : celld service status start stop


To check,start,stop or to restart celld services. ++ To check the status of cell service celld status or cellcli -e list cell attributes rsStatus, msStatus, cellsrvStatus detail ++ To restart Cell service celld restart or cellcli -e alter cell restart services all force ++ To stop Cell service celld stop or cellcli -e alter cell […]

ORA-39181: Only partial table data may be exported due to fine grain access control on


ORA-39181 is caused by an unprivileged user who tries to export a table with a fine grain access control policiy applied. The table owner is subject to access control and may not be able to export all rows in the table. Only the rows that can be seen by that user are exported. In order to preserve integrity […]

Exadata Storage Cell Critical problem : RS-7445 [Serv MS leaking memory] [It will be restarted]


Known defect: Bug 19790644 – RS-7445 [SERV MS LEAKING MEMORY] Issue is a memory leak in the Java executable. This bug affects systems running with JDK 7u51 or later versions (1.7.0_55-b13) which are 11.2.3.3.1 and 12.1.1.1.1 Systems running 11.2.3.3.0 or 12.1.1.1.0 are not affected as they use 1.7.0_25-b15 Solution: 1: Error is ignorable as MS […]

How to run an ILOM Snapshot on a Sun/Oracle X86 System for manual


1. Log in to the ILOM CLI interface. # ssh xxx.xxx.xxx.xxx Password: 2. You will see a similar output: Sun(TM) Integrated Lights Out Manager Version 2.0.2.5 Copyright 2007 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. -> 3. After the ‘->’ prompt, type the command in below: -> set /SP/diag/snapshot dataset=normal […]

I don’t have old backup (autobackup) of control files.


oracle@anarexadatatest01:/opt$ echo $ORACLE_SID ANARDEV1 oracle@anarexadatatest01:/opt$ /u01/app/11.2.0.3/grid/bin/srvctl stop database -d ANARDEV -o immediate oracle@anarexadatatest01:/opt$ /u01/app/11.2.0.3/grid/bin/srvctl start database -d ANARDEV -o mount oracle@anarexadatatest01:/opt$ oracle@anarexadatatest01:/opt$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.3.0 Production on Sun May 3 08:09:36 2015 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit […]