APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 37,356 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    April 2013
    M T W T F S S
    « Nov   Aug »
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  
  • Archives

  • Authors

Database Password File: ORAPWD

Posted by appsinfo on April 2, 2013

Create PASSWORD File

1) SQL> select * from v$pwfile_users;

no rows selected

2) orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=<sys_password> entries=10
3) Now grant sysdba privilege to the users that you need. Check V$PWFILE_USERS about the entry.

SQL>GRANT SYSDBA to SYSTEM;

 SQL> select * from v$PWFILE_USERS;

USERNAME                       SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS                            TRUE  TRUE  FALSE
SYSTEM                         TRUE  FALSE FALSE
RMANUSER                       TRUE  FALSE FALSE

 SQL> select decode(count(*), 1, ‘spfile’, ‘pfile’ ) from v$spparameter where rownum=1  and isspecified=’TRUE’;

DECODE
——
spfile

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: