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
ADVERTISEMENT
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
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
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
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
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
Jun 15, 2010
We have production environment running on oracle 9i database. we are planning to upgrade it to 10g. I have reviewed many documents and blogs but still have few concerns. Pls provide me complete steps to upgrade our 9i db to 10g.
1. For 9i to 10g upgrade we need to install oracle 10g with different oracle_home and then launch dbua and upgrade 9i?
2. will new installed 10g home will read 9i home when dbua launched?
3. Is there any upgrade installer available to upgrade to 10g like patchset upgrade installer?
View 7 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 ) 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 usingExpress version (I dont 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 1 Replies
View Related
Nov 13, 2013
I have downloaded Oracle 11g XE and installed it on my laptop, Win 7 Enterprise Everything works great, DB admin page comes up, APEX comes up (4.0.2.x). I download the Apex_4.2.3_en.zip. I extract the zip file and then follow the instructions in, Downloading from Oracle Technology Network essentially the apexins.sql, apxldimg.sql with the admin password changes and anonymous user unlock.
This is the install command, @apexins SYSAUX SYSAUX TEMP /i/
I get the Error processing request ORA-010403: no data found.
View 3 Replies
View Related
