Oracle Upgrades

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? Software/Hardware used: Oracle Client 8.1

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

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?

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

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...

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; ...

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....

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...

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?

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...

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 =...

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.

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 docwith no...