Upgrade :: Upgrade Patch For Enterprise Versus Standard 11.2.0.1
Sep 22, 2012is the upgrade patch the same for standard edition and enterprise edition or there are two separate patches?
View 5 Replies
ADVERTISEMENT
Server Administration :: Upgrade From 10G Standard ED To EE ED
Feb 12, 2012We are going to upgrade our production database from Oracle10g Standard ED to Oracle10G EE.
View 5 Replies View RelatedUpgrade :: Applying Patch Set Update 11.2.0.3.7 On 11.2.0.3.0
Aug 18, 2013Database = 11.2.0.3.0
Operating System : Solaris 11 sparc 64.
applying PSU patch : 16619892
I am trying to apply patch 16619892 on 11.2.0.3.0 to upgrade it to 11.2.0.3.7.
I hope this is a straight forword stuff i beleive, but i am getting the following errors and log details.
$ cd /noracle/patch/16619892/
xxxx@xxxx$ /noracle/home/oracle/product/11.2.0.3/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
[Code].....
Data Guard :: Upgrade To 11.2.0.3 By Installing Patch
Dec 6, 2012I have Data guard configured with a primary database and a standby database. I have installed oracle 11.2.0.1 in both servers, and I want to upgrade to 11.2.0.3 by installing the patch. I know how to install the patch in the primary. Should I follow the same procedure also on the standby or it is different?
View 5 Replies View RelatedUpgrade :: Oracle 8.1.7.4 (Patch 2376472) From Meta-link?
Aug 22, 2012I am trying to upgrade my database approx 20GB size from 8.1.7.2.1 to 8.1.7.4 runningon windows NT 32bit server.I found that we can download from metalink.oracle.comIs that any cost involved in downloading and installing or is it provided freely by Oracle.
View 7 Replies View RelatedUpgrade :: Cross Platform Upgrade From Single Instance To RAC
Jun 26, 2013I'm planning to upgrade a small database (~150GB) from 10.2.0.3 on windows 2003 23bit to 11.2.0.3 RAC on Linux 5.8.The database contains oracle spatial too. A suitable method and link to document to be followed.
View 2 Replies View RelatedUpgrade :: ORA-00904 / OBJ$EDITION / Invalid Identifier After Upgrade To 11.2.0.3
Nov 19, 2012I recently performed an upgrade on a new server from oracle 10gr2 to oracle 11gr2 (11.2.0.3).
I take the rman backup from oracle 10g server and restore it on new server where I installed oracle 11gr2.
But on my previous oracle 10gr2 server I enabled the auditing. After doing successful upgrade now when I try to login with any user except sys I receive the following error:
SQL> conn scott/tiger
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
I got the workaround by setting the parameter audit_trail=FALSE (Previous value was DB_EXTENDED) .But I want my auditing to be enabled as per y requirements.
Enterprise Manager :: OEM 10g To 12c (2 System Upgrade Process)
Aug 6, 2013I am not a DBA but I got assigned to support OEM at the company I work for and was sent to the OEM 12c install and upgrade class provided by Oracle. As with every class things work as designed in a classroom environment but not in the real world.
Following the same procedure I did in class I started working on the 10g to 12c 2 system upgrade. Everything went well until I reached the step to copy the existing database to the new server. The steps say to use DBCA in the existing 10g database and create database template with data. That work perfectly and it created a template about 10 gigs in size.
THe next steps the in the procedure calls for me to copy the template files to the new server 11g and use DBCA and create database using the template I created in the previous step. When DBCA gets to about 40% progress is fails with the errors below:
ORA-01092, ORA-00704 and ORA-39700.
See attached screenshot.
My environment
Source
OEM 10g 10.2.0.5.0
DB 10g 10.2.0.3.0
Target
OEM 12c
DB 11g 11.2.0.1.0
Upgrade :: Reference Note IDs For Database Upgrade From 11.2.0.2. To 11.2.0.3.2
Oct 22, 2012find reference note IDs for DB upgrade from 11.2.0.2 to 11.2.0.3.2, as I am finding only Exadata which I don't want but I want to find for Ebiz database, on OS - Solaris 10 9/10 s10s_u9wos_14a SPARC.
View 1 Replies View RelatedUpgrade :: Oracle 11.2.0.3.0 Database Upgrade Changes DATA_PUMP_DIR
Jun 6, 2012Along with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.Of the DB's we have upgraded the Data Pump Directory
Select * from dba_directories; (there are other commands to get this info as well).
I captured screens from the DBUA upgrades, but did not see an option to change this information.Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?
Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.
Upgrade :: SYS Table Very Slow After 11g Database Upgrade?
Nov 7, 2012All my sys tables are very slow after my database upgrade from 10.2.0.4 to 11.2.0.3 on AIX 6.1
For example
select * from ALL_TAB_COLUMNS; -- taking 19 seconds in 11.2.0.3 and few millisec in 10.2.0.4
I have deleted and updated fixed and dictionary table statistics , till I facing this issue
Upgrade :: Patchset Number To Upgrade Oracle
Jun 14, 2012Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?
View 1 Replies View RelatedEnterprise Manager :: Upgrade 11g Grid Control To 12c Cloud?
May 29, 2013Now we have 11G grid control on linux x86_64 server and we are planning to upgrade this to 12c Cloud control,
What are the available options,
1) upgrade from 11g to 12c on the same server.
2) Build another linux server and install 12cloud.
which ever is easy to have 12c upgrade. oracle recommended url's to follow the installation.
Upgrade :: Oracle Upgrade 11.1.0.7 To 11.2.0.3 - Compatible
Jul 19, 2013I am going to upgrade database from 11.1.0.7 to 11.2.0.3
1) If compatible is set to 10.2.0 in 11.2.0.3, will it work ?
2) If compatible set to maximum level, will it affect our application ?
3) Whether any code related problem occurred after upgrading like PL/SQL codes ?
Upgrade :: Oracle Database Upgrade
Mar 13, 2013We are planning to upgrade our database from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi to Oracle Standard Edition 11g . We also have oracle apex installed on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi database with oracle apex 3.1
No our plan to upgrade the database and oracle apex to 4.2. Since Oracle Enterprise Edition is licensing is very expensive we though of buying standard edition and upgrade to this version.
can we upgrade the oracle database from enterprise edition to latest standard edition?
Upgrade :: Database Upgrade From 9.2.0 To 11gr2
Aug 6, 2012Iam 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
Upgrade :: Compatible Parameter During Upgrade
May 21, 2013Why COMPATIBLE Parameter is important to be at a certain value before you UPGRADE(10.2.0.4 to 11.2.0.3) to 11g ?
View 2 Replies View RelatedUpgrade :: Upgrade 11.2.0.2 To 11.2.0.3 On Linux Environment?
Mar 23, 2013I try to upgrade 11.2.0.2 to 11.2.0.3 on Linux environment. I have to apply patch P1253900 before the upgrade per oracle doc.
however I got following conflict:
Verifying environment and performing prerequisite checks...
Checking skip_duplicate
Checking skip_subset
Conflicts/Supersets for each patch are:
Patch : 12539000
Conflict with 12827726
Conflict details:
/u01/app/grid/product/11.2.0/grid/lib/libserver11.a:/ksxp.o
Following patches have conflicts: [ 12827726 12539000 ] Refer to My Oracle Support Note 1299688.1 for instructions on resolving patch conflicts.
I checked above oracle note, and did not say any resolution.
Upgrade :: 10.2.0.1 To 10.2.0.4 Upgrade 32bit
Jun 24, 2012I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in lunux 32 bit . I faced the version incompatibilty error during patchset installation and hence ran the patchset installation with -ignoresysprereqs option.Now during the patchset installation i encountered the below error in in the install logfile.
INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:
INFO: /u01/app/oracle/product/10.2.0/bin/genclntsh
INFO: genclntsh: genclntsh: Could not locate /u01/app/oracle/product/10.2.0/network/admin/shrept.lst
[code]....
Need certified os and versions for oracle db 10gr2
Upgrade :: Database Upgrade From 11.2.0.1 To 11.2.0.3
Jan 2, 2013After many tries of upgrade'ing oracle I decided to make backup of my database and then remove 11.2.0.1 and install 11.2.0.3 to recover db. Unfortunately I am not sure how should I perform restoration.I backed up data by calling RMAN> backup database include current controlfile;
After that I moved files from fast_recovery_area and cleared my machine from current oracle release.I also did a copy of directories:
ORACLE_HOMEdbs
ORACLE_HOME
etworkadmin
ORACLE_HOMEowbinadmin
ORACLE_HOMEhostname_dbname
ORACLE_HOMEoc4jj2eeOC4J_DBConsole_hostname_dbname
Upgrade :: Migration / Upgrade 10g / R2 To 11g / 2
Jul 6, 2012I am looking for for exact steps for migration. The important question ist:
-- If we migrate from 10g to 11g, do we need addition (more) CPU's as currently we have?
-- Do wee need more powerful HW.
Upgrade :: Oracle 10g To 11g Upgrade
Feb 21, 2013I am trying to come up with a plan for an upgrade that is needed for a server I maintain. It is a Windows 2003 32bit running Oracle 10.2.0.3 on old Hardware. It also has two obscure 3rd party applications that are running on it that directly access the database. These applications are supported by off site consultants.
My initial plan was to Create a Windows 2008 R2 Virtual Server and install the same version of Oracle 10.2.0.3. Using Rman clone the database to the new server. Have the consultants come in and get the applications working. Once everything in the new environment seems to be working fine, run RMAN again and reclone the database to have all the latest data. Then at a later time upgrade the database to 11g 32bit. Virtually no downtime and we could spend all the time we needed getting the applications working and testing the new environment.
The plan is dead right of the bat though because I realize 10.2.0.3 is not supported by Windows 2008 R2. I really did not want to add an Oracle DB upgrade into the mix at the same time. Just because their are so many changes from the old environment to the new that I want to break this down into manageable chunks. And I can maybe get by with 1 day of down time.
So now I am looking at installing 11g on my Virtual Server, Clone the database, upgrade the database, have the consultants come in and get the applications working. All the while we are down. If we run into any problems, which you always do, it just completely blows the schedule.
Upgrade :: Oracle Upgrade 10.2.0.5 Non-ASM 11.2.0.3 ASM?
Jun 29, 2012I need to upgrade our current system 10.2.0.5 (non Asm) to 11.2.0.3(ASM) on the same host.
So a few options : install ASM on current 10.2.0.5, create volumes etc and shift DB into ASM
upgrade to 11.2.0.3 GI - standalone
upgrade DB to 11.2.0.3
install 11.2.0.3 GI, configure ASM and run against 10.2.0.5
DB upgrade DB to 11.2.0.3
The DB upgrade has to come last I've been told.
Patch And Non-Standard Block Size
Apr 14, 20131) When might one choose non-standard block sizes?
2) Why do we need to apply patch? Just to fix bugs?
Performance Tuning :: How Does Standard Versus Advanced Handle Index Compression
Aug 18, 2010How does standard vs advanced handle index compression? Is there an advantage to having one vs the other besides the incurred cost?
View 3 Replies View RelatedMove From Standard To Enterprise 11g
Mar 9, 2012i want to move from 11g Standard to 11g Enterprise (same Version) on Windows.
View 2 Replies View RelatedEnterprise To Standard Edition
Sep 12, 2012Recently we have downgraded our database from enterprise to standard edition.....our sga size before downgrade was 11 gb and now it is 11gb and there is no as such problem in database..I have read somewhere that standard edition doesn't support sga size more than 2 gb .
View 1 Replies View RelatedRMAN Restore In Standard From Enterprise
Jul 30, 2012i can do a rman restore from 9i Enterprise to 9i Standard?
View 2 Replies View RelatedDowngrade From Enterprise Edition To Standard
Feb 10, 2011I am checking out licenses. We all know that EE is much more expensive than SE. But many customers do have EE installed - unsure if they need all the features at all. After several years of production, a downgrade is considered 'risky' and we continue to pay the full EE.
How can we check and be sure that a downgrade to SE would not be any problem?
Some checks include:
* partitioning used in user schemas? --> no downgrade to EE
* bitmap indexes in user schemas? --> no downgrade to EE
How can we complete this list, or is there some script to make this easy?
Database Control Versus Enterprise Manager
Mar 11, 2012I always thought that Database control and Enterprise manager was synonyms...But I am reading a mock about OCA exam and there it said:
QUOTE You just can apply the pacth binaries using the Database Control and with the oPatch utility, but not with the Enterprise Manager...
But to me Database Control and Enterprise Manager are the same thing...
Are there difference between them?