为什么OS认证enable了,却不能成功进行OS认证?
[oracle@alt-5 admin]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-OCT-2009 21:11:29
Copyright (c) 1991, 2005, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.91)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date
09-OCT-2009 21:11:23
Uptime
0 days 0 hr. 0 min. 6 sec
Trace Level
support
Security
ON: Local OS AuthenticationSNMP
OFF
Listener Parameter File /db/oracle/product/10.2.1/network/admin/listener.ora
Listener Log File /db/oracle/product/10.2.1/network/log/listener.log
Listener Trace File /db/oracle/product/10.2.1/network/trace/listener.trc
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.91)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@alt-5 admin]$ less sqlnet.ora
[oracle@alt-5 admin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 9 21:14:37 2009
Copyright (c) 1982, 2005, Oracle.All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
[oracle@alt-5 admin]$ grep sqlnet.authentication_services sqlnet.ora
#bvasudev 02/07/97 - Change sqlnet.authentication_services documentation
#sqlnet.authentication_services
#sqlnet.authentication_services=(beq, kerberos5)
sqlnet.authentication_services=(nts)
[oracle@alt-5 admin]$ grep LOCAL_OS_AUTHENTICATION_LISTENER listener.ora
#LOCAL_OS_AUTHENTICATION_LISTENER=OFF
[ 本帖最后由 ora_newbie 于 2009-10-11 00:31 编辑 ]
|