Tuesday, March 24, 2020

SQL*Loader-128: unable to begin a session ORA-01005: null password given; logon denied


This error related to shell script file.

Error: Username:Password:
            SQL*Loader-128: unable to begin a session
            ORA-01005: null password given; logon denied

Solution: 
            Use $1 parameter  (UID_PWD=$1) in shell script (.prog) file. 


In shell script 1st five parameters are standard.

$0 - Shellscript name
$1 - Oracle username/password
$2 - User_id
$3 - Oracle Applications username
$4 - Concurrent request id

Also from $5, $6 ..... will be the shell script/user defined arguments.


No comments:

Post a Comment

Query to get Concurrent Program Data Template details

 SELECT  fcpt.user_concurrent_program_name       , fcp.concurrent_program_name       , fet.user_executable_name executable_name       , fe....