Re: SQL*Loader-101

Hi,
I haven't investigated it, but I'll try to guess.. at least you'll get some
ideas to start "digging".
that's 100% sqlldr needs some usr/pwd to log on to your database in order to
load the data and this is one way I can think of of how it could get the
credentials.

Every concurrent program is assigned to one of the applications modules, and
each application module is installed in one of the oracle schemas.
Here's the select that will show you which module is related to which oracle
schema:

SELECT a.application_id,
       a.application_short_name,
       ou.oracle_username
  FROM fnd_product_installations pi,
       fnd_oracle_userid         ou,
       fnd_application           a
 WHERE pi.application_id = a.application_id
   AND pi.oracle_id = ou.oracle_id;

EBS stores encrypted oracle passwords in table fnd_oracle_userid, and this
is where it can get the password to use for sqlldr.
Therefore I can think of 2 cases in your situation:
1) Your SQL Loader concurrent program is related to custom module and custom
oracle schema that is not properly registered in EBS.(register oracle
schema: system administrator -> Security -> ORACLE -> Register)
2) Oracle Schema that is related to your concurrent program contains
incorrect password in fnd_oracle_userid. (Change the password using FNDCPASS
option ORACLE for this schema)




On Fri, Apr 17, 2009 at 10:37 AM, Kalyan Sundar <kalyan.sundu@xxxxxxxxx>wrote:

> Hi All,
>
> There is a concurrent program which has executtion method of the
> executable as Sql*Loader.
> This program errors out with Invalid argument for userid/password
> while we dont actually pass userid/password for this program.
> Looks like It automatically takes password during the program
> execution. Can any one explain how thsi program takes the
> userid/password? and cause for this error?
>
>
> ------------
> SQL*Loader-101: Invalid argument for username/password
>
> SQL*Loader: Release 10.1.0.5.0 - Production on Thu Apr 16 03:40:02 2009
>
> Copyright (c) 1982, 2005, Oracle.  All rights reserved.
>
> SQL*Loader-101: Invalid argument for username/password
>
> Program exited with status 1
> Concurrent Manager encountered an error while running SQL*Loader for
> your concurrent request 20629968.
>
> Review your concurrent request log file for more detailed information.
>
>
>
> +---------------------------------------------------------------------------+
>
>
> Thanks,
> Kalyan
>
>


-- 
br,
Maris Elsins

Other related posts: