External authentication
579802Mar 3 2009 — edited Mar 4 2009Hi, below the info about current situation:
1) OS: Redhat Linux 4 update.
2) Oracle DB: 10gR2
3) the init parameter: OS_AUTHENT_PREFIX=OPS$
4) OS user: TEST
5) Oracle user: OPS$TEST (created by the command: create user OPS$TEST identified externally)
Note: in order to avoid case sensitivity, I used uppercase for all values (OPS$, oracle user OPS$TEST, and linux OS user TEST )
Problem: I login to linux as user TEST, run the 'sqlplus' program and try login to oracle not providing password (because I try to be authenticated by OS ) as below. I get the error:
$sqlplus /nolog
SQL>connect /
Enter user-name:
ERROR: ORA-01005: invalid username/password...
SQL>connect OPS$TEST
Enter user-name:
ERROR: ORA-01005: null password given...
The documentation say I could login without providing password if I ensure the situation above. Bu oracle wants the external authenticated user OPS$TEST to provide password. Then what might be the problem?