- Production
The application has a lot of Pro*C programs.
--
We are planning to have the development/test DB on Linux 2.4 on
Intel platform.
We will be doing modifications/upgrades to the application and
DB
and will be applying the changes to production.
Will there be ANY kind
a lot of Pro*C programs.
--
We are planning to have the development/test DB on Linux 2.4 on
Intel platform.
We will be doing modifications/upgrades to the application and DB
and will be applying the changes to production.
Will there be ANY kind of compatibility problem (relating to OCI
Hi!
Our production environment is on Sun OS 5.8 sparc.
[snip]
The application has a lot of Pro*C programs.
--
We are planning to have the development/test DB on Linux 2.4 on
Intel platform.
We will be doing modifications/upgrades to the application and DB
and will be applying
are planning to have the development/test DB on Linux 2.4 on
Intel platform.
We will be doing modifications/upgrades to the application and DB
and will be applying the changes to production.
Will there be ANY kind of compatibility problem (relating to OCI,
or plsql procs etc) ?
Thanks in Advance
Regards
Hi:
Thanks to everyone who responded to my message on Cross Platform
Migration... I will update the list if we come to any conclusions not
consilient with the findings given on the list..
Thanks Regards,
Sashi
Sashidhar Kondareddy
Project Manager
IT Solutions Inc, a SEI CMM Level 5
Exp/imp of a 200GB database is possible, but I'd think the time required would be the
long pole in the tent. I'd say your looking at at least a 4 day weekend at best and
only if you used direct mode. Someone has hinted that you can simply move the
datafiles from one box to the other. Well
You may want to review an article, Cross Platform Migration of a Large Production
Database, in
the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG).
The author details the procedure he followed to migrtate a 300GB production database
from HP-UX to
IBM AIX.
- Kirti
--- Goulet, Dick
Aah !Hint, hint that some certain RDBMS vendor will offer cross-platform
compatibility of database files soon.
Hemant
At 04:14 AM 07-06-03 -0800, you wrote:
Sashidar:
In THEORY HP datafiles and Sun data files are compaible. That is you
can just move the HP data files to the Sun server
1. Join the 10i beta program
2. Convert your 9.2 datafiles using the cross-platform transportable
tablespaces feature of a dummy 10i instance.
;-)
Or...
Back when one of our system swas at around 200M, we had a C program
that dumped table data in parallel by rowid ranges, wrote the streams
Direct mode doesn't work across platforms [or, at least, I haven't tried
it]. It isn't supported.
SQLLDR, Parallel Export-Import, Parallel Index Build are options -- these
can be done
in parallel. Run at least two rounds of testing to see how you can migrate
the data.
Hemant
At 06:29 AM
Wondering out aloud here. Could you export/imp using
pipes. I remember doing this on a 200gb database
going from 7.3 to 8 on Solaris, granted on the same
server. Took about 4-6 hours if I remember correctly.
Anyway to create a remote pipe on another server to
listen for inputs from another
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/09/2003 07:59 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over
dblink or ..
You may want to review
Hi all:
We are considering migration of an Oracle eBusiness Suite 11.5.8 from
HP-UX 11.0 to Solaris9.
I'd like to know if anyone has done this and how daunting the task is.
Are there any 3rd Party tools which can help out?
Coming to the conventional approaches:
1. What do you think of
Sashidar:
In THEORY HP datafiles and Sun data files are compaible. That is you
can just move the HP data files to the Sun server and recreate the data
files. Both data files are in same endianness and they are cross
platform compatible.
There is no tool to convert a datafile from one OS format
and they are cross
platform compatible.
There is no tool to convert a datafile from one OS format to another OS
format. Some time back, some one (Guess who??) tried developing a tool
and the idea was dropped since Oracle started addressing this issue as
a standard feature inside the RDBMS product. So
datafiles and Sun data files are compaible. That is you
can just move the HP data files to the Sun server and recreate the data
files. Both data files are in same endianness and they are cross
platform compatible.
There is no tool to convert a datafile from one OS format to another OS
format. Some
Title: RE: Weirdness
Probably a bit "OT" here, butanyone have any pithy
rejoinders
about
doing cross platform RPC...or how MS RPC is different from,
say,
ONC/Sun RPC?
I am
about to get into something where this will matter, and I am
just
dipping a toe in the water
about doing cross platform RPC...or how MS RPC is different from,
say, ONC/Sun RPC?
I am about to get into something where this will matter, and I am just
dipping a toe in the water.
thanks in advance for any thoughts, including those scurrilous off topic comments!
;-)
- Ross Mohan
pithy rejoinders
about doing cross platform RPC...or how MS RPC is different from,
say, ONC/Sun RPC?
I am about to get into something where this will matter, and I am just
dipping a toe in the water.
thanks in advance for any thoughts, including those scurrilous off topic
comments
If you are interested I found the answer on metalink:
select dbms_utility.port_string from dual;
Ivo
-Original Message-
Sent: Wednesday, September 26, 2001 02:09 PM
To: '[EMAIL PROTECTED]'
Hello
how is it possible in PLSQL to decide on which operating system (NT/LINUX)is
server
Hi,
You can always check for the location of the datafiles.
Their location on nt should start with {A-Z}:\ and can be evaluated
through a substring command or something
Jack
Libal, Ivo [EMAIL PROTECTED]@fatcity.com on 26-09-2001
15:10:23
Please respond to [EMAIL PROTECTED]
Sent by:
How about trying one, build an exception, and on exception try the other ?
HTH, Remco
-Oorspronkelijk bericht-
Van: Libal, Ivo [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 26 september 2001 15:10
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Platform
Hello
how is it possible
I presume you mean utl_file, not dbms_file. Doesn't this need the utl_file
parameter set up with the available directories - could you just check to
see if this parameter includes c:\log or /log
- Bill.
At 05:10 26/09/01 -0800, you wrote:
Hello
how is it possible in PLSQL to decide on
Title: RE: Platform
I've also used this query:
select substr (banner, 9, instr (banner, ':') - 9) as os
from v$version
where banner like 'TNS for %' ;
Because port_string is sometimes cryptic. For example, on my 7.3.4 database on Sun Solaris, here's what I get:
SQL select
On Wed, 15 Aug 2001, [EMAIL PROTECTED] wrote:
Guess the bottom line is the behavior of a released connection
is platform dependent.
What do you guys think? I would hope this isn't the case.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Galen Boyer
INET
Guru List,
Does anyone have any documentation or recommendations for setting up Oracle
to run the PeopleSoft application on HP9000 64 bit, such as layout of files,
init parms, initial and next extents, tuning parameters etc?
Any help is appreciated!
Willie
--
Please see the official
Guru List,
Does anyone have any documentation or recommendations for setting up Oracle
to run the PeopleSoft application on HP9000 64 bit, such as layout of files,
init parms, initial and next extents, tuning parameters etc?
Any help is appreciated!
Willie
--
Please see the official
Hi Roland,
(DISCLAIMER - I have no interest in Pacemaker software, other than that Paul
has a good product)
I use an editor called CRiSP extensively - it is a GUI-based version of a
character based editor called Brief (from Underware), that got bought by
Borland (remember them ...).
It runs
Hi List,
Currently, we are running Oracle Application 10.7 ( GL
and AP modules, character mode) + Oracle Database ..
all of them on one AIX box, so now we have plan to
move Oracle database to SUN Solaris, and still kept
Oracle application on old machine. I wonder about the
Oracle Application
29 matches
Mail list logo