Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ATP SQL Loader

User_FN052Jun 18 2021

Hi All,
Right now I have a load file together with a control file to load via sql loader. Can I use the same file to load in ATP. Is there any alternative for sql loader in the cloud. I do not have a local system to pick up the file from. The file we be on a cloud sftp server.
Thanks

Comments

sb92075

How do I ask a question on the forums?

https://forums.oracle.com/message/9362002#9362002

Emad Al-Mousa

Hi sb92075,

i didn't get you ......what is the problem with my question ?

sb92075

[oracle@localhost ~]$ oerr ora 28575

28575, 00000, "unable to open RPC connection to external procedure agent"

// *Cause:   Initialization of a network connection to the extproc agent did

//           not succeed. This problem can be caused by network problems,

//           incorrect listener configuration, or incorrect transfer code.

// *Action:  Check listener configuration in LISTENER.ORA and TNSNAMES.ORA, or

//           check Oracle Names Server.

1 person found this helpful
Emad Al-Mousa

i have checked the configuration of the listener.ora and tnsnames.ora and they are identical to what is needed from the documentation.

So, when i start up the listener the "external procedure" services comes up successfully.

Please note that per Oracle Documentation theses configurations are "NOT" required with Oracle 11g (my database version), setting the configuration from "extproc.ora" is only needed.

i have used the parameter: SET EXTPROC_DLL=ANY

1 person found this helpful
sb92075

file a bug report with MOS

Emad Al-Mousa
Answer

after extensive troubleshooting, i found out that this will occur in one of two situations:

1. the .so external procedure library is corrupted.

OR

2. the .so external procedure library is a 32 bit.......to check that use the Unix Command ( file lib.so) the output should give you 64bit

Marked as Answer by Emad Al-Mousa · Sep 27 2020
1 - 6

Post Details

Added on Jun 18 2021
#general-database-discussions, #load, #sqldeveloper
1 comment
561 views