What is Upgration? It is the process of replacing your existing software with an advance version of the identical product.Upgrading your applications usually do not require special tools. Your existing reports should look and behave the same in both products. For Example: Replacing Oracle 9i release to Oracle 10g release, SQL Server 2005 to SQL Server 2008 etc. Why […]
Category: ORACLE RAC
Steps to change SCAN IP address in RAC
To Change the SCAN IP address it must be available and need to changes on the DNS by the network admin. So we have SCAN IP address available. Steps: 1. To check the current status SCN IP address on DNS $nslookup <scan-name> $nslookup testrac-scan.abc.com Server: 160.34.11.20 Address: 160.34.11.21#40 Name: testrac-scan.abc.com Address: 160.34.11.88 Name: testrac-scan.abc.com Address: […]
Change Listener ports RAC with MGMTDB
In this post, you will know how to change the Listener Port In Oracle RAC. We can change some listener ports from 1521 to 1525 on a RAC. 1. Check the listener status [oracle@node1 ~]$ srvctl status listener -l LISTENER Listener LISTENER is enabled Listener LISTENER is running on node(s): node1,node2 2. Modify the listener […]
Master Node in Oracle RAC
In this post, I will demonstrate three methods to identify the oracle clusterware’s master node. Please note that clusterware master is different from Resource master in oracle database instance. To know about how to find the resource master, Oracle ClusterWare Master’s Node information can be found By scanning ocssd logs from various nodes By scanning crsd […]
Upgrading the Grid Infrastructure from 11.2.0.4 to 12.1.0.2 on the command line
Currently I have two node Grid Infrastructure on 11.2.0.4. The node names are node1 and node2: [grid@node1 ~]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [11.2.0.4.0] [grid@node1 ~]$ crsctl query crs softwareversion Oracle Clusterware version on node [node1] is [11.2.0.4.0] [grid@node1 ~]$ crsctl query crs softwareversion node2 Oracle Clusterware version […]
Delete a node from RAC
To remove a node from a which is part of a RAC involves several steps Stop the database and ASM on particular instance Remove the database and ASM Remove the Oracle Database Software Remove the Clustware Update the oracle inventory Current Scenario [oracle@rac1 ~]$ olsnodes -s -t rac1 Active Unpinned rac2 Active Unpinned rac3 Active […]
Adding a Database home to a 12c RAC Cluster
In previous article we added the grid home in third home (i.e rac3): Click Here Now we are going to extend the database home in 3rd home. From an existing node i.e rac1 – as the database software owner – run the following command to extend the Oracle database software to the new node “rac3” […]
Adding a Grid node to a 12c RAC Cluster
The generic steps to follow when adding the new node to the cluster are: Install Operating System Install required software Add/modify users and groups required for the installation Configure network Configure kernel parameters Configure services required such as NTP Configure storage (multipathing, zoning, storage discovery, ASMLib?) We assume that our OS,storage and network is already […]
ACCIDENTALLY data file is added without “+” sign
In RAC or ASM environment, we missed the ‘+’ sign while adding datafile in tablespace. we got error in ora-01110, ora-27037 in alert log. ORA-01157: cannot identify/lock data file 3129 – see DBWR trace file ORA-01110: data file 3129: ‘/home/oracle/product/10.2.0/db/dbs/DATA’ ORA-27037: unable to obtain file status ORA-01186: file 3129 failed verification tests ORA-01157: cannot identify/lock […]
Oracle RAC: Applying and Removing PSU in Database Home with Conflict Detection on Oracle 12c
In this article we will present how to apply and reverse a PSU applied to Database Home on a node with the conflict resolution method. To do this you need to have at least a 2-node RAC Database. If you want to patch on Grid Infrastructure Home in Oracle 12c then click here Our test environment: Grid […]