Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> making "sqlplus /" work

making "sqlplus /" work

From: niz <niz_at_infidel.freeserve.co.uk>
Date: Mon, 25 Jun 2007 20:33:47 -0700
Message-ID: <1182828827.428674.271740@z28g2000prd.googlegroups.com>


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 invalid
Received on Mon Jun 25 2007 - 22:33:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US