日本不卡不码高清免费观看,久久国产精品久久w女人spa,黄色aa久久,三上悠亚国产精品一区二区三区

您的位置：首頁技術文章
文章詳情頁

講解Oracle數據庫的sysdba權限登錄問題

瀏覽：321日期：2023-11-29 10:41:51
sysdba權限的登錄測試：

數據庫用sysdba登錄的驗證有兩種方式，一種是通過os認證，一種是通過密碼文件驗證；登錄方式有兩種，一種是在數據庫主機直接登錄（用os認證的方式），一種是通過網絡遠程登錄；需要設置的參數有兩個，一個是SQLNET.AUTHENTICATION_SERVICES，一個是REMOTE_LOGIN_PASSWORDFILE。

os認證：假如啟用了os認證，以sysdba登錄，那么只需要使用oracle軟件的安裝用戶就能登錄：sqlplus “/ as sysdba”。如果我們要禁用os認證，只利用密碼文件登錄，我們首先要有一個密碼文件：

D:oracleora92database>orapwd file=PWDoralocal.ora password=mypassword entries=10;

D:oracleora92database>

然后我們要把$ORACLE_HOME/network/admin/sqlnet.ora中設置：

SQLNET.AUTHENTICATION_SERVICES= none

大家需要注意，密碼文件只在數據庫啟動的時候加載進去，一旦加載進去，密碼文件就脫離了oracle管理，所以在你使用orapwd新建密碼文件后，里面指定的密碼需要在數據重啟后才能發生作用：

D:oracleora92database>sqlplus 'sys/mypassword as sysdba'

SQL*Plus: Release 9.2.0.1.0 - Production on Fri May 16 21:59:42 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

### 這里我們通過改SQLNET.AUTHENTICATION_SERVICES= （NTS）用os認證登錄數據庫：

sys@ORALOCAL(192.168.50.29)> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

sys@ORALOCAL(192.168.50.29)>

sys@ORALOCAL(192.168.50.29)>

sys@ORALOCAL(192.168.50.29)>

sys@ORALOCAL(192.168.50.29)> startup

ORACLE instance started.

Total System Global Area 135338868 bytes

Fixed Size 453492 bytes

Variable Size 109051904 bytes

Database Buffers 25165824 bytes

Redo Buffers 667648 bytes

Database mounted.

Database opened.

sys@ORALOCAL(192.168.50.29)>

sys@ORALOCAL(192.168.50.29)>

sys@ORALOCAL(192.168.50.29)>

sys@ORALOCAL(192.168.50.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

D:oracleora92database>

D:oracleora92database>

D:oracleora92database>

### 我們把SQLNET.AUTHENTICATION_SERVICES= （NTS）改回去。

D:oracleora92database>sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.1.0 - Production on Fri May 16 22:03:59 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

D:oracleora92database>

D:oracleora92database>

D:oracleora92database>

D:oracleora92database>sqlplus 'sys/mypassword as sysdba'

SQL*Plus: Release 9.2.0.1.0 - Production on Fri May 16 22:04:07 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.50.29)> exit

在這里，我們看到這個新改的密碼要數據庫重啟后加載才生效。同時我們看到，用os認證是無法登錄的，但是通過網絡（用@sid）是可以登錄。

D:oracleora92database>sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 00:58:32 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

D:oracleora92database>

D:oracleora92database>sqlplus 'sys/mypassword as sysdba'

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 00:59:15 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.50.29)>

sys@ORALOCAL(192.168.50.29)>

sys@ORALOCAL(192.168.50.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

D:oracleora92database>sqlplus 'sys/mypassword@oralocal as sysdba'

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 00:59:38 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.50.29)>

至此，我們已經實現不用os認證（sqlplus “/ as sysdba”的方式登錄不了）。那么我們怎么限制網絡方面利用sysdba遠程登錄呢？我們可以設置初始化文件中的REMOTE_LOGIN_PASSWORDFILE=none。

注意，當REMOTE_LOGIN_PASSWORDFILE=none時，這個參數生效需要重啟數據庫，并且，一旦啟用這個參數，將使用操作系統認證，不使用口令文件。因此如果REMOTE_LOGIN_PASSWORDFILE=none且SQLNET.AUTHENTICATION_SERVICES= none這個時候數據庫是無法登錄的。

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

D:oracleora92database>sqlplus “sys/change_on_install as sysdba”

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 01:28:58 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.50.29)> show parameter remote_login

NAME TYPE VALUE

———————————— ———– ——————————

remote_login_passwordfile string EXCLUSIVE

sys@ORALOCAL(192.168.50.29)> alter system set remote_login_passwordfile=none scope=spfile;

System altered.

Elapsed: 00:00:00.01

sys@ORALOCAL(192.168.50.29)> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

sys@ORALOCAL(192.168.50.29)> startup

ORA-01031: insufficient privileges

sys@ORALOCAL(192.168.50.29)>exit

C:Documents and SettingsAdministrator>sqlplus “/ as sysdba”

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 08:26:43 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 SettingsAdministrator>sqlplus “sys/change_on_install as sysdba”

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 08:26:53 2008

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

ERROR:

ORA-01017: invalid username/password; logon denied

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 SettingsAdministrator>

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

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 08:27:03 2008

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

ERROR:

ORA-01017: invalid username/password; logon denied

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 SettingsAdministrator>

[coolcode]

這里我們看到由于啟用了REMOTE_LOGIN_PASSWORDFILE=none，使用os認證，不用密碼文件認證，必須將SQLNET.AUTHENTICATION_SERVICES= none取消，不然是無法登錄。我們改成SQLNET.AUTHENTICATION_SERVICES= （NTS）后再次測試。

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

### 非oracle軟件安裝軟件用戶：###

C:Documents and Settingshejianmin>sqlplus “/ as sysdba”

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 20:15:13 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 Settingshejianmin>

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

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 20:15:30 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 Settingshejianmin>

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

SQL*Plus: Release 9.2.0.1.0 - Production on Sat May 17 20:15:42 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 Settingshejianmin>

### oracle 軟件安裝用戶 ####

C:Documents and SettingsAdministrator>sqlplus “/ as sysdba”

SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 5月 17 20:19:13 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 SettingsAdministrator>sqlplus “sys/change_on_install as sysdba”

SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 5月 17 20:19:33 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 SettingsAdministrator>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 SettingsAdministrator>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 SettingsAdministrator>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 SettingsAdministrator>

C:Documents and SettingsAdministrator>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 SettingsAdministrator>

C:Documents and SettingsAdministrator>

[/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”能登錄

標簽： Oracle 數據庫
日本不卡不码高清免费观看,久久国产精品久久w女人spa,黄色aa久久,三上悠亚国产精品一区二区三区
麻豆一区二区在线| 热久久久久久| 国产精品美女午夜爽爽| 日韩黄色在线观看| 在线观看视频免费一区二区三区| 欧美日韩国产在线一区| 免费观看不卡av| 亚洲福利久久| 久久久精品久久久久久96 | 中文字幕在线看片| 国内精品伊人| 福利一区视频| 国产精品国产一区| 日韩有码av| 蜜臀a∨国产成人精品| 性色一区二区| 亚洲人成网77777色在线播放| 国产精品毛片在线| 在线亚洲欧美| 色8久久久久| 日韩精品一区二区三区中文在线 | 欧美三级网址| 国产专区精品| 国产精品久久久久av电视剧| 亚洲第一区色| 视频在线在亚洲| 国产欧美在线| 日韩电影在线视频| 欧美成人高清| 免费在线观看成人| 欧美另类中文字幕| 97精品在线| 国产综合精品| 亚洲香蕉久久| 亚洲一区二区三区四区电影| 中文字幕亚洲影视| 久久精品国产大片免费观看| 欧美精品日日操| 日韩av首页| 美女毛片一区二区三区四区 | 国产精品久久久久久久久免费高清 | 亚洲麻豆一区| 中文字幕av亚洲精品一部二部| 91精品高清| 欧美~级网站不卡| 尤物在线精品| 蜜臀av在线播放一区二区三区| 日日夜夜免费精品| 久久超级碰碰| 97视频热人人精品免费| 欧美日韩一二三四| 巨乳诱惑日韩免费av| 色综合视频一区二区三区日韩| 一区二区91| 日本午夜精品久久久久| 成人污污视频| 免费久久久久久久久| 宅男噜噜噜66国产日韩在线观看| 99视频+国产日韩欧美| 亚洲精品综合| 国产精区一区二区| 麻豆理论在线观看| 九九久久电影| 亚洲va久久久噜噜噜久久| 国产乱子精品一区二区在线观看| 精品少妇av| 久久一区二区中文字幕| 喷白浆一区二区| 国产亚洲欧美日韩精品一区二区三区 | 亚洲人成网站在线在线观看| 日韩在线观看中文字幕| 国产精品xxxav免费视频| 超碰在线99| 尤物在线精品| 国产精品色在线网站| 日韩精品欧美| 日韩欧美美女在线观看| 麻豆一区在线| 在线观看免费一区二区| 久久亚洲风情| 日本aⅴ免费视频一区二区三区| 美女久久99| 国产亚洲综合精品| 久久精品资源| 国产视频一区三区| 国产精品乱战久久久| 欧美jjzz| 欧美激情在线精品一区二区三区| 日本精品影院| 亚洲精品高潮| 国产精品毛片一区二区在线看| 美女网站久久| 欧美国产偷国产精品三区| 石原莉奈在线亚洲二区| 精品少妇一区| 国产一区亚洲| 国产精品香蕉| 宅男在线一区| 国产精品传媒麻豆hd| 蜜臀av免费一区二区三区| 国产日韩免费| 红桃视频亚洲| 欧美精品91| 亚洲免费成人av在线| 日韩理论视频| 欧美午夜三级| 六月天综合网| 人人精品亚洲| 国产精品久久久久77777丨| 亚洲免费精品| 国产精品主播在线观看| 亚洲在线成人| 成人羞羞视频播放网站| 国产高清日韩| 一级欧美视频| 亚洲激情黄色| 国产v综合v| 久久精品伊人| 欧美在线精品一区| 欧美午夜不卡| 日韩在线中文| 精品精品国产三级a∨在线| 日韩国产在线观看| 91久久中文| 秋霞影院一区二区三区| 欧美天堂一区| 蜜桃视频一区二区三区在线观看| 色黄视频在线观看| 欧美激情麻豆| 青青草视频一区| 六月丁香综合| 国产视频欧美| 午夜免费一区| 欧美1区免费| 午夜精品成人av| 91麻豆国产自产在线观看亚洲| 国产精品丝袜在线播放| 亚洲tv在线| 男人操女人的视频在线观看欧美| 欧美午夜精彩| a国产在线视频| 精品不卡一区| 欧美激情视频一区二区三区在线播放| 日韩午夜视频在线| 在线视频亚洲| 国产精品色网| 宅男噜噜噜66国产日韩在线观看| 99国产精品免费视频观看| 成人三级高清视频在线看| 国产极品一区| 久久免费影院| 精品资源在线| 国产亚洲字幕| 日韩福利在线观看| 日韩高清中文字幕一区| 国产精品日本| 欧美a级片一区| 午夜国产精品视频免费体验区| 伊人精品一区| 国产精品88久久久久久| 亚洲先锋成人| 亚洲网站视频| 好看不卡的中文字幕| 国产精品日本| 喷白浆一区二区| 婷婷综合电影| 国产亚洲高清在线观看| 国产欧美69| 久久只有精品| 精品久久影院| 久久99精品久久久野外观看| 亚洲精品精选| 国产亚洲电影| 美女视频黄免费的久久| 麻豆视频在线观看免费网站黄 | 伊人久久亚洲影院| 激情五月色综合国产精品| 在线观看一区| 日本不卡不码高清免费观看| 97精品国产99久久久久久免费| 国产美女精品视频免费播放软件| 麻豆精品在线| 色爱综合av| 亚洲欧美日韩精品一区二区| 国产精品腿扒开做爽爽爽挤奶网站| 欧美网站在线| 亚洲九九精品| 欧美影院精品| 国产a亚洲精品| 91精品国产调教在线观看| 婷婷成人在线| 亚洲精品女人| 四虎成人精品一区二区免费网站 | 久久精品动漫| 亚洲黄色在线| 国产日韩高清一区二区三区在线| 精品日韩一区| 天堂网av成人| 最新国产精品视频| 精品一区91|