Unable To Upgrade From 9i To 10g?

Oct 31, 2010

I'm attempting to upgrade a 9.2.0.7 to 10.2.0.? (haven't run the patch set yet so it's at 10.2.0.1) I'm not sure if the listener is correct to proceed.

The platform is Windows x323 (server 2003)

>>I'm not an Oracle DBA, I stumble thru it in administering PTC's Windchill vault..

I am trying to run the Oracle DBUA and the documentation for the Upgrade Assistant instructs me to install in an OraHome that is separate from the existing. Done.

The Upgrading Guide then States:
"Run the Oracle Net Configuration Assistant
If you are upgrading from Oracle9i and a listener was not configured in the Oracle9i repository, run Oracle Net Configuration Assistant to configure the listening protocol address and service information for the new Oracle Database 10g database, including a listener.ora file. A version 10 listener is required for an Oracle Database 10g database. Previous versions of the listener are not supported for use with an Oracle Database 10g database. However, it is possible to use a version 10 listener with previous versions of the Oracle database."

Oracle Net Services Administration Guide, �10 states:

"Note:

A version 10 listener is required for an Oracle Database 10g database. Previous versions of the listener are not supported for use with an Oracle Database 10g database. However, it is possible to use a version 10 listener with previous versions of the Oracle database."

Here's what I've got: The Installation using the Universal installer for 10g ran w/o complaint, reported success. The installation type was Advanced>Custom per the PTC Windchill documentation. After the initial installation, the Oracle Net Configuration Assistant did not start automatically, as the documentation stated it would. (The documentation from PTC on Oracle is skimpy at best)

I launched the Network Config Assistant from the start menu in the new OraHome10g. When I tried to create the listener, TCP on port 1521, it told me this was already in use by another program. I could configure it, but until the conflict was resolved....

When I open the Net Manager, the path in the header bar of the frame is to OraHome92\network\Admin....YET, when I run HELP>About in the Net Manager it reports "Oracle Net Manager; Version 10.2.0.0.0 Production"

I had stopped all Oracle services when I ran the UI to install 10g. I have also since removed the service for the 9i TNSListener from windoze register (and restarted). Right now, there is no that shows running in Services.

??Am I actually OK to go ahead w/ the patch set, then run the Pre-Upgrade Information Tool then the Oracle DBUA?

Do I actually have a 10g listener setup?

But, the listener.ora, tnsnames.ora etc are all in the OraHom92/network/admin folder and nothing but the samples show in the OraHome10g/network/admin. Will the DBUA migrate these or should I manually transplant them into the OraHome10g directory?

View 1 Replies


ADVERTISEMENT

Unable To Upgrade Oracle 9i To 10g?

Jul 4, 2010

Question:1 I am trying to upgrade 9i to 10g , using DBUA. I am getting below error at step 1:

There is an error in creating the following process: C:\oracle\ora92\bin\sqlplus -s/nolog

The error is: createprocess:C:\oracle\ora92\bin\sqlplus -s/nolog error:193

I can login as sysdba ,using C:\oracle\ora92\bin\sqlplu for both 9i as well as 10g i did set oracle_home to C:\oracle\ora92, using command prompt.

Question 2:Is there any way i can generate the database template of running production so i can use same template to create the test server. I cant find existing template in prod :ORACLE_HOME/assistants/dbca/templates , all templates looks like the default one only.

Question 3:If i have different structure in test db server i.e i have datafiles, controlfiles in I and J drives in production, but in test i have all datafiles ,control files in H:drive Can i use Transport_tablespaces import to upgrade test server ?

View 1 Replies View Related

RMAN :: Unable To Take Backup After Upgrade From 10g To 11gr2

Dec 5, 2012

After upgrading db from 10 g to 11g ,unable to take rman backup.catlog also upgraded.SCAN listsner alos running

ps -ef |grep tns
oracle 13235 13215 0 13:23:55 pts/3 0:00 grep tns
oracle 2968 1 0 Dec 2 ? 0:47 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit
oracle 2997 1 0 Dec 2 ? 0:51 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit
oracle 19844 1 0 Dec 3 ? 0:30 /orahome_new/oracle/product/11.2.0/bin/tnslsnr LISTENER_DB -inherit
[code]....

View 2 Replies View Related

Application Express :: 4.2 Upgrade - Unable To Test Report Queries?

Apr 5, 2013

After upgrading to Apex 4.2 I'm now unable to test Report Queries. Each time I click on the Test Report button via Shared Components|Report Queries I recieve the following error message:

ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.

I still have Apex version 4.1 installed on a different server and it appears to be working fine.

View 1 Replies View Related

Upgrade :: Cross Platform Upgrade From Single Instance To RAC

Jun 26, 2013

I'm planning to upgrade a small database (~150GB) from 10.2.0.3 on windows 2003 23bit to 11.2.0.3 RAC on Linux 5.8.The database contains oracle spatial too. A suitable method and link to document to be followed. 

View 2 Replies View Related

Upgrade :: ORA-00904 / OBJ$EDITION / Invalid Identifier After Upgrade To 11.2.0.3

Nov 19, 2012

I recently performed an upgrade on a new server from oracle 10gr2 to oracle 11gr2 (11.2.0.3).

I take the rman backup from oracle 10g server and restore it on new server where I installed oracle 11gr2.

But on my previous oracle 10gr2 server I enabled the auditing. After doing successful upgrade now when I try to login with any user except sys I receive the following error:

SQL> conn scott/tiger
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier

I got the workaround by setting the parameter audit_trail=FALSE (Previous value was DB_EXTENDED) .But I want my auditing to be enabled as per y requirements.

View 1 Replies View Related

Upgrade :: Upgrade Patch For Enterprise Versus Standard 11.2.0.1

Sep 22, 2012

is the upgrade patch the same for standard edition and enterprise edition or there are two separate patches?

View 5 Replies View Related

Upgrade :: Reference Note IDs For Database Upgrade From 11.2.0.2. To 11.2.0.3.2

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

Upgrade :: Oracle 11.2.0.3.0 Database Upgrade Changes DATA_PUMP_DIR

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

Upgrade :: SYS Table Very Slow After 11g Database Upgrade?

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

Upgrade :: Patchset Number To Upgrade Oracle

Jun 14, 2012

Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?

View 1 Replies View Related

Upgrade :: Oracle Upgrade 11.1.0.7 To 11.2.0.3 - Compatible

Jul 19, 2013

I am going to upgrade database from 11.1.0.7 to 11.2.0.3

1) If compatible is set to 10.2.0 in 11.2.0.3, will it work ?
2) If compatible set to maximum level, will it affect our application ?
3) Whether any code related problem occurred after upgrading like PL/SQL codes ?

View 6 Replies View Related

Upgrade :: Oracle Database Upgrade

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

Upgrade :: Database Upgrade From 9.2.0 To 11gr2

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

Upgrade :: Compatible Parameter During Upgrade

May 21, 2013

Why COMPATIBLE Parameter is important to be at a certain value before you UPGRADE(10.2.0.4 to 11.2.0.3) to 11g ?

View 2 Replies View Related

Upgrade :: Upgrade 11.2.0.2 To 11.2.0.3 On Linux Environment?

Mar 23, 2013

I try to upgrade 11.2.0.2 to 11.2.0.3 on Linux environment. I have to apply patch P1253900 before the upgrade per oracle doc.

however I got following conflict:

Verifying environment and performing prerequisite checks...
Checking skip_duplicate
Checking skip_subset

Conflicts/Supersets for each patch are:

Patch : 12539000
Conflict with 12827726
Conflict details:
/u01/app/grid/product/11.2.0/grid/lib/libserver11.a:/ksxp.o

Following patches have conflicts: [   12827726   12539000 ] Refer to My Oracle Support Note 1299688.1 for instructions on resolving patch conflicts.

I checked above oracle note, and did not say any resolution.

View 1 Replies View Related

Upgrade :: 10.2.0.1 To 10.2.0.4 Upgrade 32bit

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

Upgrade :: Database Upgrade From 11.2.0.1 To 11.2.0.3

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

Upgrade :: Migration / Upgrade 10g / R2 To 11g / 2

Jul 6, 2012

I am looking for for exact steps for migration. The important question ist:

-- If we migrate from 10g to 11g, do we need addition (more) CPU's as currently we have?
-- Do wee need more powerful HW.

View 2 Replies View Related

Upgrade :: Oracle 10g To 11g Upgrade

Feb 21, 2013

I am trying to come up with a plan for an upgrade that is needed for a server I maintain. It is a Windows 2003 32bit running Oracle 10.2.0.3 on old Hardware. It also has two obscure 3rd party applications that are running on it that directly access the database. These applications are supported by off site consultants.

My initial plan was to Create a Windows 2008 R2 Virtual Server and install the same version of Oracle 10.2.0.3. Using Rman clone the database to the new server. Have the consultants come in and get the applications working. Once everything in the new environment seems to be working fine, run RMAN again and reclone the database to have all the latest data. Then at a later time upgrade the database to 11g 32bit. Virtually no downtime and we could spend all the time we needed getting the applications working and testing the new environment.

The plan is dead right of the bat though because I realize 10.2.0.3 is not supported by Windows 2008 R2. I really did not want to add an Oracle DB upgrade into the mix at the same time. Just because their are so many changes from the old environment to the new that I want to break this down into manageable chunks. And I can maybe get by with 1 day of down time.

So now I am looking at installing 11g on my Virtual Server, Clone the database, upgrade the database, have the consultants come in and get the applications working. All the while we are down. If we run into any problems, which you always do, it just completely blows the schedule.

View 1 Replies View Related

Upgrade :: Oracle Upgrade 10.2.0.5 Non-ASM 11.2.0.3 ASM?

Jun 29, 2012

I need to upgrade our current system 10.2.0.5 (non Asm) to 11.2.0.3(ASM) on the same host.

So a few options : install ASM on current 10.2.0.5, create volumes etc and shift DB into ASM

upgrade to 11.2.0.3 GI - standalone

upgrade DB to 11.2.0.3

install 11.2.0.3 GI, configure ASM and run against 10.2.0.5

DB upgrade DB to 11.2.0.3

The DB upgrade has to come last I've been told.

View 1 Replies View Related

Upgrade :: Upgrade To 11g R2 From 10g R2

Aug 1, 2012

How to Upgrade to 11g R2 from 10g?

Let me Explain my environment:

=> 2 Node RAC on Windows 2003
=> 1 voting disk and OCR [No mirroring]
=> ASM with Extenral Redundancy.
=> Seperat CRS,ASM & RDBMS Home.

Explain me following Areas:

1) How to upgrade to 11g R2 by using ""p10404530"" patch.
2) Fresh 11g R2 installation document on Win 2003.
2) How to Configure SCAN without DNS?
3) How to Configure OCR & Voting disk on ASM

View 2 Replies View Related

Upgrade :: Upgrade 10.2.0.4 SE To 11.2.0.3 EE

Apr 17, 2013

I'm planning to upgrade an existing 10.2.0.4 Standard Edition database to 11.2.0.3 Enterprise Edition and have a related question after getting a little uncertain looking at the MOS note .

"How to Convert Database from Standard to Enterprise Edition ? [ID 117048.1]"

Do I ?:

1. Install 10.2.0.4 EE Home and convert my 10g database from SE to EE, and then install 11.2.0.3 EE Home and upgrade the database.

or can I?:

2. Install 11.2.0.3 EE home and do the upgrade directly from 10.2.0.4 SE to 11.2.0.3 EE

View 1 Replies View Related

Oracle 9i To 10g Upgrade

Jul 3, 2010

I am trying to upgrade database from 9.2.0.7 to 10.2.0 in my test server. Here are the steps i am planning to do.

1. Export user data of production, Import in test db(ABC) using Destroy=Y Fromuser,touser parameter( this step just to refresh old test data)
2. Install 10g db, Use DBUA Utility of 10g to start upgrade>select 9i database which i want to upgrade
3. follow DBUA instruction ..create datafile paths, init.ora file, tnsnames,listener... same as the existing setup i have of 9i(so i can make replica of 9i in 10g)

question: I have another database(xyz) in test server its also in 9i, I don't want to upgrade that for now. so do i need to use one listener /tnasnames file of 10g and include setting of 9i in that 10g file ?

How to manage init,tnasnames,listener files setting in 2 db versions . Is there anything else i need to do to perform upgrade 9i-10g ? or its all ?

I will install just 10g database will import full export of 9i db. if i can do full import in 10g or should i just go for fromuser, tuser option to import? i believe for that i need to create datafiles, user,grant in new 10g db. I am not sure which option is best to perform 10g upgrade?

View 2 Replies View Related

How To Upgrade Oracle 9.2.0.1 To 9.2.0.4

Feb 3, 2011

I want to know the detailed steps for the Upgradation of database from Oracle 9.2.0.1 to 9.2.0.4?

View 4 Replies View Related

Upgrade Database From 11.2.0.2 To 11.2.0.3?

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

Forms :: Upgrade From 10g To 11g?

Jul 18, 2012

We need to upgrade ours forms for 10g to 11g. provide links to white papers that discuss forms upgrade from 10g to 11g?

View 4 Replies View Related

Upgrade To Oracle 11.2.0.1?

Mar 9, 2011

Recently we have upgraded our database from Oracle 9.2.0.8 to Oracle 11.1.0.7. But now the new requirement comes that it should be upgraded to Oracle 11.2.0.1

Our OS environment - UNIX AIX 5.3

Since its a development database, we have dataset of Oracle 9i and Oracle 11g1 cold backup. I have a query regarding this. what would be the best way to upgrade, is it from Oracle 9i to Oracle 11g1 or Oracle 11g1 to Oracle 11g2?

View 3 Replies View Related

How To Run Start Up Upgrade In 11g-RAC Env

Jun 3, 2013

11.2.0.3.5
RHEL-7
2 NODE RAC

issue : XDB component is INVALID and oracle support suggested below steps. But, in RAC env, can we do this on both nodes or only on one node. If we are doing in node1 and do we need DOWN node2 ?

{
SQL> spool xdbreload.log
SQL> connect / as sysdba
SQL> set echo on;
SQL> shutdown immediate;
[code].......

How to run UPGRADE in rac env ?

View 1 Replies View Related

Upgrade :: Migration From 10g To 11g?

Nov 2, 2012

my current database version is 10.2.0.3.0 and we are going to migrate our database to 11.2.0.3 .

Can we directly migrate database to 11.2.0.3 or will i require to apply any patch before this ?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved