ORA-28575: RPC connection with external procedure cannot opened

2004-01-21 Thread Luc . Demanche
- Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Background parameter adjustment

2004-01-13 Thread Luc . Demanche
that happen to you? Thank you Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Export bigger then 2G with Oracle7.3.4

2004-01-09 Thread Luc . Demanche
on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Export bigger then 2G with Oracle7.3.4

2004-01-09 Thread Luc . Demanche
files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle

RE: Export bigger then 2G with Oracle7.3.4

2004-01-09 Thread Luc . Demanche
8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat

Move datafiles, but can't delete them

2003-11-25 Thread Luc . Demanche
production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Move datafiles, but can't delete them

2003-11-25 Thread Luc . Demanche
production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Move datafiles, but can't delete them

2003-11-25 Thread Luc . Demanche
TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: Oracle and Firewall

2003-11-21 Thread Luc . Demanche
Hi Seema, Take a look on this document #131524.1 on Metalink. You will have to add an entry in the registry to force the connection to only use the port 1521 USE_SHARED_SOCKET=TRUE Luc -Original Message- Sent: November 21, 2003 11:21 AM To: Multiple recipients of list ORACLE-L Hi, We

Performance problem with Shareplex and Oracle

2003-10-23 Thread Luc . Demanche
My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Luc . Demanche
, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Luc . Demanche
is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? TIA Luc - Luc Demanche AstraZeneca RD

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Luc . Demanche
is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? TIA Luc - Luc Demanche

RAC vs Fail Safe

2003-10-18 Thread Luc Demanche
Title: Message Hi gurus, I'm in a process of evaluating a high availability strategy. What the difference between RAC and Fail Safe ? Luc

ORA-03237 with LOB and locally managed tablespace

2003-09-22 Thread Luc . Demanche
. Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Intermedia tag problem

2003-03-28 Thread Luc Demanche
Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche INET: [EMAIL PROTECTED

RE: Intermedia tag problem

2003-03-28 Thread Luc Demanche
Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche INET

Re: newbie sqlplus ?

2003-02-23 Thread Luc Demanche
, 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). = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax

SqlServer - Oracle transfer issues

2002-10-04 Thread Luc Demanche
= Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services

Re: cursor and no data found

2002-07-15 Thread Luc Demanche
make a "continue" statement in my loop when a request return no data e.g : cursor c1 is . for c in c1 loop select a into v1 from table1 where a 1 and b 2 and ... /* if my "select into" return no data ? how can I tell him to goes on into the loop ? */ end loop TIA P

Restore on another machine with RMAN

2002-07-04 Thread Luc Demanche
to restore it looks for the original location where RMAN created the backup. How can indicate the new location of the backup's files ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http

Restore with RMAN

2002-06-25 Thread Luc Demanche
Hi gurus, I'm in a process of testing our backup and recovery strategies. Question: For a restore of a noarchivelog database : Is't possible to restore other backups than the last one? What's happen if the last one is not good? TIA Luc = Luc Demanche [EMAIL PROTECTED

RE: Restore with RMAN

2002-06-25 Thread Luc Demanche
gurus, I'm in a process of testing our backup and recovery strategies. Question: For a restore of a noarchivelog database : Is't possible to restore other backups than the last one? What's happen if the last one is not good? TIA Luc = Luc Demanche [EMAIL PROTECTED

PL/SQL return a ref cursor to Java client

2002-05-01 Thread Luc Demanche
complicated than coding an SQL statement directly in the java client. Do you guys have a solution that may be less complicated for this example? If we are going to keep all the SQL statement in stored procs called by the java client, will we have others surprises? TIA Luc = Luc Demanche [EMAIL