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.
========
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.
No comments:
Post a Comment