Home » Infrastructure » Other Operating Systems » Autoconnect from REXX script
Autoconnect from REXX script [message #99322] Tue, 13 May 2003 13:41 Go to next message
Martin Stoddard
Messages: 2
Registered: May 2003
Junior Member
Getting ORA-01017: invalid username/password; logon denied attempting to connect to remote database via REXX script after 8.1.5.X to 8.1.7.4 upgrade. ALL other methods (interactive SQL, batch SQL, clist, etc) have no trouble autoconnecting to the same remote DB.

Has anyone had success autoconnecting to a remote DB with a REXX script in V8.1.7.4?
Re: Autoconnect from REXX script [message #99323 is a reply to message #99322] Tue, 13 May 2003 15:16 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

If you get the "invalid username/password" error you have already successfully interacted with "a database". Check the following:

1) Ensure that you've contacted the correct database:

"ALLOC DD(ORA@dbname) DUMMY"

2) Ensure that you've specified the correct userid and password.

Best regards.

Frank
Re: Autoconnect from REXX script [message #99325 is a reply to message #99323] Wed, 14 May 2003 13:02 Go to previous messageGo to next message
Martin Stoddard
Messages: 2
Registered: May 2003
Junior Member
Thanks for your reply Frank. After further testing, we've gotten autoconnect to work running REXX under JES. Speaking with the OS/390 SysAdmin, it seems her script is running from OPSMVS under Master -not- JES. Perhaps it doesn't provide current user information where JES does and in turn where Oracle expects to find it.
Regards,
- Martin
Re: Autoconnect from REXX script [message #99326 is a reply to message #99325] Thu, 15 May 2003 06:38 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi Martin,

That is GREAT news! Care to post (parts of) your REXX script so we can all learn from it?

Best regards.

Frank
Previous Topic: Re: Anyone using enclave(call)
Next Topic: transfer data from MVS file to Oracle
Goto Forum:
  


Current Time: Fri Mar 29 03:57:20 CDT 2024