What are the responsibilities of a database administrator ?
installing and upgrading the Oracle server and application tools.Allocating system storage and planning future storage requirements for the database system.Managing primary database structures (tablespaces)managing primary objects (table,views,indexes)enrolling users and maintaining...
What are the minimum parameters should exist in the parameter file (init.Ora) ?
db name - must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control file while database creation. db_domain - it is string that specifies ...
The Minimum that are required in an init.ora file are
db_name, db_block_size, udump, bdump, cdump, controfile
reduced granting of privileges - rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges for a group of related users granted to a role and then grant only the role to...
What are the different levels of auditing ?
Statement auditing, privilege auditing and object auditing.
What is user account in Oracle database?
an user account is not a physical structure in database but it is having important relationship to the objects in the database and will be having certain privileges.
How will you enforce security using stored procedures?
don't grant user access directly to tables within the application. instead grant the ability to access the procedures that access the tables. when procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.
What are the dictionary tables used to monitor a database spaces ?
dba_free_spacedba_segmentsdba_data_files.
What is a trace file and how is it created ?
each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.
What are roles? How can we implement roles ?
roles are the easiest way to grant and manage common privileges needed by different groups of database users. creating roles and assigning provides to roles. assign each role to group of users. This will simplify the job of assigning privileges to individual users.
How can we specify the archived log file name format and destination?
by setting the following values in init.Ora file. log_archive_format = arch %s/s/t/tarc (%s - log sequence number and is zero lEFT paded, %s - log sequence number not padded. %t - thread number lef-zero-paded and %t - thread...
What is the use of analyze command ?
to perform one of these function on an index,table, or cluster: - to collect statistics about object used by the optimizer and store them in the data dictionary. - to delete statistics about the object used by object from the data dictionary. - to validate the structure of the object. ...
How do you set password for listener.Ora ?
Answered by: prakashpichika
View all questions by prakashpichika View all answers by prakashpichika
Member Since Jun-2006 | Answered On : Oct 3rd, 2006
oracle@localhost> lsnrctl
LSNRCTL> set current_listener LISTENER
Current Listener is LISTENER
LSNRCTL> set save_config_on_stop on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter "save_config_on_stop" set to ON
The command completed successfully
LSNRCTL> change_password
Old password:
New password:
Reenter new password:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Password changed for LISTENER
The command completed successfully
LSNRCTL> set password
Password:
The command completed successfully
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully
LSNRCTL> exit
Cheers
To set the password for the listener.ora are as follows;
lsnrctl>lsnrctl password
oracle@localhost> lsnrctlLSNRCTL> set current_listener LISTENERCurrent Listener is LISTENERLSNRCTL> set save_config_on_stop onConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))LISTENER ...
adding to the list* involved in database design * applying patch sets * writing scripts to automate the routine DBA tasks* configuring oracle net such as listeners and tnsnames* data loading and unloa...
Defining physical and logical schema of database.
Take periodically backup of the database.
Assign authorization to the database users.
Define various method for storing and retrieving of data.