Re: RAC or Oracle Fail Safe

2003-07-20 Thread Tanel Poder
Title: RE: RAC or Oracle Fail Safe




Hi!
Of 
course you have to plan your servers' capacity accordingly, that in the event of 
node failure, the other node will not get too loaded. When one node crashes, the 
second one has to deal with queries and transactions of both servers and we must 
not forget, that also rollback of failed nodes uncommitted transactions has to 
be done!

Of 
course when you got more nodes, then the impact of one node failure would be 
smaller..

Tanel.


  
  Here I 
  would beg to differ. RAC is more safe. _Almost_ half of your online user (who 
  are on surviving node) won’t even notice the node failure when one node in a 
  RAC environment goes down. And those who were unlucky users (connected to 
  failed node), can connect immediately to the surviving node, without any 
  delay. Of course you need to configure these parameters manually. While in OFS 
  environment your users have to wait till the time surviving node brings up the 
  database and all related services (listener etc) completely. 
  
  The 
  price you may for these features is more money and more complex database 
  environment to manage.
  


Re: imp table data, but not PK indexes?

2003-07-20 Thread Tanel Poder
Hi!

 Yes, but IIRC CONSTRAINTS=Y is an exp parameter,
 not imp?

It's imp parameter as well.

 Best way to handle these things is to export twice.
 Once with all the bells and whistles turned on but
 ROWS=N (this gives you a small export file with all
 the schema logic added and takes no time at all).
 The next one is with CONSTRAINTS=N, ROWS=Y, INDEXES=N,
 DIRECT=Y.  This one is used for bulk data load.

I'd go that way:

1) export schema structure with rows=n
2) export data with constraints=n rows=y indexes=n direct=y
recordlength=65535
3) import structure file w. indexes=n constraints=n
4) import data file w. buffer=high value (constraints=n and indexes=n don't
have to specified if export was set not to export them)
5) import structure file w. constraints=y indexes=y indexfile=indexfile.sql
(nothing is actually imported, we just get constraint indexes and excplicit
indexes DDL statements into text file)
6) modify indexfile.sql and add nologging + possibly parallel clauses to
your DDL statements. Also you might want to alter session set
db_file_multiblock_read_count and sort_area_size to larger values in
beginning of your script.
7) import your data file, with buffer=big value
8) run your indexfile.sql script
9) import structure file again with constraints=y indexes=n and ignore=y

Note that indexfile created in step 5 will contain only non-system-generated
indexes! (you can check generated field in dba_indexes to see which are
system generated ones). Thus, indexes which are implicitly created using
primary and unique keys, won't show up in indexfile. But that doesn't kill
us - imp with constraints=y will eventually create these indexes anyway, we
just can't control the DDL command issued for them (you might want to set
tablespaces storing these indexes NOLOGGING temporarily during their
creation).

Also, if you plan to shorten your downtime by first exporting/importing the
structure from online database and then transferring data during downtime,
you have to worry about your sequences, because they have probably
incremented after structure export and data export. Thus a simple script has
to be done for that (thanks John ;).

Tanel.


 With these two exports, one can do just about any
 manipulation needed.

 Cheers
 Nuno Souto
 [EMAIL PROTECTED]



 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Nuno Souto
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: imp table data, but not PK indexes?

2003-07-20 Thread Nuno Souto
- Original Message - 

 2) export data with constraints=n rows=y indexes=n direct=y
 recordlength=65535
  ^^
Do you find that makes a real difference?
I haven't had much success with it...


 Also, if you plan to shorten your downtime by first exporting/importing the
 structure from online database and then transferring data during downtime,
 you have to worry about your sequences, because they have probably
 incremented after structure export and data export. Thus a simple script has
 to be done for that (thanks John ;).

Good point, thanx!

 
 Tanel.
Cheers
Nuno Souto
[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuno Souto
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RAID select

2003-07-20 Thread bhabani s pradhan
Hi

I have a DB server with RAID-1
and RAID-0+1 (There is no RAID-0).
Also the NON-RAID diska are available.

I have the tablespaces as:
SYSTEM
USERS01(Heavily Accessd)
RWEBCONFIG(Less Accessed)
RTRADE(Less Accessed)
INDEX01(Heavily Accessd)
INDEX02(Heavily Accessd)
RBS01
RBS02
TEMP
STAT(For PERFSTAT)

What could be a suitable configuration for
the datafiles under these tablespaces across
the available RAIDs. Also where the backups
and archive_dest should be.

Can anybody give me some tips on this

Thanks and Regards


___
Download the hottest  happening ringtones here!
OR SMS: Top tone to 7333
Click here now: 
http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: bhabani s pradhan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


ORA-29540: class oracle/plsql/net/TCPConnection does not exist

2003-07-20 Thread Nirmal Kumar M
Helo all,

I have installed oracle JVM on oracle817, windows2000.

Asper the doc from metalink, i installed it
sucessfully. When i'm using the utl_smtp package from
the client forms6i, the error ORA-29540: class
oracle/plsql/net/TCPConnection does not exist raised
out.

How to proceed next?. 


installation steps:
1) resource configuration, rollback segment, shared
pool, java pool, system tablespace has been done.

2) connect internal, run script initjvm.sql

i verified post installation steps, my results matched
with the document note from metalink installing jvm
on oracle817.

Thanks.
Nirmal,

=
fsdfsdfsdfsdfs

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nirmal Kumar M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Different Platform

2003-07-20 Thread bhabani s pradhan
Hi All

Our production environment is on Sun OS 5.8 sparc.
DB is

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - 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 of compatibility problem (relating to OCI, 
or plsql procs etc) ?

Thanks in Advance
Regards

___
Download the hottest  happening ringtones here!
OR SMS: Top tone to 7333
Click here now: 
http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: bhabani s pradhan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


DB shift

2003-07-20 Thread bhabani s pradhan
Hi All

We are planning to Shift our Db to a new hardware(having RAIDs). 
The OS is exactly same on both the servers.
Presently Oracle Version is 8.1.7.0.0
In the new server Oracle 8.1.7.4 is installed.

What I am planning is to Shift the DB by copying the data files 
 from old to new server.
Renaming them in mount stage if required.

For the Oracle version change (upgrade) will there be any 
problem?
So that export/import will be the only option.

Thanks for your valuable input.

Regards


___
Download the hottest  happening ringtones here!
OR SMS: Top tone to 7333
Click here now: 
http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: bhabani s pradhan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Different Platform

2003-07-20 Thread Tanel Poder
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 the changes to production.


 Will there be ANY kind of compatibility problem (relating to OCI,
 or plsql procs etc) ?

PL/SQL won't usually have any problems, at least I haven't seen any (when
moving from unix to unix you won't have thes directory path problems
either...).

OCI library side should also be the same for all unix platforms, but your
application definitely needs to be tested on Sun, there's many differences
between platforms, especially when using threading and other advanced
programming techniques.

Tanel.


 Thanks in Advance
 Regards

 ___
 Download the hottest  happening ringtones here!
 OR SMS: Top tone to 7333
 Click here now:
 http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: bhabani s pradhan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: imp table data, but not PK indexes?

2003-07-20 Thread Tanel Poder
  2) export data with constraints=n rows=y indexes=n direct=y
  recordlength=65535
   ^^
 Do you find that makes a real difference?
 I haven't had much success with it...

Never in production. But once I was writing a paper on upgrading databases
with low downtime, then I tested this parameter on NT (or was it linux?)
workstation and saw difference big enough to conclude, that this parameter
may be useful.

Tanel.



  Also, if you plan to shorten your downtime by first exporting/importing
the
  structure from online database and then transferring data during
downtime,
  you have to worry about your sequences, because they have probably
  incremented after structure export and data export. Thus a simple script
has
  to be done for that (thanks John ;).

 Good point, thanx!

 
  Tanel.
 Cheers
 Nuno Souto
 [EMAIL PROTECTED]


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Nuno Souto
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: DB shift

2003-07-20 Thread Tanel Poder
Hi!

When moving to binary compatible platform, you can directly copy over the
files (and software).

It's even possible with different versions of OS - like from SunOS 2.6 to
Solaris 8.

For upgrading to 8.1.7.4 follow the patchset readme notes.

Tanel.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 20, 2003 7:49 PM


 Hi All

 We are planning to Shift our Db to a new hardware(having RAIDs).
 The OS is exactly same on both the servers.
 Presently Oracle Version is 8.1.7.0.0
 In the new server Oracle 8.1.7.4 is installed.

 What I am planning is to Shift the DB by copying the data files
  from old to new server.
 Renaming them in mount stage if required.

 For the Oracle version change (upgrade) will there be any
 problem?
 So that export/import will be the only option.

 Thanks for your valuable input.

 Regards


 ___
 Download the hottest  happening ringtones here!
 OR SMS: Top tone to 7333
 Click here now:
 http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: bhabani s pradhan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Increase tablespace, which way is better?

2003-07-20 Thread Tanel Poder



Hi!

Also, there is (or was?) a tradeoff between size 
and number of datafiles.

Before 8i, ifI recall correctly, all datafile 
headers had to be physicallyvisited (header SCN changes were written) 
before a checkpoint could finish. If you got thousands of files, this adds 
significant overhead. Starting from 8i you actually have to do same thing, but 
with incremenal checkpointing, the datafile headers are updated in groups, thus 
distributing the jump in IO load over longer period of time. 

In 6.0, I believe there was no checkpoint process 
and logwriter was the one responsible updating all file headers. When log buffer 
was full, all transactions were halt. Others can comment it, because I haven't 
worked withO 6.

Another thing with datafile sizes was recovery in 
case of corrupt block - it's faster to restore and recover a 1GB file than a 
10GB file, but with 9i RMAN block level recovery this problem is relieved as 
well.

And last, a lot of people have had problems with 
file sizes over 2GB, even in last few years. Some filesystems simply didn't 
support files over 2GB, others could corrupt the whole file when extended over 
2GB (8.1.5 on linux for example). That's why sizes like 1G or 2040 MB were used 
a lot (by me;)

Tanel.


  "Liu, Jack" 
  [EMAIL PROTECTED] wrote:
  

  
  

  Hi, I want to increase 
  tablespace, just want to know which way is better:1. ALTER TABLESPACE 
  SYSTEMADD DATAFILE '/u01/oradata/orcl/users02.dbf'SIZE 
  1MAUTOEXTEND ONNEXT 1MMAXSIZE 100M;
  
  2.alter tablespace system 
  add datafile '/u01/oradata/orcl/users02.dbf' size 100m;
  
  Thanks,
  
  Jack
  


Yahoo! Mobile- Check  compose your email 
via SMS on your Telstra or Vodafone 
mobile.


Re: imp table data, but not PK indexes?

2003-07-20 Thread M Rafiq
I have been using it on HP and it speeds up export with direct=y. I wish HP 
should enhance this value greater than 65535 as it is maximum limit on HP. 
It helped me in export when we were changing block size from 4K to 16K

Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Sun, 20 Jul 2003 09:14:30 -0800
  2) export data with constraints=n rows=y indexes=n direct=y
  recordlength=65535
   ^^
 Do you find that makes a real difference?
 I haven't had much success with it...
Never in production. But once I was writing a paper on upgrading databases
with low downtime, then I tested this parameter on NT (or was it linux?)
workstation and saw difference big enough to conclude, that this parameter
may be useful.
Tanel.



  Also, if you plan to shorten your downtime by first exporting/importing
the
  structure from online database and then transferring data during
downtime,
  you have to worry about your sequences, because they have probably
  incremented after structure export and data export. Thus a simple 
script
has
  to be done for that (thanks John ;).

 Good point, thanx!

 
  Tanel.
 Cheers
 Nuno Souto
 [EMAIL PROTECTED]


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Nuno Souto
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
_
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


9i - scheduled jobs not running

2003-07-20 Thread Beth Wells
Hi all,

We are working with a third-party ERP system using Oracle databases, and a
basic installation of it sets up some default scheduled jobs.  We've never
had a problem on 8i or 9i on NT, but after a recent 9.2.0.3 install on
Solaris 8 we found that none of these jobs would run.  They complete
successfully if we use DBMS_JOB.SUBMIT and they re-schedule appropriately,
but never actually run again.

JOB_QUEUE_PROCESSES is set to 9, and I can see the cjq0 process, along with
j000 through j004.  No errors in the alert log, no trace files anywhere.  A
co-worker set the hidden parameter _JOB_QUEUE_INTERVAL to 10 and bounced the
db, and now the jobs are running correctly.  After setting this parameter, I
now see five entries for 'jobq slave wait' in v$session_wait, but these did
not appear earlier.

Any ideas on why this wasn't working before?  I thought that in 9i the job
queue coordinator default interval was 5 seconds, and that the hidden
parameter was only to be used if a smaller interval was needed.

Thanks in advance,
Beth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Beth Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: DB shift

2003-07-20 Thread zhu chao
Hi,
I suggest you upgrade your old server from 8170 to 8174 and then copy
the datafiles there.
Or if downtime is limited, you can use standby database to switch your
database from old to new hardware.

Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 21, 2003 12:49 AM


 Hi All

 We are planning to Shift our Db to a new hardware(having RAIDs).
 The OS is exactly same on both the servers.
 Presently Oracle Version is 8.1.7.0.0
 In the new server Oracle 8.1.7.4 is installed.

 What I am planning is to Shift the DB by copying the data files
  from old to new server.
 Renaming them in mount stage if required.

 For the Oracle version change (upgrade) will there be any
 problem?
 So that export/import will be the only option.

 Thanks for your valuable input.

 Regards


 ___
 Download the hottest  happening ringtones here!
 OR SMS: Top tone to 7333
 Click here now:
 http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: bhabani s pradhan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zhu chao
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Different Platform

2003-07-20 Thread Richard Ji
So which compiler will you standarize on?  GCC?
On Solaris I believe the Sun C Compiler is supported but not gcc, though
you can make it work.

-Original Message-
Sent: Sunday, July 20, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L


Hi All

Our production environment is on Sun OS 5.8 sparc.
DB is

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - 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 of compatibility problem (relating to OCI, 
or plsql procs etc) ?

Thanks in Advance
Regards

___
Download the hottest  happening ringtones here!
OR SMS: Top tone to 7333
Click here now: 
http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: bhabani s pradhan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).