Password file is used by Oracle database server to authenticate APPDBA - Oracle DBA

Q.  If you want the user APP_DBA to administer the oracle database from a remote machine .APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA?
- Published on 27 Jul 15

a. Control file
b. Password file
c. Listener controller file
d. Control file and password file

ANSWER: Password file
 

    Discussion

  • Nirja Shah   -Posted on 26 Aug 15
    - The following are:

    -Password file - You can create a password file using the password file creation utility, ORAPWD. For some operating systems, you can create this file as part of your standard installation.

    -Control file - It is a small binary file that records the physical structure of the database and includes: The database name. Names and locations of associated datafiles and online redo log files. The timestamp of the database creation.

    -Listener Control file - Listener configuration, stored in the listener.ora file, consists of the following elements:

    1. Name of the listener
    2. Protocol addresses that the listener is accepting connection requests on
    3. Database services

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)