Skip to Main Content

Hardware

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS 12535 TNS 12560 TNS 00505

Raghav_DBASep 4 2016

My TNS file

PROD=

(DESCRIPTION=

(ADDRESS_LIST=

  (ADDRESS=(PROTOCOL=TCP)(HOST=guard.com)(PORT=1521)))

   (CONNECT_DATA=(SERVICE_NAME=PROD) ))

DATAGUARD=

(DESCRIPTION=

(ADDRESS_LIST=

  (ADDRESS=(PROTOCOL=TCP)(HOST=guard.com)(PORT=1521)))

   (CONNECT_DATA=(SERVICE_NAME=DATAGUARD)))

My Listener is

PROD=

(DESCRIPTION=

(ADDRESS_LIST=

  (ADDRESS=(PROTOCOL=TCP)(HOST=guard.com)(PORT=1521)))

   (CONNECT_DATA=(SERVICE_NAME=PROD) ))

DATAGUARD=

(DESCRIPTION=

(ADDRESS_LIST=

  (ADDRESS=(PROTOCOL=TCP)(HOST=guard.com)(PORT=1521)))

   (CONNECT_DATA=(SERVICE_NAME=DATAGUARD)))

My SQLNET is

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE=/u01/app/oracle

AUTOMATIC_IPC=OFF

SQLNET.EXPIRE_TIME=10

NAMES.INITIAL_RETRY_TIMEOUT = 1

NAMES.REQUEST_RETRIES = 2

SQLNET.INBOUND_CONNECT_TIMEOUT = 250

NAMES.NO_PERSISTENT_RESOURCES=TRUE

SQLNET.AUTHENTICATION_SERVICES=ALL

I want to restart listener but while stopping listener getting error

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-SEP-2016 10:46:11

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=guard.com)(PORT=1521)))

TNS-12535: TNS:operation timed out

TNS-12560: TNS:protocol adapter error

  TNS-00505: Operation timed out

Comments
Post Details
Added on Sep 4 2016
0 comments
2,907 views