Re: Urgent Remote login problem

From: <MTPConsulting_at_aol.com>
Date: Tue, 21 Nov 2000 09:22:37 EST
Message-Id: <10687.122608@fatcity.com>

--part1_22.e070a35.274bdf2d_boundary
Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit

Cherie,
What tool are your users using to try to connect? That has to be in the same ORACLE_HOME as your database. The likely problem is that it's something like Forms which is now required to be in a separate home. Which means that you can no longer use OPS$ logins. Oracle is really forcing elimination of this option. Sorry.

I just went thru this with a client of mine last week.

Marc Perkowitz
MTP Systems Consulting

In a message dated 11/20/00 6:48:39 PM Central Standard Time, Cherie_Machler_at_gelco.com writes:

> I just migrated a 7.3.4 database to 8.1.5 on Sun Solaris.
> 
> Instructions said to copy init.ora, conv.dbf and orapwSID file
> from 7.3.4 $ORACLE_HOME/dbs directory to 8,1.5.   There
> was no orapwSID file in the 7.3.4 directory.  Now my users
> complain that they cannot use OPS$ logins.
> 
> In the init.ora file
> remote_os_authent   was set to true
> remote_login_passwordfile  was not present in the init.ora file.
> 
> I added remote_login_passwordfile to init.ora file and tried
> setting it to exclusive, (got an error on startup), then to shared
> (got an error on startup) and then to none and was able to
> restart.  They still indicate that they can't login to ops$.
> 
> How is the orapwfile created if you don't have one?
> 
> I am cut off from my documentation at home and my browser
> is on the fritz.
> 
> Any suggestions?  What am I doing wrong?
> 
> Thanks,
> 
> Cherie
> 
>

--part1_22.e070a35.274bdf2d_boundary
Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: 7bit

<HTML>Cherie,
 What tool are your users using to try to connect?  That has to be in the same ORACLE_HOME as your database.  The likely problem is that it's something like Forms which is now required to be in a separate home.  Which means that you can no longer use OPS$ logins.  Oracle is really forcing elimination of this option.  Sorry.
 
 I just went thru this with a client of mine last week.
 
 Marc Perkowitz
 MTP Systems Consulting
 
 In a message dated 11/20/00 6:48:39 PM Central Standard Time, Cherie_Machler_at_gelco.com writes:
 
 
 <BLOCKQUOTE TYPE=CITE style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">I just migrated a 7.3.4 database to 8.1.5 on Sun Solaris.
 
 Instructions said to copy init.ora, conv.dbf and orapwSID file
 from 7.3.4 $ORACLE_HOME/dbs directory to 8,1.5.   There
 was no orapwSID file in the 7.3.4 directory.  Now my users
 complain that they cannot use OPS$ logins.
 
 In the init.ora file
 remote_os_authent   was set to true
 remote_login_passwordfile  was not present in the init.ora file.
 
 I added remote_login_passwordfile to init.ora file and tried
 setting it to exclusive, (got an error on startup), then to shared
 (got an error on startup) and then to none and was able to
 restart.  They still indicate that they can't login to ops$.
 
 How is the orapwfile created if you don't have one?
 
 I am cut off from my documentation at home and my browser
 is on the fritz.
 
 Any suggestions?  What am I doing wrong?
 
 Thanks,
 
 Cherie
Received on Tue Nov 21 2000 - 08:22:37 CST