OraFAQ Forum: Server Utilities » Issue with sqlldr

Home » RDBMS Server » Server Utilities » Issue with sqlldr (19c full client/Instant Client)

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

Issue with sqlldr [message #684423]

Tue, 01 June 2021 10:58

bkbora
Messages: 21
Registered: April 2020

Junior Member

Hi,
I am getting below error while calling the sqlldr for Oracle 19c full client or 19c instant client. We dont have issue with 12c client.
All Oracle_home path set correctly. Any help much appreciated.

I tried all option but having same issue. No solution.

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

softlink from path x/y/z to oracle_home

oracle_home -> /u01/app/oracle/product/193000_client/

softlink from path a/b/c to oracle_home
oracle_home -> /u01/app/oracle/product/193000_client/

.profile contains(note we have multiple .profile file but different name)

export ORACLE_BASE=/u01/app/oracle/product
export DB_HOME=/u01/app/oracle/product/193000_client
export ORA_INV=/u01/app/oracle/product/oraInventory
export ADR_HOME=$ORACLE_BASE/diag
export ORA_ADMIN=$ORACLE_BASE/admin
export ORACLE_HOME=$DB_HOME
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG='english_united kingdom.we8iso8859p1'
export NLS_DATE_FORMAT='DD Mon YYYY HH24:MI:SS'
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/etc:/usr/local/bin:/sbin:$PATH:
export EDITOR=vi
stty erase ^H

umask 022

alias dbshome='export ORACLE_HOME=$DB_HOME;export LD_LIBRARY_PATH=$ORACLE_HOME/lib;export PATH=$ORACLE_HOME/bin:$PATH'

Report message to a moderator

Re: Issue with sqlldr [message #684425 is a reply to message #684423]

Tue, 01 June 2021 11:20

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Afaik, instant client does not include SQL*Loader.

And the message "No message file for product" means your ORACLE_HOME is not set correctly or Oracle program has not access to it.

Report message to a moderator

Re: Issue with sqlldr [message #684431 is a reply to message #684425]

Wed, 02 June 2021 00:29

bkbora
Messages: 21
Registered: April 2020

Junior Member

We have installed sqlldr separately.

ORACLE_HOME path we set it as i have mentioned. I don't see any error.
Any recommendation will be appreciated.

is there any other place where we need to set the oracle_home. Please help.

oracle_home -> /u01/app/oracle/product/193000_client/

oracle_home -> /u01/app/oracle/product/193000_client/

Report message to a moderator

Re: Issue with sqlldr [message #684432 is a reply to message #684431]

Wed, 02 June 2021 00:48

bkbora
Messages: 21
Registered: April 2020

Junior Member

Even we have installed full client to overcome that sqlldr issue. But no luck.

Report message to a moderator

Re: Issue with sqlldr [message #684433 is a reply to message #684432]

Wed, 02 June 2021 01:17

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have to post the following session:

id
ls -ld $ORACLE_HOME
env | egrep 'ORACLE|PATH|TNS|SQL' | sort 
<your sqlldr command and output>

And don't forget to use code tags and follow the forum rules as already asked to you in this post.

[Updated on: Wed, 02 June 2021 01:18]

Report message to a moderator

Previous Topic:	export command in oracle11g
Next Topic:	Data Pump Imp Exclude Index Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 11:05:36 CDT 2024