讲解Oracle数据库的sysdba权限登录问题

　　连接到:

　　Oracle9i EntERPrise Edition Release 9.2.0.1.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.1.0 - Production

　　sys@ORALOCAL(192.168.0.29)> exit

　　从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.1.0 - Production中断开

　　C:/Documents and Settings/Administrator>sqlplus “sys/change_on_install@oralocal as sysdba”

　　SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 5月 17 20:19:45 2008

　　Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

　　连接到:

　　Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.1.0 - Production

　　sys@ORALOCAL(192.168.0.29)> exit

　　从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.1.0 - Production中断开

　　C:/Documents and Settings/Administrator>sqlplus “11/22 as sysdba”

　　SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 5月 17 20:19:58 2008

　　Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

　　连接到:

　　Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.1.0 - Production

　　sys@ORALOCAL(192.168.0.29)>

　　[/coolcode]

　　在这里我们看到由于用了os认证，在oracle安装用户下，无论用什么方式都能登录。非oracle用户无论用什么用户都无法登录。

　　如果REMOTE_LOGIN_PASSWORDFILE=exclusive且SQLNET.AUTHENTICATION_SERVICES= none时：

　　[coolcode lang=”sql” linenum=”off”]

　　C:/Documents and Settings/Administrator>sqlplus “sys/change_on_install as sysdba”

　　SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 20:30:57 2008

　　Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

　　Connected to:

　　Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.1.0 - Production

　　sys@ORALOCAL(192.168.0.29)> exit

　　Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.1.0 - Production

　　C:/Documents and Settings/Administrator>

　　C:/Documents and Settings/Administrator>sqlplus “/ as sysdba”

　　SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 20:31:04 2008

　　Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

　　ERROR:

　　ORA-01031: insufficient privileges

　　Enter user-name:

　　ERROR:

　　ORA-01017: invalid username/password; logon denied

　　Enter user-name:

　　ERROR:

　　ORA-01017: invalid username/password; logon denied

　　SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

　　C:/Documents and Settings/Administrator>

　　C:/Documents and Settings/Administrator>

　　[/coolcode]

　　结论：

　　（1）REMOTE_LOGIN_PASSWORDFILE=none且SQLNET.AUTHENTICATION_SERVICES= none：

　　oracle安装用户本地sqlplus “/ as sysdba”无法登录

　　非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”无法登录

　　非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”无法登录

　　（2）REMOTE_LOGIN_PASSWORDFILE=exclusive且SQLNET.AUTHENTICATION_SERVICES= none：

　　oracle安装用户本地sqlplus “/ as sysdba”无法登录

　　非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”能登录

　　非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”能登录

　　（3）REMOTE_LOGIN_PASSWORDFILE=none且SQLNET.AUTHENTICATION_SERVICES= (NTS)：

　　oracle安装用户本地sqlplus “/ as sysdba”能登录

　　非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”无法登录

　　非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”无法登录

　　（4）REMOTE_LOGIN_PASSWORDFILE=exclusive且SQLNET.AUTHENTICATION_SERVICES= (NTS)：

　　oracle安装用户本地sqlplus “/ as sysdba”能登录

　　非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”能登录

　　非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”能登录