Timesten 資料庫端需要的配置

jolly10發表於2012-03-27
Timesten 資料庫端需要的配置[@more@]

[oracle@qht131 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 23 16:08

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


1.建立ttusers表空間
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
With the Partitioning, OLAP, Data Mining and Real Applicati

SQL> create tablespace ttusers datafile 'ttusers.dbf' size

Tablespace created.

2.建立 TIMESTEN schema
SQL> @ initCacheGlobalSchema.sql

Please enter the tablespace where TIMESTEN user is to be created
ttusers
The value chosen for tablespace is ttusers

******* Creation of TIMESTEN schema and TT_CACHE_ADMIN_ROLE starts *******
1. Creating TIMESTEN schema
2. Creating TIMESTEN.TT_GRIDID table
3. Creating TIMESTEN.TT_GRIDINFO table
4. Creating TT_CACHE_ADMIN_ROLE role
5. Granting privileges to TT_CACHE_ADMIN_ROLE
** Creation of TIMESTEN schema and TT_CACHE_ADMIN_ROLE done successfully **

PL/SQL procedure successfully completed.

3.建立cacheadm schema
SQL> create user cacheadm identified by cacheadm
2 default tablespace ttusers
3 quota unlimited on ttusers
4 temporary tablespace temp;

4.賦許可權給cacheadm
SQL> @grantCacheAdminPrivileges.sql

Please enter the administrator user id
cacheadm
The value chosen for administrator user id is cacheadm

***************** Initialization for cache admin begins ******************
0. Granting the CREATE SESSION privilege to CACHEADM
1. Granting the TT_CACHE_ADMIN_ROLE to CACHEADM
2. Granting the DBMS_LOCK package privilege to CACHEADM
3. Granting the RESOURCE privilege to CACHEADM
4. Granting the CREATE PROCEDURE privilege to CACHEADM
5. Granting the CREATE ANY TRIGGER privilege to CACHEADM
6. Granting the DBMS_LOB package privilege to CACHEADM
7. Granting the SELECT on SYS.ALL_OBJECTS privilege to CACHEADM
8. Granting the SELECT on SYS.ALL_SYNONYMS privilege to CACHEADM
9. Checking if the cache administrator user has permissions on the default
tablespace
Permission exists
11. Granting the CREATE ANY TYPE privilege to CACHEADM
********* Initialization for cache admin user done successfully *********

5.賦需要cache的表的許可權給cacheadm
SQL> grant select on hr.departments to cacheadm;
SQL> grant select, insert, update, delete on hr.employees to cacheadm;
SQL> grant select, insert, update, delete on hr.job_history to cacheadm;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/271283/viewspace-1057740/,如需轉載,請註明出處,否則將追究法律責任。

相關文章