摘要: 验证用户 验证指的是对要使用数据、资源或应用程序的用户、设备或其它实体的身份进行验证。通过对该身份进行验证可建立一种信任关系,从而可进一步执行交互。通过验证可将访问和操作与特定的身份联系起来,从 ...
第三种情况: 参数SQLNET.AUTHENTICATION_SERVICES 设置为 NONE 或NTS ----------------屏蔽操作系统认证都启用口令认证 |
[oracle@tyger admin]$ vim sqlnet.oraNAME.DIRECTORY_PATH=(tnsnames,ezconnect)SQLNET.AUTHENTICATION_SERVICES=(NTS)[oracle@tyger admin]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 10:36:35 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-01031: insufficient privileges[oracle@tyger admin]$ sqlplus sys/oracle@ORCL as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 10:36:52 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSYS@ORCL> 第四种情况: 当数据库屏蔽了操作系统认证,启用口令认证方式的话,需要检查remote_login_passwordfile参数,如果该参数设置为NONE,该值表示不使用口令文件,因此,此时数据库将不能登录 解决办法:启动操作系统认证,登录数据库后将remote_login_passwordfile参数修改EXCLUSIVE,然后再屏蔽操作系统认证,启用口令认证。 > remote_login_passwordfile参数可以设置为3个值 none、exclusive、shared[oracle@tyger admin]$ cat sqlnet.oraNAME.DIRECTORY_PATH=(tnsnames,ezconnect)SQLNET.AUTHENTICATION_SERVICES=(NTS)[oracle@tyger admin]$ sqlplus sys/oracle@ORCL as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 10:48:15 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSYS@ORCL>show parameter remoteNAME TYPE VALUE------------------------------------ ----------- ------------------------------remote_archive_enable string trueremote_dependencies_mode string TIMESTAMPremote_listener stringremote_login_passwordfile string EXCLUSIVEremote_os_authent boolean FALSEremote_os_roles boolean FALSESYS@ORCL>alter system set remote_login_passwordfile=none scope=spfile;System altered. ---静态参数,重启数据库生效SYS@ORCL>shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SYS@ORCL>startupORA-12514: TNS:listener does not currently know of service requested in connect descriptor[oracle@tyger admin]$ vim sqlnet.oraNAME.DIRECTORY_PATH=(tnsnames,ezconnect)#SQLNET.AUTHENTICATION_SERVICES=(NTS)[oracle@tyger admin]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 10:57:25 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SYS@ORCL>startupORACLE instance started.Total System Global Area 285212672 bytesFixed Size 1218992 bytesVariable Size 96470608 bytesDatabase Buffers 184549376 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.SYS@ORCL>show parameter remoteNAME TYPE VALUE------------------------------------ ----------- ------------------------------remote_archive_enable string trueremote_dependencies_mode string TIMESTAMPremote_listener stringremote_login_passwordfile string NONEremote_os_authent boolean FALSEremote_os_roles boolean FALSESYS@ORCL>alter system set remote_login_passwordfile=exclusive scope=spfile;System altered.SYS@ORCL>shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SYS@ORCL>startupORACLE instance started.Total System Global Area 285212672 bytesFixed Size 1218992 bytesVariable Size 96470608 bytesDatabase Buffers 184549376 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.SYS@ORCL>show parameter remoteNAME TYPE VALUE------------------------------------ ----------- ------------------------------remote_archive_enable string trueremote_dependencies_mode string TIMESTAMPremote_listener stringremote_login_passwordfile string EXCLUSIVEremote_os_authent boolean FALSEremote_os_roles boolean FALSESYS@ORCL>exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options[oracle@tyger admin]$ sqlplus sys/oracle@ORCL as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 11:04:16 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSYS@ORCL>