Tablespace

select df.tablespace_name "Tablespace",

totalusedspace "Used MB",

(df.totalspace - tu.totalusedspace) "Free MB",

df.totalspace "Total MB",

round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))

"Pct. Free"

from

(select tablespace_name,

round(sum(bytes) / 1048576) TotalSpace

from dba_data_files

group by tablespace_name) df,

(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name

from dba_segments

group by tablespace_name) tu

where df.tablespace_name = tu.tablespace_name ;

alter tablespace SOAPRD_SOAINFRA add datafile size 2G autoextend on maxsize 20G;

alter tablespace SOADE3_STB add datafile size 2G autoextend on maxsize 20G;

G-Invoicing - ECC

 

Installing Oracle Enterprise Command Center Framework, Release 12.2 (Latest Version) (Doc ID 2495053.1) Installing Oracle Enterprise Command Center Framework, Release 12.2 V12 (Doc ID 3017956.1)

G-Invoice:  G-Invoicing ECC Patch (Patch - 36861505, 36236796, 36393109, 35921608, 35921575, 36032737, 35921481, 35302496) - ECC Upgrade to V12

Sequence below

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

36236796

36393109

35921608

35921575

36032737

35921481

35302496

36861505

 July CU ECC Patch - 36861505
 July CU Servicing Patch - 36866950

• grep -i ecc_ $CONTEXT_FILE
• 
  
• To start and Stop ECC
• /dRAM4ei/applmgr/Oracle/quickInstall/bin/startAllEcc.sh
• /dRAM4ei/applmgr/Oracle/quickInstall/bin/stopAllEcc.sh
• 
  
• more $ECC_BASE/Oracle/quickInstall/env/ecc.env|grep -i ebs
• 
  
• more $ECC_BASE/Oracle/quickInstall/env/ecc.env|grep -i ebs
• 
  
• ps -fu $LOGNAME
• 
  
• IT:
• 
  
• [oracle@lufRAMfebsdl613 app]$ sqlplus ecc/INT_3CCCLE_SIT3M@\"$ECC_DB_CONNECTION\"
• 
  
• $ pwd
• /dRAM4ei/applmgr/Oracle/software/zookeeper/bin
• $ ls -ltr
• total 31
• -rwx------. 1 apdRAM4ei aadRAM4ei 1385 Mar  1  2022 zkTxnLogToolkit.sh
• -rwx------. 1 apdRAM4ei aadRAM4ei 6773 Mar  1  2022 zkServer.sh
• -rwx------. 1 apdRAM4ei aadRAM4ei 2696 Mar  1  2022 zkEnv.sh
• -rwx------. 1 apdRAM4ei aadRAM4ei 1534 Mar  1  2022 zkCli.sh
• -rwx------. 1 apdRAM4ei aadRAM4ei 1937 Mar  1  2022 zkCleanup.sh
• -rwx------. 1 apdRAM4ei aadRAM4ei  232 Mar  1  2022 README.txta

Audit Queries

 Audit:

select aud.audit_user_name UPDATED_BY, aud.audit_timestamp UPDATE_DATE, 
    (select distinct user_concurrent_program_name from APPS.FND_CONCURRENT_PROGRAMS_VL where aud.concurrent_program_id = CONCURRENT_PROGRAM_ID and last_update_date > to_date('10/01/2021','MM/DD/YYYY')) as program_name,
    decode(aud.audit_transaction_type,'U','(~) Update','I','(+) Insertion','D','(-) Deletion') as audit_type,
    (select application_name from apps.fnd_application_vl where application_id = aud.application_id) as program_app,
    aud.concurrent_program_name, aud.executable_application_id, aud.executable_id, aud.request_set_flag,
    aud.enabled_flag, aud.run_alone_flag, aud.queue_control_flag, aud.argument_method_code, aud.queue_method_code, aud.execution_method_code, aud.execution_options, aud.output_print_style, aud.print_flag,
    aud.srs_flag, aud.required_style, aud.save_output_flag, aud.printer_name, aud.minimum_width, aud.minimum_length, aud.request_priority, aud.iprog_id, aud.restart, aud.nls_compliant, aud.output_file_type, aud.enable_trace,
    aud.cd_parameter, aud.increment_proc, aud.mls_executable_app_id, aud.mls_executable_id, aud.enable_time_statistics, aud.security_group_id, aud.activity_summarizer, aud.program_type
from apps.FND_CONCURRENT_PROGRAMS_A aud
where audit_timestamp >= to_date('10/01/2023','MM/DD/YYYY')
    and audit_user_name not in ('APPS','SYSADMIN','ANONYMOUS','APPSMGR','HHSOPERATOR','UPA_SOLUTION','ORACLE12.2.0','CONCURRENT MANAGER')
order by aud.audit_timestamp;