1
Migrate Oracle 9i to Oracle 10g
kindly provide me with details steps, as i will upgrade over 50 servers. what i am doing in three sites: 1) build temp server with same version. 2) uninstall Application. 3) uninstall 9i. 4) dis-join domain. 5) install Oracle 10g. 6) join domain mandatory for my application. 7) install my application. 8) imp sys/XXX@XXX file=xx.dmp [...]
Answer Question
| November 8, 2010 5:04 AM
EXP dump files, IMP, Memory dump files, Oracle 10g, Oracle 9i, Oracle 9i migration, Oracle upgrades, Windows Server 2003
kindly provide me with details steps, as i will upgrade over 50 servers. what i am doing in three sites: 1) build temp server with same version. 2) uninstall Application. 3) uninstall 9i. 4) dis-join domain. 5) install Oracle 10g. 6) join domain mandatory for my application. 7) install my application. 8) imp sys/XXX@XXX file=xx.dmp [...]
Answer Question
| November 8, 2010 5:04 AM
EXP dump files, IMP, Memory dump files, Oracle 10g, Oracle 9i, Oracle 9i migration, Oracle upgrades, Windows Server 2003
Upgrade Oracle 9i to 10g
Hi All, Software:- Oracle 9i,Oracle 10g OS – Solaris 9. We have 5 databases in our development environment. All the databases(9i) are running on Solaris 9 OS. I have given responsibility to install oracle 10g on Solaris box(development environment). Once the 10g gets install then upgrade one of the database running on the 9i to [...]
Answer Question
| September 11, 2012 4:17 AM
Oracle 10g, Oracle 9i, Oracle 9i to 10g Upgrade, Oracle upgrades, Solaris
Hi All, Software:- Oracle 9i,Oracle 10g OS – Solaris 9. We have 5 databases in our development environment. All the databases(9i) are running on Solaris 9 OS. I have given responsibility to install oracle 10g on Solaris box(development environment). Once the 10g gets install then upgrade one of the database running on the 9i to [...]
Answer Question
| September 11, 2012 4:17 AM
Oracle 10g, Oracle 9i, Oracle 9i to 10g Upgrade, Oracle upgrades, Solaris
Upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?
How does one upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?
Answer Question
| November 18, 2009 3:42 PM
Oracle, Oracle 10i, Oracle 8.1.5, Oracle upgrades, QTP Automation
How does one upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?
Answer Question
| November 18, 2009 3:42 PM
Oracle, Oracle 10i, Oracle 8.1.5, Oracle upgrades, QTP Automation
Oracle table update exist ?
dear all, i want implemente a update on many table but i don’t know the syntax please help me. My update is at less on 5 table
Answer Question
| November 6, 2009 12:36 PM
Oracle Tables, Oracle upgrades
dear all, i want implemente a update on many table but i don’t know the syntax please help me. My update is at less on 5 table
Answer Question
| November 6, 2009 12:36 PM
Oracle Tables, Oracle upgrades
Oracle Report 6i and Oracle 11g database
I have oracle 6i report under oracle 9i database.Now database is upgraded from 9i to 11g. So if I try to compile a report 6i under oracle 11g database then which kind of error might raised?
Answer Question
| August 10, 2011 6:22 AM
Oracle 11g, Oracle 6i, Oracle Database 11g, Oracle Reports 6i, Oracle upgrades
I have oracle 6i report under oracle 9i database.Now database is upgraded from 9i to 11g. So if I try to compile a report 6i under oracle 11g database then which kind of error might raised?
Answer Question
| August 10, 2011 6:22 AM
Oracle 11g, Oracle 6i, Oracle Database 11g, Oracle Reports 6i, Oracle upgrades
Would like to upgrade to 10.2.0.4 from 9.2.0.7
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
Answer Question
| April 22, 2009 5:55 PM
Oracle 10g, Oracle 9i, Oracle Database, Oracle upgrades, Tru64
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
Answer Question
| April 22, 2009 5:55 PM
Oracle 10g, Oracle 9i, Oracle Database, Oracle upgrades, Tru64
Oracle Communication between 11g and 8i
We are considering upgrading one of our database from 8i to either 10g or 11g. We know currently that the 10g client is compatible with 8i communication because we have two performance tools database(GRID and I3) which are 10 and they appear to have no issues. However we were wondering if there is any communication [...]
Answer Question
| April 22, 2009 11:28 PM
Oracle 10g, Oracle 11g, Oracle 8i, Oracle 8i migration, Oracle migration, Oracle upgrades
We are considering upgrading one of our database from 8i to either 10g or 11g. We know currently that the 10g client is compatible with 8i communication because we have two performance tools database(GRID and I3) which are 10 and they appear to have no issues. However we were wondering if there is any communication [...]
Answer Question
| April 22, 2009 11:28 PM
Oracle 10g, Oracle 11g, Oracle 8i, Oracle 8i migration, Oracle migration, Oracle upgrades
Invalid objects after upgrade from 8.1.7.4 to 10G
for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; EXCEPTION WHEN OTHERS THEN Vrc2_err_msg:=SUBSTR(SQLERRM,1,200); RETURN; END GET_ALL_REGIONS; I am getting this error. pls-00321: expression ‘R_REGION_LIST’ is inappropriate as the left hand side of an assignment statement PL/SQL: [...]
Answer Question
| March 30, 2009 8:39 PM
ORA-00904, Oracle 10g, Oracle error messages, Oracle upgrades, PL/SQL, PLS-00321, SQL
for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; EXCEPTION WHEN OTHERS THEN Vrc2_err_msg:=SUBSTR(SQLERRM,1,200); RETURN; END GET_ALL_REGIONS; I am getting this error. pls-00321: expression ‘R_REGION_LIST’ is inappropriate as the left hand side of an assignment statement PL/SQL: [...]
Answer Question
| March 30, 2009 8:39 PM
ORA-00904, Oracle 10g, Oracle error messages, Oracle upgrades, PL/SQL, PLS-00321, SQL
Oracle 9i to Oracle 10g Upgrade – Help needed for some PL/SQL errors
We are doing a Database server upgrade from Oracle 9i to Oracle 10g. As a part of this upgrade activity, I got in total three different PL-SQL Errors for which I had to make code changes in the database server. These errors were: (1) PLS-00371: at most one declaration for “string” is permitted. (2) PLS-00593: [...]
Answer Question
| March 18, 2009 7:51 PM
Oracle 10g, Oracle 9i, Oracle 9i to 10g Upgrade, Oracle upgrades
We are doing a Database server upgrade from Oracle 9i to Oracle 10g. As a part of this upgrade activity, I got in total three different PL-SQL Errors for which I had to make code changes in the database server. These errors were: (1) PLS-00371: at most one declaration for “string” is permitted. (2) PLS-00593: [...]
Answer Question
| March 18, 2009 7:51 PM
Oracle 10g, Oracle 9i, Oracle 9i to 10g Upgrade, Oracle upgrades
Upgrading Forms30 on Oracle 7.0
I am upgrading Forms30 on Oracle 7.0 to Oracle 10g First, I am upgrading to Oracle forms 6i using Forms compiler and facing these problems I. converting language on display item. (it doesn’t show the right language on display item and headers) 2. key mapping function. 3. I need script so I can convert all [...]
Answer Question
| March 3, 2009 11:26 AM
Oracle 7, Oracle Forms 10g, Oracle Forms 6i, Oracle upgrades, SQL*Forms30
I am upgrading Forms30 on Oracle 7.0 to Oracle 10g First, I am upgrading to Oracle forms 6i using Forms compiler and facing these problems I. converting language on display item. (it doesn’t show the right language on display item and headers) 2. key mapping function. 3. I need script so I can convert all [...]
Answer Question
| March 3, 2009 11:26 AM
Oracle 7, Oracle Forms 10g, Oracle Forms 6i, Oracle upgrades, SQL*Forms30
ADO connection fails after upgrading from Oracle 10g to Oracle 11g
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property ‘SERVER’ returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?
Answer Question
| February 3, 2009 3:57 PM
ADO, ADO Connection, Database connectivity, Oracle 10g migration, Oracle 10g to 11g Migration, Oracle 11g, Oracle 11g Database, Oracle connectivity, Oracle Database, Oracle upgrades
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property ‘SERVER’ returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?
Answer Question
| February 3, 2009 3:57 PM
ADO, ADO Connection, Database connectivity, Oracle 10g migration, Oracle 10g to 11g Migration, Oracle 11g, Oracle 11g Database, Oracle connectivity, Oracle Database, Oracle upgrades
Upgrade from Oracle 10g2 to Oracle 10g4 on Linux
I’m a newbie to Oracle database administration and I’ve been recently tasked to upgrade our databases in our development environment from 10g2 to 10g4. The databases are housed on SUN servers (there are several database servers), running with RedHat Linux 4.5 operating system. Additionally, the Database servers run either in 64 or 32 bit mode. [...]
Answer Question
| March 12, 2009 9:13 PM
Linux, Oracle 10g, Oracle 10g DB issues, Oracle 10g DB Upgrade, Oracle Application Server, Oracle upgrades, Red Hat Linux
I’m a newbie to Oracle database administration and I’ve been recently tasked to upgrade our databases in our development environment from 10g2 to 10g4. The databases are housed on SUN servers (there are several database servers), running with RedHat Linux 4.5 operating system. Additionally, the Database servers run either in 64 or 32 bit mode. [...]
Answer Question
| March 12, 2009 9:13 PM
Linux, Oracle 10g, Oracle 10g DB issues, Oracle 10g DB Upgrade, Oracle Application Server, Oracle upgrades, Red Hat Linux
VB6 Oracle 10 Stored procedures with parameters
I have a vb6 – RDO code that works ok with Oracle8, recently there was an upgrade to Oracle 10g enterprise. Now I get the error 40041 -> Object Collection: Couldn’t find item indicated by text. 1110 lstrSQL = "{call Pyramid.Load_Tables(?, ?, 0)}" 1120 Set lrdoQ = vConexionDatos.MiDataBase.CreateQuery("ProcessTables", lstrSQL) 1130 lrdoQ.rdoParameters(0).Direction = rdParamInput 1140 lrdoQ.rdoParameters(0).Type [...]
Answer Question
| December 11, 2008 8:20 PM
Oracle 10g, Oracle error messages, Oracle stored procedures, Oracle upgrades, VB 6, Visual Basic
I have a vb6 – RDO code that works ok with Oracle8, recently there was an upgrade to Oracle 10g enterprise. Now I get the error 40041 -> Object Collection: Couldn’t find item indicated by text. 1110 lstrSQL = "{call Pyramid.Load_Tables(?, ?, 0)}" 1120 Set lrdoQ = vConexionDatos.MiDataBase.CreateQuery("ProcessTables", lstrSQL) 1130 lrdoQ.rdoParameters(0).Direction = rdParamInput 1140 lrdoQ.rdoParameters(0).Type [...]
Answer Question
| December 11, 2008 8:20 PM
Oracle 10g, Oracle error messages, Oracle stored procedures, Oracle upgrades, VB 6, Visual Basic
Oracle Upgrade
I want to upgrade oracle 8i to 11g on solaris10. What will be the best way to do it. I really appreciate your help.
Answer Question
| November 14, 2008 8:53 AM
Oracle 11g, Oracle 8i, Oracle 8i upgrade, Oracle migration, Oracle on Solaris 10, Oracle upgrades, Solaris 10
I want to upgrade oracle 8i to 11g on solaris10. What will be the best way to do it. I really appreciate your help.
Answer Question
| November 14, 2008 8:53 AM
Oracle 11g, Oracle 8i, Oracle 8i upgrade, Oracle migration, Oracle on Solaris 10, Oracle upgrades, Solaris 10
upgrade from Oracle 9i to 10g
I am trying to upgrade a copy 9i Production database to 10g. Using DBUA tool. After selecting the DB for the past 20 hrs the process is still running with no progress. Alert log has the message on MMNL. What are the possible ways to upgrade a 9i DB to 10g. Have followed the oracle [...]
Answer Question
| November 5, 2008 2:07 PM
Oracle 10g, Oracle 9i, Oracle upgrades
I am trying to upgrade a copy 9i Production database to 10g. Using DBUA tool. After selecting the DB for the past 20 hrs the process is still running with no progress. Alert log has the message on MMNL. What are the possible ways to upgrade a 9i DB to 10g. Have followed the oracle [...]
Answer Question
| November 5, 2008 2:07 PM
Oracle 10g, Oracle 9i, Oracle upgrades
1
