Hello,
ALERT: Listener (LISTENER) on Server (hostname.com) reporting errors: TNS-12618: TNS:versions are incompatible
Sun Sep 07 02:12:44 2014
07-SEP-2014 02:12:44 * (CONNECT_DATA=(COMMAND=status)(VERSION=169869568)) * status * 1189
TNS-01189: The listener could not authenticate the user
07-SEP-2014 02:12:45 * status * 12618
TNS-12618: TNS:versions are incompatible
Sun Sep 07 02:14:18 2014
07-SEP-2014 02:14:18 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=159.253.x.x)(PORT=51877)) * establish * XE * 0
07-SEP-2014 02:14:18 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=159.253.x.x)(PORT=51878)) * establish * XE * 0
07-SEP-2014 02:14:18 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=159.253.x.x)(PORT=51879)) * establish * XE * 0
07-SEP-2014 02:14:18 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=159.253.x.x)(PORT=51880)) * establish * XE * 0
07-SEP-2014 02:14:18 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=159.253.x.x)(PORT=51881)) * establish * XE * 0
Sun Sep 07 02:15:00 2014
07-SEP-2014 02:15:00 * service_update * XE * 0
WARNING: Subscription for node down event still pending
07-SEP-2014 02:15:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=hostname.com)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
My OS is:
-bash-4.1$ cat /etc/*-release
CentOS release 6.5 (Final)
LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch
CentOS release 6.5 (Final)
CentOS release 6.5 (Final)
SQL> select * from V$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
# lsnrctl version
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 07-SEP-2014 05:02:16
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
TNS for Linux: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production,,
The command completed successfully
# lsnrctl services
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 07-SEP-2014 05:22:52
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:238 refused:0 state:ready
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: hostname.com, pid: 8402>
(ADDRESS=(PROTOCOL=tcp)(HOST=hostname.com)(PORT=33756))
The command completed successfully
# tnsping test
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 07-SEP-2014 05:03:30
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
# tnsping XE
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 07-SEP-2014 05:16:25
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = XE)))
OK (0 msec)
# listener.ora Network Configuration File:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
# tnsnames.ora Network Configuration File:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
The oracle is running on our server for the last approximately one year and there was no problem. Nobody even touch any file then why this problem started. Please advise
Thanks in anticipation