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***

Symptoms

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.

Changes

Verified the following init.ora parameters were correctly set:

 

remote_os_authent = TRUE
OS_authent_prefix = "OPS$"

 

Cause

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 hundreds of Community platforms