Pandora:Documentation en:Oracle Advises

From Pandora FMS Wiki

Jump to: navigation, search

Go back to Pandora FMS documentation index

Advises for using Oracle DB

General Advises for using Oracle

One of techniques used to promote the Oracle DB administration consist on separate the table index in different tablespace, so in case that the index tablespace get lost, we could recover the information from the tables.

In order to could do this before creating the Pandora sketch, you should follow the following steps from an Oracle client such as SQL*plus:

CREATE TABLESPACE "PANDORA" LOGGING DATAFILE '<ruta_fichero>/PANDORADAT.dbf' SIZE 1024M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE "PANDORA_DX" LOGGING DATAFILE '<ruta_fichero>/PANDORADAT_DBX.dbf' SIZE 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT     AUTO;
 
CREATE USER "PANDORA" PROFILE "DEFAULT" IDENTIFIED BY "<contraseña>" DEFAULT TABLESPACE "PANDORA" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;

GRANT "CONNECT" TO "PANDORA";

GRANT "RESOURCE" TO "PANDORA";

GRANT ALTER ANY INDEX TO "PANDORA";
GRANT ALTER ANY SEQUENCE TO "PANDORA";
GRANT ALTER ANY TABLE TO "PANDORA";
GRANT ALTER ANY TRIGGER TO "PANDORA";
GRANT CREATE ANY INDEX TO "PANDORA";
GRANT CREATE ANY SEQUENCE TO "PANDORA";
GRANT CREATE ANY SYNONYM TO "PANDORA";
GRANT CREATE ANY TABLE TO "PANDORA";
GRANT CREATE ANY TRIGGER TO "PANDORA";
GRANT CREATE ANY VIEW TO "PANDORA";
GRANT CREATE PROCEDURE TO "PANDORA";
GRANT CREATE PUBLIC SYNONYM TO "PANDORA";
GRANT CREATE TRIGGER TO "PANDORA";
GRANT CREATE VIEW TO "PANDORA";
GRANT DELETE ANY TABLE TO "PANDORA";
GRANT DROP ANY INDEX TO "PANDORA";
GRANT DROP ANY SEQUENCE TO "PANDORA";
GRANT DROP ANY TABLE TO "PANDORA";
GRANT DROP ANY TRIGGER TO "PANDORA";
GRANT DROP ANY VIEW TO "PANDORA";
GRANT INSERT ANY TABLE TO "PANDORA";
GRANT QUERY REWRITE TO "PANDORA";
GRANT SELECT ANY TABLE TO "PANDORA";
GRANT UNLIMITED TABLESPACE TO "PANDORA"; 

Doing this, we create an sketch with the name Pandora and the tablespace PANDORA for tables and Pandora_DX for index. When you create the index instead using the sentence of the file pandoradb.oracle.sql:

CREATE INDEX taddress_ip_idx ON taddress(ip);

Change it for the sentence:

CREATE INDEX taddress_ip_idx ON taddress(ip) TABLESPACE PANDORA_DX;

In all index creations.

Go back to Pandora FMS documentation index