Grant Robertson, December 20, 2004 - 7:17 pm UTC
Thanks for your feedback on the Question.
So then my question is WHY does Oracle have to de support releases that it comes out with.
Also then WHY is 8.0.5 has a direct path to 10.1.0 ??
What about the future.
Will 10.1.0 be de supported at some stage.
December 20, 2004 - 8:06 pm UTC
I think you mean 8.0.6 -- the terminal release of the 8.0 code line (like 8.1.7 is for 8.1). 8.0.6 had a support span similar to 8.1.7 actually (it just ended support in sept 2004).
why does anyone desupport anything over time? do you have any 10 year old software sitting around that is fully supported?
Correct, the desupport notice for 10.1 is already posted on metalink. Note:190435.1
*Oracle Database 10.1.0.x
ALL Platforms
End of ECS Date 01-FEB-2009
End of ES Date 01-FEB-2012
End of EMS Date 01-FEB-2011
so keep that weekend sometime in 2009-2012 open.
Every software product has a lifespan. We announce when we ship what our intentions are, the day you install -- you already know the day support ends.
Grant Robertson, December 22, 2004 - 9:34 pm UTC
Excellent Responses.
My final question is any idea when the 10G release 2 will be out. ie (10.2.??)
Is it worth waiting for 10g release 2 to be out?
Also why do database links between 10g(or 9i) and 7.3.4 databases not work. (I'm guessing they are NOT SUPPORTED in some matrix)
Again one party may update to 10g but its customers databases may still be runnning on oracle 7. And if information is passed between the 2 via database links then
there is an issue there.
I understand that oracle 7 is an old database , but upgrading customers databases are out of our control.
What do we tell our customers when we upgrade to 10g.
"Please upgrade your database to a higher version to get information from us". Of course there are alternatives to database links but time/effort has to be spent there.
Hopefully in the way forward these impacts will be considered.
December 23, 2004 - 10:49 am UTC
It'll be out in 2005 sometime, probably.
I did not wait. If I was migrating a database from 8i (which is out of support in days from now) to another release, there would be NO question what version it would be (10gr1)
If I was in the midst of new development there would likewise be not a single question what version it would be (10gr1).
7.3.4 was many years out of support with 10gr1 and 9ir2 were released -- they never tested it, never thought to test it.
If information is getting passed from 7.x to 10g that means you are still doing new development on 7.x and anything you do on 7.x is "suspect" -- you have no channel really whatsoever for fixing things, you cannot introduce any sort of changes into an environment that is that locked off. You cannot add a disk, you cannot add ram, you cannot update the hardware, you cannot touch the OS, you cannot do a thing - it is a fragile environment, ecosystem and anything new will be/could be the straw that breaks that camels back.
They are considered -- it is just that there was 8.0.4, 8.0.5, 8.0.6, 8.1.5, 8.1.6, 8.1.7, 9.0.1, 9.2.0 in between 10gr1 and 7.3.4 for example.
A reader, January 06, 2005 - 12:06 am UTC
Thanks for your responses.
I currently have our test database on 10g i.e(10.1.0.3).
Is that the latest release so far.
Any idea when 10.1.0.4 will be out.
Thanks in advance.
A clarification on the previous question.
"If information is getting passed from 7.x to 10g that means you are still doing
new development on 7.x and anything you do on 7.x is ..."
" Currently information is passed from OUR 8i database to CLIENTS 7.3 database via db links "
WHEN we upgrade to 10g we can no more do the following
" Pass information from 10g Database to 7.3 database "
BECAUSE 7.3 IS NOT SUPPORTED.
I think you misunderstood my question.
Thanks in advace
January 06, 2005 - 10:30 am UTC
support is the place to go to ask about patch releases, timeframes, etc (it is platform dependent in many cases)
you cannot upgrade until the 7.3 database is not part of the equation or you remove the dblink
db links between 10g(10.1.0.3) and 8i(8.1.7.3.0)
Darwin, January 30, 2005 - 9:57 pm UTC
What about db links support between 8i and 10g?
I've seen in the Support Matrix that they are not supported.
Is there any other alternative to using database links that you can suggest please, or alteast direct me in the correct direction. I've heard of messaging etc.
Your help will be appreciated here.
January 30, 2005 - 10:06 pm UTC
give me the metalink note, that would not be accurate.
Actually...
Scot, February 01, 2005 - 2:40 pm UTC
It seems to me that it is very good of Oracle, and a testament to their stability in the marketplace, that they commit to a specified support window and tell you what that window will be when they first make the product available.
Oracle is basically saying, here is this new product 10gR1 that we think is very useful, and we will support it and your use of it between 2004 and 2009 (or whatever dates). They are providing us with the information we need to plan, in advance, our hardware, OS, and code development life cycles for a FIVE YEAR time span.
Not all software vendors (or proprietary in-house development teams) show such foresight.
db links between 10g(10.1.0.3) and 8i(8.1.7.3.0)
Darwin, February 01, 2005 - 3:58 pm UTC
The metalink note is 207303.1
February 02, 2005 - 4:37 am UTC
note says if you have the support, it is supported.
at this point in time, 817 is out of error correction support. meaning no new patches. If you hit an issue that was known and diagnosed prior to 817 going out of support, it'll be supplied to you (the workaround or existing patch)
else, if you have EMS (extended maintenance support), there are more options.
but basically, it is as supported as 8i itself is supported today.
A reader, February 03, 2005 - 8:31 am UTC
upgrading 8i to 10g
David, February 20, 2005 - 4:44 pm UTC
I'm facing a issue with db links between 8i and 10g.
Not that the links between 8i and 10g don't work its just that Oracle don't entirely support db links across those versions.
Here is a url in metalink that informs of Oracle's support matrix for db links.
</code>
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=207303.1&p_database_id=NOT <code>
So far this is the only issue we face from upgrading from 8i to 10g ( Because we have dependency on external 8i databases via db links).
Some of these external databases that we rely on are 8.1.6.0 and 8.1.7.3.
Since it is a 24/7 system we are planning to upgrade we want to be absolutely sure that everything will work.
Any help here would be really appreciated.
Also can we find out who is running a mission critical 24/7 system on oracle10g using database links to external 8i databases.
We are aware that there are many databases in Production on oracle10g but they may be used for small not mission critical applications.
February 20, 2005 - 4:52 pm UTC
what can I help with exactly?
You see right now -- you are using unsupported software (and have been for quite a while) -- you are already in the realm of the "unsupported but running in production".
the only thing i can suggest is to test your configurations, even if I gave 1,000 people using 10g with 8.1.6 dblinks, that doesn't mean "it'll work for you".
But, if anyone reading this is using 10g with earlier releases -- let us know how it's going.
upgrade from 8i to 10g
david, February 20, 2005 - 5:04 pm UTC
Thanks for getting back so fast.
All I need is
1> Names of organizations that use oracle 10g databases on a 24/7 basis in Production.
February 20, 2005 - 5:17 pm UTC
well, we'll see if anyone follows up. (your sales contact would be glad to give you references, as well, tons of them on www.oracle.com -- from amazon to whatever...)
Error correction and EMS
Doug, February 21, 2005 - 12:41 am UTC
You mentiond 8174 is out of error correction support, but that 8i is supported. Since 8174 is 8i, do you mean it is supported because it is still available with EMS? We have a production database on 8174 but I heard support was only available with EMS to be paid for under the customer contract.
Until the EMS expires, should I consider 8i supported? Or no.
I do undertstand the difference between error correction and EMS, no new bug fixes etc., I'm just wondering about what seems like a contradictory statement. Using Note:120607.1 for reference.
February 21, 2005 - 10:08 am UTC
8i is out of ECS (no new patches). Existing patches, solutions, workarounds, help will be provided (assuming you have support of course).
8i is supported -- 8174, but not 816 (which was referenced above).
<quote>
Some of these external databases that we rely on are 8.1.6.0 and 8.1.7.3.
</quote>
does that clear up the contradiction? I was referring to those installs.
Yes Clear
Doug, February 21, 2005 - 2:12 pm UTC
I didn't realise ES had expired for 8.1.6 and below. What options to customers have for support after ES has expired?
Can something be worked out?
February 21, 2005 - 3:48 pm UTC
outside of my domain of expertise, something to be taken up with your sales contact. sorry - i don't want to mis-speak on something.
Upgrade using Export/Import
darren, March 07, 2005 - 5:17 pm UTC
Hi Tom
We have decided to upgrade a few of our databases from oracle 8i(8.1.6.0.0) to oracle 10g(10.1.0.3)
We will be going by the export/import method of upgrading.
Here is how we have performed the upgrade so far in test
The steps are followed in sequence
1> Export of application schemas
exp userid=<schema_name>/<password> parfile=tables.par
direct=y file=schema.dmp consistent=y
2>Full database export with only Structure export no rows
exp userid=sys/<password> file=full_norows.dmp full=y
rows=n compress=n
3>Import of Application schemas in 10g database
imp userid=<schema_name>/<passwd> file=library.dmp
fromuser=<schema_name> touser=<schema_name>
4>Import of full database structure only import
imp userid=sys/<passwd> file=full_norows.dmp full=y ignore=y
My questions are
1> Is there any better method of doing export/import.
2> The step 4 above takes the longest time around 1hr.
The outage time is totally dependent on the export/import time so I want to find a way that will reduce the export/import time.
any help here will be appreciated
March 08, 2005 - 7:38 am UTC
yes, you might well be finding you have multiple constraints on your tables with that double import trick there. And this probably explains why step 4 takes so long, it is adding another redundant constraint and having to verify the existing data is OK with it!
from "Expert one on one Oracle" chapter on export/import:
<quote>
Named versus Default Named Constraints
Here is another issue with regards to system-generated named constraints and IMP/EXP. I could have called this section Where Did All of These Constraints Come From? since the prior section was called Where Did My Indexes Go? Here we start with a table T:
tkyte@TKYTE816> create table t
2 ( x int check ( x > 5 ),
3 y int constraint my_rule check ( y > 10 ),
4 z int not null ,
5 a int unique,
6 b int references t,
7 c int primary key
8 );
Table created.
tkyte@TKYTE816> select constraint_name name, constraint_type type, search_condition
2 from user_constraints where table_name = 'T';
NAME T SEARCH_CONDITION
------------------------------ - -------------------------
SYS_C002674 C "Z" IS NOT NULL
SYS_C002675 C x > 5
MY_RULE C y > 10
SYS_C002677 P
SYS_C002678 U
SYS_C002679 R
6 rows selected.
It has lots of constraints on it six all together. I'll export it, drop the table and import it again:
tkyte@TKYTE816> host exp userid=tkyte/tkyte owner=tkyte
tkyte@tkyte816> drop table T;
Table dropped.
tkyte@TKYTE816> host imp userid=tkyte/tkyte full=y ignore=y rows=n
tkyte@TKYTE816> select constraint_name name, constraint_type type, search_condition
2 from user_constraints where table_name = 'T';
NAME T SEARCH_CONDITION
------------------------------ - -------------------------
SYS_C002680 C "Z" IS NOT NULL
SYS_C002681 C x > 5
MY_RULE C y > 10
SYS_C002683 P
SYS_C002684 U
SYS_C002685 R
6 rows selected.
Looks normal so far. Lets say however, that we rerun the import for whatever reason (it failed part way through for example). What we'll then discover is:
tkyte@TKYTE816> host imp userid=tkyte/tkyte full=y ignore=y
Import: Release 8.1.6.0.0 - Production on Tue Mar 20 15:42:26 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing TKYTE's objects into TKYTE
. . importing table "T" 0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:
"ALTER TABLE "T" ADD CONSTRAINT "MY_RULE" CHECK ( y > 10 ) ENABLE NOVALIDAT"
"E"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with ORACLE error 2261:
"ALTER TABLE "T" ADD UNIQUE ("A") USING INDEX PCTFREE 10 INITRANS 2 MAXTRAN"
"S 255 STORAGE(INITIAL 524288) TABLESPACE "DATA" ENABLE"
IMP-00003: ORACLE error 2261 encountered
ORA-02261: such unique or primary key already exists in the table
About to enable constraints...
Import terminated successfully with warnings.
tkyte@TKYTE816> select constraint_name name, constraint_type type, search_condition
2 from user_constraints where table_name = 'T';
NAME T SEARCH_CONDITION
------------------------------ - -------------------------
SYS_C002680 C "Z" IS NOT NULL
SYS_C002681 C x > 5
MY_RULE C y > 10
SYS_C002683 P
SYS_C002684 U
SYS_C002685 R
SYS_C002686 C x > 5
7 rows selected.
We have an extra constraint. In fact, every time we run this, we'll have an extra constraint added. My named constraint however generates a warning on screen you cannot have the same named constraint twice. The un-named constraint for x > 5 on the other hand gets created again. This is because the database just generated a new name for it.
</quote>
So, why are you doing step 4? If it is just to get public synonyms -- just extract them from the data dictionary into a script (select 'create public synonym ' || .... || .... from dba_synonyms).
And if it is for privs, take this opportunity to get the "least set of privs" in place by only granting in the new database precisely those privileges that are needed.
Database Upgrade using export/imp
Darren, March 14, 2005 - 5:23 pm UTC
Thanks for that update.
Yes I'm doing step 4 as I have a lot of Database users & I want all their roles,privilidges,passwords imported in one shot.
I dont want to exp/imp every user.
March 14, 2005 - 7:58 pm UTC
so, now you know what to expect as a serious downside of that approach.
8i and 9i
abc, March 17, 2005 - 12:41 pm UTC
EOPRD is oracle 8i database so Is it right to say first we need to upgrade it to 9i then have to create EO042
or
New 8i database (EO042) refresh from EOPRD and then upgrade it to 9i.
Please suggest
8i and 9i
abc, March 17, 2005 - 12:42 pm UTC
Apologizes for above statements
ABC is oracle 8i database and I need to create new database XYZ ( shoudl be oracl e9i)
so Is it right to say first we need to upgrade ABC to 9i then have to create XYZ
or
New 8i database (XYZ) refresh from ABC and then upgrade it to 9i.
8i DMTs to 10G LMTs
Susan, April 11, 2005 - 10:07 am UTC
Tom,
We're planning an upgrade from 8.1.7.4 to 10G. The issue I'm facing is that our 8i dbs have Dictionary Managed Tablespaces and I'd like to convert to LMTs - with all the benefits of LMTs. Here's what I understand might be a path that would work:
1. create new 10G db with LMTs
2. pre-create tables, indexes in new db to avoid legacy storage options
3. pre-create users
4. full (?) export from 8i
5. scripts to create synonyms, roles in 10g
6. user import into 10G
Can you comment on my proposed path? Thanks so much.
April 11, 2005 - 10:11 am UTC
well, it'll take a bit of scripting to do that, the full import will tend to create some duplicate constraints and such, not sure that I'd want to have the indexes in place for an import.
Why not:
a) upgrade
b) alter table T move tablespace lmt storage ( initial 1k next 1k pctincrease 0 ) (to effectively "remote" storage clauses)
c) alter index I rebuild tablespace lmt storage (.....)
You can even do that over time, or using online redefs if you like. Something to consider, the exp/imp will take a while to set up and test in my experience.
Here again
Invisible, April 11, 2005 - 11:09 am UTC
OK, this seems like a nice place to ask...
What's involved in an Oracle upgrade, typically? I mean, the version we have is probably unsupported by now, but if it was... What do you usually do? Are consecutive versions able to read the same format on disk? Or do you run it through a conversion utility? Or do you have to do a full export/import? (Never tried to upgrade an Oracle DB before.)
We might be upgrading our application soon - and the new version demands v9 or better. I suspect what will happen is we will use the *application* to export all our data, install the new DB and new application, and then reimport all our stuff. But if the application itself didn't have this ability, what would I be doing?
(I should add that all of this is still in "maybe land" at the present time - everything takes so long to happen here...)
PS. What *is* the latest version of Oracle now? 11 or so?
April 11, 2005 - 11:17 am UTC
Oracle 10g Release 1 is the current production shipping version.
Oracle 9i Release 2 is also available.
"Typical" is in the eye of the beholder. Since you have a 3rd party application, you will have to get the guidance pretty much from them as to how to do it.
Normally, it would go like this:
a) install new software
b) shutdown existing databases (many do this before a)
c) upgrade the databases in place
there is typically no need to unload, reload. The upgrade/migration guide that comes with each release (you can get them from documentation on otn.oracle.com) describes the options in more detail.
Thanks - how about adding Linux to mix?
Susan, April 19, 2005 - 5:55 pm UTC
Hi Tom,
Thanks for your suggestion from above. What if we added converting to Linux in the mix, would that change your suggested approach? We definitely want to upgrade to 10G, we definitely want to take full advantage of LMTs. Now my manager has asked me to think about a Linux conversion, currently on Windows. Of course, a requirement is that we minimize downtime. I'm all for the Linux conversion, but, it seems like a lot of changes to do all at once. Would you do the upgrade on the Windows box as suggested above and then do the conversion? Or, do the upgrade and conversion at the same time since we have to do the OS conversion as a export/import? Thanks so much.
April 19, 2005 - 8:03 pm UTC
Well, the cautious me says.....
an upgrade is a big change. an upgrade and move to new platform is a huge change. I'd rather do two moves, upgrade -- stabilize, move -- stabilize. Each stabilization will be easier than if I throw in a new OS without experience to go with it.
The un-cautious me says....
You have two ways
a) unload, reload (exp/imp, dump/sqlldr, sqlplus copy, database links, mv's on prebuilt tables...)
b) upgrade to 10g and transport the database from windows to linux.
errorr
abc, April 19, 2005 - 9:34 pm UTC
Error
OK
ORA-01400: cannot insert NULL into ("ASK_TOM"."WWC_ASK_QUESTION_ACCESS_LOG$"."DISPLAYID")
April 20, 2005 - 6:45 am UTC
sounds like you hit back into a non-cached page or reload on a page that didn't want to be reloaded.
without any other information....
excellent!
Susan, April 20, 2005 - 10:47 am UTC
Thanks.
DATABASE BUFFER
friend, April 28, 2005 - 1:42 pm UTC
Hi Tom,
I upgraded 8.1.7.4 to 10g and after upgrade database buffer is 0 bytes ..please suggest
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
SQL> show sga
Total System Global Area 247463936 bytes
Fixed Size 1308264 bytes
Variable Size 245893528 bytes
Database Buffers 0 bytes
Redo Buffers 262144 bytes
SQL>
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 3072
db_block_checking boolean FALSE
db_block_checksum boolean TRUE
db_block_size integer 8192
db_cache_advice string ON
db_cache_size big integer 0
April 28, 2005 - 2:06 pm UTC
db_block_buffers is the "old way"
suggest you use db_cache_size instead of block buffers
block buffers in 10g
friend, April 29, 2005 - 3:08 pm UTC
The db startup banner for database buffers show 0 or v$sgastat does not have buffer cache value populated when db_block_buffers are used.
Cause
Hitting bug 3463540
Fix
Use db_cache_size instead of db_block_buffers, or the bug is fixed in 10.2
Upgrade to new physical server and version
Yogesh, October 18, 2005 - 6:37 am UTC
I've to upgrade my existing 8.0 Db to 9.2. But new version will be on new physical box (no existing oracle installation). I think I'll have to install 8 on new box and then use upgrade path. Can you please confirm if my thinking is correct.
October 18, 2005 - 9:13 am UTC
well, read this:
</code>
https://docs.oracle.com#index-MIG <code>
if you are doing the same OS/platform - just different machine, I don't see why you would need to install 8.0, you just need the database files to upgrade.
that guide outlines your options and describes how to upgrade.
Yogesh, October 18, 2005 - 10:53 am UTC
Any specific section in from "Migration"? This link landed to "Database List of Books"?
October 18, 2005 - 11:01 am UTC
the #index-MIG in the url should leave the page postitioned right on the migration guide!
Yogesh, October 25, 2005 - 1:12 pm UTC
I read the migration document which you pointed. But could not find anything specific to "database files upgrade".
Are you pointing to manual upgrade section or anything else?
October 26, 2005 - 8:54 am UTC
what is a "datafile files upgrade"?
you have a database, you are upgrading a database - you follow the database upgrade steps??
Yogesh, October 27, 2005 - 5:08 am UTC
Well in above reply you mentioned
"I don't see why you would need to install 8.0, you just need the database files to upgrade."
So I was looking for something specific to upgrade database files. Looks like my interpretation is wrong.
October 27, 2005 - 6:53 am UTC
ok, could have said:
I don't see why you would need to install 8.0, you just need the database files
to upgrade the database.
Stalled when importing 9i to 10g
Peter, October 31, 2005 - 12:31 pm UTC
Hi Tom
I tried to migrade my oracle from 9i to 10g but when i import into my 10g database always stalled at enabling the constraints. Here is the list
[pw@miserver backup]$ imp marketingsystem/marketingSystem fromuser=marketingsystem touser=marketingsystem file=marketingsystem_2005_10_29.dat log=err.log
Import: Release 9.2.0.1.0 - Production on Tue Nov 1 00:16:24 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . importing table "BUGSLIST" 1 rows imported
. . importing table "CLIENT" 325 rows imported
. . importing table "CLIENTTYPE" 62 rows imported
. . importing table "INTRODUCTIONLETTER" 20 rows imported
. . importing table "MACHINE" 0 rows imported
. . importing table "MACHINETYPE" 2 rows imported
. . importing table "PAPER" 0 rows imported
. . importing table "PAPERPRICE" 0 rows imported
. . importing table "PAPERPRICEHISTORY" 0 rows imported
. . importing table "PAPERTYPE" 0 rows imported
. . importing table "PAPERTYPEHISTORY" 0 rows imported
. . importing table "PROPOSAL" 64 rows imported
. . importing table "SUPPLIER" 0 rows imported
. . importing table "SUPPLIERMACHINE" 0 rows imported
. . importing table "USERS" 6 rows imported
. . importing table "USERSPERFORMANCE" 77 rows imported
. . importing table "USERSTYPE" 3 rows imported
About to enable constraints...
Thank You
November 01, 2005 - 5:11 am UTC
either trace it (use dbms_monitor to enable trace right after you started imp) and see what it is waiting on or use the v$ views that tell you what a session is waiting on/has waited on. (v$session_wait, v$session_event)
v$session will tell you what it is "doing" and that can be joined to v$sql to see what it is trying to execute as well.
upgrade
mo, January 26, 2006 - 8:06 pm UTC
Tom:
I am confused some by the above thread. The question:
1. Can you upgrade database 8i to 10g?
2. Would you recommend upgrading to 9i first instead.
Thanks,
January 27, 2006 - 8:29 am UTC
migration C application from 8i (32 bit ) to 10g (64 bit)
ANOOP GUPTA, April 07, 2006 - 11:40 am UTC
Hi Tom,
We migrate oracle from 8i to 10g. Also we have changed our unix box from solaris 5.6(32 bit) to 5.9(64 bit).
we are using a shared library of 'C' in our code. This library were compiled earlier with 32 bit on oracle 8i, but we need to compile it on oracle 10 g with 64 bit. But while compiling it we are getting some errors.
I tried to find the solution of this by different ways but all are suggesting to include the path for 32 bit libraries in the environment variable LD_LIBRARY_PATH. And the problem of compilation has resolved but while calling the procedures of these libraries we are again facing some errors.
So is there way to compile this 'C' library in 64 bit?? so that both problems can be resloved..
Waiting for your response.............
April 08, 2006 - 9:08 am UTC
Insufficient data. So you have a 'C' library, not sure where or how you are using this in your code. Don't even know if it is like an oci program, pro*c program, external procedure or anything.
"we are again facing some errors" is - well, vague.
Please utilize support (metalink) for this if this is a problem with compiling an oci or pro*c program on your platform.
Migration from 8i to 10g
Anoop Gupta, April 19, 2006 - 9:33 am UTC
Tom,
Thanks for you valuable comments.....
Issue has been resolved there was a problem with .mk file.
Migrate from 9i rel2 (solaris) to 10g rel2 (Red Hat Linux)
Sanji, September 14, 2006 - 8:27 pm UTC
Tom
We are in the process of migrating Database Servers from 9i rel2 on Solaris to 10g rel 2 Linux.
I have suggested dbca's "Template" option for the same.
1> Do you see any issues with the templates from 1 Os to another with different releases of Oracle.
2> Is there a better option.
Regards
Sanji
September 15, 2006 - 6:52 am UTC
you could upgrade the 9i on solaris to 10g and use cross platform transports - or even depending on the byte order of the machines, a full database transport.
Or use datapump when both are 10g
either would be more appealing to me than export/import from 9i to 10g.
but you may use a "template" database - I would use dbca from 10g on the 10g instance (so there is no "cross OS cross version" question) to create the 10g database to start.
migration from solaris to linux (diff oracle versions)
Sanji, September 14, 2006 - 9:12 pm UTC
Forgot to mention Tom. The database size is in excess of 1Tb. Export/ Import has been ruled out.
Regards
Sanji
September 15, 2006 - 6:53 am UTC
see above, even more reason to upgrade solaris first.
Migration from solaris to linux
Sanji, September 15, 2006 - 7:46 am UTC
Tom
Cross Platform transfort/ Full database transport
Does that essentially mean using the Migration Utility ?
Considering that we move from 9i to 10g on Solaris, then how exactly would we do a cross platform transport/ Full Db Transport over to Linux, which would ofcourse be running 10g ?
Regards
Sanji
A reader, September 19, 2006 - 8:16 am UTC
Hi Tom,
Many thanks for your wonderful advices. I am to upgrade 8i tp 10g. The new database will be on a new server. The requirement is..unless the new database is ready, the old needs to be up and running. When the new database is ready,can I apply the backups and archivelogs from 8i(old database which is still in use)to 10g(the new upgraded database)? Or what should be the approcah to make the new database in sync with the existing database?
Thanks.
Santosh.
upgrade from 8.1.7.4 to 9.2.0.7
A reader, October 12, 2006 - 7:04 am UTC
hi tom,
i had to upgrade a database from 8.1.7.4 to 9.2.0.7.
i started the 8i database with 8i binaries. then, i wanted to ensure that the 9i binaries will be able to connect (attach) to the 8i database instance. so, i tried with the 9i binaries a
sqlplus /nolog
connect / as sysdba;
which resulted in a "connected to an idle instance".
when i tried
sqlplus username/password
it resulted in ORA-01034: ORACLE not available + ORA-27101: shared memory realm does not exist + SVR4 Error: 2: No such file or directory...
i CAN startup mount/migrate the 8i database with the 9i binaries (this worked!)! so, i assume that it is not possible to ATTACH with 9i binaries to 8i SHARED MEMORY segments (as the segment allocation is another, afaik).
Q1) is this correct?
Q2) the 9i DBUA could attach to the 8i instance!? how is this possible?
October 12, 2006 - 8:27 am UTC
your oracle home and oracle sid are used to attach to the shared memory segments when you don't use sqlnet (as you did above - no net).
your oracle home would have been the 9i oracle home, not the 8i oracle home, hence - it won't work.
use sqlnet to connect 9i clients to 8i
the upgrade assistant won't connect to an 8i instance, 8i will be out of the picture by then.
PLEASE DO read:
</code>
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage#index-MIG <code>
the migration guide from cover to cover.
upgrade from 8.1.7.4 to 9.2.0.7
A reader, October 13, 2006 - 9:23 am UTC
tom, thanks for the answer.
i remember something about the oracle home, sid and shared memory attachment now as you told it. thanks.
i read the migration guide but can't find anything about the state the database should be in BEFORE we start the DBUA. should it be closed, in nomount state, mount state or opened? should it run on the old or the new binaries? nothing to find about in the guide!
i opened the database with the old 8i binaries because i could not open it with the new ones (only startup migrate would have been a working option). the 9i DBUA DID ATTACH to the 8i instance (listener was down)!
October 13, 2006 - 2:33 pm UTC
you run the dbua from the new oracle home, the old binaries - don't even need them.
tell you what, I'll suggest you open a tar with support to accomplish what you need, they can perhaps point you to some notes for this installation/configuration type of question.
How can i migrate and upgrade on same time !!
Charlie, November 13, 2006 - 10:34 am UTC
Hello Tom,
Can you please guide me how to migrate a existing 8i database from one server to another server in 9i. I have cold backup of 8i database.
Please let me the procedure to migrate and upgrade one thing i would like to highlight oracle 8i is not available in new box.
Thanks for your response.
EXP vs Upgrade
Rich, January 29, 2007 - 2:36 pm UTC
Hi,
Some of the databases I use, where upgraded from an Oracle 7 database upgraded to 8, then 8i, then 9i. I am thinking about migrating this database to 10gR2.
I have experienced many bugs or invalid objects that came from objects not upgraded properly (nor unremoved...). I wasn't the one who upgraded those databases, so I am not sure if this has been done in the proper way.
Since the database went through so many migrations, do you think that using imp/exp to go to 10g would help get rid of invalid or "orphans" objects that once belong to another versions?
January 31, 2007 - 1:21 pm UTC
are you thinking about doing user level exports? would not necessarily suggest a full database export. how much table data are we talking about here?
Basic Question
Chi, February 02, 2007 - 12:42 pm UTC
I have a very basic question. Do you think it's worthwhile to create separate users for each version of Oracle? In my Windows environment I use only user for all versions. In my Tru64 development box, I have one for 816, another one for 817, and yet another one for 92. It seems to me that is totally unnecessary. I'm in the process of upgrading my production 817 databases to 9i. I like to hear your opinion before I start installing Oracle 9. Thank you.
February 02, 2007 - 1:44 pm UTC
If you have a production environment, there would only be one install anyway right? I mean the only good number of Oracle instances on a server is one - no more.
it is entirely up to you - on my test/play boxes, I keep them physically separated by version and user. One a real machine, there is only one version.
Basic Question - Follow Up
Chi, February 02, 2007 - 2:15 pm UTC
Thank you for quick response.
I agree with you that I should maintain just one version in the production environment. Unfortunately I'm in a position that I may need to maintain multiple versions (I have been trying to get a time slot to upgrade the OS for over a year now). It seems to me that all I need to do is to create a shell script to set ORACLE_HOME and PATH to the version I choose, I would be able to maintain multiple version with one user. I can then use DBUA to perform the upgrade when I'm allowed to do that. Is there anything more I need to do? Thanks for the advice.
February 03, 2007 - 7:18 pm UTC
it is entirely up to you and what makes you "feel good".
If you want to use OUI, it would pretty much almost mandate a single user account holding all of the software (permission issues, that could be gotten around with some chmod'ing)
upgrading DB from 10.2.0.1.0 to 10.2.0.3
Dawar, February 20, 2007 - 11:38 pm UTC
Hello Tom,
OS: IBM/AIX 5.2
DB: 10.2.0.1.0
I am upgrading DB from 10.2.0.1.0 to 10.2.0.3.
What are the steps involved in upgrading the DB?
My understaning is to apply particular patch will upgrade the system.
Are there any thing else, I need to look at it?
Any feed back will be appeciated.
cheers
Dawar
February 21, 2007 - 10:51 am UTC
the step is:
a) read the readme that always comes with the patchset, it'll tell you precisely what you need to do, what you need to know
upgrading DB from 10.2.0.1.0 to 10.2.0.3
Dawar, February 21, 2007 - 12:43 am UTC
Is this patch (5337014 ) upgrade the DB from 10.2.0.1 to 10.2.0.3 on AIX?
If not please give ur feed back on my previous question?
upgrade 9i to 10g
Aashar BUTT, May 06, 2007 - 8:51 am UTC
Dear Tom,
Is it possible to upgrade 10gR2 database on 9iR2 without installing 10g seprately?
Regards,
May 08, 2007 - 10:23 am UTC
I don't know what that means, you would install 10g - yes. I don't know what "separately" means in this context
upgrade to 10g
Aashar BUTT, May 10, 2007 - 6:36 am UTC
What i mean from installing seperately is when i am going to start installing 10gR2, it asks for a NEW SID and location to install although oracle 9iR2 is already installed on my server. Is there a way that my installing location and specially the SID name remain the same?
Can you redirect me to a link from where i will get the information on upgrading to 10g from 9i on windows 2003 server machine?
now second question has come, i was reading over the internet regarding partitioning feature in 10g. I came to know that it requires a seperate license for that? that is weird. I have bought the whole 10g suite and now i have to buy license again for partioning.
Is there a way to check from oracle CD or from oracle website whether i have the license for it or not?
May 11, 2007 - 10:42 am UTC
give it NO sid, you aren't creating a database. I don't know why you are giving it a sid at all.
otn.oracle.com -> documentation, the installation guides, release notes, everything is right there.
You bought a license for a specific product (maybe standard edition, maybe enterprise edition, maybe SE-1 - maybe named users, maybe by cpu, maybe maybe maybe). They come with different feature sets. They have different options available to be purchased on top of that.
Sort of like getting leather heated seats in a car. You don't need them perhaps (looking at your location), but I sort of like them in the winter over here. They are an extra cost option to my car.
Most software packages of any size have this.
otn.oracle.com=> documentation -> license guide, tells you what you have.
javaw.exe
Aashar BUTT, May 13, 2007 - 6:53 am UTC
Dear Tom,
I am facing a problem in installing oracle 10g on windows 2003 server. when i press "NEXT" after selecting basic or advanced installation,the OUI.exe never starts. i found out from the task manager that javaw.exe kill itself. Altough i have tried installing oracle 10g on other machines with win xp,windows 2000 and windows 2003 installed on it and it works fine. This is the only machine i am having problem with. I have even updated the JAVA version to 1.6.
Regards,
May 14, 2007 - 1:59 pm UTC
please utilize support.
oracle 10g
Aashar Butt, June 03, 2007 - 11:02 am UTC
Dear Tom,
Can i perform a direct update of oracle 10g R2 on oracle 9.2.0.1 or do i have to update 9i to patch version 9.2.0.4 first?
proxy
Aashar BUTT, June 11, 2007 - 4:13 am UTC
Dear Tom,
Finally, i have upgraded from 9i to 10gr1. Still i am not able to upgrade to 10gR2.
Tom how can i access the EM with a proxy server. I have ISA installed in the company?
June 11, 2007 - 10:00 am UTC
please utilize support for stuff like this.
Different OS User?
Maria Saavedra, June 11, 2007 - 4:29 pm UTC
Hi Tom.
We have an 8.1.7.4 DB and we want to upgrade to a 9.2.0.7 DB ... but do we need to have two OS users?? one for the original Oracle Home(8.1.7.4) and one for the target Oracle Home (9.2.0.7) ?? ... or instead ... we can work with just one OS User with two Oracle Homes .. and switch the environment variables when we are going to start the Upgrade Assistant o Manual Upgrade?
Thanks!!!
June 11, 2007 - 6:03 pm UTC
you would use the same OS user.
you would read the upgrade/migration guide
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage#index-MIG you would read the README that comes with the 9i software
then plan the upgrade....
actually, in the year 2007, if you upgrade to 9iR2 - I'd have to ask "why". 10gr2 should be your target by far.
Upgrade from oracle 8.1.6.0 , 8.1.7.0 to oracle 8.1.7.4
A reader, August 06, 2007 - 2:54 pm UTC
Hello Tom,
We have oracle 8.1.6.0 and 8.1.7.0 and we are planning it to upgrade either 8.1.7.4 or 10g. I know your suggestion would be 10g but its not really in my hand to decide.
I have checked into metalink but i coudn't find ugrade document for 8.1.6 to 8.1.7.4
1) can you suggest any document for 8.1.6 to 8.1.7.4
2) to upgrade from 8.1.7.0 to 8.1.7.4 i think i need to apply a patchset. Is my understanding right or is there any other method for this.
Thanks
Alexander the ok, August 07, 2007 - 11:25 am UTC
Tom,
I'd be interested to read an article by you titled "Why people don't upgrade". I see so many people on this site using ancient versions of Oracle. Seems prevalent enough to add to your top list of things "done wrong", or however you want to phrase it.
upgrade and migrate from (9i/HP-Parisc) to (10g/HP-Itanium)
sajad, August 08, 2007 - 2:59 am UTC
Could you please provide me the best approach to be used for upgrade and migrate from (9i/HP-Parisc) to (10g/HP-Itanium)with current datasize of around 1.3 Terabites.
August 14, 2007 - 9:46 am UTC
read the migration guide
do the upgrade
the size of the database won't impact the time to upgrade in as much as the number of objects (plsql code for example) that need to be recompiled.
upgrade from desupported version 8i to 10g on desupported OS
Dario P, April 21, 2008 - 12:33 pm UTC
Hi Tom:
I will risk myself to be punish :-)
My english is poor, so... I apologize in advance.
Currently, there is an oracle 8i (8.1.7.4) on AIX 4 host (two actually), acceded by a mod_plsql application. Since customer has decided to change architecture and use a linux OS, we face two changes.
Reading migraton guide and your previous comments, I think the cleanest migration path could be:
- change OS and arch:
install linux 8i on linux, and exp/imp from AIX to linux.
- upgrade DB:
Perform upgrade using DBUA o manual upgrade.
1) can avoid exp/imp? (no to my knowledge)
Specifically, I'm challenged by the task of installing Oracle 8i on linux.
- Should I try to install oracle 8i on a newer linux (OEL4 or OEL5; not supported, but customer is out of support anyway) or is this a dead way?
I have done an attempt and, basically, to my understanding, gcc compiler and its architecture has changed beyond any recognition, and it doesn't seem very feasable, but...
- Should I install an old linux supported by Oracle 8i on any hardware (or virtual apliance, since installing and old linux on new hardware could be problematic) and later install 10g on a current linux and copy datafiles (probably without DBUA, not sure).
As an extra data, there are two databases, dblinked each other, and I think both must be migrated.
Thank you for your reading.
April 23, 2008 - 5:14 pm UTC
if you exp/imp - you will not need to install 8i on the other both, you exp with 8i, you import into 10g.
Since you don't have the ability to put 10g on the existing platform, export/import is probably the way to go, no way to get that database up to 10g on the existing platform to do a cross platform transport.
upgrade from desupported version 8i to 10g on desupported OS
dario, April 24, 2008 - 9:51 am UTC
No, I can't install 10g, the hardware is dying... literally. Can't go on details... It's gory :-)
Thank you for your answer.
upgrading a database from 9i to 10g
Zahir M, July 23, 2008 - 12:30 pm UTC
Tom :
I have 9i database ( size 650 gb ) on AIX . I want to upgrade it to 10g on 64 bit Windows .
What is the optimal way to move the data from AIX to Windows .
Thanks
July 24, 2008 - 10:30 am UTC
upgrade 9i to 10g
use cross platform transportable tablespaces, that would be a rather fast way to move the data, then install your application code.