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
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
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.
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 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
The below command will not import the dump, but will just create a .sql file with the DDL statementsimpdp system/**** directory=import_dir dumpfile=IMPORT.DMP sqlfile=getddl.sql