What are the steps to creating a password authentication file?

What are the steps to creating a password authentication file?

- A Password file in Oracle can be created using the ORAPWD command.
- The command below creates a file pass.pwd for 30 users and temporary password as “tempo”
- ORAPWD FILE=pass.pwd PASSWORD= tempo ENTRIES=30

What are the steps to creating a password authentication file?

The steps are :

- First set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora file
- Then dbs$orapwd file=orapw$ORACLE_SID password=sys force=y
- Then startup force;
- Then grant sysdba to user(any user in the database);
- Then conn user/user
- Then conn user/user as sysdba
- Then show user.
What is configure command and recovery catalog?
Cold Backup, Physical Backup, Logical Backup, Hot backupA recovery catalog is a schema stored in a database. It tracks backups and stores scripts for use in RMAN backup and recovery situations...
What are different types of backup? (Hot, Cold, logical, Physical)?
Cold Backup, Physical Backup, Logical Backup, Hot backup...
Concept of Flashback Query in Oracle (10g in particular)
Due to human errors, valuable data gets deleted or misentered. Oracle Flashback Technology provides a set of new features to view and undo the data back and forth.....
Post your comment