Home » SQL & PL/SQL » SQL & PL/SQL » How to install sql*loader in ubuntu
How to install sql*loader in ubuntu [message #217331] Thu, 01 February 2007 14:07 Go to next message
jocelyn
Messages: 2
Registered: February 2007
Junior Member
Hi,
I have a problem in starting or installing SQL*Loader in Ubuntu. Im using Oracle Database 10g(XE). I tried to execute the command "sqlldr" but the reponse was "command not found" I have found the path in my bin folder. I run it in the terminal and this were the results:

jocelyn@jocelyn-desktop:~$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlldr
Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=ULjocelyn@jocelyn-desktop:~$

I dont know whats wrong. Can anybody help me? Pls. I need to solved this problem. Thank you.

Best regards,
jocelyn
Re: How to install sql*loader in ubuntu [message #217332 is a reply to message #217331] Thu, 01 February 2007 14:10 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Ensure that your ORACLE_HOME and PATH variables are set correctly.
Re: How to install sql*loader in ubuntu [message #217337 is a reply to message #217331] Thu, 01 February 2007 14:39 Go to previous messageGo to next message
jocelyn
Messages: 2
Registered: February 2007
Junior Member
Hi Ebrian,
Thank you for your reply. I know my oracle home and path were set correctly. Do you have any other idea what other wrong I might have since I cannot execute sqlldr? I really need help pls.

Thank you,
jocelyn
Re: How to install sql*loader in ubuntu [message #217339 is a reply to message #217331] Thu, 01 February 2007 14:45 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
post the output from
env | sort
id
Re: How to install sql*loader in ubuntu [message #217355 is a reply to message #217337] Thu, 01 February 2007 16:12 Go to previous message
Admin@Lightsql.Com
Messages: 36
Registered: November 2006
Member

Hi,

Are you able to connect through sqlplus (instead of sqlldr)?

On either case, check there are some messages files in ORACLE_HOME and below, especially below network directory, and look at the privileges. You need to give read priv to public. I happen to see this in one linux installation, but do not remember the exact location of the message files. It was set right when priv are given.

Good luck

Jay - Programming with Oracle & Visual C++, Author of http://www.lightsql.com.
Previous Topic: counting occurances
Next Topic: Login as different user inside Procedure?
Goto Forum:
  


Current Time: Sat Dec 10 12:54:31 CST 2016

Total time taken to generate the page: 0.08744 seconds