單項(xiàng)選擇題

You manually create an additional listener process，L1，for databases PROD，
PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL> start l1
Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr： please wait...
TNSLSNR for Linux： Version 10.1.0.2.0 - Production
System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on：
（ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））
TNS-12542： TNS：address already in use TNS-12560：
TNS：protocol adapter error TNS-00512： Address already in use
Linux Error： 98： Address already in use
Listener failed to start. See the error message（s） above...
What action would you take to overcome this error without disrupting any existing database communications？（）

A.stop and restart the listener process
B.set the TNS_ADMIN environmental variable
C.stop all running listener processes and restart the listener process
D.change the port number to an unused port number and restart the listener process
E.change the IP address to host machine name in the LISTENER.ORA file and restart the listener process

你可能感興趣的試題

單項(xiàng)選擇題

In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？（）

A.%t_%s.dbf
B.arch_%t.arc
C.arch_%d.arc
D.arch_%t_%d.arc
E.arch_%d_%s_.dbf
F.arch_%t_%s_%r.arc

單項(xiàng)選擇題

Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？（）

A.The operation would fail if tbs_1 were a read-only tablespace.
B.The operation would fail if tbs_1 were a read/write tablespace.
C.The operation would fail if tbs_1 were the default tablespace for the database.
D.If the above operation were successful， media recovery would be required to bring the tablespace online.
E.If the above operation were successful， instance recovery would be required to bring the tablespace online.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （）

Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？（）

Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？（）