Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    Unanswered: init parameter remote_login_passwordfile

    Dear All
    I want to change the parameter remote_login_passwordfile to none.I have tried it in two ways
    1. in nomount mode : alter system set remote_login_passwordfile=none
    2. modify the pfile remote_login_passwordfile=none and restart DB
    They were failed. How can I change the parameter

    Many Thank.s

  2. #2
    Join Date
    Jan 2004
    Any parametric changes to init file should be associated with a shutdown of the instance and then again restarting it.
    But if its 9i we can dynamic change in the parameter value this only happens if the db has been started with spfile and not init file.
    If you donot have an spfile and want to create one from existing modified version of init file use
    create spfile from pfile;
    Startup command without a pfile parameter by default searches for spfile and only goes for init file if it doesn't find one.

    Hope it clears ur doubt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts