My Oracle Support Banner

Planned Output is Automatically Generating sqlnet.log for a SAS Program (Doc ID 2854216.1)

Last updated on MARCH 10, 2022

Applies to:

Oracle Life Sciences Data Hub - Version 3.1.0 to 3.1.0 [Release 3.1.0]
Information in this document applies to any platform.

Symptoms

When the SAS program is running the system is automatically generating a sqlnet.log file as planned output for the program. The first job submission job executes successfully, but adds a new planned output sqlnet.log for the active program instances. This will cause the next submission to fail with an ORA error shown in the sqlnet.log file. When removing the newly created planned output from the program instance and submitting the job again, this time it completes (that is the program executes successfully) but again has the new added planned output sqlnet.log. The user then has to manually remove the sqlnet.log, or else the next job will fail with the same ORA error shown below in the sqlnet log:

ORA-48165: user missing read, write, or exec permission on specified ADR Base
directory []
User inputted base directory is invalid [48188] [<USER_PATH>]

Cause

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

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


In this Document
Symptoms
Cause
Solution


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