130.Which two statements are true regarding listeners? (Choose two.)
来源:互联网 发布:淘宝店铺旺旺号怎么看 编辑:程序博客网 时间:2024/05/16 11:08
130.Which two statements are true regarding listeners? (Choose two.)
A.Listeners use only the TCP/IP protocol.
B.Multiple listener processes can run simultaneously on a host.
C.Multiple database instances can be registered with a single listener.
D.The listener-related errors can be traced only at the administrative level.
E.Only one database instance can be registered with a single listener at any time.
答案:BC
A:错误,还有ipc
Interprocess Communication (IPC)
A protocol that client applications use that resides on the same node as the listener to communicate with the database. IPC can provide a faster local connection than TCP/IP.
B:正确
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 28-JUL-2016 09:54:17
Uptime 0 days 0 hr. 0 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/11g/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/wahaha3/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wahaha3.com)(PORT=1521)))
Services Summary...
Service "hrtest" has 1 instance(s).
Instance "hrtest", status UNKNOWN, has 1 handler(s) for this service...
Service "wahaha3" has 2 instance(s).
Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
Instance "wahaha3", status READY, has 1 handler(s) for this service...
Service "wahaha3XDB" has 1 instance(s).
Instance "wahaha3", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status lis2
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias lis2
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 28-JUL-2016 09:55:05
Uptime 0 days 0 hr. 0 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/11g/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/wahaha3/lis2/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1522)))
The listener supports no services
The command completed successfully
C:正确
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 28-JUL-2016 07:32:27
Uptime 0 days 0 hr. 55 min. 42 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/11g/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/wahaha3/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wahaha3.com)(PORT=1521)))
Services Summary...
Service "hrtest" has 1 instance(s).
Instance "hrtest", status UNKNOWN, has 1 handler(s) for this service...
Service "wahaha3" has 2 instance(s).
Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
Instance "wahaha3", status READY, has 1 handler(s) for this service...
Service "wahaha3XDB" has 1 instance(s).
Instance "wahaha3", status READY, has 1 handler(s) for this service...
The command completed successfully
D:错误
这个不会写到那里的,写的地方通过lsnrctl status中可以看到Listener Log File
如果在监听文件中没有指定路径,那么默认路径为
$ORACLE_BASE/diag/tnslsnr/$ORACLE_SID/listener/alert/log.xml
如果在监听文件中指定了ADR_BASE_listener的路径那么
$ADR_BASE_listener/diag/tnslsnr/$ORACLE_SID/listener/alert/log.xml
E:错误
A.Listeners use only the TCP/IP protocol.
B.Multiple listener processes can run simultaneously on a host.
C.Multiple database instances can be registered with a single listener.
D.The listener-related errors can be traced only at the administrative level.
E.Only one database instance can be registered with a single listener at any time.
答案:BC
A:错误,还有ipc
Interprocess Communication (IPC)
A protocol that client applications use that resides on the same node as the listener to communicate with the database. IPC can provide a faster local connection than TCP/IP.
B:正确
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 28-JUL-2016 09:54:17
Uptime 0 days 0 hr. 0 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/11g/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/wahaha3/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wahaha3.com)(PORT=1521)))
Services Summary...
Service "hrtest" has 1 instance(s).
Instance "hrtest", status UNKNOWN, has 1 handler(s) for this service...
Service "wahaha3" has 2 instance(s).
Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
Instance "wahaha3", status READY, has 1 handler(s) for this service...
Service "wahaha3XDB" has 1 instance(s).
Instance "wahaha3", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status lis2
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias lis2
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 28-JUL-2016 09:55:05
Uptime 0 days 0 hr. 0 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/11g/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/wahaha3/lis2/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1522)))
The listener supports no services
The command completed successfully
C:正确
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 28-JUL-2016 07:32:27
Uptime 0 days 0 hr. 55 min. 42 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/11g/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/wahaha3/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wahaha3.com)(PORT=1521)))
Services Summary...
Service "hrtest" has 1 instance(s).
Instance "hrtest", status UNKNOWN, has 1 handler(s) for this service...
Service "wahaha3" has 2 instance(s).
Instance "wahaha3", status UNKNOWN, has 1 handler(s) for this service...
Instance "wahaha3", status READY, has 1 handler(s) for this service...
Service "wahaha3XDB" has 1 instance(s).
Instance "wahaha3", status READY, has 1 handler(s) for this service...
The command completed successfully
D:错误
这个不会写到那里的,写的地方通过lsnrctl status中可以看到Listener Log File
如果在监听文件中没有指定路径,那么默认路径为
$ORACLE_BASE/diag/tnslsnr/$ORACLE_SID/listener/alert/log.xml
如果在监听文件中指定了ADR_BASE_listener的路径那么
$ADR_BASE_listener/diag/tnslsnr/$ORACLE_SID/listener/alert/log.xml
E:错误
0 0
- 130.Which two statements are true regarding listeners? (Choose two.)
- 35.Which two statements are true regarding constraints? (Choose two.)
- 38.Which two statements are true regarding views? (Choose two.)
- 41.Which two statements are true regarding views? (Choose two.)
- 48.Which two statements are true regarding indexes? (Choose two.)
- 133.Which two statements are true regarding subqueries? (Choose two.)
- 175.Which two statements are true regarding savepoints? (Choose two.)
- 4.Which two statements are true regarding single row functions? (Choose two.)
- 67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
- 80.Which two statements are true regarding working with dates? (Choose two.)
- 108.Which two statements are true regarding the COUNT function? (Choose two.)
- 121.Which two statements are true regarding the USING clause in table joins? (Choose two .)
- 170.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
- 26.Which two statements are true regarding undo tablespaces? (Choose two.)
- 27.Which two statements are true regarding transactions in an Oracle database? (Choose two.)
- 98.Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)
- 99.Which two statements are true regarding Oracle Data Pump? (Choose two.)
- 139.Which two statements are true regarding a tablespace? (Choose two.)
- java中关键字volatile的作用
- Android:windowIsTranslucent透明 导致activity退出动画无效
- HttpClient中文乱码
- json的查询
- SSH配置笔记
- 130.Which two statements are true regarding listeners? (Choose two.)
- Java虚拟机先锋队
- ubuntu12.04下docker不能上网的解决办法
- Android编译时报错:Conversion to Dalvik format failed with error 1
- Ubuntu14.04下载&编译Android(1)
- c/c++
- JSON.parseObject(jsonString, Object.class); 将json字符串转成一个对象
- (NYoj 104)最大和 --二维最大连续子串和转化为一维,动态规划
- Android中Home键的监听和代码操作程序Home键退出(实质没有退出而类似于最小化)