首页 > 代码库 > 配置Vsphere vCenter 5.5安装使用远程Oracle数据库
配置Vsphere vCenter 5.5安装使用远程Oracle数据库
--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