Originally posted by: paul.brett

I had a client connecting to the database with acommand line, similar to this:

-CONNECT orac -USER scott -PASSWORD tiger -T+ C:\Simple\Database\Test1.dbl

...and for diagnostic purposes, it was suggested to try:

-CONNECT orac -USER scott -PASSWORD tiger 
-TV+ C:\Simple\Database\Test1.dbl

...to get more information (V for Verbose).  However, the -TV option is not valid for the database adapter, and in fact causes problems all on its own:

A database trace file is created (if the map is trigger from the Launcher) in the map directory, and called 'dtxtrig1.dbl'.  It contains the error:

Error returned by OCISessionBegin, errcode=1017
ORA-01017: invalid username/password; logon denied

The log contains:

<SourceReport   card="1"   adapter="DB"   bytes="0"   adapterreturn="-1005">
   <Message>Failed to connect to the database</Message>
</SourceReport>

When the 'V' is removed:

-CONNECT orac -USER scott -PASSWORD tiger -T+ C:\Simple\Database\Test1.dbl

....the correct trace file is written and (once the account has been unlocked) the connection works, the data is retrieved.  No database trace is produced at all if using the Command Server with -TV+.

APAR PI61491 - Invalid options on the database adapter command line get incorrectly appended to values associated with the option immediately preceding the bad option.

Invalid options that appear at the end of a database command line are completely ignored.  Before this fix, the invalid option would get appended to the value of the previous option.  For example, if the last valid option was the user id or password (e.g. "-password xyz -TV"), the password value would get all the content associated with the invalid option (e.g. password value assigned to "xyz -TV" versus just "xyz").

Thank-you.

Paul.

Follow me on Twitter