Oracle ZIP package details
The Oracle ZIP package contains the following files:
- CPUQ folder: Files with the name *_glas_cpuq.txt
- VMWARE folder: Files with the names <Vcenter Server Name>-HW-Inventory-Information.csv and <Vcenter Server Name>-VMs-Information.csv
- JAVA folder: one file with the name 3PTV_JAVAReport_<Sysdate>.csv
- logs folder: log files related to the generation of the ZIP package
- readme.txt: description of the ZIP package
- DB folder:
- One file ORCL_DETAIL.CSV - details of databases and related machine hardware information
- One file ORCL_OPTIONS.CSV - collected outcome of queries related to database features
- One file ORCL_DBA_USERS.CSV - information about database users
- One file ORCL_V$LICENSE.CSV - concurrent user session statistics
- One file ORCL_V$SESSION.CSV - concurrent user session information
- One file ORCL_OVERVIEW.CSV - collected information about database usage, options and editions, and related machine hardware
File details
The table below shows information that these files include:
File type | Details | File name |
---|---|---|
Hardware information files | The files include information such as hostname, IP address, and processor details. | For each machine, <machine_hostname>-glas_cpuq.txt is created. |
VMware files | The files include the following information:
|
Files with the names, <Vcenter Server Name>-HW-Inventory-Information.csv and <Vcenter Server Name>-VMs-Information.csv are created. |
Oracle Java inventory file | The file is in CSV format and contains the following
columns:
|
File with name, 3PTV_JAVAReport_<Sysdate>.csv is created. |
Oracle details | Details of databases and related machine
hardware information
|
ORCL_DETAIL.CSV |
Oracle options | Collected outcome of queries related to database
features
|
ORCL_OPTIONS.CSV |
Oracle database users | Information about database users
|
ORCL_DBA_USERS.CSV |
Oracle license statistics | Concurrent user session statistics
|
ORCL_V$LICENSE.CSV |
Oracle session information | Concurrent user session information
|
ORCL_V$SESSION.CSV |
Oracle overview | Collected information about database usage,
options and editions, and related machine hardware
|
ORCL_OVERVIEW.CSV |
Oracle Database Inventory files
DB_NAME - column uniquely identified the collected database instance/pluggable database on the server.
-
For non-container databases it contains V$INSTANCE.INSTANCE_NAME
-
For Container Databases (CDB) it contains the instance name concatenated with "~" separator and the Pluggable Database (PDB) name for the collected container. Any "$" character in the PDB name must be replaced with "_": V$INSTANCE.INSTANCE_NAME + || '~' ||replace(sys_context('USERENV', 'CON_NAME'), '$', '_')
Examples:
ORCL1~CDB_ROOT, ORCL1~PDB1