Category Archives for Database
oraInventory Location & oraInst.loc on Windows , Linux , Unix
Oracle Software (Database, OID, HTTP Server, Forms & Report, Discoverer …) installation issues are logged under oraInventory/logs/[filename].log (for more on oraInventory click here ) but how to identify oraInventory location on system ? Oracle Inventory Pointer oraInst.loc (registry variable inst_loc for windows) determines oraInventory location oraInventory location in windows : INST_LOC – “c:\program files\Oracle\Inventory“ oraInventory default location in Linux, AIX : Directory […]
Read MoreOracle Database Incarnation : Open Resetlogs , SCN
Q. What happens when you run ALTER DATABASE OPEN RESETLOGS ? The current online redo logs are archived, the log sequence number is reset to 1, new database incarnation is created, and the online redo logs are given a new time stamp and SCN. . Q. In what scenarios open resetlogs required ? An ALTER […]
Read MoreOracle Database – 11g R2 (11.2.0.1.0) is available to download
. Oracle Database 11g R2 is now available to download from here. You can access 11gR2 Database documentation from here For overview of Oracle Database 11g R2 click here Difference between Oracle Database 11g R1 and 11g R2 coming soon !!
Read MoreStandby Redo Logs (SRL) in Standby Database
. Standby Redo Logs (SRL) : is similar to Online Redo Log (ORL) and only difference between two is that Standby Redo Log is used to store redo data received from another database (primary database). Standby Redo Logs are only used if you have the LGWR as transport mode to Remote Standby Database. (step to check transport mode below) […]
Read MoreFile Attachment in Linux using MAIL/SENDMAIL – How to Send eBusiness 11i/r12 DB Status on Daily Basis
Assumption The rpm sharutils-4.2.1-17.i386.rpm is already there. Verify the same, as followed: rpm –qa sharutil* If not, download and install sharutils-4.2.1-17.i386.rpm by the following, as it is mandatory: rpm -ivh sharutils-4.2.1-17.i386.rpm. DB Check Script is already implemented and scheduled. As root user, schedule the following script: #!/bin/bash FILE=dbchk.doc FILE2=output.html RECIPIENT=rawishsiddiqui@yahoo.ca RECIPIENTCC=oracle@******.com RECIPIENTBCC=rsiddiqui@*****.com ( echo “Dear […]
Read MoreORA-1652: unable to extend temp segment by 128 in tablespace TEMP
This post covers quick fix for temp tablespace issue (ORA-1652) which is to add temporary datafile and then find root cause of temp tablespace issue. Extent – An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks. One or more extents make up segment. Segment […]
Read MoreOracle Fusion Middleware 11g – Repository Creation Utility (RCU)
This post covers overview of Repository Creation Utility(RCU) which is first thing you need to do, if you are planning to implement/install Oracle Fusion Middleware 11g R1 (11.1.1.0). Metadata Repository – contains metadata for Fusion Middleware Components (SOA, Webcenter, Identity Management) . There are various types of Repository – Metadata Services (MDS), Audit Services (IAU), Oracle Internet Directory (OID), […]
Read MoreSingle Instance to RAC conversion using DBCA :Part-I
There is three method available, you can use any of them to convert single instance to RAC instance. a. using dbca b. using EM c. using rconfig utility Here we are converting using DBCA (DataBase Configuration Assistant). Conversion of single instance database to RAC database using DBCA consists of two part. In first part, we […]
Read MoreInstalling Oracle Enterprise Manager (OEM) Grid – Management Agent
This post covers installation of Oracle Enterprise Management (OEM) Grid Management Agents on Machine which you are planning to monitor using Oracle Enterprise Manager Grid Control. What is OEM Grid Control Management Agent ? Management Agent is software installed on node (machine) which you are planning to monitor. Agent collects information on target node (Host, […]
Read MoreOracle RAC – Clusterware Installation Overview
This post covers overview of Oracle Clusterware Installation, for step by step guide on How to install Clusterware using VMware 2.0 (including steps to configuring multiple linux machine/network card/hard disk/raw device for OCR/Voting Disk on one Windows Machine) register for online Oracle RAC DBA training (499 USD) . Requirement for Oracle Clusterware 1. External Shared Disk to store […]
Read More