Tuesday, December 4, 2012

14 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

14 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
  4. I like this topic.This site has lots of advantage.I found many interesting things from this site. It helps me in many ways.Thanks for posting this http://www.besanttechnologies.com/training-courses/seo-training-institute-in-chennai

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

    ReplyDelete
  6. • And indeed, I’m just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective I’ve had.


    aws training in bangalore

    selinium training in bangalore


    java training in bangalore

    hadoop training in bangalore

    dotnet training in bangalore
    phyton training in bangalore


    android training in bangalore

    ReplyDelete
  7. • And indeed, I’m just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective I’ve had.

    dotnet training in bangalore

    ReplyDelete
  8. Great info on Oracle. I am a regular follower of your blog. Kindly share more information. Thanks for posting.
    BE/B.Tech Project Center in Chennai | ME/M.Tech Project Center in Chennai | Final Year Project Center in Chennai

    ReplyDelete
  9. Existing without the answers to the difficulties you’ve sorted out through this guide is a critical case, as well as the kind which could have badly affected my entire career if I had not discovered your website.

    oracle training in bangalore


    ReplyDelete

 

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