Path: utzoo!attcan!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!elroy.jpl.nasa.gov!ncar!ico!attc!toncha
From: toncha@attc.UUCP (Tony Chang)
Newsgroups: comp.databases
Subject: Using auto-login feature of ORACLE
Message-ID: <943@attc.UUCP>
Date: 18 Dec 90 20:40:08 GMT
Reply-To: toncha@auto-trol.COM ()
Organization: Auto-trol Technology, Denver
Lines: 59

Hi everyone,

This letter is writen to thank anyone who had responded to the 
question which Scott Levin and I posted to the "usenet" a few
weeks ago. The question is about using automatic login feature
of ORACLE.

The problem specifically was that when we tried to run sqlplus
using an automatic login account (OPS$ account) over a SUN
network featuring Ethernet and TCP/IP, an ORACLE error occured
indicating invalid username or password. The command and its
corresponding error messages are as the following:
 
    SQL> CONNECT /@T:oracle_server:TEST_DB
 
    ERROR: ORA-01017: invalid username/password; logon denied
 

The following command, however, worked.

    SQL> CONNECT OPS$user1/user1_password@T:oracle_server:TEST_DB

After we received responses from you guys, we were very excited 
and were very confident that this problem is definitely
solvable even though there is some indications from a couple of
responses showing that this can not be done.

We eventually found out what our problems were and had corrected
them. The problems were

1. the file permission and ownership of 'orasrv' under 
   $ORACLE_HOME/bin subdirectory is not set correctly.
   According to the ORACLE SQL*Net TCP/IP Manual, 'orasrv'
   should be owned by "root" and should have the permission
   "4555". We had our 'orasrv' owned by "oracle_dba" and
   have permissoin "555".

2. /etc/hosts on the client node did not have the server's
   Internet address listed.

We are not sure about if the second item is a factor since we
have "Yellow Page" running on the network which has all addresses
of the nodes connected. But we added the server address to the
file anyway.

Thank all of you for your generousity on sharing valuable 
knowledge on this matter. We have been puzzled by this problem
for quite a long time, and are very pleased to have it resolved.
If any of you has similiar problems, please check the above two
things first. They might be helpful. If you need any more
information regarding this matter, please feel free to contact
Scott or me. Scott's e-mail address is

	scolev@auto-trol.com

-----------------------------------------------------------------
Tun-Lian (Tony) Chang              Phone : (303) 252-2029
Marketing & Applications           Fax   : (303) 252-2249
Auto-trol Technology Corporation   email : toncha@auto-trol.com