How to create Table Space manually for CA Strong Authentication
search cancel

How to create Table Space manually for CA Strong Authentication

book

Article ID: 36130

calendar_today

Updated On:

Products

CA Advanced Authentication CA Strong Authentication CA Risk Authentication

Issue/Introduction

We are running Arcot common script for create Arcot db. The DB user has no grant to create new table space, so we have to ask our DBA to create tablespace. Which is the required portion of the arcot-db-config-for-common-8.1.sql that we need to send to the DBA to run separately?

Environment

Product: CA Advanced Authentication 8.1 (Strong Authentication and Risk Authentication)

DB: Oracle (All supported versions, Refer Release notes)

 

Resolution

If the user does not have the required permissions, a DBA can manually create the reports tablespace and delete the section in this DB script that creates this tablespace. The parameters for creating the reports tablespace in the arcot-db-config-for-common-8.1.sql database script can be changed according to the DBA's preferences. However, ensure that the tablespace name is ARReports.

Below is the section that is used in common scripts to delete existing table space(if available) and recreate it. Please refer to arcot-db-config-for-common-8.1.sql script for Oracle. You need to run this query snippet separately.

---------------------------------------------- 

DECLARE 

filename varchar2(50) := 'tabspace_arreports_'|| to_char(current_timestamp, 'YYYY-MM-DD-HH24-MI-SS') || '.dat'; 

cursor c1 is select tablespace_name from user_tablespaces where tablespace_name = 'ARREPORTS'; 

BEGIN 

FOR I IN c1 LOOP 

execute immediate 'DROP TABLESPACE '||I.tablespace_name||' including contents and datafiles'; 

END LOOP; 

EXECUTE IMMEDIATE 'CREATE TABLESPACE ARREPORTS DATAFILE '''||filename||''' SIZE 20M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED DEFAULT STORAGE (INITIAL 10K NEXT 50K MINEXTENTS 1 MAXEXTENTS 999) ONLINE'; 

END; 

/

--------------------------------------------- 

Additional Information

Detailed information of this process can be found in below CA wiki page

How to Configure the Database Server for Strong Authentication

Section: Configuring Oracle Database