Home » RDBMS Server » Server Utilities » sqlloader doesn't work
icon8.gif  sqlloader doesn't work [message #507159] Thu, 12 May 2011 15:10 Go to next message
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!
Re: sqlloader doesn't work [message #507160 is a reply to message #507159] Thu, 12 May 2011 15:13 Go to previous messageGo to next message
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
Re: sqlloader doesn't work [message #507161 is a reply to message #507160] Thu, 12 May 2011 15:15 Go to previous messageGo to next message
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!!!!!!!!!!!!!
Re: sqlloader doesn't work [message #507162 is a reply to message #507160] Thu, 12 May 2011 15:28 Go to previous messageGo to next message
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?
Re: sqlloader doesn't work [message #507163 is a reply to message #507162] Thu, 12 May 2011 15:31 Go to previous messageGo to next message
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
Re: sqlloader doesn't work [message #507164 is a reply to message #507163] Thu, 12 May 2011 15:37 Go to previous messageGo to next message
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?
Re: sqlloader doesn't work [message #507191 is a reply to message #507164] Fri, 13 May 2011 01:15 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Magic, not, missing environment variables, could be, could also be that the Oracle home directory was gone.

Regards
Michel
Previous Topic: Hot backup of tablespaces
Next Topic: Missing objects during datapump import
Goto Forum:
  


Current Time: Fri Mar 29 03:40:59 CDT 2024