Pooja Chaturvedi

• Aug 15th, 2006

If we want to say that our Database is secured then we must confirm first that our Data is validate.There are various methods of validating the Data:1. Accept only known valid Data.2. Reject known Bad...

Answer Question  Select Best Answer

 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 system security.Ensuring compliance with Oralce license agreementControlling and monitoring user access...

skumarpenugonda

 Profile Answers by skumarpenugonda Questions by skumarpenugonda

• Jul 7th, 2006

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...

Prabha Sharma

• Apr 13th, 2006

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.

Answer Question  Select Best Answer

 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 network domain where the database  is  created.  The  global ...

Chiranjeevi Manne

• Nov 9th, 2005

The Minimum that are required in an init.ora file aredb_name, db_block_size, udump, bdump, cdump, controfile

Answer Question  Select Best Answer

 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 each member of the group. DYNAMIC PRIVILEGE MANAGEMENT  - When the privileges of a group must...

Statement Auditing, Privilege Auditing and Object Auditing.

 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.

 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.

 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.

 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.

 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 number not padded). The file name created is arch 0001 are if %S is used.LOG_ARCHIVE_DEST = path.

 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.     - To identify migrated and chained rows of the table or cluster.

Read Best Answer

Editorial / Best Answer

prakashpichika  

 Profile Answers by prakashpichika Questions by prakashpichika

• Member Since Jun-2006 | 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

Mohammed Abdul Afroze

• Oct 4th, 2007

To set the password for the listener.ora are as follows;lsnrctl>lsnrctl password

prakashpichika

 Profile Answers by prakashpichika Questions by prakashpichika

• Oct 3rd, 2006

oracle@localhost> lsnrctlLSNRCTL> set current_listener LISTENERCurrent Listener is LISTENERLSNRCTL> set save_config_on_stop onConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))LISTENER ...

Improve Answer