ORA-28575: RPC connection with external procedure cannot opened

'm not using MTS Thank you for you help Luc - Luc Demanche AstraZeneca R&D 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-

Background parameter adjustment

Did that happen to you? Thank you Luc ----- Luc Demanche AstraZeneca R&D 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://w

RE: Export bigger then 2G with Oracle7.3.4

y 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 R&D Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PRO

RE: Export bigger then 2G with Oracle7.3.4

e multiple 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 R&D M

Export bigger then 2G with Oracle7.3.4

on a Oracle7.3.4 database? If not, what can I do? Thanks Luc ----- Luc Demanche AstraZeneca R&D 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-

RE: Move datafiles, but can't delete them

ion" error. > > My question is Who using it? > > My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new > path. > I don't want to bounce my production database > > Any ideas > > TIA > Luc > > - &

RE: Move datafiles, but can't delete them

w path. I don't want to bounce my production database .... Any ideas TIA Luc - Luc Demanche AstraZeneca R&D Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED]

Move datafiles, but can't delete them

;t want to bounce my production database Any ideas TIA Luc ----- Luc Demanche AstraZeneca R&D 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

RE: Oracle and Firewall

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

RE: Performance problem with Shareplex and Oracle

ttleneck? The only thing I can see 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 bottlene

RE: Performance problem with Shareplex and Oracle

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 R&D Montreal > Oracle Database Administr

RE: Performance problem with Shareplex and Oracle

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 R&D Montreal Oracle Datab

Performance problem with Shareplex and Oracle

erage" 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 R&D Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.o

RAC vs Fail Safe

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

oblem. Luc ----- Luc Demanche AstraZeneca R&D 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, C

Connectivity trought Firewall

Hi gurus,   Let say this configuration:   Client NAT1 -- NAT2 - DB   Db server is Windows2000.   Is the registry USE_SHARD_SOCKET=TRUE is enough?  If not, I will use Connection Manager, but do I need Connection Manager between NAT2 and DB only? Or between NAT1 and NAT

RE: Intermedia tag "<" problem

quot;<" character > in > the data. > > Intermedia thinks it's a new tag and tries to find a > section but it cannot. > Exemple: > Cyane < 10 Phibro Energy * > > Question : > 1- Should we do something with the "<" in our data ? > > T

Intermedia tag "<" problem

fine. But we have a problem when there is a "<" character in the data. Intermedia thinks it's a new tag and tries to find a section but it cannot. Exemple: Cyane < 10 Phibro Energy * Question : 1- Should we do something with the "<" in our data ? TIA

Re: newbie sqlplus ?

n > 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 ma

SqlServer - Oracle transfer issues

Luc ===== 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

Re: cursor and no data found

/* if my "select into"  return no data ?     how can I tell him to goes on into the loop  ? */     end loop TIA Philippe Luc Demanche[EMAIL PROTECTED]Do You Yahoo!? Yahoo! Autos - Get free new car price quotes

Restore on another machine with RMAN

n RMAN tried 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 - F

RE: Restore with RMAN

e 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] > > _______

Restore with RMAN

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 [

PL/SQL return a ref cursor to Java client

a, etc ... it's more 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