I have read some similar posts. And tried to reinstall oracle several times. But nothing worked.
Environment:
- Ubuntu 16.04
- Oracle SQL 11g Release 2
Errors I am getting:
sqlplus system
SQL*Plus: Release 11.2.0.2.0 Production on Thu Dec 15 19:54:24 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specifiedsystemctl status oracle-xe.service
● oracle-xe.service - LSB: Oracle 11g Express Edition Loaded: loaded (/etc/init.d/oracle-xe; bad; vendor preset: enabled) Active: active (exited) since Thu 2016-12-15 19:26:35 BDT; 22min ago Docs: man:systemd-sysv-generator(8) Process: 16315 ExecStop=/etc/init.d/oracle-xe stop (code=exited, status=0/SUCCESS) Process: 16339 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=0/SUCCESS)
Dec 15 19:26:28 dipu-pc systemd[1]: Starting LSB: Oracle 11g Express Edition...
Dec 15 19:26:28 dipu-pc oracle-xe[16339]: Starting Oracle Net Listener.
Dec 15 19:26:28 dipu-pc su[16357]: Successful su for oracle by root
Dec 15 19:26:28 dipu-pc su[16357]: + ??? root:oracle
Dec 15 19:26:28 dipu-pc su[16357]: pam_unix(su:session): session opened for user oracle by (uid=0)
Dec 15 19:26:28 dipu-pc oracle-xe[16339]: Starting Oracle Database 11g Express Edition instance.
Dec 15 19:26:28 dipu-pc su[16375]: Successful su for oracle by root
Dec 15 19:26:28 dipu-pc su[16375]: + ??? root:oracle
Dec 15 19:26:28 dipu-pc su[16375]: pam_unix(su:session): session opened for user oracle by (uid=0)
Dec 15 19:26:35 dipu-pc systemd[1]: Started LSB: Oracle 11g Express Edition.journalctl -xe
Dec 15 19:59:26 dipu-pc systemd[1]: Started CUPS Scheduler.
-- Subject: Unit cups.service has finished start-up
-- Defined-By: systemd
-- Support:
--
-- Unit cups.service has finished starting up.
--
-- The start-up result is done.
Dec 15 20:06:14 dipu-pc sudo[17609]: dipu : TTY=pts/0 ; PWD=/home/dipu ; USER=root ; COMMAND=/usr/sbin/service oracle-xe start
Dec 15 20:06:14 dipu-pc sudo[17609]: pam_unix(sudo:session): session opened for user root by (uid=0)
Dec 15 20:06:16 dipu-pc systemd[1]: Started LSB: Oracle 11g Express Edition.
-- Subject: Unit oracle-xe.service has finished start-up
-- Defined-By: systemd
-- Support:
--
-- Unit oracle-xe.service has finished starting up.
--
-- The start-up result is done.
Dec 15 20:06:16 dipu-pc sudo[17609]: pam_unix(sudo:session): session closed for user root
Dec 15 20:06:21 dipu-pc sudo[17639]: dipu : TTY=pts/0 ; PWD=/home/dipu ; USER=root ; COMMAND=/bin/journalctl -xe
Dec 15 20:06:21 dipu-pc sudo[17639]: pam_unix(sudo:session): session opened for user root by (uid=0)
Dec 15 20:09:28 dipu-pc sudo[17707]: dipu : TTY=pts/0 ; PWD=/home/dipu ; USER=root ; COMMAND=/bin/journalctl -xe
Dec 15 20:09:28 dipu-pc sudo[17707]: pam_unix(sudo:session): session opened for user root by (uid=0) 
