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


相似考题
参考答案和解析
正确答案: B
解析: 暂无解析
更多“You manually create an additional listener process,L1,for da”相关问题
  • 第1题:

    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

  • 第2题:

    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

  • 第3题:

    You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()

    • A、 Use the CHANGE_PASSWORD command of the Listener control utility.
    • B、 Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.
    • C、 Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.
    • D、 Manually modify the listener.ora file to include the password for the listener and restart the listener.

    正确答案:C

  • 第4题:

    You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command:   LSNRCTL>STATUS listener1   Which information will NOT be displayed when you issue the above command?() 

    • A、 whether the password is set in the listener or a file or not
    • B、 the number of client connections the service handler has refused
    • C、 the information will be displayed whether the instance can accept connections or not
    • D、 the protocol addresses on which the listener is configured to listen

    正确答案:B

  • 第5题:

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What process should you implement?() 

    • A、You should create a cached data collection
    • B、You should create an on-demand non-cached data collection 
    • C、You should create a scheduled non-cached data collection 
    • D、You should create two different SQL Agent jobs that are scheduled stimultaneously

    正确答案:A

  • 第6题:

    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

  • 第7题:

    多选题
    You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()
    A

    More than one database is to be registered with the listener.

    B

    The users will connect the database by using the host naming method.

    C

    The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.

    D

    The database that is to be registered with the listener is configured in shared server mode.

    E

    The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.


    正确答案: C,E
    解析: 暂无解析

  • 第8题:

    多选题
    Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?()
    A

    Thread creation must be routed through a dispatcher process

    B

    The local listener may spawn a now process and have that new process create a thread

    C

    Each Oracle process runs an SCMN thread.

    D

    Each multithreaded Oracle process has an SCMN thread.

    E

    The local listener may pass the request to an existing process which in turn will create a thread.


    正确答案: D,C
    解析: 暂无解析

  • 第9题:

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


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

  • 第10题:

    多选题
    You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance:   SQL> ALTER SYSTEM SWITCH LOGFILE;   Which two tasks are performed when the statement is executed? ()
    A

    The DBWn process writes to the datafile.

    B

    Changes in the background process are recorded.

    C

    The log file is updated with the current SCN number.

    D

    The System Change Number (SCN) is recorded in the control file.

    E

    The changes to the listener configuration in the listener.ora file are recorded.


    正确答案: E,C
    解析: 暂无解析

  • 第11题:

    多选题
    You are required to remove the default EXTPROC entry from the default listener configuration to create a listener that will listen specifically for EXTPROC calls. Which two methods can you use to remove the default EXTPROC entry from the default listener configuration? ()
    A

    the RMAN utility

    B

    the import/export utility

    C

    the Oracle Enterprise Manager

    D

    the change tracking feature

    E

    the Net Manager utility


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

  • 第12题:

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What process should you implement?()
    A

    You should create a cached data collection

    B

    You should create an on-demand non-cached data collection 

    C

    You should create a scheduled non-cached data collection 

    D

    You should create two different SQL Agent jobs that are scheduled stimultaneously


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

  • 第13题:

    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

  • 第14题:

    You are required to remove the default EXTPROC entry from the default listener configuration to create a listener that will listen specifically for EXTPROC calls. Which two methods can you use to remove the default EXTPROC entry from the default listener configuration? ()

    • A、 the RMAN utility
    • B、 the import/export utility
    • C、 the Oracle Enterprise Manager
    • D、 the change tracking feature
    • E、 the Net Manager utility

    正确答案:C,E

  • 第15题:

    Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener, database, and the configuration of the application. How would you avoid this scenario?()

    • A、lock the listener
    • B、hide the listener
    • C、create multiple listeners
    • D、run listener on a remote client
    • E、set a password for the listener
    • F、store listener.ora in a non-default location

    正确答案:E

  • 第16题:

    You are developing an application that receives events asynchronously.You create a WqlEventQuery instance to specify the events and event conditions to which the application must respond.You also create a ManagementEventWatcher instance to subscribe to events matching the query.You need to identify the other actions you must perform before the application can receive events asynchronously.Which two actions should you perform?()

    • A、Start listening for events by calling the Start method of the ManagementEventWatcher.
    • B、Set up a listener for events by using the EventArrived event of the ManagementEventWatcher.
    • C、Use the WaitForNextEvent method of the ManagementEventWatcher to wait for the events.
    • D、Create an event handler class that has a method that receives an ObjectReadyEventArgs parameter.
    • E、Set up a listener for events by using the Stopped event of the ManagementEventWatcher.

    正确答案:A,B

  • 第17题:

    You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application includes a function that is triggered by filling out a form and by clicking a button. Currently, the application is tested manually. You need to create an automated and iterative process to test the application. What should you do?()

    • A、 Use IntelliTrace.
    • B、 Use UISpy.exe to extract the user interface (UI) information. Then, use MSTest.exe.
    • C、 Use classes in the System.Windows.Automation and System.Windows.Automation.Text namespaces.
    • D、 Use the Action Recording methodology to record the user interface (UI) actions. Then, use MSTest.exe.

    正确答案:C

  • 第18题:

    单选题
    You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()
    A

     Use the CHANGE_PASSWORD command of the Listener control utility.

    B

     Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.

    C

     Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.

    D

     Manually modify the listener.ora file to include the password for the listener and restart the listener.


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

  • 第19题:

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


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

  • 第20题:

    单选题
    You work as a database administrator for Certkiller .com. 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.


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

  • 第21题:

    单选题
    You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command:   LSNRCTL>STATUS listener1   Which information will NOT be displayed when you issue the above command?()
    A

     whether the password is set in the listener or a file or not

    B

     the number of client connections the service handler has refused

    C

     the information will be displayed whether the instance can accept connections or not

    D

     the protocol addresses on which the listener is configured to listen


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

  • 第22题:

    多选题
    You are developing an application that receives events asynchronously.You create a WqlEventQuery instance to specify the events and event conditions to which the application must respond.You also create a ManagementEventWatcher instance to subscribe to events matching the query.You need to identify the other actions you must perform before the application can receive events asynchronously.Which two actions should you perform?()
    A

    Start listening for events by calling the Start method of the ManagementEventWatcher.

    B

    Set up a listener for events by using the EventArrived event of the ManagementEventWatcher.

    C

    Use the WaitForNextEvent method of the ManagementEventWatcher to wait for the events.

    D

    Create an event handler class that has a method that receives an ObjectReadyEventArgs parameter.

    E

    Set up a listener for events by using the Stopped event of the ManagementEventWatcher.


    正确答案: D,B
    解析: 暂无解析

  • 第23题:

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


    正确答案: H
    解析: 暂无解析

  • 第24题:

    多选题
    You work as a database administrator for Certkiller .com. Your listener process, L1,is currently listening to three databases:CertK INDB04,Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant (DBCA) you create one more database,Certkiller 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, Certkiller 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


    正确答案: B,G
    解析: 暂无解析