One of my readers today send me an error they got while restoring a database via RMAN RMAN> startup mount;…
Tag 10g
The Below Script will generate output if percentage of tablespace space left free is less tan 20%. You can easily…
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…
http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/
Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The…
Today on one of our 10g (10.2.0.1, don’t ask !) production databases running on AIX 5.3 we saw the following…
For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1.…
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:…
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
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…
Query to find out size of the 10 Largest Tables sitting inside an Oracle database which is greater than 1GB…
Suppose you have a query result and want to concatenate a string to that output for better readibility, it can…
Sometimes it is required to find the largest tables residing in your database. It helps to identify candidates for table…
SQL Query to check size of Table — Check Size in GB SELECT bytes/1024/1024/1024 FROM USER_SEGMENTS WHERE SEGMENT_NAME in (‘TABLE1′,’TABLE2’);…
######### ERROR ##### DGM-17016: failed to retrieve status for database ORA-16664: unable to receive the result from a database DGMGRL>…
We will create 2 standby databases from a single RAC primary database. 11gR2 allows upto 30 standby databases. The most…
One of the best books I have read on Oracle database security.It skips all the basics like what is a…