Tags: command, database, encountered, error, file, line, message, mysql, oracle, run, sql, sqlldr, unable, unix

unable to run sqlldr from the command line

On Database » Oracle

2,681 words with 3 Comments; publish: Thu, 14 Feb 2008 03:08:00 GMT; (25046.88, « »)

Hi

I am trying to run a sqlldr command from the unix command line but encountered with the error

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

But i can run the same command through sql plus and its working fine.

When I searched for the error above over the internet i found a few saying that env variables are not set properly. If so then how will it run through sqlplus.

Can anyone give me an idea..

Thank you

All Comments

Leave a comment...

  • 3 Comments
    • Looks like your envrionment variable is not set properly.

      What's your

      ORACLE_HOME set to ?

      #1; Sat, 23 Feb 2008 16:52:00 GMT
    • Hi,

      You need to ensure that your Oracle libraries and PATH'ed properly:

      Here is how I do it in my ,profile:

      # Loop through each host name . . .

      for host in `cat ~oracle/.rhosts|\

      cut -d"." -f1|awk '{print $1}'|sort -u`

      do

      echo " "

      echo "************************"

      echo "$host"

      echo "************************"

      # loop from database to database

      for db in `cat /etc/oratab|egrep ':N|:Y'|\

      grep -v \*|grep ${db}|cut -f1 -d':'"`

      do

      home=`rsh $host "cat /etc/oratab|egrep ':N|:Y'|\

      grep -v \*|grep ${db}|cut -f2 -d':'"`

      echo "************************"

      echo "database is $db"

      echo "************************"

      rsh $host "

      ORACLE_SID=${db}; export ORACLE_SID;

      ORACLE_HOME=${home}; export ORACLE_HOME;

      ${home}/bin/sqlplus -s /<<>

      #2; Sat, 23 Feb 2008 16:53:00 GMT
    • thanks all for replying

      i have set the env variables for the session and it worked. Looks like i have to set the oracle_home and ld_library_path every time ( opening a new putty session) i call sqlldr.

      But in a whole i am trying to run sql loader from the forms. Right now we have Oracle app server 10g which forms 10g version. As oracle app server 10g didnt come with sqlldr, we are copied the sqlldr of database on to app server with different home. after this we can run sqlldr ( on app server ) from unix scripts but not from Forms. Then we opened a qurey with oracle about app server 10g not commig with sqlldr and its remedy . But they said that they dont have specific remedy for that and suggested the same what we did.

      So we came up with java package which does the same funtion as host command and trying to run sqlldr which is on the database( ie replacing the host command in the forms with the database funtion). By using that funtion i am able to run the sqlldr from sql plus but not from forms. I couldnt easily debug it as i wont through any error messages.

      Any one have any idea of this ...

      Thank you

      #3; Sat, 23 Feb 2008 16:54:00 GMT