Oracle 12 Standard Edition SE2 12.1.0.2.0 on Redhat Linux 7.2
I have created an Oracle single-instance non-container database.(No multitenant architecture)
as user oracle (software installatio owner) I can connect with either ORACLE_SID or TWO_TASK.
as another user (Linux user myuser) I can only connect with TWO_TASK, when I try with ORACLE_SID I geet ORA-12547.
a) Why is that?
b) How do I view the sqlnet.log that was created using adrci? adrci "show incidient" and "show problem" show 0 incidents/problems
See commands below
I see the service running:
ps -ef | grep pmon
oracle 32220 1 0 Jun27 ? 00:01:02 ora_pmon_mydb
as Linux user mylinuxuser - ORA-12547 with ORACLE_SID but not with TWO_TASK
$ unset ORACLE_SID
$ export TWO_TASK=mydb
$ sqlplus myoracleuser
SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 7 21:01:36 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Last Successful login time: Thu Jul 07 2016 20:21:12 -03:00
Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
SQL> exit
Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
$ unset TWO_TASK
$ export ORACLE_SID=mydb
$ sqlplus myoracleuser
SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 7 21:01:55 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12547: TNS:lost contact
as Linux user oracle - successful connection with ORACLE_SID
$ echo OSID=$ORACLE_SID TTASK=$TWO_TASK
OSID=mydb TTASK=
$ sqlplus myoracleuser
SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 7 21:06:34 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Last Successful login time: Thu Jul 07 2016 21:01:38 -03:00
Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
SQL>