注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

金生丽水,雨润轩德

 
 
 

日志

 
 

Vcenter server 5.1 安装SSO的数据库配置  

2013-02-21 14:15:12|  分类: 虚拟化 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

vcenter server 5.1 需要首先安装SSO单点登录,对于外置数据库需要在数据库端进行相应配置,以下摘自vmware 官方文档。

 

 

 

CREATE SMALLFILE TABLESPACE "VPX" DATAFILE '/oracle/oradata/vmvcdb/vpx01.dbf'
SIZE 1G AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT
SPACE MANAGEMENT AUTO;


CREATE USER "VPXADMIN" PROFILE "DEFAULT" IDENTIFIED BY "oracle" DEFAULT TABLESPACE "VPX" ACCOUNT UNLOCK;
grant connect to VPXADMIN;
grant resource to VPXADMIN;
grant create view to VPXADMIN;
grant create sequence to VPXADMIN;
grant create table to VPXADMIN;
grant create materialized view to VPXADMIN;
grant execute on dbms_lock to VPXADMIN;
grant execute on dbms_job to VPXADMIN;
grant select on dba_tablespaces to VPXADMIN;
grant select on dba_temp_files to VPXADMIN;
grant select on dba_data_files to VPXADMIN;
grant unlimited tablespace to VPXADMIN;

alter user "VPXADMIN" quota unlimited on "VPX";


为用户启用监控,在vCenter Server中可以监控到数据库的相应情况

grant select on v_$system_event to "VPXADMIN";
grant select on v_$sysmetric_history to "VPXADMIN";
grant select on v_$sysstat to "VPXADMIN";
grant select on dba_data_files to "VPXADMIN";
grant select on v_$loghist to "VPXADMIN";

 


================SSO==========================
CREATE TABLESPACE RSA_DATA
    DATAFILE '/oracle/oradata/vmvcdb/RSA_DATA.DAT' SIZE 15360K AUTOEXTEND ON NEXT 15360K MAXSIZE 10G
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
;

CREATE TABLESPACE RSA_INDEX
    DATAFILE '/oracle/oradata/vmvcdb/RSA_INDEX.DAT' SIZE 15360K AUTOEXTEND ON NEXT 15360K MAXSIZE 10G
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    NOLOGGING
    ONLINE
;

CREATE USER RSA_DBA IDENTIFIED BY "oracle" ACCOUNT UNLOCK;

ALTER USER RSA_DBA
    DEFAULT TABLESPACE RSA_DATA
    QUOTA UNLIMITED ON RSA_DATA
    QUOTA UNLIMITED ON RSA_INDEX;

GRANT CREATE SESSION TO RSA_DBA;
GRANT CREATE ANY TABLE TO RSA_DBA;
GRANT CREATE ANY INDEX TO RSA_DBA;
GRANT CREATE ANY SYNONYM TO RSA_DBA;
GRANT CREATE ANY TRIGGER TO RSA_DBA;
GRANT CREATE ANY SEQUENCE TO RSA_DBA;
GRANT ALTER ANY TABLE TO RSA_DBA;
GRANT ALTER ANY INDEX TO RSA_DBA;
GRANT DROP ANY TABLE TO RSA_DBA;
GRANT DROP ANY INDEX TO RSA_DBA;
GRANT DROP ANY SYNONYM TO RSA_DBA;
GRANT DROP ANY TRIGGER TO RSA_DBA;
GRANT DROP ANY SEQUENCE TO RSA_DBA;
GRANT SELECT ANY TABLE TO RSA_DBA;
GRANT DELETE ANY TABLE TO RSA_DBA;
GRANT UPDATE ANY TABLE TO RSA_DBA;

CREATE USER RSA_USER IDENTIFIED BY "oracle" ACCOUNT UNLOCK;

ALTER USER RSA_USER
    DEFAULT TABLESPACE RSA_DATA
    QUOTA UNLIMITED ON RSA_DATA
    QUOTA UNLIMITED ON RSA_INDEX;

GRANT CREATE SESSION TO RSA_USER;

schema的SQL语句太多,需要将文件拷贝到数据库服务器上,@*schema.sql执行。

安装SSO时,用户名选择的是 rsa_user,  DBA账号使用 system (使用sys老报错)


  评论这张
 
阅读(1977)| 评论(0)
推荐

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018