Difference Between Database Or SID Upgrade
Oct 19, 2012
i 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.
View 3 Replies
ADVERTISEMENT
Oct 22, 2012
find 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 Related
Jun 6, 2012
Along 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.
View 4 Replies
View Related
Nov 7, 2012
All 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
View 5 Replies
View Related
Mar 13, 2013
We 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?
View 3 Replies
View Related
Aug 6, 2012
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
View 4 Replies
View Related
Jan 2, 2013
After 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
View 8 Replies
View Related
Jan 11, 2013
1.what is the difference between install database and create database?
2. if i have connected with remote database(server) then it is an instance again?
View 3 Replies
View Related
May 14, 2012
i 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...
View 6 Replies
View Related
Sep 6, 2013
When 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
View 8 Replies
View Related
Oct 26, 2012
Why is knowing the backup policy important before starting any upgrade.
View 17 Replies
View Related
Nov 5, 2012
I 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?
View 3 Replies
View Related
Jun 6, 2012
we 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 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
Jan 11, 2013
I 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 ?
View 3 Replies
View Related
Jun 24, 2012
I 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
View 2 Replies
View Related
Aug 6, 2012
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 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
Mar 9, 2011
we 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.
View 2 Replies
View Related
Apr 2, 2013
I 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 Related
May 6, 2013
I 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
View 6 Replies
View Related
Apr 22, 2013
I 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
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
Jul 30, 2012
When we upgraded the database from 10g to 11g, Apex upgrade failed. Due to the failure, I removed the old schema and did a fresh install of Apex 4.1. It is working but we lost the applications from previous Apex.
What is the best strategy when you need both database and Apex upgrades? We are a Linux workshop, setting up Apex in Oracle Fusion Middleware 11g environment.
View 0 Replies
View Related
Sep 13, 2012
Tell me the difference between Oracle RAC and Non RAC database including commands and architecture?
View 4 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
Mar 7, 2011
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 .
View 1 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
Apr 30, 2012
I have a primary and standby DB using data guard 10.2.0.3.I want to upgrade oracle to 11G.I know that primary and standby should have same version even if data guard will not work again.I want to know what is the steps by steps action to properly upgrade both DB : primary and Standby.
View 1 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
