RE: Trying to change remote_login_passwordfile from shared to exc

From: Garrity Ed R <Ed.R.Garrity_at_irs.gov>
Date: Tue, 14 Nov 2000 17:36:29 -0500
Message-Id: <10680.122058@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_01C04E8B.54772910
Content-Type: text/plain;

charset="ISO-8859-1"

Thank you very much for your suggestion. Although you would have thought that I would check for a duplicate entry, and I thought I did, I tried it again. Today I checked with "grep -i remote_login_passwordfile init*.ora". Sure enough, there was another entry at the bottom of the file. I suppose I was preoccupied with other things.

-----Original Message-----
From: Suresh Kumar [mailto:su_rek_at_hotmail.com] Sent: Monday, November 13, 2000 7:35 PM
To: Garrity Ed R; oracledba_at_lazydba.com; ORACLE-L_at_fatcity.com Subject: Re: Trying to change remote_login_passwordfile from shared to exclusi ve

Is this parameter file sharing by any other process, like RMAN or something then you need to bounce both and make sure there is no duplicate entry in parameter file.

>From: Garrity Ed R <Ed.R.Garrity_at_irs.gov>
>To: "'LazyDBA'" <oracledba_at_lazydba.com>, "'ORACLE-L'"
><ORACLE-L_at_fatcity.com>
>Subject: Trying to change remote_login_passwordfile from shared to exclusi
>ve
>Date: Mon, 13 Nov 2000 18:55:30 -0500
>
>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

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at http://profiles.msn.com.

------_=_NextPart_001_01C04E8B.54772910
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>RE: Trying to change remote_login_passwordfile from shared to = exclusive</TITLE>
</HEAD>
<BODY>

Thank you very much for your suggestion.  = Although you would have thought that I would check for a duplicate = entry, and I thought I did, I tried it again.  Today I checked = with "grep -i remote_login_passwordfile init*.ora".  = Sure enough, there was another entry at the bottom of the file.  I = suppose I was preoccupied with other things.

Ed

-----Original Message----- From: Suresh Kumar [<A = HREF=3D"mailto:su_rek_at_hotmail.com">mailto:su_rek_at_hotmail.com</A>]=

Sent: Monday, November 13, 2000 7:35 PM To: Garrity Ed R; oracledba_at_lazydba.com; = ORACLE-L_at_fatcity.com
 Subject: Re: Trying to change = remote_login_passwordfile from shared to

<BR><FONT SIZE=3D2>exclusi ve</FONT>
</P>
<BR>
<BR>

Is this parameter file sharing by any other process, = like RMAN or something 
 then you need to bounce both and make sure there is = no duplicate entry in

<BR><FONT SIZE=3D2>parameter file.</FONT>
</P>
<BR>
<BR>

>From: Garrity Ed R = <Ed.R.Garrity_at_irs.gov>
 >To: "'LazyDBA'" = <oracledba_at_lazydba.com>, "'ORACLE-L'" ><ORACLE-L_at_fatcity.com> >Subject: Trying to change = remote_login_passwordfile from shared to exclusi

<BR><FONT SIZE=3D2>&gt;ve</FONT>
<BR><FONT SIZE=3D2>&gt;Date: Mon, 13 Nov 2000 18:55:30 -0500</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;I have been trying to&nbsp; 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

<BR><FONT SIZE=3D2>&gt;'remote_login_passwordfile',</FONT>
<BR><FONT SIZE=3D2>&gt;shows that the value has remained shared.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;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

<BR><FONT SIZE=3D2>&gt;remote_login_passwordfile remains =
&quot;shared&quot;.&nbsp; I have read Oracle's</FONT>
<BR><FONT SIZE=3D2>&gt;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

<BR><FONT SIZE=3D2>&gt;init.ora file.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;I'm using Oracle 8.1.6.1 on Sun Solaris =
2.7.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Can someone provide some clues?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Thanks in Advance,</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>

>Ed

<FONT =

SIZE=3D2>_______________________________________________________________=

__________
 Get Your Private, Free E-mail from MSN Hotmail at <A = HREF=3D"http://www.hotmail.com" =
TARGET=3D"_blank">http://www.hotmail.com</A>.

Share information about yourself, create your own = public profile at Received on Tue Nov 14 2000 - 16:36:29 CST