单选题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 

题目
单选题
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

相似考题

1.You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.

2.Youmanuallycreateanadditionallistenerprocess,L1,for&enYoumanuallycreateanadditionallistenerprocess，L1，fordatabasesPROD，PAYDBandFINDB.Whilestartingupthelistenerprocess，yougetthefollowingerrormessage：LSNRCTL>startl1Starting/u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr：pleasewait...TNSLSNRforLinux：Version10.1.0.2.0-ProductionSystemparameterfileis/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.oraLogmessageswrittento/u01/app/oracle/product/10.1.0/db_1/network/log/l1.logErrorlisteningon：（ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））TNS-12542：TNS：addressalreadyinuseTNS-12560：TNS：protocoladaptererrorTNS-00512：AddressalreadyinuseLinuxError：98：AddressalreadyinuseListenerfailedtostart.Seetheerrormessage（s）above...Whatactionwouldyoutaketoovercomethiserrorwithoutdisruptinganyexistingdatabasecommunications？（）

3.YouhavejustrunthissyntaxtostartthelistenerfromtheListenerControlutility：LSNRCTL>STARTStarting/mstgelai/oracle/bin/tnslsnr：pleasewait…Systemparameterfileis/u01/oracle/network/admin/listener.oraLogmessageswrittento/u01/oracle/network/log/listener.logListeningon：（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521）））Connectingto…ThecommandcompletedsuccessfullyWhatisthenameoftheListeneryoustarted？（）A.TNSLSNRB.LISTENERC.LOCAL_LISTENERD.DEFAULT_LSRN

4.Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The environment variables have the following value:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1What is the location of the Automatic Diagnostic Repository (ADR) home?（）A./u01/app/oracle/product/11.1.0/db_1B./u01/app/oracleC.$ORACLE_HOME/bdumpD.$ORACLE_HOME/log

参考答案和解析
正确答案： D
解析： 暂无解析
更多“单选题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 w”相关问题

  • 第1题：

    You have just run this syntax to start the listener from the Listener Control utility：   LSNRCTL>START   Starting /mstgelai/oracle/bin/tnslsnr： please wait…  System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log  Listening on： （DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521））） Connecting to…  The command completed successfully   What is the name of the Listener you started？（）

    • A、TNSLSNR
    • B、LISTENER
    • C、LOCAL_LISTENER
    • D、DEFAULT_LSRN

    正确答案:C

  • 第2题：

    You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）

    • A、It would attempt to start the default listener
    • B、It would start the most recently created listener.
    • C、It would display an error with a message asking for the listener name to be specified.
    • D、It would show you a list of listeners and prompts for the listener name that you want to start.

    正确答案:A

  • 第3题：

    You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）

    • A、 by using the STATUS command of the Listener control utility
    • B、 by using the STATUS L1 command of the Listener control utility
    • C、 by using the SHOW RULES command of the Listener control utility
    • D、 by using the SET PASSWORD command of the Listener control utility
    • E、 by searching for the PASSWORD_LISTENER entry in the listener.ora file

    正确答案:B

  • 第4题：

    You work as a database administrator for Supportcenter.cn. Your listener process， L1， is currently listening to three databases： CertK INDB04， SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant （DBCA） you create one more database， SupportCenter DB07， and enable dynamic registration. Which two commands of Listener Control Utility （lsnrct1） would you use to determine whether the dynamic registration occurred for the database， SupportCenter DB07， with the L1 listener process？（）

    • A、SHOW L1
    • B、SPAWN L1
    • C、STATUS L1
    • D、SERVICES L1
    • E、STATUS LISTENER
    • F、SERVICES LISTENER
    • G、SHOWcurrent_listener

    正确答案:C,E

  • 第5题：

    You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error： ORA-01081： cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）

    • A、ORA_PATH
    • B、ORACLE_SID
    • C、ORACLE_BASE
    • D、ORACLE_HOME
    • E、LD_LIBRARY_PATH

    正确答案:B

  • 第6题：

    You issue these LSNRCTL commands：  LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02  What is the result of issuing these commands？（）

    • A、A listener named LISTENER is started.
    • B、A listener named LISTENER01 is started.
    • C、A listener named LISTENER02 is started.
    • D、The START command fails and no listener is started.

    正确答案:C

  • 第7题：

    单选题
    You have just run this syntax to start the listener from the Listener Control utility：   LSNRCTL>START   Starting /mstgelai/oracle/bin/tnslsnr： please wait…  System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log  Listening on： （DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521））） Connecting to…  The command completed successfully   What is the name of the Listener you started？（）
    A

    TNSLSNR

    B

    LISTENER

    C

    LOCAL_LISTENER

    D

    DEFAULT_LSRN


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）
    A

    It would attempt to start the default listener

    B

    It would start the most recently created listener.

    C

    It would display an error with a message asking for the listener name to be specified.

    D

    It would show you a list of listeners and prompts for the listener name that you want to start.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）
    A

    START

    B

    RELOAD

    C

    RESTART

    D

    REFRESH

    E

    START L1

    F

    RELOAD L1

    G

    RESTART L1

    H

    REFRESH L1


    正确答案： E
    解析： 暂无解析

  • 第10题：

    多选题
    When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue.  /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.  Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）
    A

    NLS_LANG

    B

    ORACLE_SID

    C

    ORACLE_HOME

    D

    ORACLE_BASE

    E

    LD_LIBRARY_PATH


    正确答案： A,D
    解析： 暂无解析

  • 第11题：

    单选题
    You executed the following command in the lsnrctl utility to stop the listener： lsnrctl> STOP L1  What is the effect of this command if L1 is the only listener configured for your database？（）
    A

    It terminates all user sessions.

    B

    It prevents users from logging in to the database remotely.

    C

    It halts the server until all user transactions are completed.

    D

    The server hangs， so users will receive an error asking them to login again.

    E

    Connected users would get an error with the message End of communication channel.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    You have two listener processes， named L1 and L2. Both the listener processes are currently functional. While viewing the listener.ora file on your database server， you find the following entry： PASSWORDS_L1 = （1sanfrjp43） What would be the impact of this setting？（）
    A

    The listener process named L1 will disconnect the unauthorized users.

    B

    The listener process named L1 will be prevented from being started by unauthorized users. 

    C

    The listener process named L1 will be prevented from being stopped by unauthorized users. 

    D

    The listener process named L1 will be prevented from being reloaded by unauthorized users.

    E

    The listener process named L1 will be prevented from accepting connections from unauthorized users.


    正确答案： E
    解析： 暂无解析

  • 第13题：

    You executed the following command in the lsnrctl utility to stop the listener： lsnrctl> STOP L1  What is the effect of this command if L1 is the only listener configured for your database？（）

    • A、It terminates all user sessions.
    • B、It prevents users from logging in to the database remotely.
    • C、It halts the server until all user transactions are completed.
    • D、The server hangs， so users will receive an error asking them to login again.
    • E、Connected users would get an error with the message "End of communication channel".

    正确答案:B

  • 第14题：

    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

    正确答案:D

  • 第15题：

    Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）

    • A、/u01/app/oracle/product/11.1.0/db_1
    • B、/u01/app/oracle
    • C、$ORACLE_HOME/bdump
    • D、$ORACLE_HOME/log

    正确答案:B

  • 第16题：

    Examine the following values of the initialization parameters in the database having the SID ORCL：   BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=   The environment variables have the following value：   ORACLE_BASE=/u01/app/oracle  ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1   What is the location of the Automatic Diagnostic Repository （ADR） home？（）

    • A、 /u01/app/oracle/product/11.1.0/db_1
    • B、 /u01/app/oracle
    • C、 $ORACLE_HOME/bdump
    • D、 $ORACLE_HOME/log

    正确答案:B

  • 第17题：

    When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue.  /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.  Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）

    • A、NLS_LANG
    • B、ORACLE_SID
    • C、ORACLE_HOME
    • D、ORACLE_BASE
    • E、LD_LIBRARY_PATH

    正确答案:B,C

  • 第18题：

    You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）

    • A、START
    • B、RELOAD
    • C、RESTART
    • D、REFRESH
    • E、START L1
    • F、RELOAD L1
    • G、RESTART L1
    • H、REFRESH L1

    正确答案:F

  • 第19题：

    单选题
    Examine the following values of the initialization parameters in the database having the SID ORCL：   BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=   The environment variables have the following value：   ORACLE_BASE=/u01/app/oracle  ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1   What is the location of the Automatic Diagnostic Repository （ADR） home？（）
    A

     /u01/app/oracle/product/11.1.0/db_1

    B

     /u01/app/oracle

    C

     $ORACLE_HOME/bdump

    D

     $ORACLE_HOME/log


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error： ORA-01081： cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）
    A

    ORA_PATH

    B

    ORACLE_SID

    C

    ORACLE_BASE

    D

    ORACLE_HOME

    E

    LD_LIBRARY_PATH


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    You issue these LSNRCTL commands：  LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02  What is the result of issuing these commands？（）
    A

    A listener named LISTENER is started.

    B

    A listener named LISTENER01 is started.

    C

    A listener named LISTENER02 is started.

    D

    The START command fails and no listener is started.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    You were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）
    A

    by using the STATUS command of the Listener control utility

    B

    by using the STATUS L1 command of the Listener control utility

    C

    by using the SHOW RULES command of the Listener control utility

    D

    by using the SET PASSWORD command of the Listener control utility

    E

    by searching for the PASSWORD_LISTENER entry in the listener.ora file


    正确答案： E
    解析： 暂无解析

  • 第23题：

    单选题
    Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）
    A

    /u01/app/oracle/product/11.1.0/db_1

    B

    /u01/app/oracle

    C

    $ORACLE_HOME/bdump

    D

    $ORACLE_HOME/log


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

相关内容