Oracle Database password file and parameter file management

Create password file [[email protected] ~]$ orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwking  password=oracle entries=5 force=y[[email protected] ~]$ sqlplus / as  sysdbaSQL> show parameter remote_login_passwordfileNAME                                   TYPE                                value------------------------------------ ---------------------------------  ------------------------------remote_login_passwordfile             string                              exclusivesql> grant sysdba  to tpcc; sql> select * from v$pwfile_users; username             sysdba           SYSOPER          Sysasm-------------------- --------------- --------------- ---------------sys                   TRUE             TRUE             FALSETPCC                  TRUE             false          &nbsp falsesql> revoke sysdba from tpcc; sql> select * from v$pwfile_users; username             sysdba           SYSOPER          Sysasm-------------------- --------------- --------------- ---------------sys                   TRUE             TRUE             false

Oracle Database password file and parameter file management