Category Archives: Database administration

How to disable and enable archive log in Oracle RAC

This document describes how to enable and disable archive log in Oracle RAC database. ENABLE ARCHIVE LOG MODE IN RAC. Step1: stop database instance on node1 using sqlplus. [oracle@rac-node1 bin]# sqlplus /nolog SQL> select instance_name from v$instance; TEST1 SQL> shutdown … Continue reading

Posted in Database administration, Oracle RAC | Leave a comment

How to configure Shared server mode

Shared memory resources are preconfigured to allow the enabling of shared server at run time. You need not configure it by specifying parameters in your initialization parameter file, but you can do so if that better suits your environment. Steps … Continue reading

Posted in Database administration | Leave a comment

How to set IDLE TIME in oracle Database

1- connect as sysdba user   SQL> conn /as sysdba SQL> sho parameter resource_limit NAME                                 TYPE        VALUE ———————————— ———– —————————— resource_limit                       boolean     FALSE   2- Change the resource parameter to true   SQL> alter system set resource_limit=TRUE scope=both; System altered. … Continue reading

Posted in Database administration | 1 Comment

dbca error ORA-12560: TNS:protocol adapter error

ORA-12560 during database creation in Win Server 2008 64bit   I encountered the following error during creation of database in Windows Server 2008 64bit domain: ORA-12560: TNS:protocol adapter error The version that I am using is Oracle Database 10.2.0.4   I … Continue reading

Posted in Database administration | Leave a comment

How to clone Oracle Binaries

DBAs sometimes install Oracle software by using a utility such as tar to copy an existing installation of the Oracle binaries to a different server . This approach is fast and simple . This technique allows DBAs to easily install the … Continue reading

Posted in Database administration | Leave a comment

Raid Level recomendation for Oracle Database

RAID Type of RAID Control Database Redo Log Archive Log File File File File 0 Striping Avoid* OK* Avoid* Avoid* 1 Shadowing OK OK Recommended Recommended 0+1 Striping + OK Recommended OK Avoid Shadowing 3 Striping with OK Avoid Avoid … Continue reading

Posted in Database administration, Linux commands for DBA | Leave a comment

How to install Oracle 10g in silent mode

Silent mode installation 1) update the database/response/enterprise.rsp contents to update are HORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 ORACLE_HOME_NAME=oraclehome1 2) Create at OS level directories /u01/app/oracle/product/10.2.0/db_1 3) cd /home/oracle/software/database ./runInstaller -silent -responsefile /home/oracle/software/database/response/enterprise.rsp Starting Oracle Universal Installer… Checking installer requirements… Checking operating system version: must be … Continue reading

Posted in Database administration | Leave a comment