Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM Oracle Database 11.2.0.3and 11.2.0.4 to…
Tag 11g
spool index_rebuild.sql select ‘alter index ‘||owner||’.’||index_name ||’ rebuild online nologging;’ from dba_indexes where owner=upper(‘SAMPLE’); spool off
The Below Script will generate output if percentage of tablespace space left free is less tan 20%. You can easily…
First Install UTL_MAIL ### To install UTL_MAIL: [code language=”sql”] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ###…
The script below can be used to check the Disk Group Space Free and also Check Directory sizes for each…
1 ) Set the environment variable also via srvctl @ oracle user. export ORACLE_UNQNAME=’$ORACLE_HOME/bin/srvctl config database |grep -w ${ORACLE_SID%?}’ srvctl…
export MMSG=/tmp/$$.mail export ADDR=”shadab@easyoradba.com” export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 export ORACLE_SID=orcl file=/tmp/${$}_`date +%Y%m%d` sqlplus -s “/as sysdba” << .eof > $file set pages…
One of the best sites for scripts related to checking library cache locks… http://allappsdba.blogspot.qa/2012/04/to-check-library-cache-lock-contention.html
Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The…
Oracle Transparent Data Encryption using Oracle Wallet If you wish to use a wallet specifically for TDE, then you must…
What to do when a production database goes hanging and there is no time left and your boss is standing…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor TNS-12541: TNS:no listener TNS-00511: No listener ERROR: ORA-12560:…
1) Query on old standby database (new primary) SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE; TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) —————————————- 12496643189 2) Flash back the…
The below command will not import the dump, but will just create a .sql file with the DDL statements impdp…
set lines 999 select GROUP_NUMBER,NAME,TOTAL_MB/1024/1024 as “Total Space in TB” ,FREE_MB/1024/1024 as “Free Space in TB” ,DATABASE_COMPATIBILITY from v$asm_diskgroup;
— Move SPFILE to ASM RAC — Already we have a PFILE called initmove.ora which was created previously from spfile…
Very well explained article why Storage Snapshots are not the best way for backing up an Oracle database. http://www.oracle.com/technetwork/database/features/availability/rman-fra-snapshot-322251.html?utm_content=buffer67053&utm_medium=social&utm_source=facebook.com&utm_campaign=buffer
Oracle has released the much anticipated patchset release to Oracle 11gR2 database. The patch is available on My Oracle Support search…
Suppose you need to fire a trigger based on the change of value of a column and then perform some…
This is a script to create a logon trigger for blocking third party tools like Toad, SQl Navigator etc from…
Oracle allows the database to access a flat file as a table. You can have a flat file with a…
This error comes when running ggsci on a linux or unix platform. Generally it is due to wrong setting of…
CREATE TABLE REPLICATION USING MATERIALIZED VIEWS ————————————————- SOURCE TABLE : LOG_RECORD TARGET TABLE : LOG_RECORD_UPD We have a large table…