eroen
-Oorspronkelijk
bericht-
Van: Jeroen
van Sluisdam [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 27 november 2003 19:09
Aan: Multiple recipients of list
ORACLE-L
Onderwerp: RE: migration sequence
oci problem
We could narrow it down to the value of the sequence exceeding
16777216 (2 to the
Jeron,
I don't know if it would help any, but if it is a DB
issue, event 10217 might be useful:
$ oerr ORA 10217
10217, 0, "debug sequence numbers"
// *Cause:
// *Action:
I have never used it myself before, but if you push
support a bit maybe they might provide details on how
this can be use
We could narrow it down to the
value of the sequence exceeding
16777216 (2 to the power of 24)
This looks familiar as described in bug 2573172
This bug describes to change the type in the odefin call to type 3 but this doesn't help.
I know this is not really a dba
issue now anymore but I
Paula,
I moved a database (Sun box) from 32 to 64 bit Oracle 9.2.x. I did nothing
except point the database to the 64 bit Oracle software. Of course, it was
the same release levels (32 & 64 were both 9.2.x). Everything is fine.
At the very least, I would think that you need to run catalog & ca
|
| To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
|
| cc:
|
| Su
Thanks Dick. It is worth a try.
-Original Message-
Sent: Thursday, November 13, 2003 6:35 PM
To: Multiple recipients of list ORACLE-L
To the best of my knowledge, & I've done this several times now, you run the
appropriate upgrade script then the utlirp.sql script to migrate from 32
To the best of my knowledge, & I've done this several times now, you run the
appropriate upgrade script then the utlirp.sql script to migrate from 32 to 64 bit.
Now you must have the 64 bit executables installed or it creates some interesting
results. But you don't have to rebuild the database
So - this is a stupid question:
We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i?
- Hmmm, create database , export, import.
-Original Message-
Sent: Thursday, November 13, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
It's actually an sql script tha
It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory
called utlirp.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 10:39 AM
To: Multiple recipients of lis
Hi Stephane,
The way you put it here would mean that the internal format of the
tablespaces will be big/little-endian independant.
That would mean either an extra amount of overhead in the low level IO,
or
Oracle-specific arithmatic everywhere in the kernel. I doubt
whether
Oracle would do that.
Well, I don't know about it's performance, but I think this conversion
doesn't require any temporary space, because the byte values of some
structures in blocks have to be swapped, and this a trivial operation.
I think it may still be faster, especially if we are dealing with huge
amounts of data,
Tanel,
Any idea about speed and temporary storage requirements? Especially for 32G+
datafiles ;-) ?
Wondering if it will really be useful in practice, compared to what is available
today. Well, it may do for simpler operations, but not necessarily faster.
SF
>- --- Original Message
You can't just copy over the files with os commands and hope that Oracle
will somehow recognize them.
You have to use RMANs new convert tablespace command to do the byte order
conversion.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Mon
It raises an interesting question. As of today, we have datafiles which are OS
dependent and _not_ binary compatible from one system to another. We upgrade to 10g
and it will become magically binary compatible. Which means that the upgrade process
will do more intimate things than updating some
Wait for 10g. They say that you could just copy the datafiles and them plug
them in to he new database, even across platforms.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 10, 2003 12:24 AM
> Hi List,
>
> C
> Hi List,
>
> Could someone please help me?
>
> Assumption situation - Platform migration of Oracle DW on Oracle DB (data
> volume 3.5 TB) from HP-UX to IBM-AIX
>
> 1.. DB migration; it is correct to use Export/Import technique/method in
> the above assumption?
Use exp/imp only for transporting
"A. Teles" wrote:
>
> Hi List,
>
> Could someone please help me?
>
> Assumption situation - Platform migration of Oracle DW on Oracle DB (data
> volume 3.5 TB) from HP-UX to IBM-AIX
>
> 1.. DB migration; it is correct to use Export/Import technique/method in
> the above assumption?
No. W
Title: Message
Your
right, sorry. My brain is fried today.
Thanx,
Alan
-Original Message-From: Weaver, Walt
[mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003
5:20 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Migration 9201 to 9203 doc needed
Title: Migration 9201 to 9203 doc needed
Unless I’m really missing something,
going from 9.2.0.1 to 9.2.0.3 is just a patch install, and the README.html
included in the patch should tell you what you need to do.
--Walt Weaver
Bozeman, Montana
-Original Message-
From:
This would be alot of extra work and downtime compared to export/import but...
1) upgrade to AIX 4.3.3 You might want to think about using AIX 64 bit here
(you can still run Oracle on 32 bit if you want).
2) upgrade to 8.1.7.4
3) AIX 4.3.3 is binary compatable with 5.1, so you _could do
If you cannot recover the database, you *** CAN *** take a cold backup
and open it elsewhere, on a 5.2 box, for example. You only have to make sure
that you loaded the right post_wait extensions. I advise you to use the ones
from 9.2. Boot the machine in 32 bit mode. No migration is necessary, col
I don't think the cursor sharing will help. We've been going 'round and
'round with the shared pool fragmentation problem and the 4031 errors.
Flushing the shared pool might or might not work; sometimes it cleans things
up; sometimes it doesn't do anything (as far as I can tell). About all you
c
Looks like a whole set of bugs we haven't come across YET
-Original Message-
Sent: 20 June 2003 10:14
To: Multiple recipients of list ORACLE-L
After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8
following NON-Documented parameters were set by Oracle Co
Hi
We had a different problem with our upgrade but the same error message -
there is a patch available from Oracle that is supposed to help(did n't for
us though)
Regards,
N.
-Original Message-
[EMAIL PROTECTED]
Sent: 01 April 2003 09:04
To: Multiple recipients of list ORACLE-L
Hi gu
An ora 1452 error says there are duplicate keys, hence you can't create a
unique key. If it is a known, death be unto me if I am wrong, 100% fact
that the unique key was valid in the original data, the first question I
would ask is: Was this an import that is being run with commit=y ignore=y,
abo
How about checking out the part of the import log where it
tells you which character sets are being used?
Jared
"Peter R" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/17/2003 03:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTE
How about using SQL Server's DTS ? So long as you have Net8 plus an OLEDB
driver for Oracle installed on your SQL Server box you can just shift the
tables across. Point and click in true SQL Server fashion, you can't go
wrong.
Ade
-Original Message-
Sent: 04 February 2003 14:40
To: Multip
Another thought is to use DTS to handle at least some of the transfer for
you. SQL Server's DTS (Data Transformation Services) package will be able
to connect to Oracle, create the table structure and import the data for
you. You are on your own as far as foreign keys and primary keys, etc. But
Read-up:
http://otn.oracle.com/documentation/oracle9i.html
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon Tiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 h
Babu - Congratulations on the project! Is this database especially large or
are you facing severe restrictions in terms of the amount of time the data
is unavailable to your users? Are there any unusual objects in SQL Server
that will be difficult to create in Oracle? I think Oracle provides a
migr
Look into Oracle Migration Workbench (on technet, it's free).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 04, 2003 4:18 AM
> Hi Listers,
>
> We are planning to migrate one of our
Best option is to use bcp to get the data out of Sybase ino a flat file,
then use SQL*Loader to get the data into some Oracle staging tables. You can
then use pl/sql procs to move the data to it's final destination.
Ade
-Original Message-
Sent: 29 January 2003 12:49
To: Multiple recipient
vijay,
oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects & data from sybase to oracle.
however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you
We attempted to use OID 3.0.1 for our LDAP implementation, but OID cannot
accept all v3LDAP-compliant LDIFs, despite what their marketing says. When
we filed a TAR, Oracle Support's solution was to have us Oracleize the
industry-standard LDIF. Wrong! This same LDIF file has since been imported
Hello Bp
Make sure that you upgrade the databases and the clients
to 9i before you move the LDAP.
I do not know about client 8.1.7, but client 8.1.6 can not
talk to 9i LDAP.
Yechiel AdarMehish
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE-L
S
]
09/11/02 10:53 AMcc:
Please respond toSubject: Re: Migration Assistant
Speeds
Keep in mind that the actual change to DB internal header blocks
does not occur until they are actually read into the DB. Therefore
I launched an ANALYZE to build statistics which ran 12 - 14 hours.
-- I shall go for full export with direct=y recordlength-65535 and
file=/dev/null which may be m
I did a 150GB V7.3.4.5 upgrade to V9.2 in less than 2 hours.
Keep in mind that the actual change to DB internal header blocks
does not occur until they are actually read into the DB. Therefore
I launched an ANALYZE to build statistics which ran 12 - 14 hours.
THT & YMMV!
See otn.oracle.com for Oracle Migration Workbench.
-Joe
--- Arslan Bahar <[EMAIL PROTECTED]> wrote:
>
> How !?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Arslan Bahar
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX:
Last time I moved a server from one data center to another we just powered
it down, unplugged it all, rolled it down the hall to the other data center
and plugged it all back in. Did this without affecting production too. Of
course production was halted due to a network upgrade but that's not th
Hi Guri,
If you don't have time to make a backup before moving a machine to a
different site at least take the time to update your resume and put it
in a safe location.
Good Luck,
John
[EMAIL PROTECTED] wrote:
>guri,
>
>If you don't have the time to get the cold backup to removable media,
[EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: MIGRATION
>Date: Mon, 25 Feb 2002 11:28:41 -0800
>
>Guri,
>
>When we move hosting centers, we certainly prefer to do it with some
>overlap. We usually move our machines with the
Guri,
When we move hosting centers, we certainly prefer to do it with some
overlap. We usually move our machines with the test databases, create
enough room to make standby databases for production. That way we can
halt the production databases, activate the standby's and switch our
application
Here's something to keep in mind...
It seems on Friday, Feb. 15, Interland picked up a few
of the servers it was hosting, placed them on a truck,
and then moved them to a new facility with a new IP
address -- without notifying at least one disgruntled
customer. The move left our reader unable to
Hi Dick,
According to the 9i Migration Utility Guide, the Mig Utility that comes
with 9i will migrate 7.3.x database to 9i directly. Unfortunately we had no
7.3.4 database to migrate to 9.0.1. So I have not had a chance to test it
myself. We migrated several 7.3.x database to 8.x using Mig Util w
Not to my knowledge. But there are other 3rd party tools to unload and load
data.
Any particular reason to not use what's provided by Oracle?
- Kirti
-Original Message-
Sent: Thursday, February 07, 2002 12:08 AM
To: Multiple recipients of list ORACLE-L
Hi
Is there any Migration uti
These errors have to do with advanced queueing. Do you have AQ_TM_PROCESSES set to
any value other than 0? If you do, set it to 0 during the upgrade. N.B., this is a
mere guess based on the information provided.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Origina
d.Still@ra
disys.comTo: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject:
The best advise is to *read* the migration manual.
Then build a test database and document the steps
needed for your site to do the migration.
This actual steps needed from the migration manual
is highly dependent on your environment.
Jared
Seema - For this amount of data, you might consider a "clone" technique. Go
to http://www.orafaq.com and search on "clone".
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 25, 2001 10:10 AM
To: Multiple recipients of list ORACLE-L
Hi
I w
Migrating is the process of transforming one database version to a later
database version. Oracle 7 to Oracle 8
is migration.
Upgrading is the process of transforming one database release to another
database release of the same database
version. Oracle 8.0.1 to 8.0.5 is upgrading database.
HTH
Erik - I believe the upgrade / recovery manual will have the more concise
definition you seek. Look for the Oracle version you are on and the one you
want to move to and it will tell you whether you need to upgrade or migrate.
With an upgrade you usually just bring up the new version and run some
You don't migrate a database from 8.x to 8.x, migrations happen between
major version numbers(like 7 to 8), heck 8 to 9 isnt even a migration
nowadays.
anyway, break out the migration guide( a misnomer at best) and start
reading the chapters on upgrading from 8.0 to 8.1.
joe
>>> [EMAIL PR
ALL_ROWS is not always good for OLTP, is this an OLTP environment? Perhaps
FIRST_ROWS is better, perhaps not.
I would recommend sticking with CBO, properly tuned, it is generally faster
in all cases, although you sometimes have to use hints to make up for an
incorrect plan choice. Like you said
In your case, i would have used offline instantiation. Have a look at the
replication manual!
Cheers
> -Original Message-
> From: Mike J Kurth [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 18:51
> To: Multiple recipients of list ORACLE-L
> Subject: Migration of simple
glad to see it worked for you. I hate to see people go through the same run
around I did.
Reed
-Original Message-
Sent: Monday, July 02, 2001 5:26 PM
To: Multiple recipients of list ORACLE-L
Thanks, Reed, I'm in. Guess you had the same problem cause I found nothing
on Metalink.
Dav
Thanks, Reed, I'm in. Guess you had the same problem cause I found nothing on
Metalink.
Dave
-
There is a bug in migration workbench that you have to make sure that your
root password on the mysql database is 8 characters long, then specify that
passwor
There is a bug in migration workbench that you have to make sure that your
root password on the mysql database is 8 characters long, then specify that
password when connecting through migration workbench.
This should clear up the handshake error.
Hope this helps.
-Original Message-
Sent
Oracle provides a tool for this. I have seen it
used successfully.
OLE Objects? Dunno
-Original Message-
Sent: Thursday, June 21, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L
Has anyone done migration of a Access dbs to Oracle . The access dbs has OLE
objects which
After engaging Oracle WWS concerning this issue we have learned that there
have been a significant
number of complaints regarding performance when upgrading to 8.1.6.x.
It appears that re-running your ANALYZE is not enough.
Dropping statistics and then running ANALYZE might be required.
--
The thing that is killing us is a single query.
This query does a group by.
It also references some user-defined functions in the column-list of the
SELECT statement.
These user-defined functions are actually SELECTS from 2 other small
tables.
It is not behaving the same way it did in versio
Dan:
What kinds of problems ? I am beginning a migration of a hybrid OLTP / OLAP
database from 7.3.4 to 8.1.5 on Solaris 2.6 We are planning to take 6 weeks to "clean
up" the
database and fix the chained /migrated rows before we migrate (mainly on the big
tables). We will spend a month tes
62 matches
Mail list logo