Home » RDBMS Server » Networking and Gateways » Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... (11g, 11.2.0.1, oel-6)
Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655913] Fri, 16 September 2016 02:07 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

At standby, listener status is appearing as "Instance "ASH2", status BLOCKED, has 1 handler(s) for this service...".
This is done at virtual box.

Below are the details ...

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                15-SEP-2016 13:28:03
Uptime                    0 days 17 hr. 24 min. 14 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
Services Summary...
Service "ASH2" has 1 instance(s).
  Instance "ASH2", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
[oracle@ash2 admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ash2.localdomain)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
(SID_LIST =
(SIF_DESC =
(SID_NAME =ASH2)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
)
)


ADR_BASE_LISTENER = /u01/app/oracle
[oracle@ash2 admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ASH2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.11)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ASH2)
	(UR=A)   
 )
  )

ASH1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ASH1)
	(UR=A)   
 )
  )

Pfile -

ASH2.__db_cache_size=671088640
ASH2.__java_pool_size=16777216
ASH2.__large_pool_size=16777216
ASH2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
ASH2.__pga_aggregate_target=671088640
ASH2.__sga_target=989855744
ASH2.__shared_io_pool_size=0
ASH2.__shared_pool_size=268435456
ASH2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/ASH2/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/ASH2/control01.ctl','/u01/app/oracle/flash_recovery_area/ASH2/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4070572032
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ASH2XDB)'
*.memory_target=1657798656
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.db_name='ASH1'
*.db_unique_name='ASH2'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ASH2XDB)'
*.FAL_SERVER='ASH1'
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(ASH2,ASH1)'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_archive_format='Arc_%d_%s_%t_%r'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/ash1','/u01/app/oracle/oradata/ASH2'
*.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/ash1','/u01/app/oracle/oradata/ASH2'
*.nls_date_format='dd/MM/yyyy'
*.open_cursors=300
*.pga_aggregate_target=148897792
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=419430400
*.sga_target=419430400
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.log_archive_dest_1='location=/u01/app/oracle/oradata/archive/ash2 VALID_FOR=(all_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ASH2'
*.log_archive_dest_2='SERVICE=ASH1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ASH1'


[root@ash2 dp1]# ifconfig
eth0      Link encap:Ethernet  HWaddr 08:00:27:39:31:3E  
          inet addr:192.168.7.11  Bcast:192.168.7.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fe39:313e/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:286 errors:0 dropped:0 overruns:0 frame:0
          TX packets:300 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:39221 (38.3 KiB)  TX bytes:36018 (35.1 KiB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:65536  Metric:1
          RX packets:1652 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1652 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:120837 (118.0 KiB)  TX bytes:120837 (118.0 KiB)

virbr0    Link encap:Ethernet  HWaddr 52:54:00:79:FF:D5  
          inet addr:192.168.122.1  Bcast:192.168.122.255  Mask:255.255.255.0
          UP BROADCAST MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)

[root@ash2 dp1]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

192.168.7.10 ash1.localdomain ash1
192.168.7.11 ash2.localdomain ash2
[root@ash2 dp1]#  cat /etc/sysconfig/selinux

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disbaled
# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted 


[root@ash2 dp1]# hostname
ash2.localdomain


[root@ash2 dp1]# ps -ef|grep pmon
oracle    6578     1  0 06:07 ?        00:00:00 ora_pmon_ASH2
root      7682  5310  0 06:55 pts/1    00:00:00 grep pmon


[oracle@ash2 ~]$ echo $ORACLE_SID
ASH2
[oracle@ash2 ~]$ 

Kindly suggest, how to resolve the issue.

Regards,
Ashish
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655914 is a reply to message #655913] Fri, 16 September 2016 02:18 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
You have typo in your listener.ora file,
(SIF_DESC =
you must be more careful when editing files by hand, and you must get into the habit of checking things when you read them, or you will never get anywhere in database administration.
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655915 is a reply to message #655914] Fri, 16 September 2016 02:53 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Thanks John,

I will rectify it and revert.

Regards,
Ashish
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655929 is a reply to message #655915] Fri, 16 September 2016 21:21 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

I have rectified it but still giving same problem after reload of listener.

[oracle@ash2 admin]$ lsnrctl reload listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2016 07:43:11

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
The command completed successfully
[oracle@ash2 admin]$ lsnrctl status listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2016 07:43:18

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                15-SEP-2016 13:28:03
Uptime                    1 days 18 hr. 15 min. 15 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
Services Summary...
Service "ASH2" has 1 instance(s).
  Instance "ASH2", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
[oracle@ash2 admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ash2.localdomain)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME =ASH2)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
)
)


ADR_BASE_LISTENER = /u01/app/oracle

[oracle@ash2 admin]$ cd ../../dbs
[oracle@ash2 dbs]$ cat initASH2.ora 
ASH2.__db_cache_size=671088640
ASH2.__java_pool_size=16777216
ASH2.__large_pool_size=16777216
ASH2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
ASH2.__pga_aggregate_target=671088640
ASH2.__sga_target=989855744
ASH2.__shared_io_pool_size=0
ASH2.__shared_pool_size=268435456
ASH2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/ASH2/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/ASH2/control01.ctl','/u01/app/oracle/flash_recovery_area/ASH2/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='ASH1'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4070572032
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ASH2XDB)'
*.memory_target=1657798656
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.db_unique_name='ASH2'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ASH2XDB)'
*.FAL_SERVER='ASH1'
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(ASH2,ASH1)'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_archive_format='Arc_%d_%s_%t_%r'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/ash1','/u01/app/oracle/oradata/ASH2'
*.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/ash1','/u01/app/oracle/oradata/ASH2'
*.nls_date_format='dd/MM/yyyy'
*.open_cursors=300
*.pga_aggregate_target=148897792
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=419430400
*.sga_target=419430400
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.log_archive_dest_1='location=/u01/app/oracle/oradata/archive/ash2 VALID_FOR=(all_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ASH2'
*.log_archive_dest_2='SERVICE=ASH1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ASH1'
[oracle@ash2 dbs]$ 

Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655931 is a reply to message #655929] Sat, 17 September 2016 03:56 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
I do not think that your database instance is registered correctly with the listener. THe static registration would show as status UNKNOWN. Better delete and re-create the listener.ora file again, perhaps there is some invisible junk in it.
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655933 is a reply to message #655931] Sat, 17 September 2016 06:42 Go to previous messageGo to next message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member
The instance may be down, mounted but not opened, or in restricted session mode.
Add "(UR=A)" to your connect string in TNSNAMES.ORA and try to connect again.
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655950 is a reply to message #655933] Sun, 18 September 2016 03:53 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John / Frank,

I tried to re-register after deleting the listener file but getting the same error. This thing i had tried several times before posting it here. Then at last I tried to put static listener, all went fail. I added (UR=A) in my tnsname file, when showed "blocked", which was pasted on the above. None of the theses helped me out.

Regards,
Ashish Kumar Mahanta

Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655951 is a reply to message #655950] Sun, 18 September 2016 04:01 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Come on, man. All you saying is "it doesn't work" without showing what the "it" is.
WHat is your listener.ora file? What does
lsnrctl status
show you?
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655952 is a reply to message #655951] Sun, 18 September 2016 05:07 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

For the reference, below steps after removing the listener file. Please suggest me to come over by this issue.

[oracle@ash2 admin]$ rm -rf listener*
[oracle@ash2 admin]$ ls -ltr
total 20
-rw-r--r--. 1 oracle oinstall  187 May  7  2007 shrept.lst
drwxr-xr-x. 2 oracle oinstall 4096 Sep 15 09:47 samples
-rw-r--r--. 1 oracle oinstall  219 Sep 15 13:46 sqlnet1609151PM4659.bak
-rw-r--r--. 1 oracle oinstall  219 Sep 18 15:09 sqlnet.ora
-rw-r--r--. 1 oracle oinstall  522 Sep 18 15:09 tnsnames.ora
[oracle@ash2 admin]$ cd ../../bin/
[oracle@ash2 bin]$ ./netca

Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@ash2 bin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2016 15:12:52

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                15-SEP-2016 13:28:03
Uptime                    3 days 1 hr. 44 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
Services Summary...
Service "ASH2" has 1 instance(s).
  Instance "ASH2", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
[oracle@ash2 admin]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2016 15:19:22

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
The command completed successfully
[oracle@ash2 admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2016 15:19:27

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

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                18-SEP-2016 15:19:27
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@ash2 bin]$ cd ../network/admin/
[oracle@ash2 admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ash2.localdomain)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@ash2 admin]$ tnsping ash1

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2016 15:28:56

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

Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.10)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ASH1) (UR=A)))
OK (0 msec)
[oracle@ash2 admin]$ tnsping ash2

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2016 15:28:58

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

Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.11)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ASH2) (UR=A)))
OK (10 msec)
[oracle@ash2 admin]$ lsnrctl status listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2016 15:29:08

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                18-SEP-2016 15:19:27
Uptime                    0 days 0 hr. 9 min. 40 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
Services Summary...
Service "ASH2" has 1 instance(s).
  Instance "ASH2", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully



Regards,
Ashish Kumar Mahanta
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655953 is a reply to message #655952] Sun, 18 September 2016 06:24 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Ashish, I told you a long time ago that you need to add a static entry in your listener.ora file. You have not done this. The network configuration necessary for Data Guard is clearly documented, you know. just do what the doc says.
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655971 is a reply to message #655953] Sun, 18 September 2016 20:27 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

Please find the details after doing the changes..


[oracle@ash2 admin]$ lsnrctl stop listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-SEP-2016 06:47:00

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
The command completed successfully
[oracle@ash2 admin]$ vi listener.ora 
[oracle@ash2 admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ash2.localdomain)(PORT = 1521))
    )
  )

SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=ASH2)
     (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME=ASH2))
    (SID_DESC=
      (SID_NAME=ASH2)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
      (PROGRAM=extproc)))


ADR_BASE_LISTENER = /u01/app/oracle


[oracle@ash2 admin]$ lsnrctl start listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-SEP-2016 06:48:44

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

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                19-SEP-2016 06:48:44
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
Services Summary...
Service "ASH2" has 1 instance(s).
  Instance "ASH2", status UNKNOWN, has 2 handler(s) for this service...
The command completed successfully
[oracle@ash2 admin]$ lsnrctl reload listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-SEP-2016 06:49:02

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
The command completed successfully
[oracle@ash2 admin]$ lsnrctl status listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-SEP-2016 06:49:14

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                19-SEP-2016 06:48:44
Uptime                    0 days 0 hr. 0 min. 29 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
Services Summary...
Service "ASH2" has 2 instance(s).
  Instance "ASH2", status UNKNOWN, has 2 handler(s) for this service...
  Instance "ASH2", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

[oracle@ash2 admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ASH2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.11)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ASH2)
	(UR=A)   
 )
  )

ASH1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ASH1)
	(UR=A)   
 )
  )

Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655973 is a reply to message #655971] Mon, 19 September 2016 00:35 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Now you appear to have the instance registered correctly. You have not however attempted to connect.

Why did you add that entry for the extproc process? I am surprised that it has not caused a problem, and it may yet do so. Get rid of it. Just follow the documented procedures.
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655977 is a reply to message #655973] Mon, 19 September 2016 06:21 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

Can you please provide me the link for the documented procedures so that i can able rectify my doubts and resolve the issue.

Will rectify and revert after doing the changes on listener file.

Regards,
Ashish
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655979 is a reply to message #655977] Mon, 19 September 2016 06:50 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
http://docs.oracle.com/database/121/SBYDB/toc.htm
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655998 is a reply to message #655979] Mon, 19 September 2016 11:53 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

Rectified the listener...

[oracle@ash2 admin]$ lsnrctl status listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-SEP-2016 22:17:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                19-SEP-2016 22:12:34
Uptime                    0 days 0 hr. 4 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
Services Summary...
Service "ASH2" has 2 instance(s).
  Instance "ASH2", status UNKNOWN, has 2 handler(s) for this service...
  Instance "ASH2", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
[oracle@ash2 admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ash2.localdomain)(PORT = 1521))
    )
  )

SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=ASH2)
     (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME=ASH2))
    (SID_DESC=
      (SID_NAME=ASH2)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
      ))


ADR_BASE_LISTENER = /u01/app/oracle

[oracle@ash2 admin]$ 


Will check the link of the document and try to rectify..

Regards,
Ashish Kumar Mahanta
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #656384 is a reply to message #655998] Wed, 05 October 2016 00:15 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

I had tried it on windows server and it gone though with unknown status instead of blocking after adding static listener into it.

Here, in linux, I tired to re-create listener but situation is same. services status is shows as blocked.

This is the information which I gathered.

Regards,
Ashish Kumar Mahanta
Re: Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #656388 is a reply to message #656384] Wed, 05 October 2016 01:04 Go to previous message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

Today, I deleted the listener & tns file and recreated it again. And status got changed from blocked to unknown and got connected.
Same thing was done before but this time gone though. Below is the details.

Thanks to all.


[oracle@ash2 admin]$ lsnrctl reload

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-OCT-2016 11:21:42

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
The command completed successfully
[oracle@ash2 admin]$ status
status: missing job name
Try `status --help' for more information.
[oracle@ash2 admin]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-OCT-2016 11:21:58

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
The command completed successfully
LSNRCTL> start
Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                05-OCT-2016 11:22:05
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
Services Summary...
Service "ASH2" has 1 instance(s).
  Instance "ASH2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                05-OCT-2016 11:22:05
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ash2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash2.localdomain)(PORT=1521)))
Services Summary...
Service "ASH2" has 1 instance(s).
  Instance "ASH2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
[oracle@ash2 admin]$ rman target sys/oracle@ASH1 auxiliary sys/oracle@ASH2

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Oct 5 11:22:40 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ASH1 (DBID=3733215881)
connected to auxiliary database: ASH2 (not mounted)

RMAN> EXIT


Recovery Manager complete.
[oracle@ash2 admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ASH2)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
    )
  )

ADR_BASE_LISTENER1 = /u01/app/oracle

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ash2.localdomain)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@ash2 admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ASH2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.11)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ASH2)
    )
  )

ASH1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ASH1)
    )
  )

[oracle@ash2 admin]$ 


Previous Topic: Z/OS Compatibility
Next Topic: Intercept connection to Oracle DB
Goto Forum:
  


Current Time: Tue Mar 19 06:54:46 CDT 2024