Re: How to name the password?

On Tue, 29 Apr 2003 05:28:40 GMT, Peter <peter_at_nomorenewsspammin.ca> wrote:

>On Sat, 26 Apr 2003 16:38:45 +0200, Frank <fvanbortel_at_netscape.net>
>wrote:
>
>
>>> To reply remove -verwijderdit from my e-mail address
>>
>>OK - so I looked thru the registry, and found none.
>>It's a non-standard entry, I suppose, like tns_admin.
>>Then searched the docu, and even in Oracle8i Configuration
>>Parameters and the Registry (Appendix C - Windows Admin Guide)
>>there is no mention of such entry in the registry.
>>
>>The Windows manuals for 9iR2 state there's a value ORA_SID_PWFILE
>>(http://download-west.oracle.com/docs/cd/B10501_01/win.920/a95491/admin.htm#1006254)
>>Searching back of ora_sid_pwfile, the only mention of such an evironment
>>setting for 8i is in the error manual: look up ora-1990.
>>
>>So it is rather ill documented for 8i, so say the least.
>>Did not bother to check for 9iR1
>
>In the manual, it says that for the initialization parameter file
>parameter REMOTE_LOGIN_PASSWORDFILE
>
>"shared" is the default value.
>
>But further on it says,
>
>"none" specifies that Oracle9i database ignores the password file and
>that authentication of privileged users is handled by the Windows
>operating system. This is the default setting.
>
>So which is the default?
>
>
>
>

Just run
show parameter remote_login_passwordfile in sql*plus, if that's not asked too much. Undoubtedly you didn't change it.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 29 2003 - 12:30:40 CDT