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

Steps to get ZPL code output using Zebra viewer - Online

Introduction ZPL is a print language used by many label printers. A print language is a set of commands that can be used to draw elements li...