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

Last updated on MAY 01, 2024

Applies to:

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

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