Database Upgrade From 9.2.0.8 To 10gR2
Oct 26, 2012Why is knowing the backup policy important before starting any upgrade.
View 17 Replies
ADVERTISEMENT
RAC & Failsafe :: Upgrade Database With ASM Storage From 10gR2 To 11gR2?
Mar 7, 2011I 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 .
Upgrade :: From Linux 32bit To 64bit - 10gR2 Database?
Dec 26, 2012I 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).
Upgrade :: 10gR2 Single Instance To 11gR2 RAC?
Aug 3, 2012upgrading 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 RelatedUpgrade :: 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 :: 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
PL/SQL :: Creating PSP Reports In Oracle Database 10gr2?
Feb 6, 2013I want to create the .psp(pl/sql ser pages) reports in the oracle database 10gr2.but i am unable to do it why because it needs http server(knew by going through some of the oracle docs but not able to understand) where i find this first of all details configuration needed for the .psp files.
View 8 Replies View RelatedOracle 10gR2 - OEM Database Control Configured For DBs
Jul 24, 2013I have multiple oracle (10gR2) databases running on a linux (5.8) server. How can I check that for which of the databases has the OEM Database Control been configured and on what port is it listening?
View 7 Replies View RelatedOracle Database Migration From 9iR2 / 10gR2 To 11gR2
Apr 22, 2013Which 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
Server Administration :: Installed 10gr2 And Implemented 3GB - Database Hang?
Jan 26, 2010My server RAM is 12GB. i installed 10gr2 and implemented /3GB also. Eventhough my database is giving problem.
View 20 Replies View RelatedRAC/ASM Clusterware Installation :: OEM Grid Control Files For Oracle Database 10gR2
Jan 22, 2013I am trying to setup my environment to prepare for hands on DBA exercises from an OCM handbook for 10g -OCM:Oracle Database 10g Administrator Certified Master Exam Guide
I need access to the following files
gc_10205_part1of2.zip, gc_10205_part2of2.zip for 32 bit linux
Apparently the above along with other Grid software was once attainable from the link below but sometime between this year and the last Oracle decided to remove this and other software from public access. URL.....
I doubt Oracle will hear my plea - educational purposes only - so given I want access to the software only.
Client Tools :: Oracle 10gR2 Database Server - Unable To Use Isqlplus?
Apr 11, 2007I have installed Oracle 10gR2 database server recently in the Windows box. The database works fine. But I am unable to connect through the Internet Explorer. I found that the service for the isqlplus is not available. Do I need to run any script for creating the service?
View 12 Replies View RelatedUpgrade :: 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 Database From 11.2.0.2 To 11.2.0.3?
May 14, 2012i have upgraded the Database from 11.2.0.2 to 11.2.0.3 , after that while i was accessing the D.B i am getting this error.
ORA-00020: maximum number of processes (600) exceeded
after that i have modifed number of process and made it to 1200.
but then i got the same issue
ORA-00020: maximum number of processes (1200) exceeded
is it any Bug or the upgradation went wrong. Is there any change in the primary and foreign keys before and after the upgrade...
Difference Between Database Or SID Upgrade
Oct 19, 2012i want to know is there any difference between upgradation of SID and database. while upgrading my database from oracle 11.2.0.2 to 11.2.0.3 in DBUA it shows my SID is upgrading (ORCL) but i have few other databases ex (test and prod).
is it enough if we upgrade the SID or we must perform any other actions..
and
2nd QUERY :
i have 2 oracle homes in my server with different versions like (11.2.0.2 and 11.2.0.3)and i have few databases and there tablespaces. how to determine which database is created on which version and which database is upgraded from 11.2.0.2 to 11.2.0.3.
Upgrade :: Upgrading Database From 10.2.0.1.0 To 10.2.0.4.0
Sep 6, 2013When upgrading database from 10.2.0.1.0 to 10.2.0.4.0 , i am getting following error$
/run Installer Starting Oracle Universal Installer...Checking installer requirements...Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3 Passed All installer requirements met. Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-09-07_01-25-05AM. Please wait ... error: invalid compressed data to inflate /tmp/OraInstall2013-09-07_01 -25-05AM/oui/jlib/ewt3.jarerror: invalid compressed data to inflate /tmp/OraInstall2013-09-07_01-25-05AM/oui/gui de/htmlguide.jar
Rolling Upgrade Of CRS / ASM / DBHomes And Database From 10.2.0.4 To 10.2.0.5?
Nov 5, 2012I have an upgrade question. My customer wants to minimize downtime and so wants to do a rolling upgrade of crs, asm, dbhomes and databases from 10.2.0.4 to 10.2.0.5.
Customer wants to upgrade server1 during normal business hours- CRS/ASM/DBHOMES, then move databases from server2 to server1 and upgrade during planned downtime, then upgrade server2 during normal business hours -CRS/ASM/DBHOMES.
3 steps, taking 3 days to complete. Is this possible? I know CRS can be done in a rolling upgrade, but what about ASM?Is this doable?
Backend Database 10.2.0.3 - Upgrade Path?
Jun 6, 2012we have a very critical application running and the backend database is 10.2.0.3. we are planing on upgrading to 10g to 11.2.0.2 and looking ways to look with minimal downtime off production. steps for upgrade with very minimal downtime of appliction?
View 2 Replies View RelatedServer Administration :: Upgrade Database From 11.2.0.1 To 11.2.0.3?
Dec 15, 2012I 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 RelatedUpgrade :: Database From 9.2.0.7 To 10.2.0.2 And Leaving COMPATIBLE To 9.2.0?
Jan 11, 2013I want to upgrade our database version (9.2.0.7) to 10g (10.2.0.2)
I know if I set COMPATIBLE parameter to 10.2.0.2 at first then I can't downgrade to 9.2.0.7 if any problem occurs I am not sure that our application can deal with 10g or not so I think it's better to leave the COMPATIBLE parameter to 9.2.0 several days for sure and if all things go well then change COMPATIBLE to 10.2.0.2 (I need to say that I can’t test our application in a test environment )
Now do you think leaving COMPATIBLE to 9.2.0 (after upgrade) for many days can cause any problem to Database ?
Upgrade :: Database 32bit From 10.2.0.1 To 10.2.0.4 Version
Jun 24, 2012I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in Linux 32 bit . I faced the version incompatibility error during patch set 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
INFO: make:
INFO: *** [client_sharedlib] Error 1
INFO:
INFO: End output from spawned process.
INFO:
--------------------------------------------------------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0/network/lib/ins_net_client.mk'. See '/u01/app/oracle/oraInventory/logs/installActions2012-06-24_11-45-11AM.log' for details.
Exception Severity: 1
***********************************************
Provide me the certified os and versions for oracle db 10gr2
Expdp Slower After 11gR2 Database Upgrade?
Aug 6, 2012After 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 RelatedServer Administration :: Upgrade 10g (10.2.0.1.0) 64bit Database To 11i?
May 23, 2012i 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 RelatedRAC & Failsafe :: Upgrade Of Oracle And Standby Database In HP UX
Mar 9, 2011we 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.
Upgrade :: Database Is Not Available For Download In Oracle Downloads
Apr 2, 2013I need to upgrade database from 9.2.0.6.0 to 11.1.0.7.0 . But 11.1.0.7.0 database is not available for download in oracle downloads. How do i download 11.1.0.7.0 and bring the links for upgrading process.
View 5 Replies View RelatedUpgrade :: Migrate Database From Windows To Linux?
May 6, 2013I need to migrate database from Windows to Linux. The current size is ~50GB.
Current Env:
OS = Windows 2003
DB version = 10.2.0.3
Proposed Env:
OS = Linux
DB version = 11.2.0.2
Would using datapump be a correct choice for this migration? Also do the step below seem correct?
01. Pre-create tablespaces on target 11g database
02. Export full database of source 10g database
03. Copy dumpfile to Destination Server
04. Grant IMPORT_FULL_DATABASE system privilege to user SYSTEM of target 11g database
05. Import full database to target 11g database
Upgrade :: Upgrading The 11g Database Using Dbua Utility?
Apr 22, 2013I have installed oracle 11g R2 in windows and i ve created database of vesrion 11.2.0.1.0. I tried to upgrade the database to higher version using the dbua utility . But in this utility source & destination both is showing as 11.2.0.1.0. upgrade the database from 11.2.0.1.0 to higher version using the dbua utility
View 16 Replies View Related