Posts

Showing posts from February, 2011

How I DROP/RECREATE Oracle Enterprise Manager 10g

Hi, Here are the steps that I followed in dropping and recreating Oracle Database Enterprise Manager. This are just my notes on how I did it. In Oracle 10g, the EMCA utility is used to recreate EM. It is location in your $ORACLE_HOME/bin directory. My environment: OS: RHEL 5.4 DB: Oracle DB 10.2.01 Here's my note: When the database host name (including the domain name) or the IP address changes, deconfigure and then reconfigure the Database Console with the repository create command. Run the following command: emca -deconfig dbcontrol db -repos drop emca -config dbcontrol db -repos create or emca -deconfig dbcontrol db emca -config dbcontrol db -repos recreate ****************************************** Make sure the the listener.ora, tnsnames.ora and sqlnet.ora are configured well sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES) listener.ora SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC

Partition and Mount Disk on LINUX in an existing Oracle Database

Here the draft that I followed in my post: Partition EMC LUNs to allocate more disk space for Oracle 1. Partition the presented disks "EMC was able to create the 3x20Gb storage " Say for example the presented disks are: # fdisk -l /dev/hda /dev/hdb /dev/hdc # fdisk /dev/hda n --new patition p --partition 1 --partition 1 <Enter> +1024M --size of the partition n --new partition p --partition 2 -- partition 2 <Enter> +1024M --size of the partition n --new partition p --partition <Enter> --default 4th partition <Enter> p --print the partitions I made w --write the new partition table and save --see my drawing for the details. 2. Format the partitioned devices # mkfs -t ext3 /dev/hda1 # mkfs -t ext3 /dev/hda2 # mkfs -t ext3 /dev/hda3 3. Create a TEMPORARY mount point for the new devices # mkdir /mnt/bdump # mkdir /mnt/cdump # mkdir /mnt/udump --set necessary permissions to the oracle user

Partition EMC LUNs to allocate more disk space for Oracle

Hi, As a Junior DBA, as of the moment, you may find my posts a little easy, but I would like to share these easy things to all newbies to Oracle. I have a recent activity with one of our clients. Here is the scenario and I would like to share it: Problem: Oracle dump files are very important to this client because they are using it for troubleshooting purposes on their RAC environment. Oracle's bdump, cdump and udump grows so fast that they need to change the disk to allocate bigger disk space. These logs make /u01 ,which is the mount for for their ORACLE_HOME, grow big and reaches 99%. Goal: 1. To partition the presented disk done by the storage engineer 2. To allot one disk per node since the disks are visible on the three nodes 3. Move the log files to these new mount points 4. Make sure that these newly partitioned disks are accessible by Oracle. Here's what I did: Findings: -        EMC was able to create three LUNs of 20 GB each. -        The three LUNs are labeled