Tuesday, December 4, 2012

4 Use orapwd to create the oracle password file.

Password file is only used to authenticate for SYSDBA,SYSOPER and SYSASM. Not for the normal user.
password file location: $ORACLE_HOME/dbs/orapw$ORACLE_SID

image

Before the Oracle 10g, if no password file exist, the create database would fail. After the 10g, the cerate database would work but no user can login from remote as SYSDBA,SYSOPER and SYSASM.

image

orapwd file=$ORACLE_HOME/dbs/orapwMYDB password=orcl

image

after the password file is created and REMOTE_LOGIN_PASSWORDFILE set to EXCLUSIVE or SHARE, we can login remotely as sysdba.

image

4 comments:

  1. There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.


    Best Oracle Training in Chennai
    Oracle Training Chennai

    ReplyDelete
  2. I am following your blog from the beginning, it was so distinct & I had a chance to collect conglomeration of information that helps me a lot to improvise myself. I hope this will help many readers who are in need of this vital piece of information. Thanks for sharing & keep your blog updated.
    Regards,
    CCNA Training in Chennai | CCNA Training institute in Chennai | CCNA Training

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates