hi experts,
On a 11.2.03 non-rac installation on a OEL 7 vm, I get a weird error. Even though the listener is running, I am not able to issue a tnsping to the DB instance. The DB instance is also up and running.
{code}
[oracle@vm1 admin]$ tnsping ggprim
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 16-FEB-2016 19:59:18
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = vm1)(Port = 1521))) (CONNECT_DATA = (SERVICE_NAME = GGPRIM)))
TNS-12541: TNS:no listener
{code}
Here is the status of the listener.
[oracle@vm1 admin]$ lsnrctl status LISTENER_GGPRIM
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-FEB-2016 19:59:32
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ggprim)))
STATUS of the LISTENER
------------------------
Alias LISTENER_GGPRIM
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 16-FEB-2016 19:55:22
Uptime 0 days 0 hr. 4 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/vm1/listener_ggprim/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ggprim)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vm1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=vm1)(PORT=2484)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@vm1 admin]$
And here is the tnsnames.ora
[oracle@vm1 admin]$ cat tnsnames.ora
GGPRIM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = vm1)(Port = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GGPRIM)
)
)
[oracle@vm1 admin]$
and here is the instance status
[oracle@vm1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Feb 16 20:05:40 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @cc
INSTANCE_NAME HOST_NAME STATUS LOGINS
---------------- ---------------------------------------- ------------ ----------
ggprim vm1 OPEN ALLOWED
MACHINE USERNAME COUNT(1)
---------------------------------------- ------------------------- ----------
vm1 SYS 1
SQL>