Monitor Tablespace Script Oracle 12c 11g 10g

The Below Script will generate output if percentage of tablespace space left free is less tan 20%. You can easily put in a shell script and schedule it on crontab to send alerts on a daily basis.   select df.tablespace_name tspace, round(sum(fs.bytes)/(df.bytes) * 100) "%_free", round(sum(fs.bytes)/(1024*1024)) free_ts_size, df.bytes/(1024*1024) tot_ts_size from dba_free_space fs, (select tablespace_name, sum(bytes) … Continue reading Monitor Tablespace Script Oracle 12c 11g 10g

ASH and AWR Scripts for Checking Wait Events and Top Consuming SQL’s

http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/

Active – Active (Bi-Directional) Replication using Oracle Golden Gate 12c

Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The adoption of GoldenGate over Streams has been quite Rapid. The complexity of Streams has intimidated many adopters, specially for Multi-Master or Peer-to-Peer Replication. GoldenGate not only makes MultiMaster Replication easy but is so full of … Continue reading Active – Active (Bi-Directional) Replication using Oracle Golden Gate 12c

ksvcreate: Process(m000) creation failed. Error in Alert log due to DNS ip change.

Today on one of our 10g (10.2.0.1, don't ask !) production databases  running on AIX 5.3 we saw the following message in the alert log. ksvcreate: Process(m000) creation failed The database slowed down to a crawl. We couldn't login even SQLPLUS, even sqlplus -prelim couldn't bring up the instance. On starting the instance we got … Continue reading ksvcreate: Process(m000) creation failed. Error in Alert log due to DNS ip change.

Running SQL Script for Multiple Databases SQL*PLUS | Mutiple Servers SQL*PLUS in Shell Script | BASH Script Looping SQL*PLUS commands

For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1. Oracle client should be installed on the Unix/Linux Server 2. Create Local TNS entry in the tnsnames.ora file for the databases where you will run the commands 3. All databases should have one common user … Continue reading Running SQL Script for Multiple Databases SQL*PLUS | Mutiple Servers SQL*PLUS in Shell Script | BASH Script Looping SQL*PLUS commands

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

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: TNS:protocol adapter error So you tried connecting to an Oracle Database and got the dreadful error. TNS listener not available, this is one of the most common errors connecting to an Oracle database and one … Continue reading ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Move SPFILE to ASM RAC

-- Move SPFILE to ASM RAC --Already we have a PFILE called initmove.ora which was created previously from spfileSQL> show parameter spfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string /u02/app/oracle/product/11.2.0 /dbhome_1/dbs/spfiletest1.oraAs you can see the spfile is in FilesystemSQL> create spfile='+DATAC1/test/spfiletest.ora' from pfile='/u03/rman/initmove.ora';File created.SQL> exitCreate a pfile called inittest.ora and add only below line only in it … Continue reading Move SPFILE to ASM RAC

Snapshots are not Backups

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