======================================= Offline datafile. ======================================= SQL> ALTER DATABASE DATAFILE 62 OFFLINE; Database altered. ======================================= Move datafile ======================================= [NEW_DB](SERVERABC)/u01/oradata03/OLD_DB-> cp /u01/oradata03/OLD_DB/grr_04_d_17.dbf /u01/oradata01/NEW_DB/ ======================================= Rename datafile ======================================= SQL> ALTER DATABASE RENAME FILE '/u01/oradata03/OLD_DB/grr_04_d_17.dbf' TO '/u01/oradata01/NEW_DB/grr_04_d_17.dbf'; Database altered. SQL> ALTER DATABASE DATAFILE 62 ONLINE; ALTER DATABASE DATAFILE 62 ONLINE * ERROR at line 1: ORA-01113: file 62 needs media recovery if it was restored from backup, or END BACKUP if it was not ORA-01110: data file 62: '/u01/oradata01/NEW_DB/grr_04_d_17.dbf' ======================================= Recover datafile ======================================= SQL> recover datafile 62; Media recovery complete. ======================================= Online datafile ======================================= SQL> ALTER DATABASE DATAFILE 62 online;
Thursday, February 9, 2012
Rename/Move Datafile without putting Tablespace offline.
Labels:
Move Datafile without offline,
RMAN
Below is a Demo where I had to Move datafile . its always a best practice & safe to offline whole Tablespace. But sometimes we don't get that liberty. Just for experimental purpose I Move/rename single Datafile of Tablespace which has 8 more Datafiles. The method dont applied to database running on Noarchivelog mode,because Recovery will be needed.
Sunday, January 22, 2012
Duplicate database from Active database.
This Post is to Duplicate database from Active database.
Visit to To Duplicate database from Active database for standby
| Target | Auxiliary | |
| SERVER | DGP | DGS |
| DATABASE | DGP | DGS |
| LISTENER | LISTENER_TESTDGP ON 1521 | LISTENER_TESTDGS ON 1524 |
| SID_LIST_LISTENER_TESTDGP = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u00/app/oracle/product/11.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = DGP) (SID_NAME = DGP) (ORACLE_HOME = /u00/app/oracle/product/11.2.0/db_1) ) ) LISTENER_TESTDGP = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.173 )(PORT = 1521)) ) ) | SID_LIST_LISTENER_TESTDGS = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u00/app/oracle/product/11.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DB_NAME=DGS) (SID_NAME = DGS) (ORACLE_HOME = /u00/app/oracle/product/11.2.0/db_1) ) ) LISTENER_TESTDGS = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.176 )(PORT = 1524)) ) ) |
========================================================================
NOTE: You must set LOCAL_LISTENER parameter in PFILE and enter Listener Defination in tsnames.ora.
if your listener is not running on default port. MAKE STATIC REGISTRATION OF AUXILIARY INSTANCE in LISTENER.
Test connection make sure if you can connect and restart Auxiliary instance from Target server.
If it fails to connect auxiliary instance use (UR=A) in your tnsentry ,as showed below.
========================================================================
--tnsnames.ora on Target side
DGP=(description=(address=(protocol=tcp)(host= 192.168.80.173 )(port=1521))(connect_data=(SERVER=DEDICATED)(SID=DGP))) DGD=(description=(address=(protocol=tcp)(host=192.168.80.177 )(port=1524))(connect_data=(SERVER=DEDICATED)(service_name=DGD))) DGS=(description=(address=(protocol=tcp)(host=192.168.80.176 )(port=1524))(connect_data=(SERVER=DEDICATED)(service_name=DGS)(UR=A)))
--tnsnames.ora on Auxilary side
DGP=(description=(address=(protocol=tcp)(host= 192.168.80.173 )(port=1521))(connect_data=(SERVER=DEDICATED)(SID=DGP)))
DGS=(description=(address=(protocol=tcp)(host=192.168.80.176 )(port=1524))(connect_data=(SERVER=DEDICATED)(service_name=DGS)(UR=A) ))
LISTENER_TESTDGS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.176 )(PORT = 1524))
)
)
========================================================================
LOCATION
TARGET SIDE.
--DATAFILES /u01/dgp/data/users01.dbf /u01/dgp/data/undotbs01.dbf /u01/dgp/data/sysaux01.dbf /u01/dgp/data/system01.dbf /u01/dgp/data/TEST.dbf --REDOLOG /u01/dgp/redo/redo03.log /u01/dgp/redo/redo02.log /u01/dgp/redo/redo01.log --OTHER PARAMETERS audit_file_dest='/u00/app/oracle/admin/DGP/adump' audit_trail='DB' compatible='11.2.0.0.0' control_files='/u01/dgp/control/control01.ctl' control_files='/u01/dgp/control/control02.ctl' core_dump_dest='/u00/app/oracle/diag/rdbms/dgp/DGP/cdump' db_block_size=8192 db_domain='' db_name='DGP' db_recovery_file_dest='/u00/app/oracle/admin/dgp/flashback' db_recovery_file_dest_size=1000M diagnostic_dest='/u00/app/oracle' dispatchers='(PROTOCOL=TCP) (SERVICE=DGPXDB)' remote_login_passwordfile='EXCLUSIVE' result_cache_max_size=672K log_archive_dest_1 LOCATION=/u00/app/oracle/admin/DGP/arch
========================================================================
Password File
Copy password file of target database to auxiliary database and rename Accordigly.
========================================================================
Lets Duplicate.
Note : if you Invoke RMAN from Auxiliary server. you can connect "rman target sys/system@DGP auxiliary /"
TESTDGS:DGS:/u00/app/oracle/product/11.2.0/db_1/dbs::rman target sys/system@DGP auxiliary=sys/system@DGS connected to target database: DGP (DBID=1579930627) connected to auxiliary database: DGS (not mounted)
Below is RMAN run block to duplicate.
RMAN>>
run
{
allocate channel prmy1 type disk;
allocate auxiliary channel stby1 type disk;
duplicate target database to DGS from active database
spfile
parameter_value_convert '/dgp','/dgs','/DGP','/DGS'
set db_file_name_convert='dgp','dgs'
set log_file_name_convert='dgp','dgs'
set local_listener='LISTENER_TESTDGS'
set log_archive_dest_1='';
}
RMAN
using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=33 device type=DISK
allocated channel: stby1
channel stby1: SID=18 device type=DISK
Starting Duplicate Db at 18-JAN-12
contents of Memory Script:
{
backup as copy reuse
targetfile '/u00/app/oracle/product/11.2.0/db_1/dbs/spfileDGP.ora' auxiliary format
'/u00/app/oracle/product/11.2.0/db_1/dbs/spfileDGS.ora' ;
sql clone "alter system set spfile= ''/u00/app/oracle/product/11.2.0/db_1/dbs/spfileDGS.ora''";
}
executing Memory Script
Starting backup at 18-JAN-12
Finished backup at 18-JAN-12
sql statement: alter system set spfile= ''/u00/app/oracle/product/11.2.0/db_1/dbs/spfileDGS.ora''
contents of Memory Script:
{
sql clone "alter system set db_name =
''DGS'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set audit_file_dest =
''/u00/app/oracle/admin/DGS/adump'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''/u01/dgs/control/control01.ctl'', ''/u01/dgs/control/control02.ctl'' comment=
'''' scope=spfile";
sql clone "alter system set db_recovery_file_dest =
''/u00/app/oracle/admin/dgs/flashback'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''dgp'', ''dgs'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''dgp'', ''dgs'' comment=
'''' scope=spfile";
sql clone "alter system set local_listener =
''LISTENER_TESTDGS'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_1 =
'''' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''DGS'' comment= ''duplicate'' scope=spfile
sql statement: alter system set audit_file_dest = ''/u00/app/oracle/admin/DGS/adump'' comment= '''' scope=spfile
sql statement: alter system set control_files = ''/u01/dgs/control/control01.ctl'', ''/u01/dgs/control/control02.ctl'' comment= '''' scope=spfile
sql statement: alter system set db_recovery_file_dest = ''/u00/app/oracle/admin/dgs/flashback'' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''dgp'', ''dgs'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''dgp'', ''dgs'' comment= '''' scope=spfile
sql statement: alter system set local_listener = ''LISTENER_TESTDGS'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_1 = '''' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 263049216 bytes
Fixed Size 2212448 bytes
Variable Size 205524384 bytes
Database Buffers 50331648 bytes
Redo Buffers 4980736 bytes
allocated channel: stby1
channel stby1: SID=1 device type=DISK
contents of Memory Script:
{
sql clone "alter system set db_name =
''DGP'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''DGS'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format '/u01/dgs/control/control01.ctl';
restore clone controlfile to '/u01/dgs/control/control02.ctl' from
'/u01/dgs/control/control01.ctl';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''DGP'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''DGS'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 263049216 bytes
Fixed Size 2212448 bytes
Variable Size 205524384 bytes
Database Buffers 50331648 bytes
Redo Buffers 4980736 bytes
allocated channel: stby1
channel stby1: SID=19 device type=DISK
Starting backup at 18-JAN-12
channel prmy1: starting datafile copy
copying current control file
output file name=/u00/app/oracle/product/11.2.0/db_1/dbs/snapcf_DGP.f tag=TAG20120118T192934 RECID=1 STAMP=772918185
channel prmy1: datafile copy complete, elapsed time: 00:00:16
Finished backup at 18-JAN-12
Starting restore at 18-JAN-12
channel stby1: copied control file copy
Finished restore at 18-JAN-12
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"/u01/dgs/data/system01.dbf";
set newname for datafile 2 to
"/u01/dgs/data/sysaux01.dbf";
set newname for datafile 3 to
"/u01/dgs/data/undotbs01.dbf";
set newname for datafile 4 to
"/u01/dgs/data/users01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/dgs/data/system01.dbf" datafile
2 auxiliary format
"/u01/dgs/data/sysaux01.dbf" datafile
3 auxiliary format
"/u01/dgs/data/undotbs01.dbf" datafile
4 auxiliary format
"/u01/dgs/data/users01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 18-JAN-12
channel prmy1: starting datafile copy
input datafile file number=00001 name=/u01/dgp/data/system01.dbf
output file name=/u01/dgs/data/system01.dbf tag=TAG20120118T192955
channel prmy1: datafile copy complete, elapsed time: 00:00:56
channel prmy1: starting datafile copy
input datafile file number=00002 name=/u01/dgp/data/sysaux01.dbf
output file name=/u01/dgs/data/sysaux01.dbf tag=TAG20120118T192955
channel prmy1: datafile copy complete, elapsed time: 00:01:05
channel prmy1: starting datafile copy
input datafile file number=00003 name=/u01/dgp/data/undotbs01.dbf
output file name=/u01/dgs/data/undotbs01.dbf tag=TAG20120118T192955
channel prmy1: datafile copy complete, elapsed time: 00:00:16
channel prmy1: starting datafile copy
input datafile file number=00004 name=/u01/dgp/data/users01.dbf
output file name=/u01/dgs/data/users01.dbf tag=TAG20120118T192955
channel prmy1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 18-JAN-12
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like "/u00/app/oracle/admin/DGP/arch/1_27_772639109.dbf" auxiliary format
"/u00/app/oracle/admin/dgs/flashback/DGS/archivelog/2012_01_18/o1_mf_1_27_%u_.arc" ;
catalog clone recovery area;
switch clone datafile all;
}
executing Memory Script
Starting backup at 18-JAN-12
channel prmy1: starting archived log copy
input archived log thread=1 sequence=27 RECID=12 STAMP=772918348
output file name=/u00/app/oracle/admin/dgs/flashback/DGS/archivelog/2012_01_18/o1_mf_1_27_06n13j2d_.arc RECID=0 STAMP=0
channel prmy1: archived log copy complete, elapsed time: 00:00:15
Finished backup at 18-JAN-12
searching for all files in the recovery area
List of Files Unknown to the Database
===========================
File Name: /u00/app/oracle/admin/dgs/flashback/DGS/archivelog/2012_01_18/o1_mf_1_27_06n13j2d_.arc
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u00/app/oracle/admin/dgs/flashback/DGS/archivelog/2012_01_18/o1_mf_1_27_06n13j2d_.arc
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=772918375 file name=/u01/dgs/data/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=772918375 file name=/u01/dgs/data/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=772918375 file name=/u01/dgs/data/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=772918375 file name=/u01/dgs/data/users01.dbf
contents of Memory Script:
{
set until scn 992279;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 18-JAN-12
starting media recovery
archived log for thread 1 with sequence 27 is already on disk as file /u00/app/oracle/admin/dgs/flashback/DGS/archivelog/2012_01_18/o1_mf_1_27_06n13j2d_.arc
archived log file name=/u00/app/oracle/admin/dgs/flashback/DGS/archivelog/2012_01_18/o1_mf_1_27_06n13j2d_.arc thread=1 sequence=27
media recovery complete, elapsed time: 00:00:00
Finished recover at 18-JAN-12
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
sql clone "alter system set db_name =
''DGS'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 263049216 bytes
Fixed Size 2212448 bytes
Variable Size 205524384 bytes
Database Buffers 50331648 bytes
Redo Buffers 4980736 bytes
allocated channel: stby1
channel stby1: SID=19 device type=DISK
sql statement: alter system set db_name = ''DGS'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 263049216 bytes
Fixed Size 2212448 bytes
Variable Size 205524384 bytes
Database Buffers 50331648 bytes
Redo Buffers 4980736 bytes
allocated channel: stby1
channel stby1: SID=19 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DGS" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/u01/dgs/redo/redo01.log' ) SIZE 5 M REUSE,
GROUP 2 ( '/u01/dgs/redo/redo02.log' ) SIZE 5 M REUSE,
GROUP 3 ( '/u01/dgs/redo/redo03.log' ) SIZE 5 M REUSE
DATAFILE
'/u01/dgs/data/system01.dbf'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/dgs/data/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/dgs/data/sysaux01.dbf",
"/u01/dgs/data/undotbs01.dbf",
"/u01/dgs/data/users01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/dgs/data/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=/u01/dgs/data/sysaux01.dbf RECID=1 STAMP=772918523
cataloged datafile copy
datafile copy file name=/u01/dgs/data/undotbs01.dbf RECID=2 STAMP=772918523
cataloged datafile copy
datafile copy file name=/u01/dgs/data/users01.dbf RECID=3 STAMP=772918523
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=772918523 file name=/u01/dgs/data/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=772918523 file name=/u01/dgs/data/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=772918523 file name=/u01/dgs/data/users01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 18-JAN-12
released channel: prmy1
released channel: stby1
RMAN> exit
========================================================================ERRORS
========================================================================
error: (most common error while doing duplicate)
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-17629: Cannot connect to the remote database server
solution : Make static registration of instance in listener.ADD (SERVICE_NAME = AUXLIARY_DB) (UR=A) TO YOUR TARGET SERVER's tnsnames entry combination of both is must.
error:
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
solution: Add tns entries on both side.
error:
RMAN-05501: aborting duplication of target database
RMAN-05517: tempfile /u01/TEST11/temp01.dbf conflicts with file used by target database
solution: USE set newname for tempfile 1 to '/u01/dgs/data/temp11.dbf';
error
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server
solution: connect to target as rman target sys/system@DGP
Thursday, December 15, 2011
Desktop / Laptop processor for VMWARE & Parameters to Improve Performance
Nowadays many of us Install "VMWARE" on top of that "Linux" on top of that "Oracle database / RAC" or what so ever. After three layers actual resource and virtual resource get disconnects.
Virtualization on Desktop / Laptop is common, and still we expect it to run like Actual server.
As Hardware also play significant role in virtualization. Intel has come up with few new features in processor which can help speed up small-scale Virtual Guest.
one can take help to choose/compare which cpu is better.
- VT-x Virtulization technology
With VT-x, every transition between guest software and the VMM can change the linear-address space, allowing guest software full use of its own address space.
- VT-d Virtualization Technology for Direct I/O
An input/output memory management unit (IOMMU) enables guest virtual machines to directly use peripheral devices
When your have Host OS is 64bit and runs with VT-x supported processor.
Most common error you get is
just reboot your pc -> f11/esc -> bios setting -> enable virtual technologies -> save & exits.
Updating BIOS will solve this problem.
Performance can be improve by below settings in .vmx files.
================================================
This parameter will help you if you have VT-x enable features in your host cpu.
monitor.virtual_mmu = "hardware"
monitor.virtual_exec = "hardware"
vhv.enable = "TRUE"
hypervisor.cpuid.v0 = "FALSE" <-- This one is specially for paravirtulization
mainMem.useNamedFile = "false"
======================================================
Monday, October 17, 2011
Upgrade CRS to 11.2.0.1 Grid Infrastructre. / Upgrade clusterware to Grid Infrastructure
As we all know that, In 11gR2 CRS and ASM has been consolidate in one binaries and named as GRID Infrastructure.
Upgrade to GRID can be done in two methods.
2) CRS and ASM in together in single Installation.
Its recommended to Upgrade both together.
RACN1:/u00/grid-> ./runcluvfy.sh stage -pre crsinst -n racn1,racn2 -fixup -ve>
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "RACN1"
Destination Node Reachable?
------------------------------------ ------------------------
racn1 yes
racn2 yes
Result: Node reachability check passed from node "RACN1"
Checking user equivalence...
Check: User equivalence for user "oracle"
Node Name Comment
------------------------------------ ------------------------
racn2 passed
racn1 passed
Result: User equivalence check passed for user "oracle"
Checking node connectivity...
Checking hosts config file...
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 passed
racn1 passed
Verification of the hosts config file successful
Interface information for node "racn2"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.133.152 192.168.133.0 0.0.0.0 192.168.133.1 00:0C:29:BA:2F:B6 1500
eth0 192.168.133.156 192.168.133.0 0.0.0.0 192.168.133.1 00:0C:29:BA:2F:B6 1500
eth1 192.168.131.78 192.168.131.0 0.0.0.0 192.168.133.1 00:0C:29:BA:2F:C0 1500
virbr0 192.168.122.1 192.168.122.0 0.0.0.0 192.168.133.1 00:00:00:00:00:00 1500
Interface information for node "racn1"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.133.151 192.168.133.0 0.0.0.0 192.168.133.1 00:0C:29:71:48:34 1500
eth0 192.168.133.155 192.168.133.0 0.0.0.0 192.168.133.1 00:0C:29:71:48:34 1500
eth1 192.168.131.76 192.168.131.0 0.0.0.0 192.168.133.1 00:0C:29:71:48:3E 1500
virbr0 192.168.122.1 192.168.122.0 0.0.0.0 192.168.133.1 00:00:00:00:00:00 1500
Check: Node connectivity of subnet "192.168.133.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racn2:eth0 racn2:eth0 yes
racn2:eth0 racn1:eth0 yes
racn2:eth0 racn1:eth0 yes
racn2:eth0 racn1:eth0 yes
racn2:eth0 racn1:eth0 yes
racn1:eth0 racn1:eth0 yes
Result: Node connectivity passed for subnet "192.168.133.0" with node(s) racn2,racn1
Check: TCP connectivity of subnet "192.168.133.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
RACN1:192.168.133.151 racn2:192.168.133.152 passed
RACN1:192.168.133.151 racn2:192.168.133.156 passed
RACN1:192.168.133.151 racn1:192.168.133.155 passed
Result: TCP connectivity check failed for subnet "192.168.133.0"
Check: Node connectivity of subnet "192.168.131.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racn2:eth1 racn1:eth1 yes
Result: Node connectivity passed for subnet "192.168.131.0" with node(s) racn2,racn1
Check: TCP connectivity of subnet "192.168.131.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
RACN1:192.168.133.151 racn2:192.168.131.78 passed
RACN1:192.168.133.151 racn1:192.168.131.76 passed
Result: TCP connectivity check passed for subnet "192.168.131.0"
Check: Node connectivity of subnet "192.168.122.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racn2:virbr0 racn1:virbr0 yes
Result: Node connectivity passed for subnet "192.168.122.0" with node(s) racn2,racn1
Check: TCP connectivity of subnet "192.168.122.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
RACN1:192.168.133.151 racn2:192.168.122.1 passed
RACN1:192.168.133.151 racn1:192.168.122.1 passed
Result: TCP connectivity check passed for subnet "192.168.122.0"
Interfaces found on subnet "192.168.133.0" that are likely candidates for VIP are:
racn2 eth0:192.168.133.152 eth0:192.168.133.156
racn1 eth0:192.168.133.151 eth0:192.168.133.155
Interfaces found on subnet "192.168.131.0" that are likely candidates for a private interconnect are:
racn2 eth1:192.168.131.78
racn1 eth1:192.168.131.76
Interfaces found on subnet "192.168.122.0" that are likely candidates for a private interconnect are:
racn2 virbr0:192.168.122.1
racn1 virbr0:192.168.122.1
Result: Node connectivity check passed
Check: Total memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 947.4MB (970140.0KB) 1.5GB (1572864.0KB) failed
racn1 947.4MB (970140.0KB) 1.5GB (1572864.0KB) failed
Result: Total memory check failed
Check: Available memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 557.55MB (570932.0KB) 50MB (51200.0KB) passed
racn1 485.21MB (496860.0KB) 50MB (51200.0KB) passed
Result: Available memory check passed
Check: Swap space
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
Result: Swap space check failed
Check: Free disk space for "racn2:/tmp"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/tmp racn2 / 12.39GB 1GB passed
Result: Free disk space check passed for "racn2:/tmp"
Check: Free disk space for "racn1:/tmp"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/tmp racn1 / 11.31GB 1GB passed
Result: Free disk space check passed for "racn1:/tmp"
Check: User existence for "oracle"
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 exists passed
racn1 exists passed
Result: User existence check passed for "oracle"
Check: Group existence for "oinstall"
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 exists passed
racn1 exists passed
Result: Group existence check passed for "oinstall"
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 exists passed
racn1 exists passed
Result: Group existence check passed for "dba"
Check: Membership of user "oracle" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
racn2 yes yes yes yes passed
racn1 yes yes yes yes passed
Result: Membership check for user "oracle" in group "oinstall" [as Primary] passed
Check: Membership of user "oracle" in group "dba"
Node Name User Exists Group Exists User in Group Comment
---------------- ------------ ------------ ------------ ----------------
racn2 yes yes yes passed
racn1 yes yes yes passed
Result: Membership check for user "oracle" in group "dba" passed
Check: Run level
Node Name run level Required Comment
------------ ------------------------ ------------------------ ----------
racn2 5 3,5 passed
racn1 5 3,5 passed
Result: Run level check passed
Check: Hard limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
racn2 hard 65536 65536 passed
racn1 hard 65536 65536 passed
Result: Hard limits check passed for "maximum open file descriptors"
Check: Soft limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
racn2 soft 1024 1024 passed
racn1 soft 1024 1024 passed
Result: Soft limits check passed for "maximum open file descriptors"
Check: Hard limits for "maximum user processes"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
racn2 hard 16384 16384 passed
racn1 hard 16384 16384 passed
Result: Hard limits check passed for "maximum user processes"
Check: Soft limits for "maximum user processes"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
racn2 soft 2047 2047 passed
racn1 soft 2047 2047 passed
Result: Soft limits check passed for "maximum user processes"
Check: System architecture
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 i686 x86 passed
racn1 i686 x86 passed
Result: System architecture check passed
Check: Kernel version
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 2.6.18-164.el5PAE 2.6.18 passed
racn1 2.6.18-164.el5PAE 2.6.18 passed
Result: Kernel version check passed
Check: Kernel parameter for "semmsl"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 250 250 passed
racn1 250 250 passed
Result: Kernel parameter check passed for "semmsl"
Check: Kernel parameter for "semmns"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 32000 32000 passed
racn1 32000 32000 passed
Result: Kernel parameter check passed for "semmns"
Check: Kernel parameter for "semopm"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 100 100 passed
racn1 100 100 passed
Result: Kernel parameter check passed for "semopm"
Check: Kernel parameter for "semmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 128 128 passed
racn1 128 128 passed
Result: Kernel parameter check passed for "semmni"
Check: Kernel parameter for "shmmax"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 4294967295 536870912 passed
racn1 4294967295 536870912 passed
Result: Kernel parameter check passed for "shmmax"
Check: Kernel parameter for "shmmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 4096 4096 passed
racn1 4096 4096 passed
Result: Kernel parameter check passed for "shmmni"
Check: Kernel parameter for "shmall"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 1073741824 2097152 passed
racn1 1073741824 2097152 passed
Result: Kernel parameter check passed for "shmall"
Check: Kernel parameter for "file-max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 6553600 6815744 failed
racn1 6553600 6815744 failed
Result: Kernel parameter check failed for "file-max"
Check: Kernel parameter for "ip_local_port_range"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 between 1024 & 65000 between 9000 & 65500 failed (ignorable)
racn1 between 1024 & 65000 between 9000 & 65500 failed (ignorable)
Result: Kernel parameter check passed for "ip_local_port_range"
Check: Kernel parameter for "rmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 4194304 262144 passed
racn1 4194304 262144 passed
Result: Kernel parameter check passed for "rmem_default"
Check: Kernel parameter for "rmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 4194304 4194304 passed
racn1 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_max"
Check: Kernel parameter for "wmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 262144 262144 passed
racn1 262144 262144 passed
Result: Kernel parameter check passed for "wmem_default"
Check: Kernel parameter for "wmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 262144 1048576 failed
racn1 262144 1048576 failed
Result: Kernel parameter check failed for "wmem_max"
Check: Kernel parameter for "aio-max-nr"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
racn2 3145728 1048576 passed
racn1 3145728 1048576 passed
Result: Kernel parameter check passed for "aio-max-nr"
Check: Package existence for "make-3.81"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 make-3.81-3.el5 make-3.81 passed
racn1 make-3.81-3.el5 make-3.81 passed
Result: Package existence check passed for "make-3.81"
Check: Package existence for "binutils-2.17.50.0.6"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 binutils-2.17.50.0.6-12.el5 binutils-2.17.50.0.6 passed
racn1 binutils-2.17.50.0.6-12.el5 binutils-2.17.50.0.6 passed
Result: Package existence check passed for "binutils-2.17.50.0.6"
Check: Package existence for "gcc-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 gcc-4.1.2-46.el5 gcc-4.1.2 passed
racn1 gcc-4.1.2-46.el5 gcc-4.1.2 passed
Result: Package existence check passed for "gcc-4.1.2"
Check: Package existence for "gcc-c++-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 gcc-c++-4.1.2-46.el5 gcc-c++-4.1.2 passed
racn1 gcc-c++-4.1.2-46.el5 gcc-c++-4.1.2 passed
Result: Package existence check passed for "gcc-c++-4.1.2"
Check: Package existence for "libgomp-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libgomp-4.4.0-6.el5 libgomp-4.1.2 passed
racn1 libgomp-4.4.0-6.el5 libgomp-4.1.2 passed
Result: Package existence check passed for "libgomp-4.1.2"
Check: Package existence for "libaio-0.3.106"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libaio-0.3.106-3.2 libaio-0.3.106 passed
racn1 libaio-0.3.106-3.2 libaio-0.3.106 passed
Result: Package existence check passed for "libaio-0.3.106"
Check: Package existence for "glibc-2.5-24"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 glibc-2.5-42 glibc-2.5-24 passed
racn1 glibc-2.5-42 glibc-2.5-24 passed
Result: Package existence check passed for "glibc-2.5-24"
Check: Package existence for "compat-libstdc++-33-3.2.3"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 compat-libstdc++-33-3.2.3-61 compat-libstdc++-33-3.2.3 passed
racn1 compat-libstdc++-33-3.2.3-61 compat-libstdc++-33-3.2.3 passed
Result: Package existence check passed for "compat-libstdc++-33-3.2.3"
Check: Package existence for "elfutils-libelf-0.125"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passed
racn1 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passed
Result: Package existence check passed for "elfutils-libelf-0.125"
Check: Package existence for "elfutils-libelf-devel-0.125"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed
racn1 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed
Result: Package existence check passed for "elfutils-libelf-devel-0.125"
Check: Package existence for "glibc-common-2.5"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 glibc-common-2.5-42 glibc-common-2.5 passed
racn1 glibc-common-2.5-42 glibc-common-2.5 passed
Result: Package existence check passed for "glibc-common-2.5"
Check: Package existence for "glibc-devel-2.5"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 glibc-devel-2.5-42 glibc-devel-2.5 passed
racn1 glibc-devel-2.5-42 glibc-devel-2.5 passed
Result: Package existence check passed for "glibc-devel-2.5"
Check: Package existence for "glibc-headers-2.5"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 glibc-headers-2.5-42 glibc-headers-2.5 passed
racn1 glibc-headers-2.5-42 glibc-headers-2.5 passed
Result: Package existence check passed for "glibc-headers-2.5"
Check: Package existence for "libaio-devel-0.3.106"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libaio-devel-0.3.106-3.2 libaio-devel-0.3.106 passed
racn1 libaio-devel-0.3.106-3.2 libaio-devel-0.3.106 passed
Result: Package existence check passed for "libaio-devel-0.3.106"
Check: Package existence for "libgcc-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libgcc-4.1.2-46.el5 libgcc-4.1.2 passed
racn1 libgcc-4.1.2-46.el5 libgcc-4.1.2 passed
Result: Package existence check passed for "libgcc-4.1.2"
Check: Package existence for "libstdc++-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libstdc++-4.1.2-46.el5 libstdc++-4.1.2 passed
racn1 libstdc++-4.1.2-46.el5 libstdc++-4.1.2 passed
Result: Package existence check passed for "libstdc++-4.1.2"
Check: Package existence for "libstdc++-devel-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 libstdc++-devel-4.1.2-46.el5 libstdc++-devel-4.1.2 passed
racn1 libstdc++-devel-4.1.2-46.el5 libstdc++-devel-4.1.2 passed
Result: Package existence check passed for "libstdc++-devel-4.1.2"
Check: Package existence for "sysstat-7.0.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 sysstat-7.0.2-3.el5 sysstat-7.0.2 passed
racn1 sysstat-7.0.2-3.el5 sysstat-7.0.2 passed
Result: Package existence check passed for "sysstat-7.0.2"
Check: Package existence for "unixODBC-2.2.11"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 unixODBC-2.2.11-7.1 unixODBC-2.2.11 passed
racn1 unixODBC-2.2.11-7.1 unixODBC-2.2.11 passed
Result: Package existence check passed for "unixODBC-2.2.11"
Check: Package existence for "unixODBC-devel-2.2.11"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 unixODBC-devel-2.2.11-7.1 unixODBC-devel-2.2.11 passed
racn1 unixODBC-devel-2.2.11-7.1 unixODBC-devel-2.2.11 passed
Result: Package existence check passed for "unixODBC-devel-2.2.11"
Check: Package existence for "ksh-20060214"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 ksh-20080202-14.el5 ksh-20060214 passed
racn1 ksh-20080202-14.el5 ksh-20060214 passed
Result: Package existence check passed for "ksh-20060214"
Checking for multiple users with UID value 0
Result: Check for multiple users with UID value 0 passed
Check: Current group ID
Result: Current group ID check passed
Checking Core file name pattern consistency...
Core file name pattern consistency check passed.
Checking to make sure user "oracle" is not in "root" group
Node Name Status Comment
------------ ------------------------ ------------------------
racn2 does not exist passed
racn1 does not exist passed
Result: User "oracle" is not part of "root" group. Check passed
Check default user file creation mask
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
racn2 0022 0022 passed
racn1 0022 0022 passed
Result: Default user file creation mask check passed
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
The NTP configuration file "/etc/ntp.conf" is available on all nodes
NTP Configuration file check passed
Checking daemon liveness...
Check: Liveness for "ntpd"
Node Name Running?
------------------------------------ ------------------------
racn2 no
racn1 no
Result: Liveness check failed for "ntpd"
PRVF-5415 : Check to see if NTP daemon is running failed
Result: Clock synchronization check using Network Time Protocol(NTP) failed
Fixup information has been generated for following node(s):
racn1,racn2
Please run the following script on each node as "root" user to execute the fixups:
'/tmp/CVU_11.2.0.1.0_oracle/runfixup.sh'
Pre-check for cluster services setup was unsuccessful on all the nodes.
[root@RACN1 CVU_11.2.0.1.0_oracle]# ./runfixup.sh
Response file being used is :./fixup.response
Enable file being used is :./fixup.enable
Log file location: ./orarun.log
Setting Kernel Parameters...
fs.file-max = 6553600
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.wmem_max = 262144
net.core.wmem_max=262144
./orarun.sh: line 728: [: 262144net.core.wmem_max: integer expression expected
The value for wmem_max in response file is not greater than value for wmem_max in /etc/sysctl.conf file. Hence not changing it.
net.core.wmem_max = 1048576
[root@RACN2 CVU_11.2.0.1.0_oracle]# ./runfixup.sh
Response file being used is :./fixup.response
Enable file being used is :./fixup.enable
Log file location: ./orarun.log
Setting Kernel Parameters...
fs.file-max = 6553600
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.wmem_max = 262144
net.core.wmem_max=262144
./orarun.sh: line 728: [: 262144net.core.wmem_max: integer expression expected
The value for wmem_max in response file is not greater than value for wmem_max in /etc/sysctl.conf file. Hence not changing it.
net.core.wmem_max = 1048576
.3. NTP ERROR FIXED
Move /etc/ntp.conf
[root@RACN1 ~]# mv /etc/ntp.conf /etc/ntp.conf.old
[root@RACN2 ~]# mv /etc/ntp.conf /etc/ntp.conf.old
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
Network Time Protocol(NTP) configuration file not found on any of the nodes. Oracle Cluster Time Synchronization Service(CTSS) can be used instead of NTP for time synchronization on the cluster nodes
Result: Clock synchronization check using Network Time Protocol(NTP) passed
CONFIGURE SCAN IP
SET ASM ROLLING PARAMETER
asmca_rolling_upgrade=true
Oracle strongly recommends that you configure the SCAN either on DNS or GNS, with a maximum of three IPs in a round-robin fashion
|
4. Configure DNS files or /etc/hosts
Editing needed in DNS, since I m not using DNS I will edit my /etc/hosts and Add a new IP.
5. Create GRID_HOME and set environment
export GRID_HOME=/u01/app/grid
To Upgrade ASM alone with GRID , we need to export below parameter.
export asmca_rolling_upgrade=true
CRS don’t need to shutdown as its Rolling Upgrade.
While Running rootupgrade.sh after installation .it will shutdown old (11.1.0.7) and start new CRS (11.2.0.1).
RACN1:/home/oracle-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE racn1
ora....N1.lsnr application ONLINE ONLINE racn1
ora.racn1.gsd application ONLINE ONLINE racn1
ora.racn1.ons application ONLINE ONLINE racn1
ora.racn1.vip application ONLINE ONLINE racn1
ora....SM2.asm application ONLINE ONLINE racn2
ora....N2.lsnr application ONLINE ONLINE racn2
ora.racn2.gsd application ONLINE ONLINE racn2
ora.racn2.ons application ONLINE ONLINE racn2
ora.racn2.vip application ONLINE ONLINE racn2
6.Run Installer of Grid Infrastructure setup and select to upgrade Grid Infrastructure.
7. It will detect if its Running on ASM.
8. Node selection / Choose if you want to upgrade ASM along with CRS.
9.enter SCAN detail .
8. 10.Enter ASM pwd.
10. Select OS group for ASM.
11. Enter Installation Location Detail. ($GRID_HOME)
12.Installation in progress.
13.Run the Rootupgrade.sh on both node.
[root@RACN1 grid]# ./rootupgrade.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2011-10-12 21:04:39: Parsing the host name
2011-10-12 21:04:39: Checking for super user privileges
2011-10-12 21:04:39: User has super user privileges
Using configuration parameter file: /u01/app/grid/crs/install/crsconfig_params
Creating trace directory
Cluster Synchronization Services appears healthy
Event Manager appears healthy
Cluster Ready Services appears healthy
Shutting down Oracle Cluster Ready Services (CRS):
Oct 12 21:05:11.420 | INF | daemon shutting down
Stopping resources.
This could take several minutes.
Successfully stopped Oracle Clusterware resources
Stopping Cluster Synchronization Services.
Shutting down the Cluster Synchronization Services daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
CRS-2672: Attempting to start 'ora.mdnsd' on 'racn1'
CRS-2676: Start of 'ora.mdnsd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'racn1'
CRS-2676: Start of 'ora.gipcd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'racn1'
CRS-2676: Start of 'ora.gpnpd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'racn1'
CRS-2676: Start of 'ora.cssdmonitor' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'racn1'
CRS-2672: Attempting to start 'ora.diskmon' on 'racn1'
CRS-2676: Start of 'ora.diskmon' on 'racn1' succeeded
CRS-2676: Start of 'ora.cssd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'racn1'
CRS-2676: Start of 'ora.ctssd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'racn1'
CRS-2676: Start of 'ora.crsd' on 'racn1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'racn1'
CRS-2676: Start of 'ora.evmd' on 'racn1' succeeded
clscfg: EXISTING configuration version 4 detected.
clscfg: version 4 is 11 Release 1.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
racn1 2011/10/12 21:11:27 /u01/app/grid/cdata/racn1/backup_20111012_211127.olr
Preparing packages for installation...
cvuqdisk-1.0.7-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Updating inventory properties for clusterware
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 1139 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 1022 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
[root@RACN1 grid]#
14. Now ASM will get upgrade.
15. validate all resources.
Validate All Resources are ONLINE with all new command.
./crsctl stat res -t
GSD will be OFFLINE by default in 11R2.
If any 9i database is cluster then GSD must be ONLINE.
To start GSD as ROOT.
./srvctl enable nodeapps -g
./srvctl start nodeapps