OraFAQ Forum: Networking and Gateways » Instance "ASH2", status BLOCKED, has 1 handler(s) for this service...

Home » RDBMS Server » Networking and Gateways » Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... (11g, 11.2.0.1, oel-6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Instance "ASH2", status BLOCKED, has 1 handler(s) for this service... [message #655913]

Fri, 16 September 2016 02:07

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

Report message to a moderator

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

John Watson
Messages: 8964
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.

Report message to a moderator

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

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Thanks John,

I will rectify it and revert.

Regards,
Ashish

Report message to a moderator

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

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]$

Report message to a moderator

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

John Watson
Messages: 8964
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.

Report message to a moderator

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

Frank Naude
Messages: 4589
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.

Report message to a moderator

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

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

Report message to a moderator

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

John Watson
Messages: 8964
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?

Report message to a moderator

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

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

Report message to a moderator

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

John Watson
Messages: 8964
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.

Report message to a moderator

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

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)   
 )
  )

Report message to a moderator

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

John Watson
Messages: 8964
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.

Report message to a moderator

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

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

Report message to a moderator

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

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

http://docs.oracle.com/database/121/SBYDB/toc.htm

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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]$

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 29 00:01:22 CST 2025