How to…………………
How to find Concurrent Manager Node in Multi-Node environment? Method 1: SQLPLUS> select node_name from apps.fnd_nodes where support_cp=’Y’; Method 2: Execute "ps -ef | grep…
Category: Blog
Your blog category
Problems and Solutions
Problems and Solutions: Problems: I hit the Restart button to start the Standard manager, but it still did not start? Solution: The ICM will start…
How to find Oracle Database Components version
Oracle RDBMS VersionSELECT * FROM V$VERSION; Version of OPATCH$ perl $ORACLE_HOME/OPatch/opatch.pl version Listener Version$ lsnrctl version Check Database 32-bit or 64-bit?select length(addr)*4 ‘-bits’ word_length from…
Configure Oracle Automatic Storage Management (ASM) Part – 6
Now we configure Oracle ASM. First we install oracleasmlib package. Download the ASM library from OTN and install the ASM RPM as the root user.…
Configure Oracle Cluster File System (OCFS2) Part – 5
Now we install and Configure OCFS2, OCFS2 is a general-purpose cluster file system. It enables all nodes to share files concurrently via the standard file…
Create Disk Partation for OCFS2 and Oracle ASM Part – 4
After OS installation and Configuration. We will configure and prepare a set of raw disks for OCFS2 (/dev/sdb), Oracle ASM (/dev/sdd, /dev/sde). Log In as…
Convert Stand-alone database to Oracle 10gR2 RAC by using “MANUALLY”
Method: “Manually” Task 1 (Create First Virtual Machine) Task 2 (Create Shared Storage and Configure) Task 3 (Create and Configure the Second Virtual Machine) Task…
Convert Stand-alone database to Oracle 10gR2 RAC by using “DBCA”
Method: “DBCA” We can use DBCA to convert from single-instance Oracle databases to RAC. DBCA automates the configuration of the control file attributes, creates the…
Administering Cluster Ready Services (CRS)
We use Cluster Control Utility “CRSCTL” to perform administrative operation of oracle clusterware. It is located in $CRS_HOME/bin and must be executed by the “root”…
Managing OCR and Voting Disk
OCR: Oracle Cluster registry (OCR) store the cluster configuration information and database configuration information like cluster node list, cluster database instance to node mapping and…