My Oracle Support Banner

Unable To Create SAS Datasets - Generating ORA-01017 (Doc ID 295765.1)

Last updated on SEPTEMBER 30, 2010

Applies to:

Oracle Clinical - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 30-SEP-2010***


Run the following:

  • Conduct
  • Data Extract
  • SAS datasets

Job ends in success, but SAS file indicates the following errors:


ORA-1017  username and password invalid, etc.
ORA-12560  no connection to DBMS


The SAS is running separately on laptop machine, and transferred over via MS Disk Sharing.


Verified the following init.ora parameters were correctly set:


remote_os_authent = TRUE
OS_authent_prefix = "OPS$"



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.