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
ADVERTISEMENT
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
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Jan 21, 2011
Iam planning to upgrade my Oracle Database from 10G to 11G .
Its on HP Unix Environment 11.23 and
Oracle CRS 10.2.0.4
Oracle ASM 10.2.0.4
Oracle RDBMS 10.2.0.4
Its in RAC env...and Active-Active DB running controlled by tnsnames.ora .
View 8 Replies
View Related
Mar 4, 2012
My Oracle DB 10.2.0.1 is working fine in Windows XP. Now, I want to upgrade to Oracle 10.2.0.4. I have two Oracle CDs
1) Oracle Database Vault 10g release 2(10.2.0.4.0) for Microsoft Windows DVD&
2) Oracle Enterprise Manager 10g release 4 Grid control (10.2.0.4.0) patch for Microsoft Windows DVD.
But I don't have metalink support. How can I upgrade Oracle DB.
View 1 Replies
View Related
Oct 25, 2012
After upgrade 10g to 11g, the below sql is not working. I have issue with connect by, if we use it with subquery it will hang.
select item_code
from bom_list_pos
where ln_id in (select ln_id
from bom_list_nodes
start with ln_id IN (select ln_id from bom_used_work_pack where rownum =1)
connect by prior ln_id = parent_ln_id)
I ran 10g, able to get it less than minute, but 11g hang. below is explain plan.
11g explain plan
-----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 19 | 209 | 148M (1)|494:23:18 |
|* 1 | FILTER | | | | | |
| 2 | TABLE ACCESS FULL | BOM_LIST_POS | 810K| 8711K| 7484 (1)| 00:01:30 |
|* 3 | FILTER | | | | | |
|* 4 | CONNECT BY NO FILTERING WITH SW (UNIQUE)| | | | | |
| 5 | TABLE ACCESS FULL | BOM_LIST_NODES | 46041 | 449K| 241 (1)| 00:00:03 |
|* 6 | FILTER | | | | | |
|* 7 | COUNT STOPKEY | | | | | |
| 8 | INDEX FAST FULL SCAN | UWPD_LN_FK_I | 1 | 5 | 2 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter( EXISTS (SELECT 0 FROM "M_SYS"."BOM_LIST_NODES" "SYS_ALIAS_1" WHERE "LN_ID"=:B1 START
WITH EXISTS (<not feasible>)
3 - filter("LN_ID"=:B1)
4 - access("PARENT_LN_ID"=PRIOR "LN_ID")
filter( EXISTS (<not feasible>)
6 - filter("LN_ID"=:B1)
7 - filter(ROWNUM=1)
-------------------
10g explain plan
--------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 440 | 9240 | 27 (4)| 00:00:01 |
| 1 | TABLE ACCESS BY INDEX ROWID | BOM_LIST_POS | 88 | 704 | 6 (0)| 00:00:01 |
| 2 | NESTED LOOPS | | 440 | 9240 | 27 (4)| 00:00:01 |
| 3 | VIEW | VW_NSO_2 | 5 | 65 | 2 (0)| 00:00:01 |
| 4 | HASH UNIQUE | | 5 | 30 | | |
|* 5 | CONNECT BY WITH FILTERING | | | | | |
| 6 | TABLE ACCESS BY INDEX ROWID | BOM_LIST_NODES | | | | |
| 7 | NESTED LOOPS | | 1 | 16 | 1 (0)| 00:00:01 |
| 8 | VIEW | VW_NSO_1 | 1 | 13 | 1 (0)| 00:00:01 |
|* 9 | COUNT STOPKEY | | | | | |
| 10 | INDEX FULL SCAN | UWPD_LN_FK_I | 122 | 366 | 1 (0)| 00:00:01 |
|* 11 | INDEX UNIQUE SCAN | LN_PK | 783 | 2349 | 0 (0)| 00:00:01 |
| 12 | NESTED LOOPS | | | | | |
| 13 | CONNECT BY PUMP | | | | | |
| 14 | TABLE ACCESS BY INDEX ROWID| BOM_LIST_NODES | 5 | 30 | 2 (0)| 00:00:01 |
|* 15 | INDEX RANGE SCAN | LN_LN_FK_I | 5 | | 1 (0)| 00:00:01 |
|* 16 | INDEX RANGE SCAN | LP_LN_FK_I | 88 | | 1 (0)| 00:00:01 |
--------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
5 - access("PARENT_LN_ID"=PRIOR "LN_ID")
9 - filter(ROWNUM=1)
11 - access("LN_ID"="$nso_col_1")
15 - access("PARENT_LN_ID"=PRIOR "LN_ID")
16 - access("LN_ID"="$nso_col_1")
View 3 Replies
View Related
Oct 26, 2010
I am migrating Oracle windows 32-bit (10g) db to hp-ux machine (11g R2). I have exported all the data from windows machine using dp and plan is to export it to 11g db on UNIX. Before I start the import I need to have similar structure on newly created 11g db on UNIX (tablespaces etc). I am wondering what would be the best option to
1. Generate the code to create all the tablespaces on the new database
2. How can I tell import into different tablespace?
3. I would like import indexes into separate tablespace than data.
Total size of the export is around 300gb.
View 3 Replies
View Related
May 18, 2010
Our company is using forms 4.5 on Oracle 8.0.6. We want to upgrade to forms 6i. But there is no oracle support available for this version. Before going to forms 10g, we have to upgrade our forms to 6i.
My question is how do we request to Oracle support to supply us the 6i installation CD's. Is there any particular format to request upgrade from oracle support?
View 1 Replies
View Related
Oct 11, 2012
We have a function that is called in various other PL/SQL packages, and performance has always been very good. On 29th Sept we upgraded our db to 10.2.0.5.0 and since then, a package that calls the function has gone from ~4mins, to ~2.5hrs to run.
In PL/SQL Developer, a simple select that calls the function has gone from ~0.5secs to retrieve the first 100 rows, to ~12secs. I ran a profile of the main package, which highlighted the where the bottleneck was (a fetch from an explicit cursor). Running an explain plan on the cursor SQL doesn't really show up anything untoward.
However, I found that if I subtly changed the cursor SQL, (so that it did the same thing, but was written differently), it fixed the performance problems.
where ade_start_date between cpDate-cpDays and cpDate-1
/*and ade_start_date < cpDate
and ade_start_date >= (cpDate-cpDays)*/
From this, we thought that there may have been a bad cached execution plan which the change of code forced a recalculation of. However, about 2 hours later, the changed code ran slowly again. So a further subtle change was made, which fixed the issue again. Until this morning, when it was running slowly again.
This feels like it is CBO/stats related potentially, but is out of my area of knowledge unfortunately. We have our DBA investigating this, but there may be things I can test to narrow down the possibilities in the meantime.
View 5 Replies
View Related
Dec 28, 2012
I have been trying to upgrade my personal laptop with 11G from 10G. Since I didn't had any important data, so i removed 10G and tried to go for a fresh install of 11G.
Below are the entries of my files:
Listener.ora
# listener.ora Network Configuration File: C:appNikproduct11.2.0dbhome_1NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL.WORLD)
(ORACLE_HOME = C:appNikproduct11.2.0dbhome_1)
[code]........
If i start the database in no mount it doesn't give any error. Once I try to mount it, it gives the following error:
SQL> alter database mount
2 ;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> show parameter control;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string C:APPNIKPRODUCT11.2.0DBHO
ME_1DATABASEORA_CONTROL1.CTL
, C:APPNIKPRODUCT11.2.0DB
HOME_1DATABASEORA_CONTROL2.C
TL
control_management_pack_access string DIAGNOSTIC+TUNING
View 11 Replies
View Related
May 2, 2012
Currently, We are running oracle 11.2.0.1 on Linux server. There are 32 DB instances on this server. As per requirement, we need to install 11.2.0.2 DB on the same server. Is it advisable to have both 11.2.0.1 and 11.2.0.2 databases on the same server with different ORACLE_HOME.
How about ORACLE_BASE?? OR, do we need to upgrade all the DB's from 11.2.0.1 to 11.2.0.2. During the upgrade process, if i need to take backup with exp/imp utility, what is the best way to take 32 DB's backups instead of taking each DB backup at a time?
View 2 Replies
View Related
Jan 30, 2012
When we upgrade from 10g to 11g oracle upgrades the stats table by EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('OWNER','TABLE'); But When we import from 10g to 11g do we need to upgarde the stats table??
View 2 Replies
View Related
Jan 16, 2012
We have the requirement to upgrade the Oracle discoverer reports from 11i to R12. what are the steps/white paper required to do this activity at the earliest.
View 1 Replies
View Related
Nov 8, 2010
steps required to upgrade oracle db from 11.1.0.6 to 11.2.0.1.
Is it a single step or i need to patch it to 11.1.0.7 then upgrade it using dbua to 11.2.0.1?
View 1 Replies
View Related
Feb 23, 2010
Currently installed 8.1.7.0 .i want to upgrade to 10.2.0.1.0 in the upgrade documentation its written the direct upgrade is not supported for 8.1.7.0, first update to 8.1.7.4 and then direct upgrade to 10.x.
unable to find 8.1.7.4 update.any link to find update or guideline to direct upgrade to 10.x.
View 7 Replies
View Related
