操作系统认证连接远程数据库

How To Implement OS Authentication in Web Forms for a Remote Database Authentication? [ID 577787.1]

Configuring an External Service to Authenticate Users and Passwords
http://docs.oracle.com/cd/E11882_01/network.112/e16543/authentication.htm#DBSEG99843

ORA-32004: obsolete and/or deprecated parameter(s) specified: remote_os_authent [ID 456001.1]

SQL> alter system set OS_AUTHENT_PREFIX='' scope=spfile;

System altered.

SQL> alter system set remote_os_authent=true scope=spfile;

System altered.

重启数据库

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  690503680 bytes
Fixed Size                  1346412 bytes
Variable Size             503317652 bytes
Database Buffers          180355072 bytes
Redo Buffers                5484544 bytes
Database mounted.
Database opened.

SQL> show parameter auth

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
ldap_directory_sysauth               string      no
os_authent_prefix                    string
remote_os_authent                    boolean     TRUE
SQL> create user oracle identified externally;

User created.

SQL> grant connect,resource to oracle;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@dbserver admin]$ sqlplus /

SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 30 19:43:35 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "ORACLE"
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@dbserver admin]$ sqlplus /@test_orcl

SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 30 19:44:30 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "ORACLE"

[oracle@dbserver admin]$ sqlplus /@test_orcl as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 30 20:04:28 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges

[oracle@dbserver admin]$ sqlplus u1/u1@test_orcl

SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 30 20:06:01 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24756186/viewspace-742342/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24756186/viewspace-742342/