g.mrunalini

 Profile Answers by g.mrunalini 

• Jul 22nd, 2008

 

There are two types of authentications
OS level
DB level

For OS level authentication:

1. Shutdown the database
2. Set OS_AUTHENT_PREFIX=' '    in init.ora file
3.$ connect  '/ as sysdba'
4. > startup
5.> create user  username(OS level userid created by admin) identified externally;
6.>grant connect, resource to username;
7.dbs$ sqlplus /
8. $username connect  / as sysdba
9. startup force

For DB level authentication:

1. set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE  in init.ora file
2. dbs$orapwd file=orapw$ORACLE_SID password=sys force=y
3. startup force;
4. grant sysdba to user(any user in the database);
5. conn user/user
6. conn user/user as sysdba
7. sho user

ashokbabugaddipati

 Profile Answers by ashokbabugaddipati 

• Jun 2nd, 2011

 

1.set the remote_login_passwordfile='EXCLUSIVE'

2.orapwd  file=pwdsid.ora password=xxxxxx  force=y

we have to check the password file is created or not using the following query

SQL> select * from v$pwfile_users;