单项选择题

A.stop and restart the listener processB.set the TNS_AD……

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

<上一题目录下一题>

热门试题

单项选择题Inyourdatabase，youmaybeforcedtoperformarecoveryusingtheRESETLOGSoptionduringwhichtheredologswouldberesettosequencenumber1.Youwanttoavoidtheoverwritingofoldlogfiles.Whicharchivedlogfilenameformatensuresthis？（）

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

单项选择题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.

多项选择题The following are the details of your database：Instance name：test Host name ： tech1.us.oracle.com IP address：145.33.230.186 Enterprise Manager Console HTTP Port number：5500 You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control？（）

A.http：//145.33.230.186：5500/em
B.http：//www.145.33.230.186：5500/em
C.http：//tech1.us.oracle.com：5500/em
D.http：//test.145.33.230.186：5500/em
E.http：//test.tech1.us.oracle.com：5500
F.http：//www.tech1.us.oracle.com：5500/em
G.http：//test.tech1.us.oracle.com：5500/em

单项选择题You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）

A.A
B.B
C.C
D.D
E.E

多项选择题Yourapplicationdemandsfrequentconnectionanddisconnectionfromthedatabase.YouhavethreelistenerprocessesthatarelisteningforthedatabasePROD.WhilesettinguptheconnectstringusingOracleEnterpriseManager10gDatabaseControl，whichtwooptionswouldyouselecttobalancetheconnectionloadacrossallthelistenerprocesses？（）

A.Use only the first address.
B.Try one address，selected at random.
C.Try each address，in order，until one succeeds.
D.Try each address，randomly，until one succeeds.