Online DBA Support
Oracle Database Community
RSS
  • Home
  • Contact

How to change IP address for Oracle RAC Public and VIP interfaces

By Nazim On May 20, 2012 · Add Comment
We have a 2 node RAC cluster on HP-UX environment. Scenario what we are trying to achieve is to change the public and virtual interface ip addresses in the cluster. Our Cluster has been successfully configure with the below IP’s OLD Public IP Node 1 -- 192.168.2.2 Node 2 -- 192.168.2.3 OLD Virtual IP Node [...]
[Continue Reading...]

RMAN Recovery Scenario I – Loss of all datafiles

By Nazim On May 17, 2012 · Add Comment
Oracle Recovery Manager (RMAN), a command-line and Oracle Enterprise Manager-based tool, is the Oracle-preferred method for efficiently backing up and recovering an Oracle database. RMAN is designed to work intimately with the server, providing block-level corruption detection during backup and restore.
[Continue Reading...]

ORA-12541: TNS no listener while remote archiving

By Nazim On May 17, 2012 · Add Comment
[Continue Reading...]

How to enable users to view other users workflow notifications

By Nazim On January 14, 2012 · Add Comment
By default and design, only SYSADMIN user can view other users notifications. What if a requirement comes to enable everyone/certain group of people to view every ones notifications … this might sound crazy for a production environment but it’s a valid request on a Development environment. Ok coming to the technicalities,
[Continue Reading...]

Oracle RMAN Cloning

By Nazim On January 9, 2012 · Add Comment
Oracle Recovery Manager (RMAN), a command-line and Oracle Enterprise Manager-based tool, is the Oracle-preferred method for efficiently backing up and recovering an Oracle database.
[Continue Reading...]

Parameter file management

By Nazim On December 28, 2011 · Add Comment
Oracle provide two types of parameter file   1- Pfile=text file, static file, user side file, can be updated through vi editor 2-spfile= binary file cannot be open, server side file, dynamic file, can be modified “alter system” command in sql prompt.   Default location for both files are in side $ORACLE_HOME/dbs Both parameter files [...]
[Continue Reading...]

Tablespace Management

By Nazim On December 27, 2011 · Add Comment
A tablespace is a logical storage unit within an Oracle database. It is logical because a tablespace is not visible in the file system of the machine on which the database resides. A tablespace, in turn, consists of at least one datafile which, in turn, are physically located in the file system of the server. [...]
[Continue Reading...]

ASM (Automatic Storage Management)

By Nazim On December 27, 2011 · Add Comment
ASM (Automatic Storage Management)   Configuration of ASM Instance $ df -h $ fdisk –l  (To check size of hard disk and all partitions) $  fdisk /dev/sda $  m ( To check all commands) $  n (To add partitions)
[Continue Reading...]

INSTALLATION OF ORACLE APPS R12 IN REDHAT LINUX 5 (32 bits.)

By Nazim On December 27, 2011 · Add Comment
INSTALLATION OF ORACLE APPS R12 IN REDHAT LINUX 5 (32 bits) prerequisites   Installation Requirement : 1) Disk space requirement: Node                 Space Required ———————————————– Mid-Tier                28GB DB Tier – Prod      45GB DB Tier – Vision    133GB
[Continue Reading...]

How to read Buffer Cache Advisory in AWR?

By Nazim On December 20, 2011 · Add Comment
In this section we will learn how to read and analyze the buffer cache statistics for our database using AWR report.
[Continue Reading...]
← Previous Entries
  • Pages

    • About
  • Tags

    11g advisory AIX archives AWR backup buffer cache cluster database datafile file management ip listener maintenance management notification oracle RAC recovery remote RMAN SQL srvctl tablespace virtual workflow
  • Latest posts

    • How to change IP address for Oracle RAC Public and VIP interfaces
    • RMAN Recovery Scenario I – Loss of all datafiles
    • ORA-12541: TNS no listener while remote archiving
    • How to enable users to view other users workflow notifications
    • Oracle RMAN Cloning
  • Archives

    • May 2012 (3)
    • January 2012 (2)
    • December 2011 (5)
    • October 2011 (2)
    • September 2011 (5)
    • August 2011 (2)
    • July 2011 (2)
    • June 2011 (1)
    • May 2011 (5)
    • March 2011 (2)
    • February 2011 (1)
    • January 2011 (8)
    • December 2010 (37)
    • August 2010 (1)
    • June 2010 (1)
  • Recent comments

    • About
    • Contact
    Build a website with PageLines