[oracle@AZDB~]$ vi /home/oracle/oracle/product/10.2.0/db_1/dbs/initAZKKDB.ora
remote_login_passwordfile=’exclusive’ ->Single instance db
'shared‘ ->Multiple instance db
’none’ ->Default

Creating Passwordfile:

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

 [oracle@AZDB~]$ sqlplus sys as sysdba
 SQL*Plus: Release – 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:

SQL> show user;

View to know the password file users:

SQL> select * from v$pwfile_users;
———————        ———         —– —–
SYS           TRUE         TRUE
anar          TRUE         FALSE

Leave a Reply

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

You are commenting using your 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: