java口令认证_用户验证-OS认证和口令认证测试

[oracle@tyger admin]$ cat sqlnet.ora

NAME.DIRECTORY_PATH=(tnsnames,ezconnect)

SQLNET.AUTHENTICATION_SERVICES=(NTS)

[oracle@tyger admin]$ sqlplus sys/oracle@ORCL as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 10:48:15 2014

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SYS@ORCL>show parameter remote

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

remote_archive_enable                string      true

remote_dependencies_mode             string      TIMESTAMP

remote_listener                      string

remote_login_passwordfile            string      EXCLUSIVE

remote_os_authent                    boolean     FALSE

remote_os_roles                      boolean     FALSE

SYS@ORCL>alter system set remote_login_passwordfile=none scope=spfile;

System altered.

---静态参数，重启数据库生效

SYS@ORCL>shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS@ORCL>startup

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

[oracle@tyger admin]$ vim sqlnet.ora

NAME.DIRECTORY_PATH=(tnsnames,ezconnect)

#SQLNET.AUTHENTICATION_SERVICES=(NTS)

[oracle@tyger admin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 10:57:25 2014

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

Connected to an idle instance.

SYS@ORCL>startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1218992 bytes

Variable Size              96470608 bytes

Database Buffers          184549376 bytes

Redo Buffers                2973696 bytes

Database mounted.

Database opened.

SYS@ORCL>show parameter remote

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

remote_archive_enable                string      true

remote_dependencies_mode             string      TIMESTAMP

remote_listener                      string

remote_login_passwordfile            string      NONE

remote_os_authent                    boolean     FALSE

remote_os_roles                      boolean     FALSE

SYS@ORCL>alter system set remote_login_passwordfile=exclusive scope=spfile;

System altered.

SYS@ORCL>shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS@ORCL>startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1218992 bytes

Variable Size              96470608 bytes

Database Buffers          184549376 bytes

Redo Buffers                2973696 bytes

Database mounted.

Database opened.

SYS@ORCL>show parameter remote

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

remote_archive_enable                string      true

remote_dependencies_mode             string      TIMESTAMP

remote_listener                      string

remote_login_passwordfile            string      EXCLUSIVE

remote_os_authent                    boolean     FALSE

remote_os_roles                      boolean     FALSE

SYS@ORCL>exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

[oracle@tyger admin]$ sqlplus sys/oracle@ORCL as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 11:04:16 2014

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SYS@ORCL>