remote_os_authent

[Sophia Choi]

I have tried to create an user who is called choi identified externally default tablespace users. I also create an user login account in NT server.
But I can use alter system set remote_os_authent=true and cannot find this parameter in init.ora.
So, how can I do ?
Thanks

[Nagendra Prasad]

btw... What version of oracle are u using?
anyway... one thing u might want to check is the value that you have set for the init.ora parameter os_authent_prefix. This is prob. set to OPS$.
You would need to prefix ur username with this.
[ September 16, 2003: Message edited by: Nagendra Prasad ]
Sorry.. just read ur post once again... and understood it differently.. is you priblem this:
u executed 'alter system'.. and u cannnot see the result in 'init.ora'???
Welll... that will never happen..u would have to manually add this paramter to the file.
[ September 16, 2003: Message edited by: Nagendra Prasad ]

[Sophia Choi]

As I want to try OS authentication, a parameter remote_os_authent has to be defined to be true. Since i can't find the parameter in init.ora, I add it at the last line. I shutdown and startup the instance. but the value is empty as I use show parameter remote_os_authent .
How can I do ?
Thanks

[Nagendra Prasad]

Sophia,
It looks like we might have edited the wrong init.ora???
There is another way you can check the value of this parameter.
Try a query against v$parameter view for this parameter name.
Also, could you please let me know what ur startup commands are?
try startup pfile=PATH_AND_NAME of ur init.ora

[Sophia Choi]

The parameter remote_os_authent is true right now.
But when I log in as choi in NT and type sqlplus / in the command , it says the invalid username/password.