Oracle Rac With Scan Error
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
1
I have installed Oracle RAC with ASM on Oracle Linux 5.8. My database version is 11.2.0.1.
I have 2 node in my plan and all of them are active.
I set scan in my DNS server but I can not connect to database with scan listener. I can connect to each node with their VIP.
Some of data about listener is listed in below.
[grid@rac1 ~]$ srvctl config scan_listener
SCAN Listener LISTNERE_SCAN_1_SCAN1 exists. Port: TCP:1521
[grid@rac1 ~]$ srvctl status scan_listener
SCAN Listener LISTNERE_SCAN_1_SCAN1 is enabled
SCAN listener LISTNERE_SCAN_1_SCAN1 is running on node rac1
[grid@rac1 ~]$ lsnrctl status LISTNERE_SCAN_1_SCAN1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:46:23
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTNERE_SCAN_1_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 02-JUL-2015 05:04:58
Uptime 0 days 0 hr. 41 min. 25 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/rac1/listnere_scan_1_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTNERE_SCAN_1_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.245)(PORT=1521)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 ~]$ lsnrctl sERVICES LISTNERE_SCAN_1_SCAN1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:46:58
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)))
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521)))
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac1.localdomain, pid: 5305>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.localdomain)(PORT=30855))
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac2.localdomain, pid: 5293>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2.localdomain)(PORT=36946))
The command completed successfully
[grid@rac1 ~]$nano /u01/app/11.2.0/grid/network/admin/listener.ora
LISTNERE_SCAN_1_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))) # $
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
# listener.ora.rac1 Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora.rac1
# Generated by Oracle configuration tools.
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1 = ON
LISTENER_SCAN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTNERE_SCAN_1_SCAN1=ON # line added by Agent
[oracle@rac1 ~]$ nano /u01/app/oracle/product/11.2.0/db_1/network/admin/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.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[oracle@rac1 ~]$ nano /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:56:20
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (20 msec)
The error when I want to connect to racdb with scan name is:
[oracle@rac1 ~]$ sqlplus system/oracle@orcl
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 2 05:57:03 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of server
oracle rac listener
edited Jul 2 '15 at 8:06
Mat
8,20223338
asked Jul 2 '15 at 6:40
saeed.shsaeed.sh
761514
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
1
I have installed Oracle RAC with ASM on Oracle Linux 5.8. My database version is 11.2.0.1.
I have 2 node in my plan and all of them are active.
I set scan in my DNS server but I can not connect to database with scan listener. I can connect to each node with their VIP.
Some of data about listener is listed in below.
[grid@rac1 ~]$ srvctl config scan_listener
SCAN Listener LISTNERE_SCAN_1_SCAN1 exists. Port: TCP:1521
[grid@rac1 ~]$ srvctl status scan_listener
SCAN Listener LISTNERE_SCAN_1_SCAN1 is enabled
SCAN listener LISTNERE_SCAN_1_SCAN1 is running on node rac1
[grid@rac1 ~]$ lsnrctl status LISTNERE_SCAN_1_SCAN1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:46:23
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTNERE_SCAN_1_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 02-JUL-2015 05:04:58
Uptime 0 days 0 hr. 41 min. 25 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/rac1/listnere_scan_1_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTNERE_SCAN_1_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.245)(PORT=1521)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 ~]$ lsnrctl sERVICES LISTNERE_SCAN_1_SCAN1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:46:58
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)))
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521)))
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac1.localdomain, pid: 5305>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.localdomain)(PORT=30855))
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac2.localdomain, pid: 5293>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2.localdomain)(PORT=36946))
The command completed successfully
[grid@rac1 ~]$nano /u01/app/11.2.0/grid/network/admin/listener.ora
LISTNERE_SCAN_1_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))) # $
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
# listener.ora.rac1 Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora.rac1
# Generated by Oracle configuration tools.
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1 = ON
LISTENER_SCAN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTNERE_SCAN_1_SCAN1=ON # line added by Agent
[oracle@rac1 ~]$ nano /u01/app/oracle/product/11.2.0/db_1/network/admin/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.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[oracle@rac1 ~]$ nano /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:56:20
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (20 msec)
The error when I want to connect to racdb with scan name is:
[oracle@rac1 ~]$ sqlplus system/oracle@orcl
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 2 05:57:03 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of server
oracle rac listener
edited Jul 2 '15 at 8:06
Mat
8,20223338
asked Jul 2 '15 at 6:40
saeed.shsaeed.sh
761514
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Services are in thestate:blocked. Is the name resolution set up correctly for public and VIP names? (DNS or/etc/hosts)
– Balazs Papp
Jul 2 '15 at 7:51
In dns i set rac-scan and in /etc/hosts i set public and vip and private ip for all of nodes . where can i check state of services ?
– saeed.sh
Jul 2 '15 at 7:57
For the local listeners:lsnrctl status listener,lsnrctl services listener.
– Balazs Papp
Jul 2 '15 at 8:44
At the top of my head. remote_listener in your spfile needs to point to the scan address.
– Bjarte Brandt
Jul 2 '15 at 17:15
You scan service should also have at least 3 VIPs.
– eckes
Sep 29 '17 at 0:04
add a comment |
1
1
1
I have installed Oracle RAC with ASM on Oracle Linux 5.8. My database version is 11.2.0.1.
I have 2 node in my plan and all of them are active.
I set scan in my DNS server but I can not connect to database with scan listener. I can connect to each node with their VIP.
Some of data about listener is listed in below.
[grid@rac1 ~]$ srvctl config scan_listener
SCAN Listener LISTNERE_SCAN_1_SCAN1 exists. Port: TCP:1521
[grid@rac1 ~]$ srvctl status scan_listener
SCAN Listener LISTNERE_SCAN_1_SCAN1 is enabled
SCAN listener LISTNERE_SCAN_1_SCAN1 is running on node rac1
[grid@rac1 ~]$ lsnrctl status LISTNERE_SCAN_1_SCAN1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:46:23
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTNERE_SCAN_1_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 02-JUL-2015 05:04:58
Uptime 0 days 0 hr. 41 min. 25 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/rac1/listnere_scan_1_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTNERE_SCAN_1_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.245)(PORT=1521)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 ~]$ lsnrctl sERVICES LISTNERE_SCAN_1_SCAN1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:46:58
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)))
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521)))
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac1.localdomain, pid: 5305>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.localdomain)(PORT=30855))
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac2.localdomain, pid: 5293>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2.localdomain)(PORT=36946))
The command completed successfully
[grid@rac1 ~]$nano /u01/app/11.2.0/grid/network/admin/listener.ora
LISTNERE_SCAN_1_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))) # $
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
# listener.ora.rac1 Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora.rac1
# Generated by Oracle configuration tools.
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1 = ON
LISTENER_SCAN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTNERE_SCAN_1_SCAN1=ON # line added by Agent
[oracle@rac1 ~]$ nano /u01/app/oracle/product/11.2.0/db_1/network/admin/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.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[oracle@rac1 ~]$ nano /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:56:20
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (20 msec)
The error when I want to connect to racdb with scan name is:
[oracle@rac1 ~]$ sqlplus system/oracle@orcl
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 2 05:57:03 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of server
oracle rac listener
edited Jul 2 '15 at 8:06
Mat
8,20223338
asked Jul 2 '15 at 6:40
saeed.shsaeed.sh
761514
I have installed Oracle RAC with ASM on Oracle Linux 5.8. My database version is 11.2.0.1.
I have 2 node in my plan and all of them are active.
I set scan in my DNS server but I can not connect to database with scan listener. I can connect to each node with their VIP.
Some of data about listener is listed in below.
[grid@rac1 ~]$ srvctl config scan_listener
SCAN Listener LISTNERE_SCAN_1_SCAN1 exists. Port: TCP:1521
[grid@rac1 ~]$ srvctl status scan_listener
SCAN Listener LISTNERE_SCAN_1_SCAN1 is enabled
SCAN listener LISTNERE_SCAN_1_SCAN1 is running on node rac1
[grid@rac1 ~]$ lsnrctl status LISTNERE_SCAN_1_SCAN1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:46:23
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTNERE_SCAN_1_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 02-JUL-2015 05:04:58
Uptime 0 days 0 hr. 41 min. 25 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/rac1/listnere_scan_1_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTNERE_SCAN_1_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.245)(PORT=1521)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 ~]$ lsnrctl sERVICES LISTNERE_SCAN_1_SCAN1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:46:58
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)))
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521)))
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac1.localdomain, pid: 5305>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.localdomain)(PORT=30855))
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac2.localdomain, pid: 5293>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2.localdomain)(PORT=36946))
The command completed successfully
[grid@rac1 ~]$nano /u01/app/11.2.0/grid/network/admin/listener.ora
LISTNERE_SCAN_1_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTNERE_SCAN_1_SCAN1)))) # $
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
# listener.ora.rac1 Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora.rac1
# Generated by Oracle configuration tools.
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1 = ON
LISTENER_SCAN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTNERE_SCAN_1_SCAN1=ON # line added by Agent
[oracle@rac1 ~]$ nano /u01/app/oracle/product/11.2.0/db_1/network/admin/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.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[oracle@rac1 ~]$ nano /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-JUL-2015 05:56:20
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (20 msec)
The error when I want to connect to racdb with scan name is:
[oracle@rac1 ~]$ sqlplus system/oracle@orcl
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 2 05:57:03 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of server
oracle rac listener
oracle rac listener
edited Jul 2 '15 at 8:06
Mat
8,20223338
asked Jul 2 '15 at 6:40
saeed.shsaeed.sh
761514
edited Jul 2 '15 at 8:06
Mat
8,20223338
asked Jul 2 '15 at 6:40
saeed.shsaeed.sh
761514
edited Jul 2 '15 at 8:06
Mat
8,20223338
edited Jul 2 '15 at 8:06
Mat
8,20223338
edited Jul 2 '15 at 8:06
Mat
8,20223338
8,20223338
asked Jul 2 '15 at 6:40
saeed.shsaeed.sh
761514
asked Jul 2 '15 at 6:40
saeed.shsaeed.sh
761514
asked Jul 2 '15 at 6:40
saeed.shsaeed.sh
761514
761514
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Services are in thestate:blocked. Is the name resolution set up correctly for public and VIP names? (DNS or/etc/hosts)
– Balazs Papp
Jul 2 '15 at 7:51
In dns i set rac-scan and in /etc/hosts i set public and vip and private ip for all of nodes . where can i check state of services ?
– saeed.sh
Jul 2 '15 at 7:57
For the local listeners:lsnrctl status listener,lsnrctl services listener.
– Balazs Papp
Jul 2 '15 at 8:44
At the top of my head. remote_listener in your spfile needs to point to the scan address.
– Bjarte Brandt
Jul 2 '15 at 17:15
You scan service should also have at least 3 VIPs.
– eckes
Sep 29 '17 at 0:04
add a comment |
Services are in thestate:blocked. Is the name resolution set up correctly for public and VIP names? (DNS or/etc/hosts)
– Balazs Papp
Jul 2 '15 at 7:51
In dns i set rac-scan and in /etc/hosts i set public and vip and private ip for all of nodes . where can i check state of services ?
– saeed.sh
Jul 2 '15 at 7:57
For the local listeners:lsnrctl status listener,lsnrctl services listener.
– Balazs Papp
Jul 2 '15 at 8:44
At the top of my head. remote_listener in your spfile needs to point to the scan address.
– Bjarte Brandt
Jul 2 '15 at 17:15
You scan service should also have at least 3 VIPs.
– eckes
Sep 29 '17 at 0:04
Services are in the
state:blocked. Is the name resolution set up correctly for public and VIP names? (DNS or /etc/hosts)– Balazs Papp
Jul 2 '15 at 7:51
Services are in the
state:blocked. Is the name resolution set up correctly for public and VIP names? (DNS or /etc/hosts)– Balazs Papp
Jul 2 '15 at 7:51
In dns i set rac-scan and in /etc/hosts i set public and vip and private ip for all of nodes . where can i check state of services ?
– saeed.sh
Jul 2 '15 at 7:57
In dns i set rac-scan and in /etc/hosts i set public and vip and private ip for all of nodes . where can i check state of services ?
– saeed.sh
Jul 2 '15 at 7:57
For the local listeners:
lsnrctl status listener, lsnrctl services listener.– Balazs Papp
Jul 2 '15 at 8:44
For the local listeners:
lsnrctl status listener, lsnrctl services listener.– Balazs Papp
Jul 2 '15 at 8:44
At the top of my head. remote_listener in your spfile needs to point to the scan address.
– Bjarte Brandt
Jul 2 '15 at 17:15
At the top of my head. remote_listener in your spfile needs to point to the scan address.
– Bjarte Brandt
Jul 2 '15 at 17:15
You scan service should also have at least 3 VIPs.
– eckes
Sep 29 '17 at 0:04
You scan service should also have at least 3 VIPs.
– eckes
Sep 29 '17 at 0:04
add a comment |
1 Answer
1
active
oldest
votes
0
I had similar issue and local listener was null, fixed it when enetered proper values
I'm no expert in RAC but here is how they could look
show parameter listener
NAME TYPE VALUE
-------------------------- -------------------- ------------------------------
listener_networks string ((NAME=network2)(LOCAL_LISTENER=ot1pfcrs001_net002p)(REMOTE_LISTENER=ot1pfcrs001_net2))
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=10.101.73.140)(PORT=1541))
remote_listener string ot1pfcrs001.database.dv.hgn:1541
edited Jul 27 '17 at 19:58
Mark Stewart
8041721
answered Jul 27 '17 at 19:21
aymanzoneaymanzone
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f105746%2foracle-rac-with-scan-error%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
I had similar issue and local listener was null, fixed it when enetered proper values
I'm no expert in RAC but here is how they could look
show parameter listener
NAME TYPE VALUE
-------------------------- -------------------- ------------------------------
listener_networks string ((NAME=network2)(LOCAL_LISTENER=ot1pfcrs001_net002p)(REMOTE_LISTENER=ot1pfcrs001_net2))
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=10.101.73.140)(PORT=1541))
remote_listener string ot1pfcrs001.database.dv.hgn:1541
edited Jul 27 '17 at 19:58
Mark Stewart
8041721
answered Jul 27 '17 at 19:21
aymanzoneaymanzone
1
add a comment |
0
I had similar issue and local listener was null, fixed it when enetered proper values
I'm no expert in RAC but here is how they could look
show parameter listener
NAME TYPE VALUE
-------------------------- -------------------- ------------------------------
listener_networks string ((NAME=network2)(LOCAL_LISTENER=ot1pfcrs001_net002p)(REMOTE_LISTENER=ot1pfcrs001_net2))
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=10.101.73.140)(PORT=1541))
remote_listener string ot1pfcrs001.database.dv.hgn:1541
edited Jul 27 '17 at 19:58
Mark Stewart
8041721
answered Jul 27 '17 at 19:21
aymanzoneaymanzone
1
add a comment |
0
0
0
I had similar issue and local listener was null, fixed it when enetered proper values
I'm no expert in RAC but here is how they could look
show parameter listener
NAME TYPE VALUE
-------------------------- -------------------- ------------------------------
listener_networks string ((NAME=network2)(LOCAL_LISTENER=ot1pfcrs001_net002p)(REMOTE_LISTENER=ot1pfcrs001_net2))
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=10.101.73.140)(PORT=1541))
remote_listener string ot1pfcrs001.database.dv.hgn:1541
edited Jul 27 '17 at 19:58
Mark Stewart
8041721
answered Jul 27 '17 at 19:21
aymanzoneaymanzone
1
I had similar issue and local listener was null, fixed it when enetered proper values
I'm no expert in RAC but here is how they could look
show parameter listener
NAME TYPE VALUE
-------------------------- -------------------- ------------------------------
listener_networks string ((NAME=network2)(LOCAL_LISTENER=ot1pfcrs001_net002p)(REMOTE_LISTENER=ot1pfcrs001_net2))
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=10.101.73.140)(PORT=1541))
remote_listener string ot1pfcrs001.database.dv.hgn:1541
edited Jul 27 '17 at 19:58
Mark Stewart
8041721
answered Jul 27 '17 at 19:21
aymanzoneaymanzone
1
edited Jul 27 '17 at 19:58
Mark Stewart
8041721
edited Jul 27 '17 at 19:58
Mark Stewart
8041721
edited Jul 27 '17 at 19:58
Mark Stewart
8041721
8041721
answered Jul 27 '17 at 19:21
aymanzoneaymanzone
1
answered Jul 27 '17 at 19:21
aymanzoneaymanzone
1
answered Jul 27 '17 at 19:21
aymanzoneaymanzone
1
1
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f105746%2foracle-rac-with-scan-error%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Services are in the
state:blocked. Is the name resolution set up correctly for public and VIP names? (DNS or/etc/hosts)– Balazs Papp
Jul 2 '15 at 7:51
In dns i set rac-scan and in /etc/hosts i set public and vip and private ip for all of nodes . where can i check state of services ?
– saeed.sh
Jul 2 '15 at 7:57
For the local listeners:
lsnrctl status listener,lsnrctl services listener.– Balazs Papp
Jul 2 '15 at 8:44
At the top of my head. remote_listener in your spfile needs to point to the scan address.
– Bjarte Brandt
Jul 2 '15 at 17:15
You scan service should also have at least 3 VIPs.
– eckes
Sep 29 '17 at 0:04