Upgrade :: Database 32bit From 10.2.0.1 To 10.2.0.4 Version
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
ADVERTISEMENT
Dec 26, 2012
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).
View 2 Replies
View Related
Dec 19, 2011
i need to upgrade this version to 10.1.2.3, and i don't have an account in metalink to download the patch.
View 11 Replies
View Related
Jul 12, 2011
We are planning upgrade three 32-bit 9i databases (on three physical machines) to a single 64-bit 11g VMware box. Average size of DB is 300GB.Planning to move the first 9i DB by the end of this month, followed by 2 and 3.How to do this using hot backup?
View 6 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 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
View 2 Replies
View Related
Oct 4, 2010
I have one query regarding ORACLE 10g RAC.
I have installed 10gRAC [10.2.0.1] on VMware.
now I have requirement to upgarde it this existing RAC setup to 10.2.0.4.
options for me the steps or sequence I need to follow in upgrade path? like first needs to upgarde crs,then fro ASM and lastly for DB something like this.
View 5 Replies
View Related
Oct 15, 2010
We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.
if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.
Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.
View 3 Replies
View Related
Aug 9, 2012
I had two installations of Oracle on my server (10.2.0.4 and 11.2.0.1) under different linux users. The Databases used different listeners on different ports.
I upgraded my Oracle 11g to 11.2.0.3 successfully two weeks ago. However today I just checked that I couldnt reload my Oracle 10g Listener. On further analysis (lsnrctl status) I discovered that my 10g listener's version was "TNSLSNR for Linux: Version 11.2.0.3.0" . My Start Date from lsnrctl gives me the date when my Oracle 11g was upgraded.
Now I have tried to reload my 11g listener which works normally. I cannot reload my 10g listener (TNS-01190: The user is not authorized to execute the requested listener command). When i run ps command there is no process on my server for my 10g listener. I can only see my 11g listener process after running ps command. However everybody can ping my databases on Oracle 10g but i cannot identify or kill my listener process even on server level.
View 4 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
Jun 26, 2012
We are running Oracle Enterprise software on various client and DB servers and we are experiencing a problem (outlined here [URL] .....) where the apparent mismatch between the oracle drivers are causing the errors.
Our db servers are using 10.2.0.4 and 10.2.0.5 drivers and the clients are using 10.2.0.1.
Firstly, are the drivers the same on the Express and Enterprise editions so that if I update a development server using Express version (I don't have the authority to upgrade the Enterprise version nor the time to commission that) and it is successful, can I reasonably expect an upgrade to the Enterprise client versions on other servers to be safe/error free, baring environmental factors of course ?
Secondly, can I upgrade to version 10.2.0.5 now or do I have to go to the 11g version only ?
View 2 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
Feb 6, 2013
Mistakenly I have configure dataguard on different versions. Primary is 11.2.0.3.0 and Stand By is 11.2.0.1.0. Log shipping is perfectly working, but cannot put Stand By in read only mode.
View 3 Replies
View Related
Feb 8, 2012
what jobs will be created when we upgrade to oracle 11.1 version ?
View 4 Replies
View Related
May 28, 2012
"How to Migrate Oracle 11gR2 32bit to 11gR2 64bit on Microsoft Windows"
Currently we are having Microsoft Windows Server 2003 standard Edition service pack 2 and we are trying to migrate it to microsoft windows server 2008 Release 2 standard Edition
View 4 Replies
View Related
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
Aug 15, 2013
I have doubts on export
1.) If we have taken exp (traditional export)of schema�s on database version 10.2.0 then shall we imp(traditional export) on database version 11.2.0?
2.) If we have taken expdp of schema�s on database version 10.2.0 then shall we impdp on database version 11.2.0?
3.) If we have taken exp(traditional export) of schema�s on database version 10.2.0 then shall we impdp on database version 11.2.0?
View 6 Replies
View Related
Aug 24, 2012
Oracle 11.2.0.1 and 11.2.0.3.
Can rman refresh database from 11.2.0.1 to 11.2.0.3?
In another words, my source database is 11.2.0.1, my target database is 11.2.0.3
I want to refresh target database from source database. Is it ok since version is different?
View 6 Replies
View Related
Jun 3, 2010
I have a report of version 10g . I want to run this report in oracle reports 6i version.
View 1 Replies
View Related
Mar 30, 2012
I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?
View 4 Replies
View Related
Feb 1, 2013
What database version is supported as a repository for 10g OMS?
View 5 Replies
View Related
Jun 21, 2011
what does mean VERSION_TIME column in V$DATABASE;i know that there is an other column which is called CREATED which indicates when the database has been created and i think it will never change,but, what about VERSION_TIME ? when does it change ?
View 6 Replies
View Related
Feb 22, 2011
what version of java is supported by Oracle Database 10g and 11g. Actually i am writing a User Defined Function in Java and was asking this question to know which version of java i need to compile the source file before uploading the jar.
View 2 Replies
View Related
Feb 6, 2010
i have a oracle server installed enterprise edition, for some reation i need to degrade the version from enterprise to standard
i need same tablespace,data's everything same as of now.
View 8 Replies
View Related
May 10, 2012
I have Windows 7 (System Type - 64-bit OPerating System & ACPI X64 PC Type) and want to install Oracle Database.
The compatible version with the above operating system and send me the direct link for downloading.
View 17 Replies
View Related
Nov 16, 2012
how many rows created (replaced ?) und stored in v$object_usage on each fact of index scan? I'm using 11.2 version of database server
View 7 Replies
View Related