RE: Run sqlldr as non-oracle user
- From: "kathy.robb" <kathy.robb@xxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Thu, 16 Apr 2009 20:11:21 -0600
Sounds like your environment isn't set up correctly. try.
. oraenv
And give it the ORACLE_SID when you ask for it. Also - set your TWO_TASK
environment variable to be same as ORACLE_SID.
That should help.
Kathy
_____
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Ramakrishnan
Seshadhri
Sent: Thursday, April 16, 2009 7:36 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: Run sqlldr as non-oracle user
Jay,
Thanks for your response. I have ful 777 privilege on the ORACLE_HOME where
I am trying to run the sqlldr.
Still the problem persists.
Ram
On Fri, Apr 17, 2009 at 1:14 AM, Sriramulu, Jayakumar
<Jayakumar.Sriramulu@xxxxxxxxxxxxx> wrote:
Might be a permission issue. Please give read and execute access to all on
$ORACLE_HOME folder recursively.
Thanks,
Jay
_____
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Ramakrishnan
Seshadhri
Sent: Thursday, April 16, 2009 6:32 AM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Run sqlldr as non-oracle user
Greetings,
I am trying to run sqlldr program as a non-oracle user (i.e. user other than
Oracle software owner) on Linux.
I endup with the following error :
[user@linux ~]$ sqlldr
Message 2100 not found; No message file for product=RDBMS,
facility=ULMessage 2100 not found; No message file for product=RDBMS,
facility=UL[user@linux ~]$
I have my PATH variable pointing to $ORACLE_HOME/bin and I am able to use
sqlplus escutable and connect to database from this unix account.
Please let me know if there is any setup involved that must be done before
running sqlldr as other user.
Thanks in Advance.
Ram
Other related posts:
