unix user not able to connect using sqlplus..

From: Anand Patil <anand.patil_at_verizon.com>
Date: 19 Mar 2002 13:38:55 -0800
Message-ID: <27aedf68.0203191338.2c4e287f_at_posting.google.com>


Hi,
I have installed oracle 9i on linux 7.1. If my userid is oracle i can start sqlplus, connect to oracle and start oracle.
But when i am normal unix user, i can start sqlplus, but when i try to connect from within sqlplus i get invalid login, password. message.
I read a couple of postings and set correct permission in the $ORACLE_HOME/bin dir etc.. and set the setuid bit. From other window i can do su - userid and enter the password and can get logged in.
why does this same userid and password not work in sqlplus? I can connect as sysdba, but i don't want a normal user connecting as sysdba.
DO i need to change the groupid of the normal unix user to oracle gid?
I had done create user ... identified externally as oracle user to create this user in oracle database.
Thanks for any input. Received on Tue Mar 19 2002 - 22:38:55 CET

Original text of this message