Reason: The database is using ASM as storage. Before you upgrade database, you need to upgrade ASM using Automatic Storage Management Configuration (ASMCA) from grid infrastructure home. Starting with 11gR2, ASM should be running from grid infrastructure home.
My installation environment
[oracle@lv-rms-test ~]$ cat .bash_profile.grid
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/opt/oracle/112/grid/asm
unset ORACLE_HOME
export PATH=$PATH:/opt/oracle/install/cpujan2010/OPatch
export PATH=$PATH:/sbin
export PATH=$PATH:/usr/ccs/bin
export ORACLE_HOME=/opt/oracle/112/grid/app
export ORACLE_SID=+ASM # Each RAC node must have a unique Oracle SID! E.g. orcl1, orcl2,...
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERICA.NEE8ISO8859P4
#export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
check if you have old ASM instance
[oracle@lv-rms-test ~]$ cat /etc/oratab
+ASM:/opt/oracle/102:N
Run script after grid installation(with your path, if it is different)
[root@lv-rms-test grid]# /opt/oracle/112/grid/app/perl/bin/perl -I/opt/oracle/112/grid/app/perl/lib -I/opt/oracle/112/grid/app/crs/install /opt/oracle/112/grid/app/crs/install/roothas.pl
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
CSS appears healthy
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
CRS-4664: Node lv-rms-test successfully pinned.
Adding daemon to inittab
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
lv-rms-test 2011/02/17 17:26:45 /opt/oracle/112/grid/app/cdata/lv-rms-test/backup_20110217_172645.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
[oracle@lv-rms-test ~]$ . .bash_profile.11g
[oracle@lv-rms-test ~]$ env | grep ORA
ORACLE_UNQNAME=MAN2
ORACLE_SID=RMS
ORACLE_BASE=/opt/oracle/112
ORACLE_TERM=xterm
ORA_NLS33=/opt/oracle/112/product/11.2.0/dbhome_1/ocommon/nls/admin/data
ORACLE_HOME=/opt/oracle/112/product/11.2.0/dbhome_1
[oracle@lv-rms-test ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 18-FEB-2011 11:52:58
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /opt/oracle/112/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Log messages written to /opt/oracle/112/diag/tnslsnr/lv-rms-test/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lv-rms-test)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 18-FEB-2011 11:52:58
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /opt/oracle/112/diag/tnslsnr/lv-rms-test/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lv-rms-test)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@lv-rms-test ~]$ . .bash_profile.grid
[oracle@lv-rms-test ~]$ env | grep ORA
ORACLE_UNQNAME=MAN2
ORACLE_SID=+ASM
ORACLE_BASE=/opt/oracle/112/grid/asm
ORACLE_TERM=xterm
ORA_NLS33=/opt/oracle/112/grid/app/ocommon/nls/admin/data
ORACLE_HOME=/opt/oracle/112/grid/app
[oracle@lv-rms-test ~]$ asmca
[oracle@lv-rms-test ~]$ . .bash_profile.grid
[oracle@lv-rms-test ~]$ sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 18 11:59:44 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Automatic Storage Management option
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /opt/oracle/112/grid/app/dbs/spfile+ASM.ora
SQL> exit
[oracle@lv-rms-test ~]$ cat /etc/oratab
+ASM:/opt/oracle/112/grid/app:N
Last check
[oracle@lv-rms-test ~]$ cat /etc/oratab
+ASM:/opt/oracle/112/grid/app:N
RMS:/opt/oracle/112/product/11.2.0/dbhome_1:N # line added by Agent
Good luck
1) Download Oracle Grid Infrastructure installation.
2) Install the Oracle Grid Infrastructure as described in the manual
My installation environment
[oracle@lv-rms-test ~]$ cat .bash_profile.grid
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/opt/oracle/112/grid/asm
unset ORACLE_HOME
export PATH=$PATH:/opt/oracle/install/cpujan2010/OPatch
export PATH=$PATH:/sbin
export PATH=$PATH:/usr/ccs/bin
export ORACLE_HOME=/opt/oracle/112/grid/app
export ORACLE_SID=+ASM # Each RAC node must have a unique Oracle SID! E.g. orcl1, orcl2,...
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERICA.NEE8ISO8859P4
#export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
3) After the Oracle Grid Infrastructure installation is completed, please verify that the
ASM instance is running under the old ASM Oracle Home Release (11gR1, 10gR2 or
10gR1). ASMCA will try to start it if it is not running.
check if you have old ASM instance
[oracle@lv-rms-test ~]$ cat /etc/oratab
+ASM:/opt/oracle/102:N
4) Since the Oracle Grid Infrastructure 11gR2 (11.2.0.2.0) was installed, please make
sure the CSS service is running:
Run script after grid installation(with your path, if it is different)
[root@lv-rms-test grid]# /opt/oracle/112/grid/app/perl/bin/perl -I/opt/oracle/112/grid/app/perl/lib -I/opt/oracle/112/grid/app/crs/install /opt/oracle/112/grid/app/crs/install/roothas.pl
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
CSS appears healthy
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
CRS-4664: Node lv-rms-test successfully pinned.
Adding daemon to inittab
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
lv-rms-test 2011/02/17 17:26:45 /opt/oracle/112/grid/app/cdata/lv-rms-test/backup_20110217_172645.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
5) run listener under ORACLE HOME 11gR2 (11.2.0.2.0)
[oracle@lv-rms-test ~]$ cd [oracle@lv-rms-test ~]$ . .bash_profile.11g
[oracle@lv-rms-test ~]$ env | grep ORA
ORACLE_UNQNAME=MAN2
ORACLE_SID=RMS
ORACLE_BASE=/opt/oracle/112
ORACLE_TERM=xterm
ORA_NLS33=/opt/oracle/112/product/11.2.0/dbhome_1/ocommon/nls/admin/data
ORACLE_HOME=/opt/oracle/112/product/11.2.0/dbhome_1
[oracle@lv-rms-test ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 18-FEB-2011 11:52:58
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /opt/oracle/112/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Log messages written to /opt/oracle/112/diag/tnslsnr/lv-rms-test/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lv-rms-test)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 18-FEB-2011 11:52:58
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /opt/oracle/112/diag/tnslsnr/lv-rms-test/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lv-rms-test)(PORT=1521)))
The listener supports no services
The command completed successfully
6) Then run the ASMCA from the new Oracle Grid Infrastructure 11gR2 (11.2.0.2.0)
Oracle Home:[oracle@lv-rms-test ~]$ . .bash_profile.grid
[oracle@lv-rms-test ~]$ env | grep ORA
ORACLE_UNQNAME=MAN2
ORACLE_SID=+ASM
ORACLE_BASE=/opt/oracle/112/grid/asm
ORACLE_TERM=xterm
ORA_NLS33=/opt/oracle/112/grid/app/ocommon/nls/admin/data
ORACLE_HOME=/opt/oracle/112/grid/app
[oracle@lv-rms-test ~]$ asmca
- ASMCA will show the ASM Oracle Home Path from the previous and new release (see screenshot below).
- Please provide the ASMSNMP password (see screenshot below).And then press the [Upgrade ASM] button; ASMCA will start with the ASM instance upgrade (see screenshot below).
- After the ASM instance is upgraded, please validate that the diskgroups are mounted.
Then press the [Exit] button.
7) Verify that the ASM instance is now running under new 11gR2 Grid Infrastructure
Oracle Home:
[oracle@lv-rms-test ~]$ . .bash_profile.grid
[oracle@lv-rms-test ~]$ sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 18 11:59:44 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Automatic Storage Management option
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /opt/oracle/112/grid/app/dbs/spfile+ASM.ora
SQL> exit
[oracle@lv-rms-test ~]$ cat /etc/oratab
+ASM:/opt/oracle/112/grid/app:N
Finaly you can upgrade your 10.2.0.5 database on ASM to 11.2.0.2. I used dbua (database upgrade assistant).
Run dbua from ORACLE HOME 11g (not from GRID home)
Last check
[oracle@lv-rms-test ~]$ cat /etc/oratab
+ASM:/opt/oracle/112/grid/app:N
RMS:/opt/oracle/112/product/11.2.0/dbhome_1:N # line added by Agent
Good luck
can u plz tel me frm where to Download Oracle Grid Infrastructure installation.
ReplyDeleteHello, just wanted to mention, I liked this blog post.
ReplyDeleteIt was helpful. Keep on posting!
my site :: juice recipes for weight loss (http://Www.Crp-01.Org.br/psiweb/index.Php?Title=Usu%C3%A1rio:LavadaVbwy)
Do you have a spam issue on this blog; I also am a blogger, and I was wanting to know your situation; many of us have developed some nice practices and we are looking to exchange strategies with other folks,
ReplyDeletebe sure to shoot me an email if interested.
my web site - lemonade diet recipe
tory burch outlet, nike air max, uggs on sale, longchamp, nike air max, ray ban sunglasses, tiffany and co, tiffany jewelry, oakley sunglasses, louis vuitton, ugg boots, oakley sunglasses, ugg boots, louboutin outlet, ray ban sunglasses, prada handbags, michael kors, burberry, oakley sunglasses, nike outlet, louis vuitton outlet, louis vuitton, replica watches, michael kors outlet, michael kors outlet, michael kors outlet, nike free, kate spade outlet, chanel handbags, oakley sunglasses, longchamp outlet, longchamp outlet, polo ralph lauren outlet, replica watches, burberry outlet online, prada outlet, ugg boots, louis vuitton, gucci outlet, louboutin, michael kors outlet, louis vuitton outlet, jordan shoes, ugg boots
ReplyDeletelacoste pas cher, nike air max, vans pas cher, replica handbags, mulberry, michael kors, true religion jeans, air jordan pas cher, north face, air max, ralph lauren uk, oakley pas cher, coach outlet, north face, louboutin pas cher, tn pas cher, sac guess, michael kors, coach purses, nike roshe run, hogan, coach outlet, nike free run uk, sac longchamp, hermes, ray ban pas cher, hollister pas cher, kate spade handbags, nike free, vanessa bruno, timberland, nike air max, michael kors, ray ban uk, lululemon, ralph lauren pas cher, burberry, hollister, nike blazer, michael kors, true religion outlet, longchamp pas cher, nike roshe, true religion jeans, new balance pas cher, air force, converse pas cher, nike air max, abercrombie and fitch, true religion jeans
ReplyDeletemoncler, juicy couture outlet, thomas sabo, swarovski crystal, barbour jackets, canada goose outlet, karen millen, canada goose, replica watches, pandora jewelry, ugg,ugg australia,ugg italia, vans, marc jacobs, louis vuitton, louis vuitton, supra shoes, moncler, canada goose, barbour, bottes ugg, ugg pas cher, doudoune canada goose, links of london, moncler, ray ban, louis vuitton, coach outlet, converse outlet, moncler, montre pas cher, sac louis vuitton pas cher, hollister, moncler, lancel, canada goose outlet, pandora charms, louis vuitton, canada goose uk, hollister, moncler outlet, canada goose, doke gabbana outlet, ugg,uggs,uggs canada, pandora jewelry, moncler, moncler, gucci, ugg boots uk, juicy couture outlet, pandora charms, converse, swarovski, wedding dresses
ReplyDeleteomega outlet
ReplyDeleteferragamo outlet
ferragamo shoes sale
kate spade uk
kate spade uk outlet
true religion jeans
true religion outlet
true religion uk outlet
oakley sunglasses wholesale
tory burch outlet online
burberry outlet store
burberry outlet store
burberry outlet sale
tory burch outlet online
hollister clothing store
cheap replica watches
ralph lauren polo
nba jerseys
ralph lauren outlet
ralph lauren outlet
ralph lauren outlet
hollister shirts
oakley sunglasses
oakley sunglasses wholesale
oakley sunglasses
cheap oakley sunglasses
discount oakley sunglasses
mont blanc pens
oakley canada
iphone case
lululemon pants
ghd uk
rolex watches,rolex watches,swiss watches,watches for men,watches for women,omega watches,replica watches,rolex watches for sale,rolex replica,rolex watch,cartier watches,rolex submariner,fake rolex,rolex replica watches,replica rolex
hollister clothing store
ralph lauren outlet
lllllyuan20160601
شركة كشف تسربات المياه بالدمام
ReplyDeleteكشف تسربات المياه بالدمام
شركة عزل اسطح بالدمام
شركة عزل خزانات المياه بالدمام
شركه عزل مائى بالدمام
شركة عزل حرارى بالدمام
شركة ترميم منازل بالدمام
شركة مكافحة حشرات بالدمام
شركة رش مبيدات بالدمام
شركة تسليك مجارى بالدمام
شركة ترميم منازل بالدمام
شركة صيانة منازل بالدمام
Moneylender
ReplyDeleteDigibrand
michael kors bags
ReplyDeletecheap ugg boots
polo ralph lauren outlet
coach outlet online
canada goose outlet
coach factory outlet online
salvatore ferragamo shoes
christian louboutin sale
moncler uk
louboutin sale
zhi20161126
gucci handbags
ReplyDeletepolo ralph lauren outlet
louis vuitton outlet
polo outlet
adidas uk
nike air force 1
ugg outlet store
michael kors outlet clearance
fitflops sale clearance
hollister kids
20170223caiyan
Entire life Replacement is an element that you rarely find, when you Buy facebook reviews. Exclusively a few excellent service providers give this. buying facebook reviews
ReplyDeleteair max
ReplyDeletenhl jerseys
coach outlet online
gucci outlet
marc jacobs
true religion jeans
nike blazer
polo shirts
swarovski crystal
dior handbags
20184.23chenjinyan
undefeated clothing
ReplyDeleteversace sunglasses
nike dunks
kobe 12
oakley vault
adidas slides
true religion
north face outlet
maillot de foot
mac cosmetics
chenyingying20181110
ReplyDeleteفني صحي بالكويت
https://www.rashed-kw.com/مكافحة-حشرات-بالكويت/
https://www.rashed-kw.com/نقل-عفش-بالكويت/
https://www.rashed-kw.com/شركة-تنظيف-بالكويت/
i5n39b7k22 s6o03c4s81 h6x29o6j48 g0e73t0o78 i9t04v3z30 m9g36a6k79
ReplyDeletevan
ReplyDeleteerzincan
sivas
ağrı
manisa
NMEE
whatsapp görüntülü show
ReplyDeleteücretli.show
XZ40
istanbul evden eve nakliyat
ReplyDeletekonya evden eve nakliyat
düzce evden eve nakliyat
bursa evden eve nakliyat
diyarbakır evden eve nakliyat
Q7UU
B7F79
ReplyDeleteBinance Güvenilir mi
Sivas Evden Eve Nakliyat
Kırşehir Şehir İçi Nakliyat
İstanbul Şehirler Arası Nakliyat
Çerkezköy Marangoz
Gümüşhane Şehirler Arası Nakliyat
Çorum Lojistik
Denizli Parça Eşya Taşıma
Çerkezköy Fayans Ustası
C58B3
ReplyDeletebinance kod
B4F11
ReplyDelete%20 binance komisyon indirimi