Ameer Khan

Primary Database Server: server1.soumya.comStandby Database Server: server2.soumya.com Primary Database: primStandby database: stand Database version:11.2.0.1.0 Both the database prim and stand are in sync. For the “Real Time Apply” implementation, we need to makesure that we have created the Standby Redo Logs on the standby database with the size same as that of theOnline Redo logs… Continue Reading

Tuning individual Oracle SQL statements The acronym SQL stands for Structured Query Language. SQL is an industry standard database query language that was adopted in the mid-1980s. It should not be confused with commercial products such as Microsoft SQL Server or open source products such as MySQL, both of which use the acronym as part… Continue Reading

Scenario:-Create a new oracle database on your local system(192.168.72.169) from existing database ‘prim’ on ip (192.168.72.172) using oracle cold backup Source database ip :-     192.168.72.169Destination database ip:- 192.168.72.172Database version:-        Oracle 11gOs version:-                Rhel 6 IN SOURCE DATABASE : # To take a cold backup… Continue Reading

Oracle Version :11gOS: Rhel 6.4 #Turn on flashback and archivelog from mount stageSQL> shut immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started. Total System Global Area  413372416 bytesFixed Size                  2213896 bytesVariable Size             318769144 bytesDatabase Buffers        … Continue Reading

Oracle Database 11g Release 2 RAC On RHEL 5.4 Using NFS:- NFS is an abbreviation of Network File System, a platform independent technology created by Sun Microsystems thatallows shared access to files stored on computers via an interface called the Virtual File System (VFS) that runs ontop of TCP/IP.Computers that share files are considered NFS… Continue Reading

ORA-00054: resource busy and acquire with NOWAIT specifiedCause: The NOWAIT keyword forced a return to the command promptbecause a resource was unavailable for a LOCK TABLE or SELECT FORUPDATE command.Action: Try the command after a few minutes or enter the command withoutthe NOWAIT keyword. Example:SQL> alter table emp add (mobile varchar2(15));*ERROR at line 1:ORA-00054: resource… Continue Reading

Here i’m trying to do the disaster recovery using RMAN. Primary machine:192.168.2.102Secondary Machine:192.168.2.104 In primary machine:-[oracle@server1 ~]$ sqlplus /  as sysdbaSQL> select name from v$database; NAME———PRIM Now creating a table and we will check it on the secondary machine which i would use for distaster recovery.SQL> create table students (name varchar(20)); Table created. SQL> insert… Continue Reading

Primary Database Server: server1.soumya.comStandby Database Server: server2.soumya.com Primary Database: primStandby database: stand Database version:11.2.0.1.0 Reason:-1. Might be due to the network outage between the primary and the standby database leading to the archivegaps. Data guard would be able to detect the archive gaps automatically and can fetch the missing logs assoon as the connection is… Continue Reading

Oracle Version: oracle 11gOS Version:- RHEL 6 [oracle@server1 ~]$ mkdir /backups/db_backup/[oracle@server1 ~]$ chown -Rf oracle:oinstall /backups/db_backup/[oracle@server1 ~]$ sqlplus / as sysdbaSQL> CREATE DIRECTORY backup AS ‘/backups/db_backup/’;SQL> exit # vi /home/oracle/expdp_backup.sh #!/bin/bashexport PS1=”`/bin/hostname -s`-> “export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=soumyadbexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binpath1=/backups/db_backupdate1=`date +%d%m%y_%H%M%S`/u01/app/oracle/product/11.2.0/db_1/bin/expdp system/system full=y directory=backup dumpfile=backup_$date1.dmp logfile=log_$date1.log exclude=statisticscd /backups/db_backup//bin/tar -zcvf /backups/db_backup/backup_$date1.tar.gz backup_$date1.dmp :wq Now schedule the script… Continue Reading

ORA-28002: the password will expire within 7 days Cause: The user’s account is about to about to expire within 7days  and the password needsto be changed.Action: Change the password. Solutions:-sqlplus soumya/soumyaSQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 2 08:52:52 2015ERROR:ORA-28002: the password will expire within 7 days1. Simply change the password to avoid it temporary… Continue Reading