Oraclestartupinrestrictedmode-創(chuàng)新互聯(lián)

關(guān)于OCP的小知識(shí)點(diǎn)，實(shí)例受限啟動(dòng)，實(shí)例啟動(dòng)的知識(shí)點(diǎn)很多，也是OCP學(xué)習(xí)的重點(diǎn)，需要多看官方文檔和多做測(cè)試。
Restricting Access to an Instance at Startup 
--實(shí)例啟動(dòng)限制

You can start an instance, and optionally mount and open a database, in restricted mode so that the instance is available only to administrative personnel (not general database users).
Use this mode of instance startup when you must accomplish one of the following tasks:
--實(shí)例啟動(dòng)限制模式適用的場(chǎng)景，一定是我們不希望其他連接訪(fǎng)問(wèn)數(shù)據(jù)，對(duì)數(shù)據(jù)庫(kù)數(shù)據(jù)進(jìn)行改動(dòng)，數(shù)據(jù)備份，loader，臨時(shí)阻止已經(jīng)升級(jí)遷移會(huì)常常使用到。

?Perform an export or import of data
?Perform a data load (with SQL*Loader)
?Temporarily prevent typical users from using data
?Perform certain migration or upgrade operations

Typically, all users with the CREATE SESSION system privilege can connect to an open database. Opening a database in restricted mode allows database access only to users with both the CREATE SESSION and RESTRICTED SESSION system privilege. Only database administrators should have the RESTRICTED SESSION system privilege. Further, when the instance is in restricted mode, a database administrator cannot access the instance remotely through an Oracle Net listener, but can only access the instance locally from the system that the instance is running on. 

The following command starts an instance (and mounts and opens the database) in restricted mode:

小實(shí)驗(yàn)：
[root@11g-ocp ~]# su - oracle
<11g-ocp:orcl:/home/oracle>$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 12 18:12:11 2018

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP and Real Application Testing options

SQL> startup restrict force 
ORACLE instance started.
--限制模式啟動(dòng)

Total System Global Area 1870647296 bytes
Fixed Size                  2254304 bytes
Variable Size             503319072 bytes
Database Buffers         1358954496 bytes
Redo Buffers                6119424 bytes
Database mounted.
Database opened.
SQL> drop user roidba;
--刪除測(cè)試用戶(hù)

User dropped.

SQL> create user roidba identified by roidba;
--創(chuàng)建測(cè)試用戶(hù)

User created.

SQL> grant connect,resource to roidba;
--授權(quán)訪(fǎng)問(wèn)

Grant succeeded.

SQL> conn roidba/roidba;
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
--登陸報(bào)錯(cuò)，缺少系統(tǒng)權(quán)限r(nóng)estricted session 

Warning: You are no longer connected to ORACLE.
SQL> conn / as sysdba
Connected.
SQL> grant restricted session to roidba;

Grant succeeded.
--授予系統(tǒng)權(quán)限r(nóng)estricted session 

SQL> conn roidba/roidba
Connected.
--使用roidba連接數(shù)據(jù)庫(kù)，成功

SQL> conn / as sysdba
Connected.
SQL> revoke restricted session from roidba;
--收回權(quán)限

Revoke succeeded.

SQL> alter system disable restricted session;
--取消限制

System altered.

SQL> conn roidba/roidba;
--收回權(quán)限和取消限制抵消，可以繼續(xù)登陸
Connected.
SQL> 

這些都是OCP的小知識(shí)點(diǎn)，大家有時(shí)間多做測(cè)試。一定要多動(dòng)手，多看文檔，多思考。

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線(xiàn)，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性?xún)r(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專(zhuān)為企業(yè)上云打造定制，能夠滿(mǎn)足用戶(hù)豐富、多元化的應(yīng)用場(chǎng)景需求。

創(chuàng)新互聯(lián)公司服務(wù)緊隨時(shí)代發(fā)展步伐，進(jìn)行技術(shù)革新和技術(shù)進(jìn)步，經(jīng)過(guò)十多年的發(fā)展和積累，已經(jīng)匯集了一批資深網(wǎng)站策劃師、設(shè)計(jì)師、專(zhuān)業(yè)的網(wǎng)站實(shí)施團(tuán)隊(duì)以及高素質(zhì)售后服務(wù)人員，并且完全形成了一套成熟的業(yè)務(wù)流程，能夠完全依照客戶(hù)要求對(duì)網(wǎng)站進(jìn)行成都網(wǎng)站設(shè)計(jì)、做網(wǎng)站、建設(shè)、維護(hù)、更新和改版，實(shí)現(xiàn)客戶(hù)網(wǎng)站對(duì)外宣傳展示的首要目的，并為客戶(hù)企業(yè)品牌互聯(lián)網(wǎng)化提供全面的解決方案。

分享文章：Oraclestartupinrestrictedmode-創(chuàng)新互聯(lián)
標(biāo)題網(wǎng)址：http://bm7419.com/article30/iphso.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站改版、虛擬主機(jī)、網(wǎng)站建設(shè)、網(wǎng)頁(yè)設(shè)計(jì)公司、企業(yè)建站、品牌網(wǎng)站設(shè)計(jì)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話(huà)：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)