OraFAQ Forum: Server Utilities » sqlloader doesn't work

Home » RDBMS Server » Server Utilities » sqlloader doesn't work

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlloader doesn't work [message #507159]

Thu, 12 May 2011 15:10

nefadbr
Messages: 4
Registered: May 2011

Junior Member

Hello!

Im trying to use sqlldr in Fedora Linux but it doesnt work Sad

The message:

Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS

oracle.sh:

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib:/usr/include/oracle/11.2/client:/usr/share/oracle/11.2/client

export ORACLE_SID=zxin

export PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

is anything missing?

Thanks for help!

Report message to a moderator

Re: sqlloader doesn't work [message #507160 is a reply to message #507159]

Thu, 12 May 2011 15:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>is anything missing?
Missing? no
Wrong? yes
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

Report message to a moderator

Re: sqlloader doesn't work [message #507161 is a reply to message #507160]

Thu, 12 May 2011 15:15

nefadbr
Messages: 4
Registered: May 2011

Junior Member

OH MY GOD THANK YOU VERY MUCH!!!!!!! im trying to make it work SO MANY TIME WASTED MY GOD thanks!!!!!!!!!!!!!

Report message to a moderator

Re: sqlloader doesn't work [message #507162 is a reply to message #507160]

Thu, 12 May 2011 15:28

nefadbr
Messages: 4
Registered: May 2011

Junior Member

Ok, i sing victory so fast, that the gods punished me.

i can execute sqlldr from shell, but when i try to use the php function readfile, say that i dont habe the sqlldr Oo some idea?

Report message to a moderator

Re: sqlloader doesn't work [message #507163 is a reply to message #507162]

Thu, 12 May 2011 15:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i can execute sqlldr from shell, but when i try to use the php function readfile, say that i dont habe the sqlldr Oo some idea?
php process has different OS environment

a quick way to compare is from command line do as below

env | sort -o /tmp/capture.env

from php process do similar

env | sort -o /tmp/php.env

then do
diff /tmp/php.env /tmp/capture.env

Report message to a moderator

Re: sqlloader doesn't work [message #507164 is a reply to message #507163]

Thu, 12 May 2011 15:37

nefadbr
Messages: 4
Registered: May 2011

Junior Member

Wow, this is so strange... 5 minutes ago, i have th sqlldr send me that msg in the first post. I reboot my system, and now i have command not found. Oo

I just reboot, and try to execute sqlldr..

from shell or from php, command not found... magic?

Report message to a moderator

Re: sqlloader doesn't work [message #507191 is a reply to message #507164]

Fri, 13 May 2011 01:15

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Magic, not, missing environment variables, could be, could also be that the Oracle home directory was gone.

Regards
Michel

Report message to a moderator

Previous Topic:	Hot backup of tablespaces
Next Topic:	Missing objects during datapump import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 20 23:30:35 CST 2025