PASSWORD FILE MANAGEMENT


[oracle@AZDB~]$ vi /home/oracle/oracle/product/10.2.0/db_1/dbs/initANARDB.ora

remote_login_passwordfile=’exclusive’ ->Single instance db

'shared‘ ->Multiple instance db

’none’ ->Default

remote_os_roles=true

:wq!




Creating Passwordfile:




[oracle@AZDB~]$ orapwd file=$ORACLE_HOME/dbs/orapwANARDB password=—- entries=5




 [oracle@AZDB~]$ sqlplus sys as sysdba

 SQL*Plus: Release 10.2.0.1.0 – Production on Tue Dec 9 15:35:17 2008

 Copyright (c) 1982, 2005, Oracle. All rights reserved.

 Enter password:

 Connected to an idle instance.




 SQL> create spfile from pfile;

 File created.




SQL> startup;

ORACLE instance started.

Total System Global Area 348127232 bytes

Fixed Size 1219328 bytes

Variable Size 289408256 bytes

Database Buffers 50331648 bytes

Redo Buffers 7168000 bytes

Database mounted.

Database opened.




SQL> create user anar identified by anar;

User created.




SQL> grant sysdba to anar;

Grant succeeded.




SQL> connect anar as sysdba;

Enter password:

Connected.




SQL> show user;

USER is “SYS”




View to know the password file users:




SQL> select * from v$pwfile_users;

USERNAME      SYSDB         SYSOP

———————        ———         —– —–

SYS           TRUE         TRUE

anar          TRUE         FALSE
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: