Hi,
I was working on solving ora-12514 tns listener ora problem but i find out more through R & D. Please help
All of my *.ora file is configured according to this url ORACLE-BASE - Oracle Network Configuration but even if the information for tns,sql,listener.ora of my pc is required then please do let me know.
[grid@netsystemsolution ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 05-JAN-2015 07:55:02
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=netsystemsolution.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 05-JAN-2015 07:27:06
Uptime 0 days 0 hr. 27 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/netsystemsolution/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=netsystemsolution.com)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[root@netsystemsolution oracle]# vi /etc/hosts
192.168.0.1 netsystemsolution.com localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
IF YOU DISCONNECT THE INTERNET AND TYPE AS FOLLOWING THEN IT SHOWS :-
[root@netsystemsolution oracle]# ping netsystemsolution.com
connect: Network is unreachable
[root@netsystemsolution oracle]# ping 192.168.0.1
connect: Network is unreachable
BUT IF YOU CONNECT YOUR PC TO THE INTERNET AND TRY PING AGAIN THEN HERE IS WHAT IT SHOWS :
[root@netsystemsolution oracle]# ping netsystemsolution.com
PING netsystemsolution.com (192.168.0.1) 56(84) bytes of data.
It shows PING netsystemsolution.com (192.168.0.1) 56(84) bytes of data. only this and neither it moves forward.
AGAIN IF YOU TRY TNSPING OF THE THE FOLLOWING THEN :
[grid@netsystemsolution ~]$ tnsping orcl.netsystemsolution.com
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 05-JAN-2015 09:23:23
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
/u01/app/11.2.0/grid/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = netsystemsolution.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL.netsystemsolution.com)))
TNS-12535: TNS:operation timed out
[grid@netsystemsolution ~]$
PLEASE LOOK AT THE HOST IP OF THIS ONE (tnsping lsnrctl), HERE IT SEEMS TO BE DIFFERENT
[grid@netsystemsolution ~]$ tnsping lsnrctl
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 05-JAN-2015 09:26:17
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
/u01/app/11.2.0/grid/network/admin/sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=89.31.143.8)(PORT=1521)))
TNS-12535: TNS:operation timed out
[grid@netsystemsolution ~]$
After tyring TSNPING LSNRCTL command, I again rechecked lsnrctl status and now here is what it shows :-
[grid@netsystemsolution ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 05-JAN-2015 09:29:49
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=netsystemsolution.com)(PORT=1521)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out