.用srvctl命令配置service 除了用DBCA圖形方式,還可以使用命令方式配置service,這種方法對于維護遠程尤其有用。無論是創建還是維護都是用一個命令srvctl,先看一下srvctl命令和service相關的語法,如下: 創建service [oracle@felix1 ~]$ srvctl add servi
.用srvctl命令配置service
除了用DBCA圖形方式,還可以使用命令方式配置service,這種方法對于維護遠程尤其有用。無論是創建還是維護都是用一個命令srvctl,先看一下srvctl命令和service相關的語法,如下:
創建service
[oracle@felix1 ~]$ srvctl add service -h
Usage: srvctl add service -d -s-r “” [-a””] [-P ]
-dUnique name forthe database
-sService name
-r”” List ofpreferred instances
-a”” List ofavailable instances
-PTAF policy (NONE,BASIC, or PRECONNECT)
Usage: srvctl add service -d -s-u {-r “” | -a””}
-dUnique name forthe database
-sService name
-u Add a new instance to serviceconfiguration
-rName of newpreferred instance
-aName of new available instance
-h Print usage
[oracle@felix1 ~]$
示例如下:
Felix1,felix2為實例名;Felix是數據庫名;策略是:BASIC
[oracle@felix1~]$ srvctl add service -d felix -s taf_srvctl -r felix2 -a felix1 -P BASIC
[oracle@felix1~]$
查看service配置
[oracle@felix1 ~]$ srvctl config service -d felix-a
taf_server PREF: felix1 AVAIL: felix2 TAF: basic
taf_srvctl PREF: felix2 AVAIL: felix1 TAF: BASIC
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl config service -d felix-h
Usage: srvctl config service -d [-s] [-a] [-S ]
-dUnique name forthe database
-sService name
-a Additional attributes
-SAdditionalinformation for EM Console
-h Print usage
[oracle@felix1 ~]$
如果不指定“-s service_name”,就會顯示所有的service配置,這些配置只包括preferred和avilable instance。使用-a選項,還會顯示TAF的信息。
是否自動運行
數據庫啟動時,會自動啟動所有的service。有時為了維護的需要,需要禁用這個特性。在維護完成之后再啟動這個特性。
[oracle@felix1 ~]$ srvctl disable service -h
Usage: srvctl disable service -d -s”” [-i ]
-dUnique name forthe database
-s”” Commaseparated service names
-iInstance name
-h Print usage
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl disable service -d felix-s taf_server -i felix1
[oracle@felix1 ~]$ srvctl config service -d felix-a
taf_server PREF: felix1 AVAIL: felix2 TAF: basic
Service taf_server is disabled on instance(s) felix1.
taf_srvctl PREF: felix2 AVAIL: felix1 TAF: BASIC
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl disable service -d felix-s taf_server
PRKP-1024 : The service taf_server is stillrunning.
關閉服務service并diable:
[oracle@felix1 ~]$ srvctl stop service -h
Usage: srvctl stop service -d [-s”” [-i ]] [-f]
-dUnique name forthe database
-s”” Commaseparated service names
-iInstance name
-f Disconnect all sessionsduring stop or relocate service operations
-h Print usage
[oracle@felix1 ~]$ srvctl stop service -d felix -staf_server
[oracle@felix1 ~]$ srvctl config service -d felix-a
taf_server PREF: felix1 AVAIL: felix2 TAF: basic
taf_srvctl PREF: felix2 AVAIL: felix1 TAF: BASIC
[oracle@felix1 ~]$ srvctl disable service -d felix-s taf_server
[oracle@felix1 ~]$ srvctl config service -d felix-a
taf_server PREF: felix1 AVAIL: felix2 TAF: basic
Service taf_server is disabled.
taf_srvctl PREF: felix2 AVAIL: felix1 TAF: BASIC
[oracle@felix1 ~]$
啟動service
[oracle@felix1 ~]$ srvctl start service -h
Usage: srvctl start service -d [-s”” [-i ]] [-o]
-dUnique name forthe database
-s”” Commaseparated service names
-iInstance name
-oOptions to startupcommand (e.g. open, mount, or nomount)
-h Print usage
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl start service -d felix -s taf_server
[oracle@felix1 ~]$
查看service狀態。
[oracle@felix1 ~]$ srvctl status service -h
Usage: srvctl status service -d [-s””] [-f] [-v] [-S ]
-dUnique name forthe database
-s”” Commaseparated service names
-f Include disabled applications
-v Verbose output
-SAdditionalinformation for EM Console
-h Print usage
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl status service -d felix -s taf_server -f -v
Service taf_server is running on instance(s)felix2
[oracle@felix1 ~]$ srvctl status service -d felix -s taf_server -f -v -S 3
#@=info: operation={status} config={full}ver={10.2.0.0.0}
#@=service[0]: name={taf_server} enabled={true}pref={felix1} avail={felix2} disabled_insts={felix1} tafpolicy={basic}type={user}
#@=service[1]: name={felix} enabled={true}pref={felix1, felix2} avail={} disabled_insts={} tafpolicy={NONE}type={internal}
Service taf_server is running on instance(s)felix2
#@=result[0]: up={felix2} down={felix1}disabled={felix1} unknown={}
#@=result[1]: up={felix1, felix2} down={}disabled={} unknown={}
#@=done: status={0}
[oracle@felix1 ~]$
刪除service。
[oracle@felix1 ~]$ srvctl remove service -h
Usage: srvctl remove service -d -s[-i ] [-f]
-dUnique name forthe database
-sService name
-iInstance name
-f Force remove
-h Print usage
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl status service -d felix
Service taf_server is running oninstance(s) felix1
Service taf_srvctl is not running.
[oracle@felix1 ~]$ srvctl remove service -d felix-s taf_server -i felix1
taf_server PREF: felix1 AVAIL: felix2
Remove service taf_server from the instancefelix1? (y/[n]) y
PRKP-1024 : The service taf_server is still running.
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl remove service -d felix-s taf_srvctl -i felix1
taf_srvctl PREF: felix2 AVAIL: felix1
Remove service taf_srvctl from the instancefelix1? (y/[n]) y
PRKP-1067 : Instance felix1 is the last availableinstance for service taf_srvctl. Try modify service instead.
[oracle@felix1 ~]$ srvctl config service -d felix -a
taf_server PREF: felix1 AVAIL: felix2 TAF: basic
taf_srvctl PREF: felix2 AVAIL: felix1 TAF: BASIC
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl remove service -d felix -staf_srvctl -f
[oracle@felix1 ~]$ srvctl config service -d felix -a
taf_server PREF: felix1 AVAIL: felix2 TAF: basic
[oracle@felix1 ~]$ srvctl remove service -d felix-s taf_server -f
PRKP-1024: The service taf_server is still running.
[oracle@felix1 ~]$ srvctl stop service -d felix -staf_server
[oracle@felix1 ~]$ srvctl remove service -d felix-s taf_server -f
[oracle@felix1 ~]$ srvctl config service -d felix -a
[oracle@felix1 ~]$
修改服務
[oracle@felix1 ~]$ srvctl modify service -h
Usage: srvctl modify service -d -s-i -t [-f]
-dUnique name forthe database
-sService name
-iOld instance name
-tNew instance name
-f Disconnect all sessionsduring stop or relocate service operations
Usage: srvctl modify service -d -s-i -r [-f]
-dUnique name forthe database
-sService name
-iInstance name
-r Upgrade instance to preferred
-f Disconnect all sessionsduring stop or relocate service operations
Usage: srvctl modify service -d -s-n -i [-a ][-f]
-dUnique name forthe database
-sService name
-n Modify service configuration
-r “” List of preferred instances
-a”” List ofavailable instances
-f Disconnect all sessionsduring stop or relocate service operations
Usage: srvctl modify service -d -s-P [-f]
-dUnique name forthe database
-sService name
-PTAF policy (NONE,BASIC, or PRECONNECT)
-f Disconnect all sessionsduring stop or relocate service operations
-h Print usage
[oracle@felix1 ~]$
[oracle@felix2 ~]$ srvctl modify service -d felix-s taf_srvctl -n -i felix1,felix2 -f
[oracle@felix2 ~]$ srvctl config service -d felix -a
taf_srvctlPREF: felix1 felix2 AVAIL: TAF: basic
[oracle@felix2 ~]$
【參考大話RAC–張曉明】
本條技術文章來源于互聯網,如果無意侵犯您的權益請點擊此處反饋版權投訴
本文系統來源:php中文網
本文由 貴州做網站公司 整理發布,部分圖文來源于互聯網,如有侵權,請聯系我們刪除,謝謝!
網絡推廣與網站優化公司(網絡優化與推廣專家)作為數字營銷領域的核心服務提供方,其價值在于通過技術手段與策略規劃幫助企業提升線上曝光度、用戶轉化率及品牌影響力。這...
在當今數字化時代,公司網站已成為企業展示形象、傳遞信息和開展業務的重要平臺。然而,對于許多公司來說,網站建設的價格是一個關鍵考量因素。本文將圍繞“公司網站建設價...
在當今的數字化時代,企業網站已成為企業展示形象、吸引客戶和開展業務的重要平臺。然而,對于許多中小企業來說,高昂的網站建設費用可能會成為其發展的瓶頸。幸運的是,隨...
visualstudio愛心代碼怎么啟動?Visualstudio love代碼啟動方法如下:1.Open the visual studio software.2.單擊文件-新建-項目。3.輸入文件路徑和項目名稱,選擇一個空項目,然后單擊“確定”。4.右鍵單擊源文件,然后單擊添加-新項。5.選擇C文件。6.然后就可以輸入代碼了。7.輸入好的代碼,返回0;在最后;在其前面添加getchar();否...
OPPO手機怎么把騰訊vip借給好友?您只不需要把你的騰訊公司賬號密碼還有登錄密碼直接告知給你的好友,然后在他的騰訊公司上登陸即可。怎么才能共享朋友的騰訊視頻vip?騰訊公司的vip會員的話,也可以通過直接登錄為主在另外的那個手機并且登錄。因為騰訊公司的vip用戶意見多個線設備同時登陸,你可以通過用戶名密碼直接登錄,也是可以通過號登錄。你也可以將你的賬號和密碼說下你要共享的好朋友,然后讓他通過用戶...
如何將BT5安裝到U盤中?開始安裝:1。首先,將U盤格式化為FAT32格式2。解壓縮下載的unetbootin并運行unetbootin窗口-最新.exe接口如下:3。點擊界面右下角的“…”,選擇您下載的BT5 ISO鏡像。下面的輸入框是要設置的已保存配置文件的大小。根據個人需要和U盤大小填寫。比如我的U盤是8GB,填寫3200m,3.06gb的鏡像,3200m配置文件加載滿后大約7GB,U盤中還...