Exploring the new Oracle 11g ASM features against Oracle 10g database
Exploring the new Oracle 11g ASM features against Oracle 10g database
We all know that Oracle 11g release has much more to offer. For those who are using ASM as their storage they can upgrade their ASM instance to Oracle11g immediately and start exploiting 11g ASM features against their 10g database.
Below are shown the simple steps to follow and you are all set to go with ASM 11g features for your 1og database.
1. Install Oracle 11g RDBMS software for your new ASM 11g HOME. Upgrade clusterware to Oracle 11g.
2. Shutdown your 10g database & ASM instance
3. Reconfigure Oracle Cluster Synchronization Services to run from new 11g home
Set PATH and other environment variables(ORACLE_HOME, ORACLE_SID) to new ORACLE 11g executables.
Login as root and run following command.
[root@raclinux1oracle]# localconfig reset
Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
Configuration for local CSS has been initialized
Stale CSS daemon is running… killing it now
Cleaning up Network socket directories
Setting up Network socket directories
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process…
Expecting the CRS daemons to be up within 600 seconds.
Cluster Synchronization Services is active on these nodes.
arul
Cluster Synchronization Services is active on all the nodes.
Oracle CSS service is installed and running under init(1M)
[root@raclinux1 oracle]#
4. Copy password file & S/Pfile to new 11g ORACLE_HOME/dbs folder
$ cp spfile+ASM.ora /u02/app/oracle/product/11g/db_1/dbs
$ cp orapw+ASM /u02/app/oracle/product/11g/db_1/dbs
5. Remove the obsolete initialization parameters
Parameters like background/user/core dump dest are obsolete in 11g, so remove those parameters.
Change the remote login passwordfile to exclusive.
6. Login as sysdba and start the ASM instance from 11g home and grant sysasm privilege.
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Mon Dec 14 01:11:50 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 284565504 bytes
Fixed Size 1299428 bytes
Variable Size 258100252 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> grant sysasm to sys;
Grant succeeded.
SQL> exit
7. Start 10g RDBMS instance.
set PATH and other environment variables(ORACLE_HOME, ORACLE_SID) to ORACLE 10g RDBMS instance.
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 – Production on Mon Dec 14 01:13:46 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 184549376 bytes
Fixed Size 1218412 bytes
Variable Size 71305364 bytes
Database Buffers 109051904 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
8. All set to go.
Now you can use 11g ASM features for your 10g RDBMS instance.
ASMCMD has the few very handy new commands: cp, lsdsk, pwd…
Few examples..
ASMCMD [+data/vis] > cp spfilevis.ora +data/vis/test/spfilevis.ora
source +data/vis/spfilevis.ora
target +data/vis/test/spfilevis.ora
copying file(s)…
file, +DATA/vis/test/spfilevis.ora, copy committed.
ASMCMD [+data/vis] > cd test
ASMCMD [+data/vis/test] > ls
spfilevis.ora
$ asmcmd -v
asmcmd version 11.1.0.6.0
ASMCMD [+data/vis/test] > pwd
+data/vis/test
ASMCMD [+data/vis/test] > lsdsk
Path
/dev/raw/raw1
/dev/raw/raw2
ASMCMD [+data/vis/test] > lsct
DB_Name Status Software_Version Compatible_version Instance_Name Disk_Group
vis CONNECTED 10.2.0.1.0 10.2.0.1.0 vis DATA
vis CONNECTED 10.2.0.1.0 10.2.0.1.0 vis FRA
No comments yet.
-
Archives
- February 2017 (1)
- November 2016 (1)
- October 2016 (1)
- May 2016 (2)
- March 2016 (3)
- December 2014 (2)
- July 2014 (1)
- June 2014 (6)
- May 2014 (5)
- February 2014 (1)
- December 2012 (2)
- November 2012 (8)
-
Categories
-
RSS
Entries RSS
Comments RSS
Leave a Reply