NetBackup IT Analytics 安装和升级指南 (Linux)

创建数据库和用户：

1. 创建特定于 NetBackup IT Analytics 的表空间。

   表空间名		引用命令
   aptare_tbs_data_1m		CREATE TABLESPACE aptare_tbs_data_1m DATAFILE <datafile path> SIZE 8G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO /
   aptare_tbs_idx_1m		CREATE TABLESPACE aptare_tbs_idx_1m DATAFILE <datafile path> SIZE 8G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO /
   aptare_tbs_data_20m		CREATE TABLESPACE aptare_tbs_data_20m DATAFILE <datafile path> SIZE 8G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO /
   aptare_tbs_idx_10m		CREATE TABLESPACE aptare_tbs_idx_10m DATAFILE <datafile path> SIZE 8G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO /
   aptare_tbs_data_200m		CREATE TABLESPACE aptare_tbs_data_200m DATAFILE <datafile path> SIZE 8G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 16K EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO /
   aptare_tbs_idx_100m		CREATE TABLESPACE aptare_tbs_idx_100m DATAFILE <datafile path> SIZE 8G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 16K EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO /
   aptare_tbs_data_200m_lob		CREATE TABLESPACE aptare_tbs_data_200m_lob DATAFILE <datafile path> SIZE 8G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 16K EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO /
   aptare_tbs_data_200m_col		CREATE TABLESPACE aptare_tbs_data_200m_col DATAFILE <datafile path> SIZE 8G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 16K EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO /
   aptare_tbs_iot_200m		CREATE TABLESPACE aptare_tbs_iot_200m DATAFILE <datafile path> SIZE 8G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 16K EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO /

2. 创建两个数据库架构用户：PORTAL 和 APTARE_RO。

   为 PORTAL 用户分配密码 portal，为 APTARE_RO 用户分配密码 aptaresoftware123。您可以在使用以下 SQL 查询创建用户时更改这些信息。

   CREATE USER PORTAL 
       PROFILE DEFAULT
       IDENTIFIED BY portal
       DEFAULT TABLESPACE aptare_tbs_data_1m
       TEMPORARY TABLESPACE aptare_temp_tbs
       ACCOUNT UNLOCK;
   
   
   CREATE USER APTARE_RO 
       IDENTIFIED BY aptaresoftware123 
       DEFAULT TABLESPACE APTARE_TBS_DATA_1M 
       TEMPORARY TABLESPACE APTARE_TEMP_TBS;

3. 创建具有所需权限的以下所需数据库目录：

   CREATE OR REPLACE DIRECTORY UNIX_DIR AS '/u01/aptare/database';
   CREATE OR REPLACE DIRECTORY LOGFILE_DIR AS '/tmp';
   GRANT READ,WRITE ON DIRECTORY UNIX_DIR to portal;
   GRANT READ,WRITE ON DIRECTORY LOGFILE_DIR to portal;

   请注意，数据库服务器文件系统上的文件夹路径也可以更改为其他路径。

4. 为相应的用户架构授予以下权限：

   特定于用户的架构		架构所需的授权
   APTARE_RO		GRANT CONNECT TO aptare_ro; GRANT CREATE ANY CONTEXT TO aptare_ro; GRANT CREATE SYNONYM TO aptare_ro;
   门户		GRANT CONNECT TO PORTAL; GRANT RESOURCE TO PORTAL; GRANT CREATE TABLESPACE TO PORTAL; GRANT UNLIMITED TABLESPACE TO PORTAL; GRANT QUERY REWRITE TO PORTAL; GRANT SELECT_CATALOG_ROLE TO PORTAL; GRANT SELECT ANY DICTIONARY TO PORTAL; GRANT CREATE ANY LIBRARY TO PORTAL; GRANT SELECT ON dba_free_space TO PORTAL; GRANT SELECT ON dba_data_files TO PORTAL; GRANT SELECT ON dba_temp_files TO PORTAL; GRANT CREATE SESSION, CREATE ANY CONTEXT TO PORTAL;
   	用于执行 dbms_session 软件包的语句：
   		GRANT EXECUTE ON DBMS_SESSION TO PORTAL; GRANT EXECUTE ON DBMS_LOCK TO PORTAL;
   	用于执行 dbms_utility 软件包的语句：
   		GRANT EXECUTE ON DBMS_UTILITY TO PORTAL; GRANT CREATE VIEW TO PORTAL; GRANT CREATE TABLE TO PORTAL;
   	用于创建物化视图的语句
   		GRANT CREATE MATERIALIZED VIEW TO PORTAL;
   	用于设置日志记录目录的语句
   		GRANT CREATE ANY DIRECTORY TO PORTAL;
   	要为 Oracle 19c 添加的语句
   		GRANT CREATE JOB TO PORTAL; GRANT EXECUTE ON DBMS_SCHEDULER TO PORTAL;
   	用于添加安全性的语句
   		GRANT EXECUTE ON SYS.DBMS_LOB TO PORTAL; GRANT EXECUTE ON SYS.UTL_FILE TO PORTAL; GRANT EXECUTE ON SYS.DBMS_RANDOM TO PORTAL; GRANT EXECUTE ON SYS.DBMS_JOB TO PORTAL; GRANT EXECUTE ON SYS.DBMS_SQL TO PORTAL; GRANT READ ON SYS.ALL_DIRECTORIES TO PORTAL; GRANT READ ON SYS.DUAL TO PORTAL;
   	用于启用 FIPS 遵从性的语句
   		GRANT EXECUTE ON DBMS_CRYPTO TO PORTAL;

5. 要使用自定义密码安装 NetBackup IT Analytics，请执行以下操作：

   • 将 config.sh 文件复制到门户服务器上的本地目录，以便可以编辑文件。

     # mount -o loop itanalytics_installer_11400_linux.iso /mnt/diska
     # mkdir /tmp/portal
     # cp  /mnt/diska/config.sh /tmp/portal

   • 在 /tmp/portal/config.sh 中更新 PORTAL 和 APTARE_RO 用户密码。

     ORACLE_PORTAL_SEC_CODE=<password for PORTAL user>
     ORACLE_APTARE_RO_SEC_CODE=<password for APTARE_RO user>

   • 运行门户安装程序 Itanalyticsinstaller.sh。

     /mnt/diska/Itanalyticsinstaller.sh -C /tmp/portal/config.sh
     

   • 按照 在与 Oracle 应用程序二进制文件部署位置不同的计算机上安装门户二进制文件部分中所述从步骤 4 开始操作，在不同位置的计算机上部署门户二进制文件。

6. 要使用默认密码安装 NetBackup IT Analytics，请按照 在与 Oracle 应用程序二进制文件部署位置不同的计算机上安装门户二进制文件部分中所述从步骤 3 开始操作，在不同位置的计算机上部署门户二进制文件。