Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: making "sqlplus /" work
In message <46809214$0$26930$426a34cc_at_news.free.fr>, Michel Cadot
<micadot{at}altern{dot}org@?.?.invalid> writes
>
>"niz" <niz_at_infidel.freeserve.co.uk> a écrit dans le message de news:
>1182828827.428674.271740_at_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
>|
>
>alter user scott identified externally;
>
>
Also *.os_authent_prefix=' ' looks as if it has a space in it. It needs
to be an empty string. ''
-- Jim Smith Ponder Stibbons Limited <http://oracleandting.blogspot.com/> RSS <http://oracleandting.blogspot.com/atom.xml>Received on Tue Jun 26 2007 - 01:03:14 CDT