Prepare Oracle Database
If QAD Enterprise Applications is running on an Oracle database, perform the following procedure as the Oracle DBA to prepare the database for QXtend installation:
1 Use the following command to make the $ORACLE_HOME/network/admin/tnsnames.ora file readable to all users:
chmod o+r $ORACLE_HOME/network/admin/tnsnames.ora
2 Create an Oracle Net Service for QXtend using the netca command.
3 Beginning with QAD Enterprise Edition 2012.1, tablespaces QXEVENTS and QXEVENTS_IDX for QXEvents database are created automatically when you install QAD Enterprise Applications. If they do not exist, create the QXEvents tablespace with database admin. Use the following SQL commands as an example (/dbs/ueeora is the Oracle Data Directory).
CREATE TABLESPACE "QXEVENTS" DATAFILE
'/dbs/ueeora/qxevents_ORAU.dbf' SIZE 5242880
AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "QXEVENTS_IDX" DATAFILE
'/dbs/ueeora/qxevents_ORAU_idx01.dbf' SIZE 5242880
AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
4 Create the QXO database user. In the following example, the user name is qxodb and the password is qxodb.
CREATE USER qxodb IDENTIFIED BY qxodb;
GRANT CONNECT, RESOURCE TO qxodb;
GRANT CREATE SESSION TO qxodb;
GRANT SELECT ON "SYS"."ARGUMENT$" TO qxodb;
GRANT SELECT ON "SYS"."COL$" TO qxodb;
GRANT SELECT ON "SYS"."COM$" TO qxodb;
GRANT SELECT ON "SYS"."CON$" TO qxodb;
GRANT SELECT ON "SYS"."DUAL" TO qxodb;
GRANT SELECT ON "SYS"."ICOL$" TO qxodb;
GRANT SELECT ON "SYS"."IND$" TO qxodb;
GRANT SELECT ON "SYS"."LINK$" TO qxodb;
GRANT SELECT ON "SYS"."OBJ$" TO qxodb;
GRANT SELECT ON "SYS"."PROCEDURE$" TO qxodb;
GRANT SELECT ON "SYS"."SEQ$" TO qxodb;
GRANT SELECT ON "SYS"."SYN$" TO qxodb;
GRANT SELECT ON "SYS"."TAB$" TO qxodb;
GRANT SELECT ON "SYS"."TS$" TO qxodb;
GRANT SELECT ON "SYS"."USER$" TO qxodb;
GRANT SELECT ON "SYS"."VIEW$" TO qxodb;
5 Beginning with QAD Enterprise Edition 2012.1, tablespaces QXODB, QXODB_IDX, and QXODB_LOB for QXO database are created automatically when you install QAD Enterprise Applications. If they do not exist, create the QXO tablespace. Use the following SQL commands as an example (/dbs/ueeora is the Oracle Data Directory).
CREATE TABLESPACE "QXODB" DATAFILE
'/dbs/ueeora/qxodb_ORAU.dbf' SIZE 5242880
AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "QXODB_IDX" DATAFILE
'/dbs/ueeora/qxodb_ORAU_idx01.dbf' SIZE 5242880
AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "QXODB_LOB" DATAFILE
'/dbs/ueeora/qxodb_lob_ORAU.dbf' SIZE 5242880
AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;