Local External Job Fails with ORA-27300, ORA-27301 and ORA-27302 (Doc ID 2278661.1)

Last updated on JUNE 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

When connecting to SQL*Plus using Oracle password authentication and the default database (i.e. no service name specified at the command line, e.g. sqlplus mprs/mprs) a local external job fails.
However, when connecting using a service name (e.g. sqlpus mprs/mprs@TR2) the same local external job succeeds.

The errors received are:

where 'oracle' is the only member of group 'oinstall'. 

Checked 1059981.1, and it doesn't work in this case.

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