I'm getting inconsistent success when trying to discover Oracle options. Is there any detailed documentation that indicates the prerequisites needed for success?

rerose · ‎01-06-2021

I'm having difficulty identifying the root cause in the Oracle DB on UNIX pattern when the Oracle options aren't captured. I have SSH credentials and Oracle credentials configured. It appears that there are certain Oracle files that are parsed to gather the information needed to capture the data. Is there a comprehensive list of these files? Or do they need to be in specific formats in order for the pattern to collect successfully? Any information will be greatly appreciated.

Chirag K · ‎01-06-2021

what exact error you are getting?

rerose · ‎01-06-2021

The interesting thing is that some DB's on the same host are collecting the options successfully. Others are not. See below for log file. Is it related to the TNSNAMES file?

Discovery Log

2021-01-06 06:04:22: Task is running on MID server ProdMid_USONP001

2021-01-06 06:04:22: setAttribute(samp_client_access,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_key_value,[{}])

2021-01-06 06:04:22: setAttribute(samp_oracle_options,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_db_ora_instance,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_db_instance_size,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_db_ora_pdb_instance,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_config_file_tracked,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_db_ora_catalog,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_db_ora_instance,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_db_instance_size,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_db_ora_pdb_instance,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_config_file_tracked,[{}])

2021-01-06 06:04:22: setAttribute(cmdb_ci_db_ora_catalog,[{}])

Pre Pattern Execution

2021-01-06 06:04:22: Getting pre pattern execution data generated by script.

2021-01-06 06:04:22: setAttribute(pre_cmdb_running_process,[{parent=aee51455db3c68d07e4160fdd39619c1, classify=true, count=1, sys_mod_count=1, pid=11283, sys_updated_on=2020-12-20 06:09:07, sys_domain_path=/, sys_tags=, listening_on=, command=ora_pmon_MANDEV, ppid=1, sys_id=03e59455db3c68d07e4160fdd3961955, computer=1908d3ccdb161090ac7bc68913961994, sys_updated_by=mckesson_mid_26, connecting_to=, sys_created_on=2020-11-29 08:56:02, sys_domain=global, name=ora_pmon_MANDEV, key_parameters=, absent=false, parameters=, sys_created_by=mckesson_mid_29}])

2021-01-06 06:04:22: setAttribute(SAM_installed,true)

2021-01-06 06:04:22: setAttribute(pattern_runtime_mode,horizontal)

Selecting Pattern for Execution

2021-01-06 06:04:22: Pattern: Oracle DB On Unix

2021-01-06 06:04:22: setAttribute(pattern,Oracle DB On Unix)

Process Detection

2021-01-06 06:04:22: Executing SSH command: uname -a

2021-01-06 06:04:22: Command result: SunOS XXXX.ulab.XXXX.unx 5.11 11.3 sun4v sparc sun4v

2021-01-06 06:04:22: setAttribute(UNAME_A,SunOS XXXX.ulab.XXXX.unx 5.11 11.3 sun4v sparc sun4v)

2021-01-06 06:04:22: Executing SSH command as superuser: ps -eo user,pid,ppid,comm,args | grep -i '11283' | grep -v grep

2021-01-06 06:04:23: Command result: orascd 11283 1 ora_pmon_MANDEV ora_pmon_MANDEV

2021-01-06 06:04:23: Getting process info of proc 11283

2021-01-06 06:04:23: Executing SSH command as superuser: pwdx 11283

2021-01-06 06:04:23: Command result: 11283: /oracleSCD1/product/12.2.0.1/dbs

2021-01-06 06:04:23: Executing SSH command as superuser: pargs -e 11283

2021-01-06 06:04:24: Command result:

11283: ora_pmon_MANDEV

envp[0]: ORACLE_SPAWNED_PROCESS=1

envp[1]: SKGP_SPAWN_DIAG_POST_FORK_TS=

envp[2]: OS=SunOS

envp[3]: LC_ALL=

envp[4]: LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/opt/dpsapps/dbappagent/lib/sparcv9:/usr/lib:/usr/5lib:

envp[5]: SSH_CONNECTION=172.17.0.162 63104 10.9.9.146 22

envp[6]: LC_MONETARY=

envp[7]: ORACLE_SID=MANDEV

envp[8]: ORACLE_BASE=/oracleSCD1

envp[9]: LANG=en_US.UTF-8

envp[10]: TZ=America/Phoenix

envp[11]: DISPLAY=localhost:11.0

envp[12]: ORACLE_HOME=/oracleSCD1/product/12.2.0.1

envp[13]: HOSTNAME=XXXX.ulab.XXXX.unx

envp[14]: OLDPWD=/oracleSCD1/product/12.2.0.1

envp[15]: EDITOR=vi

envp[16]: ENVSTR=SCD1

envp[17]: USER=orascd

envp[18]: ENV=/home/orascd/.alias

envp[19]: MCKTIFF_HOME=/u02/apps/sps/imagemanager

envp[20]: LC_COLLATE=

envp[21]: WHOAMI=orascd

envp[22]: PWD=/oracleSCD1/product/12.2.0.1/OPatch

envp[23]: HOME=/home/orascd

envp[24]: LC_........

Result is larger than 1000 characters and was truncated by the logger

2021-01-06 06:04:24: Executing SSH command as superuser: ls -l /proc/11283/path/a.out

2021-01-06 06:04:24: Command result: lrwxrwxrwx 1 orascd dba 0 Dec 17 18:56 /proc/11283/path/a.out -> /oracleSCD1/product/12.2.0.1/bin/oracle

2021-01-06 06:04:24: Valid response to command: ls -l /proc/11283/path/a.out

2021-01-06 06:04:24: setAttribute(process,ProcessDTO [executable='ora_pmon_MANDEV', commandLine='ora_pmon_MANDEV', executablePath='/oracleSCD1/product/12.2.0.1/bin/oracle', executableDir='', currentDir='/oracleSCD1/product/12.2.0.1/dbs', pid='11283', parentProcessId='1', userName='orascd', domain='', image type='null'])

match we didnt get instance name

2021-01-06 06:04:24: Execution time: 0 ms

match we are on solaris

2021-01-06 06:04:24: Execution time: 0 ms

Check process name to match Oracle listener or Oracle

2021-01-06 06:04:24: Execution time: 0 ms

Set tcp_port

2021-01-06 06:04:24: setAttribute(tcp_port,null)

2021-01-06 06:04:24: Execution time: 0 ms

find instance

2021-01-06 06:04:24: Step condition is false. step not executed.

2021-01-06 06:04:24: Execution time: 0 ms

if process contains ora_pmon

2021-01-06 06:04:24: setAttribute(sid,MANDEV)

2021-01-06 06:04:24: Execution time: 0 ms

ps pmon

2021-01-06 06:04:24: Step condition is false. step not executed.

2021-01-06 06:04:24: Execution time: 0 ms

set pmon pid

2021-01-06 06:04:24: setAttribute(pmon_pid,11283)

2021-01-06 06:04:24: Execution time: 0 ms

find the pmon process

2021-01-06 06:04:24: Executing SSH command as superuser: ps -eo user,pid,ppid,comm,args | grep -i '11283' | grep -v grep

2021-01-06 06:04:25: Command result: orascd 11283 1 ora_pmon_MANDEV ora_pmon_MANDEV

2021-01-06 06:04:25: Getting process info of proc 11283

2021-01-06 06:04:25: Executing SSH command as superuser: pwdx 11283

2021-01-06 06:04:25: Command result: 11283: /oracleSCD1/product/12.2.0.1/dbs

2021-01-06 06:04:25: Executing SSH command as superuser: pargs -e 11283

2021-01-06 06:04:26: Command result:

11283: ora_pmon_MANDEV

envp[0]: ORACLE_SPAWNED_PROCESS=1

envp[1]: SKGP_SPAWN_DIAG_POST_FORK_TS=

envp[2]: OS=SunOS

envp[3]: LC_ALL=

envp[4]: LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/opt/dpsapps/dbappagent/lib/sparcv9:/usr/lib:/usr/5lib:

envp[5]: SSH_CONNECTION=172.17.0.162 63104 10.9.9.146 22

envp[6]: LC_MONETARY=

envp[7]: ORACLE_SID=MANDEV

envp[8]: ORACLE_BASE=/oracleSCD1

envp[9]: LANG=en_US.UTF-8

envp[10]: TZ=America/Phoenix

envp[11]: DISPLAY=localhost:11.0

envp[12]: ORACLE_HOME=/oracleSCD1/product/12.2.0.1

envp[13]: HOSTNAME=XXXX.ulab.XXXX.unx

envp[14]: OLDPWD=/oracleSCD1/product/12.2.0.1

envp[15]: EDITOR=vi

envp[16]: ENVSTR=SCD1

envp[17]: USER=orascd

envp[18]: ENV=/home/orascd/.alias

envp[19]: MCKTIFF_HOME=/u02/apps/sps/imagemanager

envp[20]: LC_COLLATE=

envp[21]: WHOAMI=orascd

envp[22]: PWD=/oracleSCD1/product/12.2.0.1/OPatch

envp[23]: HOME=/home/orascd

envp[24]: LC_........

Result is larger than 1000 characters and was truncated by the logger

2021-01-06 06:04:26: Executing SSH command as superuser: ls -l /proc/11283/path/a.out

2021-01-06 06:04:26: Command result: lrwxrwxrwx 1 orascd dba 0 Dec 17 18:56 /proc/11283/path/a.out -> /oracleSCD1/product/12.2.0.1/bin/oracle

2021-01-06 06:04:26: Valid response to command: ls -l /proc/11283/path/a.out

2021-01-06 06:04:26: setAttribute(pmon_process,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:04:26: Execution time: 1860 ms

match

2021-01-06 06:04:26: Execution time: 0 ms

extract ora home

2021-01-06 06:04:26: setAttribute(oracle_home_from_pmon,/oracleSCD1/product/12.2.0.1)

2021-01-06 06:04:26: Execution time: 0 ms

set ora_home_exe

2021-01-06 06:04:26: setAttribute(ora_home_exe,/oracleSCD1/product/12.2.0.1)

2021-01-06 06:04:26: Execution time: 0 ms

set process

2021-01-06 06:04:26: setAttribute(ora_process,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:04:26: Execution time: 0 ms

export oracle home

2021-01-06 06:04:26: Executing SSH command: export ORACLE_HOME=/oracleSCD1/product/12.2.0.1

2021-01-06 06:04:26: Command result:

2021-01-06 06:04:26: Execution time: 188 ms

take the ora home from listener path

2021-01-06 06:04:26: setAttribute(oracle_home,/oracleSCD1/product/12.2.0.1)

2021-01-06 06:04:26: Execution time: 0 ms

sets the display label

2021-01-06 06:04:26: setAttribute(name,MANDEV@XXXX)

2021-01-06 06:04:26: Execution time: 0 ms

Get version

2021-01-06 06:04:26: Executing SSH command: export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;/oracleSCD1/product/12.2.0.1/bin/sqlplus -v

2021-01-06 06:04:26: Command result: SQL*Plus: Release 12.2.0.1.0 Production

2021-01-06 06:04:26: setAttribute(version,12.2.0.1.0)

2021-01-06 06:04:26: Execution time: 250 ms

Get version from path

2021-01-06 06:04:26: Step condition is false. step not executed.

2021-01-06 06:04:26: Execution time: 0 ms

Parse context xml

2021-01-06 06:04:26: Executing SSH command as superuser: ls -1HF /oracleSCD1/product/12.2.0.1/inventory/Components21/oracle.server /DuMmY

2021-01-06 06:04:27: Command result:

/DuMmY: No such file or directory

/oracleSCD1/product/12.2.0.1/inventory/Components21/oracle.server:

12.2.0.1.0/

2021-01-06 06:04:27: Executing SSH command as superuser: ls -1HF /oracleSCD1/product/12.2.0.1/inventory/Components21/oracle.server/12.2.0.1.0/context.xml /DuMmY

2021-01-06 06:04:27: Command result:

/DuMmY: No such file or directory

/oracleSCD1/product/12.2.0.1/inventory/Components21/oracle.server/12.2.0.1.0/context.xml

2021-01-06 06:04:27: Executing SSH command: ls -E -L "/oracleSCD1/product/12.2.0.1/inventory/Components21/oracle.server/12.2.0.1.0/context.xml" | tr -s ' '|cut -d' ' -f6,7

2021-01-06 06:04:28: Command result: /oracleSCD1/product/12.2.0.1/inventory/Components21/oracle.server/12.2.0.1.0/context.xml: Permission denied

2021-01-06 06:04:28: Failed to get last modification time of /oracleSCD1/product/12.2.0.1/inventory/Components21/oracle.server/12.2.0.1.0/context.xml. continue to get file regardless.. Failed to parse last modified time of file through command like. Returned data time string: /oracleSCD1/product/12.2.0.1/inventory/Components21/oracle.server/12.2.0.1.0/context.xml: Permission denied

2021-01-06 06:04:28: Executing SSH command as superuser: cat "/oracleSCD1/product/12.2.0.1/inventory/Components21/oracle.server/12.2.0.1.0/context.xml"

2021-01-06 06:04:28: Command result:

<?xml version="1.0" standalone="yes" ?>

<COMP_CONTEXT>

<VAR_LIST SIZE="129">

<VAR NAME="sl_dlgDBConfig_Options0"........

Result is larger than 1000 characters and was truncated by the logger

2021-01-06 06:04:28: setAttribute(context,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:04:28: Execution time: 1625 ms

Filter context for the edition

2021-01-06 06:04:28: setAttribute(context,[])

2021-01-06 06:04:28: Execution time: 0 ms

Set edition if enterprise

2021-01-06 06:04:28: Step condition is false. step not executed.

2021-01-06 06:04:28: Execution time: 0 ms

Set edition if standard

2021-01-06 06:04:28: Step condition is false. step not executed.

2021-01-06 06:04:28: Execution time: 0 ms

Parse globalvariables xml

2021-01-06 06:04:28: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/inventory/globalvariables/oracle.server/globalvariables.xml

2021-01-06 06:04:29: Command result: /oracleSCD1/product/12.2.0.1/inventory/globalvariables/oracle.server/globalvariables.xml

2021-01-06 06:04:29: Executing SSH command: ls -E -L "/oracleSCD1/product/12.2.0.1/inventory/globalvariables/oracle.server/globalvariables.xml" | tr -s ' '|cut -d' ' -f6,7

2021-01-06 06:04:29: Command result: /oracleSCD1/product/12.2.0.1/inventory/globalvariables/oracle.server/globalvariables.xml: Permission denied

2021-01-06 06:04:29: Failed to get last modification time of /oracleSCD1/product/12.2.0.1/inventory/globalvariables/oracle.server/globalvariables.xml. continue to get file regardless.. Failed to parse last modified time of file through command like. Returned data time string: /oracleSCD1/product/12.2.0.1/inventory/globalvariables/oracle.server/globalvariables.xml: Permission denied

2021-01-06 06:04:29: Executing SSH command as superuser: cat "/oracleSCD1/product/12.2.0.1/inventory/globalvariables/oracle.server/globalvariables.xml"

2021-01-06 06:04:29: Command result:

<VAR NAME="oracle_install_RACInstall" TYPE="BOOL" VALUE="F" ADVISE="T" COMPUTE_AT_CLONE="F" CALC_REQD="F" CLASS="oracle.sysman.oii.oiis.OiisVariable" EXTENDS_FROM="" ALLOW_ASSIGNMENT="T" HANDLE_ERRORS="F" VAL_REQD="F" ........

Result is larger than 1000 characters and was truncated by the logger

2021-01-06 06:04:29: setAttribute(globalvar,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:04:29: Execution time: 1172 ms

Filter globalvar for the edition

2021-01-06 06:04:29: setAttribute(globalvar,[{name=oracle_install_db_InstallType, value=EE, forEach=/oracleSCD1/product/12.2.0.1/inventory/globalvariables/oracle.server/globalvariables.xml}])

2021-01-06 06:04:29: Execution time: 0 ms

Set edition if enterprise from globalvar

2021-01-06 06:04:29: setAttribute(edition,Enterprise)

2021-01-06 06:04:29: Execution time: 0 ms

Set edition if standard from globalvar

2021-01-06 06:04:29: Step condition is false. step not executed.

2021-01-06 06:04:29: Execution time: 0 ms

Parse tnsnames.ora

2021-01-06 06:04:29: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:04:30: Command result: /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:04:30: Executing SSH command: ls -E -L "/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora" | tr -s ' '|cut -d' ' -f6,7

2021-01-06 06:04:30: Command result: 2019-09-05 18:13:51.906885700

2021-01-06 06:04:30: file /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora was served from cache....

2021-01-06 06:04:30: setAttribute(connect_sql,[{service_name=MANDEV, listener_port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service_name=SPSDEV.WORLD, listener_port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service_name=UHUBDEV.WORLD, listener_port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:04:30: Execution time: 578 ms

Filter service names

2021-01-06 06:04:30: Step condition is false. step not executed.

2021-01-06 06:04:30: Execution time: 0 ms

Set the servicename variable from the table

2021-01-06 06:04:30: setAttribute(servicename,MANDEV)

2021-01-06 06:04:30: Execution time: 0 ms

Set the servicename variable from sid if empty

2021-01-06 06:04:30: Step condition is false. step not executed.

2021-01-06 06:04:30: Execution time: 0 ms

Exclude TCPS ports

2021-01-06 06:04:30: setAttribute(connect_sql,[{service_name=MANDEV, listener_port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service_name=SPSDEV.WORLD, listener_port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service_name=UHUBDEV.WORLD, listener_port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:04:30: Execution time: 0 ms

Set tcp_port

2021-01-06 06:04:30: setAttribute(tcp_port,1525)

2021-01-06 06:04:30: Execution time: 0 ms

Determine sudo

2021-01-06 06:04:30: setAttribute(sudo,sudo)

2021-01-06 06:04:30: Execution time: 0 ms

Set tcp_port from netstat

2021-01-06 06:04:30: Step condition is false. step not executed.

2021-01-06 06:04:30: Execution time: 0 ms

Select edition from oracle DB if empty

2021-01-06 06:04:30: Step condition is false. step not executed.

2021-01-06 06:04:30: Execution time: 0 ms

run SQL query for Unix

2021-01-06 06:04:30: Executing SSH command: export TNS_ADMIN=;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1; echo -e set head off feed off pages 0 line 3000\\n"select NAME || '####' || VALUE from v\$parameter;" | /oracleSCD1/product/12.2.0.1/bin/sqlplus -s CONFIG_SCAN_USER/'*****'@MANDEV

2021-01-06 06:04:31: Command result:

SP2-0734: unknown command beginning "-e set hea..." - rest of line ignored.

NAME||'####'||VALUE

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

lock_name_space####

processes####300

sessions####500

timed_statistics####TRUE

timed_os_statistics####0

resource_limit####TRUE

license_max_sessions####0

license_sessions_warning####0

long_module_action####TRUE

standby_db_preserve_states####NONE

instance_abort_delay_time####0

NAME||'####'||VALUE

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

cpu_count####100

instance_groups####

event####

sga_max_size####3221225472

use_large_pages####TRUE

pre_page_sga####TRUE

shared_memory_address####0

hi_shared_memory_address####0

lock_sga####FALSE

processor_group_name####

allow_group_access_to_sga####FALSE

NAME||'####'||VALUE

----------------------------------------------------------------------------........

Result is larger than 1000 characters and was truncated by the logger

2021-01-06 06:04:31: setAttribute(extended_attr,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:04:31: Execution time: 1127 ms

put sql file for win platform

2021-01-06 06:04:31: Step condition is false. step not executed.

2021-01-06 06:04:31: Execution time: 0 ms

run SQL query for Win

2021-01-06 06:04:31: Step condition is false. step not executed.

2021-01-06 06:04:31: Execution time: 0 ms

set source to DB

2021-01-06 06:04:31: setAttribute(extended_attr,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:04:31: Execution time: 0 ms

Set install directory

2021-01-06 06:04:31: setAttribute(install_directory,/oracleSCD1/product/12.2.0.1)

2021-01-06 06:04:31: Execution time: 0 ms

Find the pfile name

2021-01-06 06:04:31: Command result: spfileMANDEV.ora

2021-01-06 06:04:31: setAttribute(pfile,spfileMANDEV.ora)

2021-01-06 06:04:31: Execution time: 219 ms

Fill pfile path

2021-01-06 06:04:31: setAttribute(pfile,/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora)

2021-01-06 06:04:31: Execution time: 0 ms

Save pfile content

2021-01-06 06:04:31: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora

2021-01-06 06:04:32: Command result: /oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora

2021-01-06 06:04:32: Executing SSH command: ls -E -L "/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora" | tr -s ' '|cut -d' ' -f6,7

2021-01-06 06:04:32: Command result: 2021-01-02 17:06:05.417640210

2021-01-06 06:04:32: Executing SSH command as superuser: cat "/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora"

2021-01-06 06:04:32: Command result:

C"E ?:~ CC"QWMANDEV.__data_transfer_cache_size=0

MANDEV.__db_cache_size=687865856

MANDEV.__inmemory_ext_roarea=0

MANDEV.__inmemory_ext_rwarea=0

MANDEV.__java_pool_size=50331648

MANDEV.__large_pool_size=620756992

MANDEV.__oracle_base='/oracleSCD1'#ORACLE_BASE set from environment

MANDEV.__pga_aggregate_target=1073741824

MANDEV.__sga_target=3221225472

MANDEV.__shared_io_pool_size=134217728

MANDEV.__shared_pool_size=1694498816

MANDEV.__streams_pool_size=0

*.archive_lag_target=900

*.audit_file_dest='CC"/oradiag/MANDEV/adump'

*.audit_sys_operations=TRUE

*.audit_syslog_level='LOCAL1.WARNING'

*.audit_trail='OS'

*.compatible='12.2.0'

*.control_files='/oradataSCD1/MANDEV/control01.ctl','/oracleSCD1/product/db_controlfiles/MANDEV/control02.ctl'

*.core_dump_dest='/oradiag/MANDEV/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_name='MANDEV'

*.db_recovery_file_dest_size=214748364800

*.db_recovery_file_des........

Result is larger than 1000 characters and was truncated by the logger

2021-01-06 06:04:32: setAttribute(pfile,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:04:32: Execution time: 1078 ms

Set main ci table attributes

2021-01-06 06:04:32: setAttribute(cmdb_ci_db_ora_instance,[{tcp_port=1525, install_directory=/oracleSCD1/product/12.2.0.1, pfile=[C"E ?:~ CC"QWMANDEV.__data_transfer_cache_size=0, MANDEV.__db_cache_size=687865856, MANDEV.__inmemory_ext_roarea=0, MANDEV.__inmemory_ext_rwarea=0, MANDEV.__java_pool_size=50331648, MANDEV.__large_pool_size=620756992, MANDEV.__oracle_base='/oracleSCD1'#ORACLE_BASE set from environment, MANDEV.__pga_aggregate_target=1073741824, MANDEV.__sga_target=3221225472, MANDEV.__shared_io_pool_size=134217728, MANDEV.__shared_pool_size=1694498816, MANDEV.__streams_pool_size=0, *.archive_lag_target=900, *.audit_file_dest='CC"/oradiag/MANDEV/adump', *.audit_sys_operations=TRUE, *.audit_syslog_level='LOCAL1.WARNING', *.audit_trail='OS', *.compatible='12.2.0', *.control_files='/oradataSCD1/MANDEV/control01.ctl','/oracleSCD1/product/db_controlfiles/MANDEV/control02.ctl', *.core_dump_dest='/oradiag/MANDEV/cdump', *.db_block_size=8192, *.db_domain='', *.db_name='MANDEV', *.db_recovery_file_dest_si

2021-01-06 06:04:32: Execution time: 0 ms

get discovery type

2021-01-06 06:04:32: setAttribute(discovery_type,horizontal)

2021-01-06 06:04:32: Execution time: 0 ms

run SQL query for Unix

2021-01-06 06:04:32: Executing SSH command: export TNS_ADMIN=;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1; echo -e set head off feed off pages 0 line 3000\\n"select NAME || '####' || VALUE from v\$parameter;" | /oracleSCD1/product/12.2.0.1/bin/sqlplus -s CONFIG_SCAN_USER/'*****'@MANDEV

2021-01-06 06:04:33: Command result:

SP2-0734: unknown command beginning "-e set hea..." - rest of line ignored.

NAME||'####'||VALUE

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

lock_name_space####

processes####300

sessions####500

timed_statistics####TRUE

timed_os_statistics####0

resource_limit####TRUE

license_max_sessions####0

license_sessions_warning####0

long_module_action####TRUE

standby_db_preserve_states####NONE

instance_abort_delay_time####0

NAME||'####'||VALUE

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

cpu_count####100

instance_groups####

event####

sga_max_size####3221225472

use_large_pages####TRUE

pre_page_sga####TRUE

shared_memory_address####0

hi_shared_memory_address####0

lock_sga####FALSE

processor_group_name####

allow_group_access_to_sga####FALSE

NAME||'####'||VALUE

----------------------------------------------------------------------------........

Result is larger than 1000 characters and was truncated by the logger

2021-01-06 06:04:33: setAttribute(extended_attr,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:04:33: Execution time: 1031 ms

put sql file for win platform

2021-01-06 06:04:33: Step condition is false. step not executed.

2021-01-06 06:04:33: Execution time: 0 ms

run SQL query for Win

2021-01-06 06:04:33: Step condition is false. step not executed.

2021-01-06 06:04:33: Execution time: 0 ms

set source to DB

2021-01-06 06:04:33: setAttribute(extended_attr,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:04:33: Execution time: 0 ms

###Oracle options and packs usage ###

2021-01-06 06:04:33: Execution time: 0 ms

get discovery type

2021-01-06 06:04:33: setAttribute(discovery_type,horizontal)

2021-01-06 06:04:33: Execution time: 0 ms

verify horizontal mode

2021-01-06 06:04:33: Execution time: 0 ms

put Oracle options_packs_usage_statistics sql file

2021-01-06 06:04:33: all commands failed on host: 10.9.9.146. command type: GET_ADDRESS_WIDTH. command track:

WindowsAddressWidthCommand\(NotRelevant),; input:

2021-01-06 06:04:33: Putting file to /tmp/sntmp/options_packs_usage_statistics.sql on 10.9.9.146

2021-01-06 06:04:33: Executing SSH command: mkdir -p /tmp/sntmp

2021-01-06 06:04:33: Command result:

2021-01-06 06:04:34: setAttribute(oraStatisticsScript,/tmp/sntmp/options_packs_usage_statistics.sql)

2021-01-06 06:04:34: Execution time: 516 ms

create output folder and remove old csv file

2021-01-06 06:04:34: Executing SSH command: mkdir -p MANDEV_XXXX;cd MANDEV_XXXX;rm -f *options_packs_usage_statistics.csv; echo Done

2021-01-06 06:04:34: Command result: Done

2021-01-06 06:04:34: setAttribute(dummy,Done)

2021-01-06 06:04:34: Execution time: 94 ms

set ora_home_exe if empty

2021-01-06 06:04:34: Step condition is false. step not executed.

2021-01-06 06:04:34: Execution time: 0 ms

run options_packs_usage_statistics.sql

2021-01-06 06:04:34: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s CONFIG_SCAN_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:05:34: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:05:34: Command failed with status timeout

2021-01-06 06:05:34: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s SERVICENOW_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:06:34: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:06:34: Command failed with status timeout

2021-01-06 06:06:34: Execution time: 120170 ms

verify csv file

2021-01-06 06:06:34: Executing SSH command: cd ~/MANDEV_XXXX; ls *options_packs_usage_statistics.csv | wc -l

2021-01-06 06:06:34: Command result: 0

2021-01-06 06:06:34: setAttribute(success,0)

2021-01-06 06:06:34: Execution time: 93 ms

get db name from pfile if success=0

2021-01-06 06:06:34: setAttribute(db_name,[{entry=MANDEV}])

2021-01-06 06:06:34: Execution time: 0 ms

get db name from prop file

2021-01-06 06:06:34: Step condition is false. step not executed.

2021-01-06 06:06:34: Execution time: 0 ms

get db_name from pfile

2021-01-06 06:06:34: Step condition is false. step not executed.

2021-01-06 06:06:34: Execution time: 0 ms

get tnsnames info

2021-01-06 06:06:34: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:06:35: Command result: /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:06:35: file /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora was served from cache....

2021-01-06 06:06:35: setAttribute(ora_info,[{alias=MANDEV, port=1525, sid=MANDEV, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {alias=SPSDEV, port=1525, sid=SPSDEV.WORLD, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {alias=UHUBDEV, port=1525, sid=UHUBDEV.WORLD, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:06:35: Execution time: 485 ms

get tnsnames info 2

2021-01-06 06:06:35: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:06:35: Command result: /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:06:35: file /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora was served from cache....

2021-01-06 06:06:35: Execution time: 390 ms

union info tables

2021-01-06 06:06:35: setAttribute(ora_info,[{alias=MANDEV, port=1525, sid=MANDEV, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {alias=SPSDEV, port=1525, sid=SPSDEV.WORLD, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {alias=UHUBDEV, port=1525, sid=UHUBDEV.WORLD, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:06:35: Execution time: 0 ms

keep our info

2021-01-06 06:06:35: setAttribute(ora_info,[{alias=MANDEV, port=1525, sid=MANDEV, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:06:35: Execution time: 0 ms

run options_packs_usage_statistics.sql 2

2021-01-06 06:06:35: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s CONFIG_SCAN_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:07:35: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:07:35: Command failed with status timeout

2021-01-06 06:07:35: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s SERVICENOW_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:08:35: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:08:35: Command failed with status timeout

2021-01-06 06:08:35: Execution time: 120150 ms

verify we have csv file

2021-01-06 06:08:35: Executing SSH command: cd ~/MANDEV_XXXX; ls *options_packs_usage_statistics.csv | wc -l

2021-01-06 06:08:35: Command result: 0

2021-01-06 06:08:35: setAttribute(success,0)

2021-01-06 06:08:35: Execution time: 94 ms

run options_packs_usage_statistics.sql 3

2021-01-06 06:08:35: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s CONFIG_SCAN_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:09:35: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:09:35: Command failed with status timeout

2021-01-06 06:09:35: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s SERVICENOW_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:10:35: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:10:35: Command failed with status timeout

2021-01-06 06:10:35: Execution time: 120164 ms

verify we have csv file

2021-01-06 06:10:35: Executing SSH command: cd ~/MANDEV_XXXX; ls *options_packs_usage_statistics.csv | wc -l

2021-01-06 06:10:36: Command result: 0

2021-01-06 06:10:36: setAttribute(success,0)

2021-01-06 06:10:36: Execution time: 94 ms

populate tracked file

2021-01-06 06:10:36: Step condition is false. step not executed.

2021-01-06 06:10:36: Execution time: 0 ms

#Populate options#

2021-01-06 06:10:36: Execution time: 0 ms

get output file

2021-01-06 06:10:36: Step condition is false. step not executed.

2021-01-06 06:10:36: Execution time: 0 ms

parse file content

2021-01-06 06:10:36: Step condition is false. step not executed.

2021-01-06 06:10:36: Execution time: 0 ms

transform currently_used column

2021-01-06 06:10:36: Step condition is false. step not executed.

2021-01-06 06:10:36: Execution time: 0 ms

create relation between oracle instance and options or packs

2021-01-06 06:10:36: Step condition is false. step not executed.

2021-01-06 06:10:36: Execution time: 0 ms

###END###

2021-01-06 06:10:36: Execution time: 0 ms

###Oracle options and packs usage ###

2021-01-06 06:10:36: Execution time: 0 ms

get discovery type

2021-01-06 06:10:36: setAttribute(discovery_type,horizontal)

2021-01-06 06:10:36: Execution time: 0 ms

verify horizontal mode

2021-01-06 06:10:36: Execution time: 0 ms

put Oracle options_packs_usage_statistics sql file

2021-01-06 06:10:36: all commands failed on host: 10.9.9.146. command type: GET_ADDRESS_WIDTH. command track:

WindowsAddressWidthCommand\(NotRelevant),; input:

2021-01-06 06:10:36: Putting file to /tmp/sntmp/options_packs_usage_statistics.sql on 10.9.9.146

2021-01-06 06:10:36: Executing SSH command: mkdir -p /tmp/sntmp

2021-01-06 06:10:36: Command result:

2021-01-06 06:10:36: setAttribute(oraStatisticsScript,/tmp/sntmp/options_packs_usage_statistics.sql)

2021-01-06 06:10:36: Execution time: 531 ms

set ora_home_exe if empty

2021-01-06 06:10:36: Step condition is false. step not executed.

2021-01-06 06:10:36: Execution time: 0 ms

set sid from servicename

2021-01-06 06:10:36: Step condition is false. step not executed.

2021-01-06 06:10:36: Execution time: 0 ms

create output folder and remove old csv file

2021-01-06 06:10:36: Executing SSH command: mkdir -p MANDEV_XXXX;cd MANDEV_XXXX;rm -f *options_packs_usage_statistics.csv; echo Done

2021-01-06 06:10:36: Command result: Done

2021-01-06 06:10:36: setAttribute(dummy,Done)

2021-01-06 06:10:36: Execution time: 94 ms

get host name

2021-01-06 06:10:36: setAttribute(tmp,XXXX)

2021-01-06 06:10:36: Execution time: 0 ms

run options_packs_usage_statistics.sql

2021-01-06 06:10:36: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s CONFIG_SCAN_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:11:36: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:11:36: Command failed with status timeout

2021-01-06 06:11:36: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s SERVICENOW_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:12:36: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:12:36: Command failed with status timeout

2021-01-06 06:12:36: Execution time: 120160 ms

verify csv file

2021-01-06 06:12:36: Executing SSH command: cd ~/MANDEV_XXXX; ls *options_packs_usage_statistics.csv | wc -l

2021-01-06 06:14:36: Command result: Terminated the probe because the max timeout was exceeded: 60 seconds.

2021-01-06 06:14:36: Command failed with status timeout

2021-01-06 06:14:36: Execution time: 120009 ms

get db name from pfile if success=0

2021-01-06 06:14:36: setAttribute(db_name,[{entry=MANDEV}])

2021-01-06 06:14:36: Execution time: 0 ms

get db name from prop file

2021-01-06 06:14:36: Step condition is false. step not executed.

2021-01-06 06:14:36: Execution time: 0 ms

get db_name from pfile

2021-01-06 06:14:36: Step condition is false. step not executed.

2021-01-06 06:14:36: Execution time: 0 ms

get tnsnames info

2021-01-06 06:14:36: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:16:36: Command failed with status timeout

2021-01-06 06:16:36: Failed to run command: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora as superuser. fallback to regular userExecution of command sudo ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora on host 10.9.9.146 failed with status timeout. Terminated the probe because the max timeout was exceeded: 60 seconds.

2021-01-06 06:16:36: Executing SSH command: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:18:36: Command result: Terminated the probe because the max timeout was exceeded: 60 seconds.

2021-01-06 06:18:36: Command failed with status timeout

2021-01-06 06:18:36: Command GetFileNamesByExpression (ls -1) failed, exception is Execution of command ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora on host 10.9.9.146 failed with status timeout. Terminated the probe because the max timeout was exceeded: 60 seconds.

2021-01-06 06:18:36: Execution time: 240041 ms

get tnsnames info 2

2021-01-06 06:18:36: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:20:36: Command failed with status timeout

2021-01-06 06:20:36: Failed to run command: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora as superuser. fallback to regular userExecution of command sudo ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora on host 10.9.9.146 failed with status timeout. Terminated the probe because the max timeout was exceeded: 60 seconds.

2021-01-06 06:20:36: Executing SSH command: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:22:36: Command result: Terminated the probe because the max timeout was exceeded: 60 seconds.

2021-01-06 06:22:36: Command failed with status timeout

2021-01-06 06:22:36: Command GetFileNamesByExpression (ls -1) failed, exception is Execution of command ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora on host 10.9.9.146 failed with status timeout. Terminated the probe because the max timeout was exceeded: 60 seconds.

2021-01-06 06:22:36: Execution time: 240039 ms

union info tables

2021-01-06 06:22:36: setAttribute(ora_info,[{alias=MANDEV, port=1525, sid=MANDEV, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:22:36: Execution time: 0 ms

keep our info

2021-01-06 06:22:36: setAttribute(ora_info,[{alias=MANDEV, port=1525, sid=MANDEV, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:22:36: Execution time: 0 ms

run options_packs_usage_statistics.sql 2

2021-01-06 06:22:36: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s CONFIG_SCAN_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:24:27: Command result: Terminated the probe because the max timeout was exceeded: 60 seconds.

2021-01-06 06:24:27: Command failed with status timeout

2021-01-06 06:24:27: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s SERVICENOW_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:25:28: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:25:28: Command failed with status timeout

2021-01-06 06:25:28: Execution time: 171375 ms

verify we have csv file

2021-01-06 06:25:28: Executing SSH command: cd ~/MANDEV_XXXX; ls *options_packs_usage_statistics.csv | wc -l

2021-01-06 06:25:28: Command result: 0

2021-01-06 06:25:28: setAttribute(success,0)

2021-01-06 06:25:28: Execution time: 63 ms

run options_packs_usage_statistics.sql 3

2021-01-06 06:25:28: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s CONFIG_SCAN_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:26:28: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:26:28: Command failed with status timeout

2021-01-06 06:26:28: Executing SSH command: export LD_LIBRARY_PATH=/oracleSCD1/product/12.2.0.1/lib:/lib:/usr/lib;cd ~/MANDEV_XXXX; export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1;"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s SERVICENOW_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/options_packs_usage_statistics.sql

2021-01-06 06:27:28: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:27:28: Command failed with status timeout

2021-01-06 06:27:28: Execution time: 120101 ms

verify we have csv file

2021-01-06 06:27:28: Executing SSH command: cd ~/MANDEV_XXXX; ls *options_packs_usage_statistics.csv | wc -l

2021-01-06 06:27:28: Command result: 0

2021-01-06 06:27:28: setAttribute(success,0)

2021-01-06 06:27:28: Execution time: 63 ms

populate tracked file

2021-01-06 06:27:28: Step condition is false. step not executed.

2021-01-06 06:27:28: Execution time: 0 ms

#Populate options#

2021-01-06 06:27:28: Execution time: 0 ms

get output file

2021-01-06 06:27:28: Step condition is false. step not executed.

2021-01-06 06:27:28: Execution time: 0 ms

parse file content

2021-01-06 06:27:28: Step condition is false. step not executed.

2021-01-06 06:27:28: Execution time: 0 ms

transform currently_used column

2021-01-06 06:27:28: Step condition is false. step not executed.

2021-01-06 06:27:28: Execution time: 0 ms

create relation between oracle instance and options or packs

2021-01-06 06:27:28: Step condition is false. step not executed.

2021-01-06 06:27:28: Execution time: 0 ms

###END###

2021-01-06 06:27:28: Execution time: 0 ms

verify HD mode

2021-01-06 06:27:28: Execution time: 0 ms

get defined lsnr info win

2021-01-06 06:27:28: Step condition is false. step not executed.

2021-01-06 06:27:28: Execution time: 0 ms

get defined lsnr info Unix

2021-01-06 06:27:28: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:27:28: Command result: /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:27:28: file /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora was served from cache....

2021-01-06 06:27:28: setAttribute(defined_services,[{service=MANDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service=SPSDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service=UHUBDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:27:28: Execution time: 422 ms

get defined lsnr info Unix 2

2021-01-06 06:27:28: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:27:29: Command result: /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:27:29: file /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora was served from cache....

2021-01-06 06:27:29: Execution time: 338 ms

union tables

2021-01-06 06:27:29: setAttribute(defined_services,[{service=MANDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service=SPSDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service=UHUBDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:27:29: Execution time: 0 ms

filter info relevant to our service

2021-01-06 06:27:29: setAttribute(defined_services,[{service=MANDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:27:29: Execution time: 0 ms

filter info relevant to our sid

2021-01-06 06:27:29: setAttribute(defined_services,[{service=MANDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:27:29: Execution time: 0 ms

Verify sid servicename

2021-01-06 06:27:29: setAttribute(sid_update,MANDEV)

2021-01-06 06:27:29: Execution time: 0 ms

update sid

2021-01-06 06:27:29: setAttribute(sid,MANDEV)

2021-01-06 06:27:29: Execution time: 0 ms

put size sql file

2021-01-06 06:27:29: all commands failed on host: 10.9.9.146. command type: GET_ADDRESS_WIDTH. command track:

WindowsAddressWidthCommand\(NotRelevant),; input:

2021-01-06 06:27:29: Putting file to /tmp/sntmp/Oracle_instance_size.sql on 10.9.9.146

2021-01-06 06:27:29: Executing SSH command: mkdir -p /tmp/sntmp

2021-01-06 06:27:29: Command result:

2021-01-06 06:27:29: setAttribute(sqlQuery,/tmp/sntmp/Oracle_instance_size.sql)

2021-01-06 06:27:29: Execution time: 282 ms

get container size info win

2021-01-06 06:27:29: Step condition is false. step not executed.

2021-01-06 06:27:29: Execution time: 0 ms

get container size info Unix

2021-01-06 06:27:29: Executing SSH command: export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1; "/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s CONFIG_SCAN_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/Oracle_instance_size.sql

2021-01-06 06:28:29: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:28:29: Command failed with status timeout

2021-01-06 06:28:29: Executing SSH command: export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1; "/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s SERVICENOW_USER/'*****'@XXXX:1525/MANDEV @/tmp/sntmp/Oracle_instance_size.sql

2021-01-06 06:29:29: Command result:

ERROR:

ORA-12541: TNS:no listener

2021-01-06 06:29:29: Command failed with status timeout

2021-01-06 06:29:29: Execution time: 120043 ms

get container size info Unix from SID

2021-01-06 06:29:29: Step condition is false. step not executed.

2021-01-06 06:29:29: Execution time: 0 ms

terminate with no results

2021-01-06 06:29:29: Execution time: 0 ms

2021-01-06 06:29:29: Pattern exit because Graceful Termination, reason: Sql Queries failed please check the log

verify HD mode

2021-01-06 06:29:29: Execution time: 0 ms

get defined lsnr info win

2021-01-06 06:29:29: Step condition is false. step not executed.

2021-01-06 06:29:29: Execution time: 0 ms

get defined lsnr info Unix

2021-01-06 06:29:29: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:29:30: Command result: /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:29:30: file /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora was served from cache....

2021-01-06 06:29:30: setAttribute(defined_services,[{service=MANDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service=SPSDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service=UHUBDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:29:30: Execution time: 407 ms

get defined lsnr info Unix 2

2021-01-06 06:29:30: Executing SSH command as superuser: ls -1 /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:29:30: Command result: /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora

2021-01-06 06:29:30: file /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora was served from cache....

2021-01-06 06:29:30: Execution time: 375 ms

union tables

2021-01-06 06:29:30: setAttribute(defined_services,[{service=MANDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service=SPSDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {service=UHUBDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:29:30: Execution time: 0 ms

filter info relevant to our service

2021-01-06 06:29:30: setAttribute(defined_services,[{service=MANDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:29:30: Execution time: 0 ms

filter info relevant to our sid

2021-01-06 06:29:30: setAttribute(defined_services,[{service=MANDEV, port=1525, host=XXXX, forEach=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:29:30: Execution time: 0 ms

Verify sid servicename

2021-01-06 06:29:30: setAttribute(sid_update,MANDEV)

2021-01-06 06:29:30: Execution time: 0 ms

update sid

2021-01-06 06:29:30: setAttribute(sid,MANDEV)

2021-01-06 06:29:30: Execution time: 0 ms

get CDB information yes or no

2021-01-06 06:29:30: all commands failed on host: 10.9.9.146. command type: GET_ADDRESS_WIDTH. command track:

WindowsAddressWidthCommand\(NotRelevant),; input:

2021-01-06 06:29:30: Putting file to /tmp/sntmp/Oracle_CDB.sql on 10.9.9.146

2021-01-06 06:29:30: Executing SSH command: mkdir -p /tmp/sntmp

2021-01-06 06:29:30: Command result:

2021-01-06 06:29:30: setAttribute(cdbquery,/tmp/sntmp/Oracle_CDB.sql)

2021-01-06 06:29:30: Execution time: 281 ms

check is CDB Unix

2021-01-06 06:29:30: Executing SSH command: export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1; echo "select CDB from v\$database;" |"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s CONFIG_SCAN_USER/'*****'@XXXX:1525/MANDEV

2021-01-06 06:29:30: Command result:

ERROR:

ORA-12541: TNS:no listener

SP2-0306: Invalid option.

Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]

where <logon> ::= <username>[/<password>][@<connect_identifier>]

<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

2021-01-06 06:29:30: Command failed with status 0

2021-01-06 06:29:30: Executing SSH command: export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1; echo "select CDB from v\$database;" |"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s SERVICENOW_USER/'*****'@XXXX:1525/MANDEV

2021-01-06 06:29:31: Command result:

ERROR:

ORA-12541: TNS:no listener

SP2-0306: Invalid option.

Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]

where <logon> ::= <username>[/<password>][@<connect_identifier>]

<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

2021-01-06 06:29:31: Command failed with status 0

2021-01-06 06:29:31: Execution time: 501 ms

check is CDB Unix with SID

2021-01-06 06:29:31: Step condition is false. step not executed.

2021-01-06 06:29:31: Execution time: 0 ms

check is CDB Windows

2021-01-06 06:29:31: Step condition is false. step not executed.

2021-01-06 06:29:31: Execution time: 0 ms

terminate if not CDB mode

2021-01-06 06:29:31: Execution time: 0 ms

2021-01-06 06:29:31: Pattern exit because Graceful Termination, reason: The Get Oracle PDB info if exit section running for Oracle CDB installations.

run SQL query for Win get catalogs

2021-01-06 06:29:31: Executing SSH command: echo set head off feed off pages 0 line 3000 && echo SELECT table_name || '####' FROM user_tables; |"/oracleSCD1/product/12.2.0.1\bin\sqlplus" -s -L CONFIG_SCAN_USER/'*****'@MANDEV

2021-01-06 06:29:31: Command result: sh: syntax error at line 1: `|' unexpected

2021-01-06 06:29:31: Command failed with status 3

2021-01-06 06:29:31: Executing SSH command: echo set head off feed off pages 0 line 3000 && echo SELECT table_name || '####' FROM user_tables; |"/oracleSCD1/product/12.2.0.1\bin\sqlplus" -s -L SERVICENOW_USER/'*****'@MANDEV

2021-01-06 06:29:31: Command result: sh: syntax error at line 1: `|' unexpected

2021-01-06 06:29:31: Command failed with status 3

2021-01-06 06:29:31: Execution time: 188 ms

run SQL query for Unix get catalogs

2021-01-06 06:29:31: Executing SSH command: export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1; echo "SELECT table_name || '####' FROM user_tables;" |"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s CONFIG_SCAN_USER/'*****'@XXXX:1525/MANDEV

2021-01-06 06:29:31: Command result:

ERROR:

ORA-12541: TNS:no listener

SP2-0306: Invalid option.

Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]

where <logon> ::= <username>[/<password>][@<connect_identifier>]

<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

2021-01-06 06:29:31: Command failed with status 0

2021-01-06 06:29:31: Executing SSH command: export TNS_ADMIN=/oracleSCD1/product/12.2.0.1/network/admin;export ORACLE_HOME=/oracleSCD1/product/12.2.0.1; echo "SELECT table_name || '####' FROM user_tables;" |"/oracleSCD1/product/12.2.0.1/bin/sqlplus" -s SERVICENOW_USER/'*****'@XXXX:1525/MANDEV

2021-01-06 06:29:31: Command result:

ERROR:

ORA-12541: TNS:no listener

SP2-0306: Invalid option.

Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]

where <logon> ::= <username>[/<password>][@<connect_identifier>]

<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

2021-01-06 06:29:31: Command failed with status 0

2021-01-06 06:29:31: Execution time: 469 ms

filter empty rows

2021-01-06 06:29:31: setAttribute(cmdb_ci_db_ora_catalog,[])

2021-01-06 06:29:31: Execution time: 0 ms

remove duplicates

2021-01-06 06:29:31: Step condition is false. step not executed.

2021-01-06 06:29:31: Execution time: 0 ms

set name variable

2021-01-06 06:29:31: setAttribute(cmdb_ci_db_ora_catalog,[])

2021-01-06 06:29:31: Execution time: 0 ms

create rel between schema to instance

2021-01-06 06:29:31: Step condition is false. step not executed.

2021-01-06 06:29:31: Execution time: 0 ms

File Tracking

2021-01-06 06:29:31: No tracked file definitions found for CI Type cmdb_ci_db_ora_pdb_instance

2021-01-06 06:29:31: No tracked file definitions found for CI Type cmdb_ci_db_instance_size

2021-01-06 06:29:31: About to resolve [ CI Type: cmdb_ci_db_ora_instance | CI Data: {tcp_port=1525, install_directory=/oracleSCD1/product/12.2.0.1, pfile=[C"E ?:~ CC"QWMANDEV.__data_transfer_cache_size=0, MANDEV.__db_cache_size=687865856, MANDEV.__inmemory_ext_roarea=0, MANDEV.__inmemory_ext_rwarea=0, MANDEV.__java_pool_size=50331648, MANDEV.__large_pool_size=620756992, MANDEV.__oracle_base='/oracleSCD1'#ORACLE_BASE set from environment, MANDEV.__pga_aggregate_target=1073741824, MANDEV.__sga_target=3221225472, MANDEV.__shared_io_pool_size=134217728, MANDEV.__shared_pool_size=1694498816, MANDEV.__streams_pool_size=0, *.archive_lag_target=900, *.audit_file_dest='CC"/oradiag/MANDEV/adump', *.audit_sys_operations=TRUE, *.audit_syslog_level='LOCAL1.WARNING', *.audit_trail='OS', *.compatible='12.2.0', *.control_files='/oradataSCD1/MANDEV/control01.ctl','/oracleSCD1/product/db_controlfiles/MANDEV/control02.ctl', *.core_dump_dest='/oradiag/MANDEV/cdump', *.db_block_size=8192, *.db_domain='', *.db_name='MANDEV', *

2021-01-06 06:29:31: About to resolve definition concat {

get_attr {"install_directory"}

"/dbs/*.ora"

}

2021-01-06 06:29:31: Resolved expression: /oracleSCD1/product/12.2.0.1/dbs/*.ora

2021-01-06 06:29:31: About to get file names from expression /oracleSCD1/product/12.2.0.1/dbs/*.ora

2021-01-06 06:29:31: Executing SSH command as superuser: ls -1HF /oracleSCD1/product/12.2.0.1/dbs /DuMmY

2021-01-06 06:29:32: Command result:

/DuMmY: No such file or directory

/oracleSCD1/product/12.2.0.1/dbs:

hc_MANDEV.dat

hc_SPSDEV.dat

hc_UHUBDEV.dat

init.ora

initMANDEV.ora

initSPSDEV.ora

initSPSDEV.ora20190905

initUHUBDEV.ora

lkMANDEV

lkSPSDEV

lkUHUBDEV

orapwMANDEV

orapwSPSDEV

snapcf_MANDEV.f

snapcf_SPSDEV.f

snapcf_UHUBDEV.f

spfileMANDEV.ora

spfileSPSDEV.ora

spfileSPSDEV.ora.bak

spfileUHUBDEV.ora

spfileUHUBDEV.ora.bak

spfileUHUBDEV.ora0.bak

spfileUHUBDEV.ora1.bak

spfileUHUBDEV.ora2.bak

spfileUHUBDEV.ora3.bak

tdpoerror.log

2021-01-06 06:29:32: Resolved file paths: [/oracleSCD1/product/12.2.0.1/dbs/init.ora, /oracleSCD1/product/12.2.0.1/dbs/initMANDEV.ora, /oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora, /oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora, /oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora, /oracleSCD1/product/12.2.0.1/dbs/spfileSPSDEV.ora, /oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora]

2021-01-06 06:29:32: About to resolve definition concat {

get_attr {"install_directory"}

"/network/admin/*.ora"

}

2021-01-06 06:29:32: Resolved expression: /oracleSCD1/product/12.2.0.1/network/admin/*.ora

2021-01-06 06:29:32: About to get file names from expression /oracleSCD1/product/12.2.0.1/network/admin/*.ora

2021-01-06 06:29:32: Executing SSH command as superuser: ls -1HF /oracleSCD1/product/12.2.0.1/network/admin /DuMmY

2021-01-06 06:29:32: Command result:

/DuMmY: No such file or directory

/oracleSCD1/product/12.2.0.1/network/admin:

ldap.ora

listener.ora

listener.ora.090419

listener.ora20190905

listener.ora20190911

listener.ora20201217

samples/

shrept.lst

sqlnet.ora

sqlnet.ora20200902

tnsnames.ora

2021-01-06 06:29:32: Resolved file paths: [/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora, /oracleSCD1/product/12.2.0.1/network/admin/listener.ora, /oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora, /oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora]

2021-01-06 06:29:32: Tracked file resolution: [ CI Type: cmdb_ci_db_ora_instance | CI Data: {tcp_port=1525, install_directory=/oracleSCD1/product/12.2.0.1, pfile=[C"E ?:~ CC"QWMANDEV.__data_transfer_cache_size=0, MANDEV.__db_cache_size=687865856, MANDEV.__inmemory_ext_roarea=0, MANDEV.__inmemory_ext_rwarea=0, MANDEV.__java_pool_size=50331648, MANDEV.__large_pool_size=620756992, MANDEV.__oracle_base='/oracleSCD1'#ORACLE_BASE set from environment, MANDEV.__pga_aggregate_target=1073741824, MANDEV.__sga_target=3221225472, MANDEV.__shared_io_pool_size=134217728, MANDEV.__shared_pool_size=1694498816, MANDEV.__streams_pool_size=0, *.archive_lag_target=900, *.audit_file_dest='CC"/oradiag/MANDEV/adump', *.audit_sys_operations=TRUE, *.audit_syslog_level='LOCAL1.WARNING', *.audit_trail='OS', *.compatible='12.2.0', *.control_files='/oradataSCD1/MANDEV/control01.ctl','/oracleSCD1/product/db_controlfiles/MANDEV/control02.ctl', *.core_dump_dest='/oradiag/MANDEV/cdump', *.db_block_size=8192, *.db_domain='', *.db_name='MA

2021-01-06 06:29:32: Retrieving tracked files for the following resolution: [[ CI Type: cmdb_ci_db_ora_instance | CI Data: {tcp_port=1525, install_directory=/oracleSCD1/product/12.2.0.1, pfile=[C"E ?:~ CC"QWMANDEV.__data_transfer_cache_size=0, MANDEV.__db_cache_size=687865856, MANDEV.__inmemory_ext_roarea=0, MANDEV.__inmemory_ext_rwarea=0, MANDEV.__java_pool_size=50331648, MANDEV.__large_pool_size=620756992, MANDEV.__oracle_base='/oracleSCD1'#ORACLE_BASE set from environment, MANDEV.__pga_aggregate_target=1073741824, MANDEV.__sga_target=3221225472, MANDEV.__shared_io_pool_size=134217728, MANDEV.__shared_pool_size=1694498816, MANDEV.__streams_pool_size=0, *.archive_lag_target=900, *.audit_file_dest='CC"/oradiag/MANDEV/adump', *.audit_sys_operations=TRUE, *.audit_syslog_level='LOCAL1.WARNING', *.audit_trail='OS', *.compatible='12.2.0', *.control_files='/oradataSCD1/MANDEV/control01.ctl','/oracleSCD1/product/db_controlfiles/MANDEV/control02.ctl', *.core_dump_dest='/oradiag/MANDEV/cdump', *.db_block_size=8192

2021-01-06 06:29:32: Retrieving files for [ CI Type: cmdb_ci_db_ora_instance | CI Data: {tcp_port=1525, install_directory=/oracleSCD1/product/12.2.0.1, pfile=[C"E ?:~ CC"QWMANDEV.__data_transfer_cache_size=0, MANDEV.__db_cache_size=687865856, MANDEV.__inmemory_ext_roarea=0, MANDEV.__inmemory_ext_rwarea=0, MANDEV.__java_pool_size=50331648, MANDEV.__large_pool_size=620756992, MANDEV.__oracle_base='/oracleSCD1'#ORACLE_BASE set from environment, MANDEV.__pga_aggregate_target=1073741824, MANDEV.__sga_target=3221225472, MANDEV.__shared_io_pool_size=134217728, MANDEV.__shared_pool_size=1694498816, MANDEV.__streams_pool_size=0, *.archive_lag_target=900, *.audit_file_dest='CC"/oradiag/MANDEV/adump', *.audit_sys_operations=TRUE, *.audit_syslog_level='LOCAL1.WARNING', *.audit_trail='OS', *.compatible='12.2.0', *.control_files='/oradataSCD1/MANDEV/control01.ctl','/oracleSCD1/product/db_controlfiles/MANDEV/control02.ctl', *.core_dump_dest='/oradiag/MANDEV/cdump', *.db_block_size=8192, *.db_domain='', *.db_name='MANDEV

2021-01-06 06:29:32: setAttribute(cmdb_ci_db_ora_instance,[{tcp_port=1525, install_directory=/oracleSCD1/product/12.2.0.1, pfile=[C"E ?:~ CC"QWMANDEV.__data_transfer_cache_size=0, MANDEV.__db_cache_size=687865856, MANDEV.__inmemory_ext_roarea=0, MANDEV.__inmemory_ext_rwarea=0, MANDEV.__java_pool_size=50331648, MANDEV.__large_pool_size=620756992, MANDEV.__oracle_base='/oracleSCD1'#ORACLE_BASE set from environment, MANDEV.__pga_aggregate_target=1073741824, MANDEV.__sga_target=3221225472, MANDEV.__shared_io_pool_size=134217728, MANDEV.__shared_pool_size=1694498816, MANDEV.__streams_pool_size=0, *.archive_lag_target=900, *.audit_file_dest='CC"/oradiag/MANDEV/adump', *.audit_sys_operations=TRUE, *.audit_syslog_level='LOCAL1.WARNING', *.audit_trail='OS', *.compatible='12.2.0', *.control_files='/oradataSCD1/MANDEV/control01.ctl','/oracleSCD1/product/db_controlfiles/MANDEV/control02.ctl', *.core_dump_dest='/oradiag/MANDEV/cdump', *.db_block_size=8192, *.db_domain='', *.db_name='MANDEV', *.db_recovery_file_dest_si

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {name=/oracleSCD1/product/12.2.0.1/dbs/initMANDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initMANDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initMANDEV.ora}, {name=/oracleSCD1/product/12.2.0.1/dbs/spfileSPSDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileSPSDEV.ora}])

2021-01-06 06:29:32: Retrieving files with the following properties: [File Path=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora ; File stamp=613a139a7d188976277294cdde79fe697750f8569ce2e33f3d74197e5a3715226b68c077 ; File size=4608 ; File last modified=2021-01-02 17:06:05 ; Save Content=true ;Recent Changes={

"fRecentChanges" : [ {

"timestamp" : 1608449318692

}, {

"timestamp" : 1609055079462

}, {

"timestamp" : 1609658719434

} ]

} ; Tracking Status=1, File Path=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora ; File stamp=c7a32b8ce4e32b179dfc4300ac44ccd38c48eda371c7287bb677d414b1807d1b0a1c0935 ; File size=966 ; File last modified=2020-12-15 11:32:33 ; Save Content=true ;Recent Changes={

"fRecentChanges" : [ {

"timestamp" : 1608449319255

} ]

} ; Tracking Status=1, File Path=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora ; File stamp=c754159e828782e9f107fd1601a37190422c339870e80691b0ae615251288f82c9601925 ; File size=190 ; File last modified=2019-09-04 10:53:

2021-01-06 06:29:32: About to fetch file=File Path=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora ; File stamp=613a139a7d188976277294cdde79fe697750f8569ce2e33f3d74197e5a3715226b68c077 ; File size=4608 ; File last modified=2021-01-02 17:06:05 ; Save Content=true ;Recent Changes={

"fRecentChanges" : [ {

"timestamp" : 1608449318692

}, {

"timestamp" : 1609055079462

}, {

"timestamp" : 1609658719434

} ]

} ; Tracking Status=1

2021-01-06 06:29:32: Executing SSH command as superuser: ls -l "/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora" | grep \^-

2021-01-06 06:29:32: Command result: -rw-r----- 1 orascd dba 4608 Jan 2 17:06 /oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora

2021-01-06 06:29:32: File info: [{owner=orascd, file_path=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora, size=4608, last_modification=1609635965000}]

2021-01-06 06:29:32: File attributes: {owner=orascd, file_path=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora, size=4608, last_modification=1609635965000}

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora, file_size=4608}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileSPSDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora, last_modified=2021-01-02 17:06:05, file_size=4608}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileSPSDEV.ora}])

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, tracking_status=1, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora, last_modified=2021-01-02 17:06:05, file_size=4608}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initMANDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileSPSDEV.ora}])

2021-01-06 06:29:32: file /oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora was served from cache....

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,[{save_content=true, tracking_status=1, name=/oracleSCD1/product/12.2.0.1/dbs/spfileMANDEV.ora, last_modified=2021-01-02 17:06:05, file_size=4608, hash=613a139a7d188976277294cdde79fe697750f8569ce2e33f3d74197e5a3715226b68c077}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/ldap.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initSPSDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/init.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/listener.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/spfileUHUBDEV.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/network/admin/tnsnames.ora}, {save_content=true, name=/oracleSCD1/product/12.2.0.1/dbs/initMANDEV.ora}, {save_content=true, name=/oracleS

2021-01-06 06:29:32: setAttribute(cmdb_ci_config_file_tracked,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:29:32: About to fetch file=File Path=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora ; File stamp=c7a32b8ce4e32b179dfc4300ac44ccd38c48eda371c7287bb677d414b1807d1b0a1c0935 ; File size=966 ; File last modified=2020-12-15 11:32:33 ; Save Content=true ;Recent Changes={

"fRecentChanges" : [ {

"timestamp" : 1608449319255

} ]

} ; Tracking Status=1

2021-01-06 06:29:32: Executing SSH command as superuser: ls -l "/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora" | grep \^-

2021-01-06 06:29:33: Command result: -rw-rw-r-- 1 orascd dba 966 Dec 15 11:32 /oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora

2021-01-06 06:29:33: Executing SSH command: ls -E -L "/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora" | tr -s ' '|cut -d' ' -f6,7

2021-01-06 06:29:33: Command result: 2020-12-15 11:32:33.994365820

2021-01-06 06:29:33: File info: [{owner=orascd, file_path=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora, size=966, last_modification=1608060753000}]

2021-01-06 06:29:33: File attributes: {owner=orascd, file_path=/oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora, size=966, last_modification=1608060753000}

2021-01-06 06:29:33: setAttribute(cmdb_ci_config_file_tracked,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:29:33: setAttribute(cmdb_ci_config_file_tracked,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:29:33: setAttribute(cmdb_ci_config_file_tracked,........)

The max object size reached the maximum limit of [1000]. To adjust this use the mid property mid.sm.discolog.max_object_size.

2021-01-06 06:29:33: file /oracleSCD1/product/12.2.0.1/network/admin/sqlnet.ora was served from cache....