Differing behaviour in SQLPlus for user log in

Aug 12, 2016 8:55AM · Aug 12, 2016 8:55AM

Hi All,

I've a question regarding the behaviour that I'm seeing on one of my servers, that I'm hoping someone can assist with.

I have two connection methods, both using SQLPlus but giving different results for the same user:

Here is the first:

[oracle@Linux ~]$ sqlplus sys@examples as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 12 13:37:43 2016

Enter password:

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show con_name

CON_NAME

------------------------------

EXAMPLES

SQL> conn oe

Enter password:

SQL*Plus (MOSC)