Trying to change remote_login_passwordfile from shared to exclusi

From: Garrity Ed R <Ed.R.Garrity_at_irs.gov>
Date: Mon, 13 Nov 2000 18:55:30 -0500
Message-Id: <10679.121956@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04DCD.341B4250
Content-Type: text/plain;

charset="ISO-8859-1"

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,

------_=_NextPart_001_01C04DCD.341B4250
Content-Type: text/html;

charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DISO-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Trying to change remote_login_passwordfile from shared to =
exclusive</TITLE>
</HEAD>
<BODY>

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 =3D '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
Received on Mon Nov 13 2000 - 17:55:30 CST