Saturday, May 12, 2012

Hyperic on Oracle DB

http://support.hyperic.com/display/DOC/Set+Up+Oracle

(full DDL to create tablespaces at the bottom of the above document....)

create temporary tablespace TEMP_HQDB
tempfile 'TEMP_HQDB.DBF' size 2G extent management local;

this will create a file
C:\oraclexe\app\oracle\product\10.2.0\server\database\TEMP_HQDB.DBF


create tablespace TS_HQDB logging datafile 'TS_HQDB.dbf' size 3g extent management local;

this will create a file
C:\oraclexe\app\oracle\product\10.2.0\server\database\TS_HQDB.DBF

This could take several minutes.


CREATE USER HQUSER IDENTIFIED BY HQPASSWORD DEFAULT TABLESPACE TS_HQDB;
GRANT CONNECT, RESOURCE, CREATE VIEW TO HQUSER;


copy ojdbc6.jar to the installer (what? you need to reinstall Hyperic Server to switch to Oracle DB? Oh no :o(((( ....)

No comments: