配置Vsphere vCenter 5.5安裝使用遠程Oracle資料庫

標籤：vmware vsphere 5.5

--1.建立ORACLE VCENTER資料表空間及資料檔案
CREATE TABLESPACE "VCENTER" DATAFILE ‘$PATH/VCENTER.DBF‘ SIZE 1G AUTOEXTEND ON
NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

--2.建立ORACLE VCENTER使用者並授許可權
CREATE USER "VC" PROFILE "DEFAULT" IDENTIFIED BY "VC" DEFAULT TABLESPACE "VCENTER" ACCOUNT UNLOCK;
GRANT CONNECT TO VC;
GRANT RESOURCE TO VC;
GRANT CREATE VIEW TO VC;
GRANT CREATE SEQUENCE TO VC;
GRANT CREATE TABLE TO VC;
GRANT CREATE MATERIALIZED VIEW TO VC;
GRANT EXECUTE ON DBMS_LOCK TO VC;
GRANT EXECUTE ON DBMS_JOB TO VC;
GRANT SELECT ON DBA_TABLESPACES TO VC;
GRANT SELECT ON DBA_TEMP_FILES TO VC;
GRANT SELECT ON DBA_DATA_FILES TO VC;
GRANT UNLIMITED TABLESPACE TO VC;

 

/*
3.配置遠端存取的ORACLE資料庫連接,必須先配置Oracle串連,VCenter Server系統才能遠端存取Oracle資料庫
(1).將Oracle client安裝到VCENTER本地系統上,並使用netca命令配置遠端存取的tnsname
(2).下載並安裝ODBC驅動程式
(3).windows中控制台-管理工具-資料來源,在系統DSN中進行添加
*/

 

本文出自 “日常工作/學習記錄筆記” 部落格，請務必保留此出處http://aimar111.blog.51cto.com/175714/1535211