Home » RDBMS Server » Server Utilities » Issue with sqlldr (19c full client/Instant Client)
Issue with sqlldr [message #684423] Tue, 01 June 2021 10:58 Go to next message
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'
Re: Issue with sqlldr [message #684425 is a reply to message #684423] Tue, 01 June 2021 11:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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.

Re: Issue with sqlldr [message #684431 is a reply to message #684425] Wed, 02 June 2021 00:29 Go to previous messageGo to next message
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/
Re: Issue with sqlldr [message #684432 is a reply to message #684431] Wed, 02 June 2021 00:48 Go to previous messageGo to next message
bkbora
Messages: 21
Registered: April 2020
Junior Member
Even we have installed full client to overcome that sqlldr issue. But no luck.
Re: Issue with sqlldr [message #684433 is a reply to message #684432] Wed, 02 June 2021 01:17 Go to previous message
Michel Cadot
Messages: 68625
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:
  


Current Time: Thu Mar 28 11:18:24 CDT 2024