exploiting 11g asm features against 10g database-凯发app官方网站

凯发app官方网站-凯发k8官网下载客户端中心 | | 凯发app官方网站-凯发k8官网下载客户端中心
  • 博客访问: 3977061
  • 博文数量: 536
  • 博客积分: 10470
  • 博客等级: 上将
  • 技术积分: 4825
  • 用 户 组: 普通用户
  • 注册时间: 2006-05-26 14:08
文章分类

全部博文(536)

文章存档

2024年(3)

2021年(1)

2019年(1)

2017年(1)

2016年(2)

2013年(2)

2012年(10)

2011年(43)

2010年(10)

2009年(17)

2008年(121)

2007年(252)

2006年(73)

相关博文
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·

分类: oracle

2009-09-30 10:33:46

exploiting 11g asm features against 10g database

we all know that new oracle 11g release has much more to offer. its going to take some time for every one to adopt 11g in production. lot of testing to be done. management has to be convinced about its stability based on success stories of others customers. but somewhere, someone has to start.

for those who are using asm as their storage can upgrade their asm instance alone to 11g immediately and start exploiting 11g asm features against their 10g database.

following are 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.

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@arul oracle]# 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@arul 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 jan 21 09:11:50 2008
凯发app官方网站 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 jan 21 09:13:46 2008

凯发app官方网站 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/mars] > cp spfilemars.ora data/mars/test/spfilemars.ora
source data/mars/spfilemars.ora
target data/mars/test/spfilemars.ora
copying file(s)...
file, data/mars/test/spfilemars.ora, copy committed.

asmcmd [ data/mars] > cd test
asmcmd [ data/mars/test] > ls
spfilemars.ora

$ asmcmd -v
asmcmd version 11.1.0.6.0


asmcmd [ data/mars/test] > pwd
data/mars/test


asmcmd [ data/mars/test] > lsdsk
path
/dev/raw/raw1
/dev/raw/raw2

asmcmd [ data/mars/test] > lsct
db_name status software_version compatible_version instance_name disk_group
mars connected 10.2.0.1.0 10.2.0.1.0 mars data
mars connected 10.2.0.1.0 10.2.0.1.0 mars fra
阅读(2797) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
")); function link(t){ var href= $(t).attr('href'); href ="?url=" encodeuricomponent(location.href); $(t).attr('href',href); //setcookie("returnouturl", location.href, 60, "/"); }
网站地图