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 […]
Articles Tagged: ORACLE RAC
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 […]
Oracle RAC – Applying and Removing PSUs in Grid Infrastructure Home with Conflict Detection (12.1.0.2.0)
In this article we will present how to apply and remove PSU in Grid Infrastructure Home on only one node using the conflict resolution method with roll forward method. To do this we need a RAC of at least 2 nodes. If you want to patch on Database Home in Oracle 12c then click here […]
ORA-15032: Not All Alterations Performed
While setting attribute on a ASM diskgroup, we got below error. oracle@crmcpredb1:~$ echo $ORACLE_SID +ASM1 oracle@crmcpredb1:~$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 16 11:19:25 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Real Application Clusters […]
Enable Archive Log Mode In Oracle RAC
1. stop the database service. srvctl stop database -d RAC 2. start the database in mount state. srvctl start database -d RAC -o mount 3. enable archive log mode. SQL> alter database archivelog; Database altered. 4. Restart the database service (using srvctl) srvctl stop database -d RAC srvctl start database -d RAC 5. set the […]
Move Datafile From File System To ASM Disk In 11g
Below steps need to be followed to move the datafile to ASM disk group. SOLUTION: 1. Make the datafile offline; SQL> select file_name from dba_data_files; FILE_NAME ——————————————————————————– +DATA/RAC2/DATAFILE/system.260.934026715 +DATA/RAC2/DATAFILE/sysaux.261.934026717 +DATA/RAC2/DATAFILE/undotbs1.262.934026719 +DATA/RAC2/DATAFILE/undotbs2.264.934026727 +DATA/RAC2/DATAFILE/users.265.934026729 /export/home/oracle/user02.dbf alter database datafile ‘/export/home/oracle/user01.dbf’ offline; 2. Connect to RMAN and copy datafile to ASM DISKGROUP RMAN> copy datafile ‘/export/home/oracle/user02.dbf’ to ‘+DATA/RAC2/DATAFILE/user02.db’; Starting backup […]
How to change ASM SYS Password and Creating SYSASM user 11g.
First we can try with normal method SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME —————- +ASM SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>; ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password> * ERROR at line 1: ORA-01109: database not open We cannot change the password for ASM databases via alter user command. Because passwords are […]
Upgrading Oracle Grid Infrastructure 11gR2 to 12cR2
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). 1. Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 12.2.0.1 to 11.2.0.4 later one. If you […]
How to check Cluster Name
To check the cluster name use, $ORA_CRS_HOME/bin/cemutlo -n