I have a database running on 10205 version. It is a RAC database with ASM storage.
I want to migrate this database to other server and upgrade this database to 11202 version .
upgrading a single instance 10.2.0.2 database of approx size 2TB to 11.2.0.3 rac 2 node db on linux.
View 3 Replies View RelatedIs there any document available for 10g to 11gR2 RAC upgrade on AIX?
View 1 Replies View Relatedup gradation steps from 10g RAC to 11gr2 RAC.
View 1 Replies View RelatedWhy is knowing the backup policy important before starting any upgrade.
View 17 Replies View RelatedWhich is the best method for migration of database from Oracle 9iR2,10gR2 to 11gR2.
Current Environment
Server1
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 9.2.0.8 (32 bit)
Average Db Size: 600Gb
RAc Configuration: No
Server2
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 10.2.0.3 (64 bit)
Average Db Size: 600Gb
RAC Configuration: No
Proposed Environment
Server1 and Server2
Operating System: Sun Solaris 10
Oracle Database: Oracle Database Enterprise Edition 11.2.0.3 (64 bit)
RAC Configuration: No
Hardware is New : Yes
I need to do the following:
(1) Move my 10gR2 database from 32-bit Linux to 11gR2 64-Bit Linux (using an RMAN backup from 10gR2 restored on the 64-bit machine) then
(2) Bring up the database on 64-bit hardware and then upgrade to 11.2.0.3 (64-Bit) [Without installing the 10.2.0.3 64-Bit software]
Haven't tried restoring to 11.2.0.3 from a RMAN 10.2.0.3 backup. I was trying not to have to install the Oracle 10.2.0.3 software for 64-bit on the 64-bit machine. Was hoping to go directly to 11.2.0.3 (64-bit).
Iam doing some oracle database upgrade from 9.2.0 to 11gr2 . is it possible to upgrade directly from this 9i version to 11gr2 .
Version : 9.2.0 to 11gr2
After upgrading 11gR1 database (11.1.0.7.0) to 11gR2 (11.2.0.3.0), the datapump exports have been taking quite a bit longer. When database was 11gR1, a full expdp took approx. 40-45 minutes. After upgrade, it takes approx. 1 hour 40-50 minutes. These times were with parallel=4. I tried with parallel=8 and parallel=12, both of these took around 1 hour 5-10 minutes, better but still quite a bit slower than pre-11gR2 upgrade. I tried with exclude=statistics, index_statistics, indexes; it still took approx. 1 hour 40-45 minutes. This is a PeopleSoft database so there are many, many objects to be exported. The database was upgraded using dbua.
View 1 Replies View Relatedwe had our Oracle RAC database at primary and Standby database as DR. It was running in 10g (10.2.0.1.0) in HP UX 11i platform.
We need to upgrade both the setups from 10.2.0.1.0 to 10.2.0.4.0 . I will go through the upgrade guide, i like to know is there any special case for upgrading when we do for both primary and standby database.
And whether i need to create a new Oracle home with 10.2.0.4.0 software or i can upgrade in the same oracle home which already exists.
I am migrating an oracle 10g to 11gR2. i am a bit confused. The developers in my work place have a tablespace for storing table and a different tablespace for storing indexes.
For the migration i am using exp and imp. My question is how i am going to migrate the indexes from 10g to 11gR2?
OS; solaris sparc 10
Oracle 10g: 10.2.0.1.0
oracle 11g: 11.2.0.1.0
Question: to migrate from oracle 10gR2 in Windows to oracle 11gR2 in Linux . Steps are:
1. need to expdp all schemas/users from oracle 10gR2 in Windows,
2. then impdp each schema/user into oracle 10gR2 in Linux first,
3. then upgrade the oracle 10gR2 in Linux to oracle 11gR2 in Linux ?
4. Do I need to pre-create all the same tablespaces first in oracle 10gR2 in Linux ?
Is it correct ? or I can migrate straight all schemas/users from oracle 10gR2 in Windows to oracle 11gR2 in Linux using impdp ?
ORACLE DBA
EXPERTS
�I can install multiple versions of Oracle databases 10GR2 and 11GR2 in a single node using a unique Oracle ASM single instance?
My comp is running with RAC 11gR2 with ASM on external redundancy. we are planning to move on normal redundancy.
which will be better normal redundancy or external redundancy.
I wish to install 11g r1 RAC on my laptop having linux 4 as platform (on vmware) , for that i prepare 4 partition for that (on node1)
/dev/sdb1 - for ocr
/dev/sdb2 - for voting disk
/dev/sdb3 - for asmdisk group
/dev/sda5 - fro asmdisk group
by assuming external redundancy for ocr and voting disk i kept only one disk
and i configured following in /etc/sysconfig/rawdevices
/dev/raw/raw1 /dev/sdb1 -- ocr
/dev/raw/raw2 /dev/sdb2 -- voting disk
/dev/raw/raw3 /dev/sdb3 -- asmdisk group
/dev/raw/raw4 /dev/sdb5 -- asmdisk group
and my question is how node2 can understat these raw device as shared storage?
I am trying to apply 11.2.0.2.5 psu on a 2-node cluster running on RHEL 5.5 vms. Followed ORACLE-BASE examples when installed this laptop RAC. I am not using any ACFS and none of GI and DB homes are shared. But, on node 2, cluvfy THINKS database home is shared.
[oracle@rac1 trace]$ /oracle_grid/product/11.2.0.2/bin/cluvfy comp ssa -t software -s /oracle/product/11.2.0.2/db_1 -n rac1,rac2 -display_status
Verifying shared storage accessibility
Checking shared storage accessibility...
"/oracle/product/11.2.0.2/db_1" is not shared
Shared storage check failed on nodes "rac2,rac1"
Verification of shared storage accessibility was unsuccessful on all the specified nodes.
NODE_STATUS::rac2:VFAIL
NODE_STATUS::rac1:VFAIL
OVERALL_STATUS::VFAIL
[oracle@rac1 trace]$ /oracle_grid/product/11.2.0.2/bin/cluvfy comp ssa -t software -s /oracle_grid/product/11.2.0.2 -n rac1,rac2 -display_status
Verifying shared storage accessibility
Checking shared storage accessibility...
"/oracle_grid/product/11.2.0.2" is not shared
Shared storage check failed on nodes "rac2,rac1"
Verification of shared storage accessibility was unsuccessful on all the specified nodes.
NODE_STATUS::rac2:VFAIL
NODE_STATUS::rac1:VFAIL
OVERALL_STATUS::VFAIL
[oracle@rac1 trace]$ hostname
rac1
[oracle@rac1 trace]$ echo $ORACLE_HOSTNAME
rac1
[oracle@rac1 trace]$
##################################################################################
[oracle@rac2 trace]$ /oracle_grid/product/11.2.0.2/bin/cluvfy comp ssa -t software -s /oracle/product/11.2.0.2/db_1 -n rac1,rac2 -display_status
Verifying shared storage accessibility
Checking shared storage accessibility...
"/oracle/product/11.2.0.2/db_1" is shared
Shared storage check was successful on nodes "rac2,rac1"
Verification of shared storage accessibility was successful.
NODE_STATUS::rac2:SUCC
NODE_STATUS::rac1:SUCC
OVERALL_STATUS::SUCC
[oracle@rac2 trace]$ /oracle_grid/product/11.2.0.2/bin/cluvfy comp ssa -t software -s /oracle_grid/product/11.2.0.2/ -n rac1,rac2 -display_status
Verifying shared storage accessibility
Checking shared storage accessibility...
"/oracle_grid/product/11.2.0.2/" is not shared
Shared storage check failed on nodes "rac2,rac1"
Verification of shared storage accessibility was unsuccessful on all the specified nodes.
NODE_STATUS::rac2:VFAIL
NODE_STATUS::rac1:VFAIL
OVERALL_STATUS::VFAIL
[oracle@rac2 trace]$ hostname
rac2
[oracle@rac2 trace]$ echo $ORACLE_HOSTNAME
rac2
[oracle@rac2 trace]$
I can not determine any reasons and do not know how to fix.
I'm trying to install Oracle 11gR2 RAC on AIX, do we need to turn on Multicasting, can we install without multicasting? Also can I have the ASM disk with external redundancy for OCR and Voting Disk?
View 3 Replies View RelatedI am installing 11gr2 11.2.0.2 grid infrastructure software. while running root.sh on node1 it got failed.
Start of resource "ora.crsd" failed
CRS-2672: Attempting to start 'ora.crsd' on 'rac1'
CRS-5017: The resource action "ora.crsd start" encountered the following error:
Start action for daemon aborted
CRS-2674: Start of 'ora.crsd' on 'rac1' failed
CRS-2679: Attempting to clean 'ora.crsd' on 'rac1'
CRS-2681: Clean of 'ora.crsd' on 'rac1' succeeded
CRS-4000: Command Start failed, or completed with errors.
Clusterware exclusive mode start of Clusterware Ready Services failed at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 6475.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
I have 2 node 11gR2 RAC running on AIX 6.1, after I shutdown the database and restart crs using crsctl start crs, ASM instance comes back up but not the database and I had to start the database using srvctl, isn't that the database should come up when I start the crs?
View 4 Replies View RelatedAny experience before on Oracle 11gr2 RAC to RAC via EMC SRDF setup?
View 5 Replies View RelatedI am having 2 data centers within 1/2 km distance. And we kept each vote disk in once site. In case of site failure, the cluster needs a 3rd set. We don't have 3rd site.
Last open world, Oracle announced that oracle storage on cloud as announced. If I get the small space on the cloud, can i put my 3rd vote disk on the cloud?
I am looking for different cheap storage options to build test RAC setup for DB on Linux@Dell PowerEdge T100 .
View 1 Replies View Relatedwe don't have system or storage admin available..I have to create the development environment. I have 2 Dell 2950 Power Edgde Servers and 500 GB Buffalo NAS with Windows 2K3 X64 EE, tell me whether I can install Oracle RAC with this kit.
If yes , how can I configure shared storage and present it to OS so that both nodes can see it.
We have the following scenario that we need to replicate:
Our current systems are on oracle RAC+ASM with 2 nodes, they are on physical hardware.We would like to replicate from physical to VM, storage is DELL compellent.
Can this be done online without RMAN at SAN level replication? how to replicate the systems.
Here are the cards I've been dealt:
I've inherited a 10.2.0.1.0 instance running on a windows 2003 box; running fine, no problems other than system has been in production since 2005 and has gotten pretty old and tired. This old box has one tablespace on it... called "gateway".
I've installed 11.2.0.1 on a new (Windows 2008 R2 Enterprise 64-bit) server and created an empty database also called "gateway".
Now to move the data and views, objects, everything.
I've read up on a variety of migration techniques (oops, I mean "upgradation" LOL) and can follow the steps...
In short, I want to pull everything off of server a (10.2) and put it into production on server b (11.2). There seems to be quit a few options.
1. install 10.2 on my NEW server (server b), move the data over and get everything running, then install 11.2 and have it upgrade the database as part of the installation process.
2. drop the empty tablespace on server b, stop the database on server a, copy the files over from the old to the new home, run DBUA or set the compatibility attribute...
3. run some type of server a to server b utility that can bridge the two over the network. Some type of mirroring technique?
4. run file export scripts on server a, copy files to server b and run various import scripts
I tend to think that option 3 would be the best because both instances are in great health and are running right now. Is there a mechanism that allows the 11.2 instance to see and upgrade from a different server?
Yesterday I was installing 11.2.0.2 patch to our Oracle 11gR2(11.2.0.1.0) Two node RAC cluster on OEL 5.4 x86 Linux.Before installing I have read [URL] support note which says "Note: All Oracle Grid Infrastructure patch set upgrades must be out-of-place upgrades, in which you install the patch set into a new Grid home. In-place patch set upgrades are not supported. "
During Installation I found following Installation Option :
1) Install and configure Oracle grid Infrastructure for a cluster
2) Configure Oracle Grid Infrastructure for a Standalone Server
3) Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management
4) Install Oracle Grid Infrastructure Software Only
Which option should I have to choose here ?
Im planning to upgrade oracle10g to 11gr2.. i have query on that ..
my 10g having ORACLE_HOME=/app/ora/10.2.0, orainventory =/app/ora/oraInventory
new 11g ORACLE_HOME=/app/ora/11.2.0 .orainventory =?
my question is where i need to set ora inventory location for my new 11g? or it will create new location for that?
OS version : IBM AIX
After upgrading db from 10 g to 11g ,unable to take rman backup.catlog also upgraded.SCAN listsner alos running
ps -ef |grep tns
oracle 13235 13215 0 13:23:55 pts/3 0:00 grep tns
oracle 2968 1 0 Dec 2 ? 0:47 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit
oracle 2997 1 0 Dec 2 ? 0:51 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit
oracle 19844 1 0 Dec 3 ? 0:30 /orahome_new/oracle/product/11.2.0/bin/tnslsnr LISTENER_DB -inherit
[code]....
We have imported 8i DMP file into 11gR2 successfully by IMP command.
Afterthat, we give EXP command for backup in 11gR2, but it shows some error like NCHAR character data type...
i.e. IMP works fine while upgrading 8i DMP in 11gR2, but then EXP shows error in 11gR2.
I have some confusions regarding to 11gR2 RAC installation:
- Is Grid Infrastructure only the solution to install Clusterware Application 11gR2? My requirement is to install only the Cluster ware Software for 11gR2 (For 11gR1 we have "linux.x64_11gR1_clusterware.zip") using ocfs2 file system, Archive Mode not enabled.