Server Administration :: Upgrade Oracle 11.2.0.1 To 11.2.0.2
May 2, 2012
Currently, We are running oracle 11.2.0.1 on Linux server. There are 32 DB instances on this server. As per requirement, we need to install 11.2.0.2 DB on the same server. Is it advisable to have both 11.2.0.1 and 11.2.0.2 databases on the same server with different ORACLE_HOME.
How about ORACLE_BASE?? OR, do we need to upgrade all the DB's from 11.2.0.1 to 11.2.0.2. During the upgrade process, if i need to take backup with exp/imp utility, what is the best way to take 32 DB's backups instead of taking each DB backup at a time?
View 2 Replies
ADVERTISEMENT
Dec 28, 2012
I have been trying to upgrade my personal laptop with 11G from 10G. Since I didn't had any important data, so i removed 10G and tried to go for a fresh install of 11G.
Below are the entries of my files:
Listener.ora
# listener.ora Network Configuration File: C:appNikproduct11.2.0dbhome_1NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL.WORLD)
(ORACLE_HOME = C:appNikproduct11.2.0dbhome_1)
[code]........
If i start the database in no mount it doesn't give any error. Once I try to mount it, it gives the following error:
SQL> alter database mount
2 ;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> show parameter control;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string C:APPNIKPRODUCT11.2.0DBHO
ME_1DATABASEORA_CONTROL1.CTL
, C:APPNIKPRODUCT11.2.0DB
HOME_1DATABASEORA_CONTROL2.C
TL
control_management_pack_access string DIAGNOSTIC+TUNING
View 11 Replies
View Related
Nov 8, 2010
steps required to upgrade oracle db from 11.1.0.6 to 11.2.0.1.
Is it a single step or i need to patch it to 11.1.0.7 then upgrade it using dbua to 11.2.0.1?
View 1 Replies
View Related
Feb 23, 2010
Currently installed 8.1.7.0 .i want to upgrade to 10.2.0.1.0 in the upgrade documentation its written the direct upgrade is not supported for 8.1.7.0, first update to 8.1.7.4 and then direct upgrade to 10.x.
unable to find 8.1.7.4 update.any link to find update or guideline to direct upgrade to 10.x.
View 7 Replies
View Related
Jun 15, 2010
We have production environment running on oracle 9i database. we are planning to upgrade it to 10g. I have reviewed many documents and blogs but still have few concerns. Pls provide me complete steps to upgrade our 9i db to 10g.
1. For 9i to 10g upgrade we need to install oracle 10g with different oracle_home and then launch dbua and upgrade 9i?
2. will new installed 10g home will read 9i home when dbua launched?
3. Is there any upgrade installer available to upgrade to 10g like patchset upgrade installer?
View 7 Replies
View Related
Nov 25, 2011
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
View 3 Replies
View Related
Jun 24, 2010
I have upgraded my database from 10.2.0.4 to 10.2.0.5. however while upgrading database using DBUA I am getting this error.table or view does not exist ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579 ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596 ORA-06512: at line 1The WMSYS.OWM_MIG_PKG is warped package and I can't understand what it means. How can I understand what view or table is absent in my database?
View 6 Replies
View Related
Apr 27, 2011
I want to upgrade my Oracle version from 10.2.0.1.0 to 10.2.0.4.0 but but i don't know what are the correct ways. i read the read me file in the patch set and fallowed the steps but its giving me error e.g. "Error in writing to file D:Oracleproduct10.2.0.2.0inoraevrus10.dll" every time. We have no RAC and Cluster Environment.
View 10 Replies
View Related
Sep 21, 2011
I am trying to upgrade the oracle 9.2.0.8 database in oracle 11.2.0.2. I have installed the new oracle home for 11g and after running the pre-upgrade script and setting the all environment variable like oracle base, oracle home, oracle sid and ora_nls
i am running the dbua but after click on finish button it's do the processing of 2% but after that i get
-------------------------------------------------
ORA-12709 error while loading create
database character set
--------------------------------------------------
View 11 Replies
View Related
Mar 10, 2011
I am looking to migrate and upgrade an Oracle 9i database to 10g.
Would there be any fallout if the characterset were changed from US7ASCII to UTF8?
View 2 Replies
View Related
Feb 8, 2012
what jobs will be created when we upgrade to oracle 11.1 version ?
View 4 Replies
View Related
Feb 4, 2012
Can I directly upgrade Oracle 9.2.0.1.0 From RHEL-4 platform to Oracle 11g Rel 2 on RHEL -5 platform?I have the export dump and cold backup of Oracle 9.2.0.1.0 database.
View 11 Replies
View Related
Apr 25, 2011
I have installed 11g ,i.e 11.0.6 then applied the 11.0.7 patch after that , when i tried to open the db in upgrade getting the error like
$ sqlplus '/as sysdba'
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Apr 26 02:56:43 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
[code]...
View 3 Replies
View Related
Feb 23, 2010
We are using Oracle standard edition 10.2.0.2 on Solaris x86-64 platform, and I'm trying to estimate reasonability of movement to 10.2.0.4.A disadvantage I see is according to 10.2.0.2 "Availability and Known Issues" amount of "issues introduced" is about 10, but in 10.2.0.4 there are 63 "issues introduced", according to similar document. I suspect that some of bugs can be eliminated by applying 10.2.0.4.3 patchset, but I'm not sure that all of them will be eliminated. A benefit of 10.2.0.4 (and especially 10.2.0.4.3) is presence of all necessary critical patches (up to Jan2010).
View 4 Replies
View Related
Nov 22, 2011
i want to upgrade my database version is 10.2.0.1.0 to 10.2.0.4.0 steps and patch information on windows
View -1 Replies
View Related
Apr 22, 2010
i m planning upgrade my server from 10.2.0.1 to 11.2...we have license for oracle 10g standard edition.
tell me the procedure from licensing point.
View 2 Replies
View Related
Oct 27, 2011
We plan on using our current enterprise application, which is using 10.2.0.5.0 on the backend, until the end of 2012. Then we're going to switch over to a whole new system.
Our vendor is telling us that Oracle will stop issuing security patches and bug fixes for Oracle 10g at the end of 2011. Should we upgrade to 11g? If we do not upgrade to 11g, then we would be on 10g for about one year without these security patches and bug fixes. Should this be a concern?
View 3 Replies
View Related
Nov 11, 2011
I'm planning on upgrading our 10.2.0.4 database to 11.2.0.1 on the same server. Would like to hear the best efficient method to do so from the experts.. My first option is to use datapump method, so I can take a backup and uninstall 10g on the server, Install 11g and import the data. But as I was reading through the documents on the upgrade, I think it is best to use DBUA instead. I'm planning to follow this document to upgrade using DBUA. [URL]
Few doubts on this..
1. Since I will be upgrading the existing 10g database, I suppose I need not uninstall 10g prior to the upgrade. I read that DBUA will shutdown the database during the upgrade. Currently we have Oracle 10g software in c:oracleproduct10.2.0db_1 and the data files are in different disk drives and also in c:oracleoradata folder. So will DBUA move the physical datafiles to the new location?
2. Do I need to stop 10g listener prior to running DBUA?
3. Will I be able to uninstall 10g after the upgrade?
View 5 Replies
View Related
Jul 21, 2011
We have a 9.2.0.5 1.09TB Database running on windows 2000 Advanced server(32Bit) and we want to go to Windows 2008R2(64bit)on 11gR2(64bit).
View 3 Replies
View Related
Apr 28, 2012
Point for upgrading my 10G to 11G. It is a standalone DB on windows 2003. I have already install the 11G software on a different oracle_home. I need know to re-direct my datafiles to the new oracle_home.
View 1 Replies
View Related
Sep 17, 2010
Oracle has changed the way to upgrade the software, i'm completely lost and angry i used to be able to just download the patch and install however the new patch that came out on the 13th of September is completely different, I just want to upgrade the current version of 11.2.0.1 to 11.2.2.0 somehow the software i got wont let me keeps saying the "software is on version 10.2.1. need to upgrade" how to upgrade to that? these are the files I have after the unzip of all 7 downloads
drwxr-xr-x 8 oracle oinstall 4096 Sep 7 01:10 database
drwxr-xr-x 8 oracle oinstall 4096 Sep 7 01:12 grid
drwxr-xr-x 6 oracle oinstall 4096 Sep 7 01:16 examples
drwxr-xr-x 6 oracle oinstall 4096 Sep 7 01:17 client
drwxr-xr-x 7 oracle oinstall 4096 Sep 7 01:19 gateways
drwxr-xr-x 20 oracle oinstall 4096 Sep 17 15:50 deinstall
[code]....
View 2 Replies
View Related
Dec 15, 2012
I tried updating the oracle database from version 11.2.0.1 to 11.2.0.3 but I have no clear procedure. I chose the option of the installer "upgrade database" and install the software on a new home. To migrate, must be all oracle services stopped? In the migration phase, it is normal to ask me listener data, etc .... or installer now detects the same database?
View 1 Replies
View Related
Aug 28, 2011
I tried to upgrade oracle 10.2.0.4 to 11.2.0.2 on the Solaris 10 server, but after 40 minutes it hangs bei oracle XML Database.
View 5 Replies
View Related
Feb 12, 2012
We are going to upgrade our production database from Oracle10g Standard ED to Oracle10G EE.
View 5 Replies
View Related
Mar 22, 2011
I have upgraded a 9i db to 10g on another server using rman backup (9.2.0.8.0 on linux to 10.2.0.4.0 on Linux)
I copied the hot backup - rman from 9i db server to 10g db server
Then I restores the rman backup on the 10g db server opened the database with
alter database open restlogs upgrade;
@?/rdbms/admin/catupgrd.sql
shutdown immediate;
startup restrict
@?/rdbms/admin/utlrp.sql
Now I have all components in VALID state but the db server itself in INVALID state as can be seen from results below
SQL> select comp_name, status, version from dba_registry;
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
Oracle Database Catalog Views
VALID 10.2.0.4.0
Oracle Database Packages and Types
VALID 10.2.0.4.0
SQL> @?/rdbms/admin/utlu102s.sql TEXT
.
Oracle Database 10.2 Upgrade Status Utility 03-22-2011 10:35:20
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:06:59
.
Total Upgrade Time: 00:07:05
PL/SQL procedure successfully completed.
SQL>
Has the upgrade failed?
Note that
OS for 9i db server is
Linux 2.6.9-42.EL #1 x86_64 x86_64 x86_64 GNU/Linux
OS for 10g db server is
Linux 2.6.18-53.el5 #1 x86_64 x86_64 x86_64 GNU/Linux
View 4 Replies
View Related
May 23, 2012
i want to upgrade my 10g(10.2.0.1.0) 64bit database to 11i. how can perform it. os windows xp.
View 1 Replies
View Related
Apr 23, 2012
where I can download patchset to upgrade my database from 10.2.0.3 to 10.2.0.5?
View 1 Replies
View Related
Oct 1, 2010
I am testing upgrade from 11.1.0.6 to 11.2.0.2 patchset on linux X86-64 version. And facing the following component related issue.
The following components cannot be upgraded as the corresponding upgrade scripts are missing:
OLAP Analytic Workspace ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/apsdbmig.sql )
OLAP Catalog ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/amddbmig.sql )
Spatial ( /u01/app/oracle/product/11.2.0/dbhome_3/md/admin/sdodbmig.sql )
Oracle OLAP API ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/xoqdbmig.sql )
If you want to upgrade these components, you must first install them, using the OUI, and then re-run the Upgrade Assistant. Do you want to continue with upgrade? Note: If you continue, the above components will not be considered as part of the upgrade process.*
Following is the status of the specified components from 11.1.0.6
COMP_ID COMP_NAME VERSION STATUS
AMD OLAP Catalog 11.1.0.6.0 VALID
SDO Spatial 11.1.0.6.0 VALID
APS OLAP Analytic Workspace 11.1.0.6.0 VALID
Should I install these components while installing 11.2.0.2 patchset prior upgrading? I was unable to find any component installation on OUI.
Also DBUA pre-upgrade asked to remove existing UltraSearch from 11.1.0.6 prior upgrading. Though I removed it, but not sure is that going to hamper the upgraded DB, as I'm not sure of the usage of this component as well.
View 7 Replies
View Related
Sep 16, 2013
We have a 9208 Prod Database running out of 9i binaries in a HP UX Machine.We want to upgrade it to 102030.We tried upgrading it once and we failed .Oracle came back saying we need to apply a binary patch on the 10g Oracle Home as the error we faced is a bug.This is HP UX machine and there are no 10g databases running here.
.Management has asked to do a test run so that upgrade does not fail again.Unfortunately we do not have an identical test env in this case to test the binary patch.
Here is how we planned.
1)We make a copy of the existing 9208 Database in the same machine as a new SID i.e Clone to a new SID and make it up and running.
2)We apply the binary patch on the 10203.
3)Attempt the upgrade .If it goes fine we are good.
4)If the upgrade does not go fine and brings up new surprises(Say Oracle come back and says another patch is required),Will we have already done irreversible damage to our 10g binaries ?
Is there a good way to revert back the upgrade ? Will the inventory be corrupt?
Is there a way to get back to old binaries if the applied patch did not work or if Oracle says to apply new patch.? Finally will all the above create an issue to the existing 9i Database?
View 5 Replies
View Related
Sep 28, 2012
how to upgrade Oracle SERVER jvm version
View 2 Replies
View Related
