Ameer Khan

Health check of the Database Instance :- Explanation:-An ideal health check should provide an overview of a database’s stability across three major areas for consideration: AvailabilityPerformanceScalability Category: Availability1. Database space (Should consider both database space and OS space; would be ideal to also consider growth trends.)2. Archive log space and listener status.3. Dump area space… Continue Reading

Before you Begin- System Requirements Architecture These instructions are for installing Red Hat Enterprise Linux 6 (RHEL6) on a 32-bit  and  64-bit systems (x86_64). Minimum Memory Red Hat recommends for 32 bit a minimum of 1GB memory/logical CPU, and for 64 bit a minimum of 1GB of memory, 1GB/logical CPU.  Minimum Disk Space  minimum disk size of… Continue Reading

How to Rename A Datafile in A Physical Standby Environment:- Primary db_unique_name:- primStandby db_unique_name:- stand 1.Verify primary and standby databases and also change the initialization parameter STANDBY_FILE_MANAGEMENT from AUTO to MANUAL.At Primary Database :-SQL> select name,db_unique_name,database_role,switchover_status from v$database; NAME      DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS——— —————————— —————-… Continue Reading

ORA-00845: MEMORY_TARGET not supported on this systemProblem Description:-While creating a startup database using dbca the database creation GUI gives error message in a pop up window,ORA-00845: MEMORY_TARGET not supported on this systemfrom where you can ignore the error message.The similar scenario also occurs whenever you try to start your database using startup command, shows error… Continue Reading

Resizing standby datafile if disk runs out of space on standby server:- Primary db: PrimStandby db: Stand On primary database server:- [root@server1 ~]# df -hFilesystem            Size  Used Avail Use% Mounted on/dev/sda2             8.7G  6.4G  1.9G  78% / Here on primary server i have 1.9G as… Continue Reading

Scenario:- We are deleting controlfiles from database and would recover database after dropping them. Database version :- Oracle 11g R2OS: Rhel 6Database sid: orclArchivelog mode: enabled Step1:-$cd /u01/app/oracle/oradata/orcl$rm -rf *.ctl $sqlplus / as sysdbaSQL>startupORACLE instance started. Total System Global Area  413372416 bytesFixed Size                  2213896 bytesVariable Size  … Continue Reading