DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, September 19, 2012

SQL*Loader-128: unable to begin a session , ORA-01017: invalid username/password; logon denied

Description :
=========

The Custom upload program which is using the sqlldr was running fine till yesterday and there was no changes made in the server. But all of the sudden the program is completing with the Error.


Checked the executable of that concurrent program and the executable was only the control file (.ctl) which has the normal parameters like the following

options (skip=1)

LOAD DATA
APPEND
INTO TABLE XXDOYEN_TEST_EXCEL_UPLD_CTL
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

But it does not have any username and passwd to use the sqlldr , as that function takes care by the Executable Method : SQL*Loader. which is defined for the concurrent program.


Also we have tested by logging in to the server at the backend with the apps user and it works fine with the sqlldr. But when we are running this using concurrent request we are getting the following error message.

Version Details:
==========
Database : 11.0.7
Apps : 12.1.1
OS : IBM AIX 64 bit.

Error:

====

+-----------------------------
Starting concurrent program execution...
-----------------------------
Arguments
------------
/test02/apps/apps_st/appl/doyen/12.0.0/testing/CUSTOM/Saravana.csv

SQL*Loader-128: unable to begin a session

ORA-01017: invalid username/password; logon denied

SQL*Loader: Release 10.1.0.5.0 - Production on Wed Sep 19 10:42:17 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL*Loader-128: unable to begin a session
ORA-01017: invalid username/password; logon denied
Program exited with status 1
Concurrent Manager encountered an error while running SQL*Loader for your concurrent request 19779643.

Review your concurrent request log file for more detailed information.

Solution:

======

1. Just Bounce the concurrent managers and if possible please bounce the Apps and the db also. As there may be some block would have happend.

If the issue still persists then Conctact Oracle Support.

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.