Re: Trying to change remote_login_passwordfile from shared to exclusi

From: Gillian M <zmkj04_at_yahoo.com>
Date: Tue, 14 Nov 2000 10:53:39 -0800 (PST)
Message-Id: <10680.122025@fatcity.com>

The parameter is

remote_login_password_file

G!

• Garrity Ed R <Ed.R.Garrity_at_irs.gov> wrote: > I have been trying to change the value for
  > 'remote_login_passwordfile' from
  > shared to exclusive. So far, nothing I've done has
  > been successful. I have
  > it set equal to exclusive, in my init.ora file, yet
  > every time I stop and
  > restart the database, the statement,
  > select name, value from v$parameter where name =
  > 'remote_login_passwordfile',
  > shows that the value has remained shared.
  >
  > In the init.ora file I purposely misspelled
  > 'remote_login_passwordfile' to
  > see if I was using the wrong init.ora file. I
  > received an error. Oracle
  > told me that I was not using a valid parameter. So
  > I know I'm editing the
  > correct file. Next I misspelled exclusive. Once
  > again Oracle complained,
  > this time telling me that I had not entered a valid
  > value. Next I removed
  > the password file, but then the database would
  > mount, but would not open.
  > It complained that the password file did not exist.
  > So I created it using
  > "orapwd" and then I could alter database open. But
  > the value for
  > remote_login_passwordfile remains "shared". I have
  > read Oracle's
  > Administrator's Guide and the Oracle8i DBA Handbook
  > (Loney & Theriault), but
  > have found no clues. I get the same results if I
  > set
  > 'remote_login_passwordfile' equal to none. It still
  > says shared.
  >
  > The value of ifile is null, so no config.ora file is
  > being called by my
  > init.ora file.
  >
  > I'm using Oracle 8.1.6.1 on Sun Solaris 2.7.
  >
  > Can someone provide some clues?
  >
  > Thanks in Advance,
  >
  > Ed
  >
  

  ---

Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays! Received on Tue Nov 14 2000 - 12:53:39 CST