Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> making "sqlplus /" work
hi,
i want to make "sqlplus /" connect directly into the db without giving "invalid username/password" or prompting for username and password.
what do i need to to do in order to achieve this?
i have a unix user scott. i have a db user scott.
i have these relevant oracle db parameters:
*.remote_os_authent=TRUE
*.os_authent_prefix=' '
logged in as unix user scott, i want to issue "sqlplus /" and connect directly into the db.
logged into unix user scott:
sqlplus scott/tiger -> works OK
sqlplus scott -> prompts for password
sqlplus -> prompts for username & password
sqlplus /.-> gives ERROR:ORA-01017: invalid username/password; logon
denied
what am i missing here?
-- reply to group, email invalidReceived on Mon Jun 25 2007 - 22:33:47 CDT