Concurrent Requests

UTL_FILE_DIR 19C Database

Services Create & Start 

SID&UNIX

sid.sql

unix.sql

Restore Point 

Estimate Archive Size:

SELECT SUM_ARCH.DAY,

         SUM_ARCH.GENERATED_GB,

         SUM_ARCH_DEL.DELETED_GB,

         SUM_ARCH.GENERATED_GB - SUM_ARCH_DEL.DELETED_GB "REMAINING_GB"

    FROM (  SELECT TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY') DAY,

                   SUM (ROUND ( (blocks * block_size) / (1024 * 1024 * 1024), 2))

                      GENERATED_GB

              FROM V$ARCHIVED_LOG

             WHERE ARCHIVED = 'YES'

          GROUP BY TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY')) SUM_ARCH,

         (  SELECT TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY') DAY,

                   SUM (ROUND ( (blocks * block_size) / (1024 * 1024 * 1024), 2))

                      DELETED_GB

              FROM V$ARCHIVED_LOG

             WHERE ARCHIVED = 'YES' AND DELETED = 'YES'

          GROUP BY TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY')) SUM_ARCH_DEL

   WHERE SUM_ARCH.DAY = SUM_ARCH_DEL.DAY(+)

ORDER BY TO_DATE (DAY, 'DD/MM/YYYY'); 

Show parameter reco;

Show parameter dest_1;

alter system set db_recovery_file_dest='/prodarch/oradata/nadhans/' scope=both;

create restore point BEFORE_PATCHING guarantee flashback database;

select * from v$restore_point;

Drop Restore Point :

drop restore point BEFORE_PATCHING;

Decrypt Weblogic Password

Step 1:

cd  $EBS_DOMAIN_HOME/security

vi decrypt_password.py 

from weblogic.security.internal import *

from weblogic.security.internal.encryption import *

encryptionService = SerializedSystemIni.getEncryptionService(".")

clearOrEncryptService = ClearOrEncryptedService(encryptionService)

# Take encrypt password from user

pwd = raw_input("Paste encrypted password ({AES}fk9EK...): ")

# Delete unnecessary escape characters

preppwd = pwd.replace("\\", "")

# Display password

print "Decrypted string is: " + clearOrEncryptService.decrypt(preppwd)

Step2: 

Source wls environment file:

. $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh

STEP 3:

[applmgr@testenv security]$ java weblogic.WLST decrypt_password.py

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Paste encrypted password ({AES}fk9EK...): {AES}PVXB/uhJyeFDjoJmFqZHg8k+vW6/hACDcP6KugEmGX4=

Decrypted string is: *******

Invalid Objects 

find . -name "*.req" -mtime +30 -exec rm {} \; &

select count(*) from dba_objects where status='INVALID';

select comp_id,status from dba_registry;

exec sys.utl_recomp.recomp_parallel(10);

select object_name, object_type, owner, LAST_DDL_TIME,status  from dba_objects where status = 'INVALID' and object_name||owner not in (select object_name||owner from invalid_Objects_10DEC22);

select object_name, object_type, owner, LAST_DDL_TIME,status  from dba_objects where status = 'INVALID' and object_name||owner not in (select object_name||owner from 31AUG2022);

select object_name, object_type, owner, LAST_DDL_TIME,status  from dba_objects where status = 'INVALID' and object_name||owner not in (select object_name||owner from invalid_Objects_JUL_2021);

col OBJECT_NAME for a30

col OWNER for a20

select BUG_NUMBER,BUG_ID,CREATION_DATE,LANGUAGE,CREATED_BY from ad_bugs where BUG_NUMBER in ('33128953','33372456');

select BUG_NUMBER,BUG_ID,CREATION_DATE,LANGUAGE,CREATED_BY from apps.ad_bugs where BUG_NUMBER='&a';

select BUG_NUMBER,BUG_ID,CREATION_DATE,LANGUAGE,CREATED_BY from ad_bugs where BUG_NUMBER in('33782739','33623398');,'30735865','31904550');,'28969483','29143795','30144049','31006617','31165250','30868356');

select BUG_NUMBER,BUG_ID,CREATION_DATE,LANGUAGE,CREATED_BY from ad_bugs where BUG_NUMBER in ('30628681','30735865')';,'32181474','32266274','32433768')

select OBJECT_NAME,OWNER,OBJECT_TYPE,LAST_DDL_TIME,STATUS from dba_objects where OBJECT_NAME in ('XXPMRY_AP_SELF_ASSESS_TAX_REV','@AP_CUSTOM_INV_VALIDATION_PKG')l,'XXNHR_NTM_TXN_PKG','XXNHR_SUBINV_TRANSFER_PKG','NHR_APPLY_HOLD');

select object_name,object_type,owner,LAST_DDL_TIME,status from dba_objects where status = 'INVALID'

select * from AD_BUGS where bug_number='30273541';

 create table dba_objects_B4 as select * from dba_objects where status='INVALID';

select BUG_NUMBER,BUG_ID,CREATION_DATE,LANGUAGE,CREATED_BY from ad_bugs where BUG_NUMBER in ('33782739','33168635','33625264')','30144049','30144066','30868356','31006617','31165250')

select BUG_NUMBER,BUG_ID,CREATION_DATE,LANGUAGE,CREATED_BY from ad_bugs where BUG_NUMBER in ('32438203','28840844','32840432','32460404','31206584');   ','32117360','30980446','32004048','32636526');

select name,open_mode,log_mode,database_role,dbid from v$database;

set lines 200 pages 200

col OBJECT_NAME for a30

col OWNER for a20

select OBJECT_NAME,OWNER,OBJECT_TYPE,LAST_DDL_TIME,STATUS from dba_objects where OBJECT_NAME='CFZ_REP_COMMON_PKG';

select BUG_NUMBER,BUG_ID,CREATION_DATE,LANGUAGE,CREATED_BY from ad_bugs where BUG_NUMBER in('32071646','32117360','32004048');,'31667105');,'28969483','29143795','30144049','31006617','31165250','30868356');

find . -name "*.log" -mtime +10 -exec rm  {} \;

 find . -type f -name "file to delete" -exec rm -f {} ;

 find . -name "*.trc" -mtime +7 -type f -exec mv "{}" /shared/tracefiles_23_Aug_21/ \; &

SELECT owner, index_name, tablespace_name

FROM   dba_indexes

WHERE  status = 'UNUSABLE';

ls -lShr | tail -30

select object_name from dba_objects where status like 'INVALID' minus select object_name from dba_objects_backup;

After Upgrading Database to 19c Running AutoConfig on Database Tier Ends in "ORA-01034: ORACLE not available" and "ORA-27101: shared memory realm does not exist" Error (Doc ID 2748893.1) To BottomTo Bottom  

PROD_INVALIDS:

 select object_name, object_type, owner, LAST_DDL_TIME,status  from dba_objects where status = 'INVALID' and object_name||owner not in (select object_name||owner from dba_objectsbkpsep15);

SELECT DISTINCT sql_id, plan_hash_value

FROM dba_hist_sqlstat dhs,

(

SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap, MAX(snap_id) max_snap

FROM dba_hist_snapshot ss

WHERE ss.begin_interval_time BETWEEN (SYSDATE - &No_Days) AND SYSDATE

) s

WHERE dhs.snap_id BETWEEN s.min_snap AND s.max_snap

  AND dhs.sql_id IN ( '&SQLID')

30433124,31349591,31349591_ESA:u31349591.drv,31349591_PTB:u31349591.drv,31800803,33346385,28732161,28732161_PTB:u28732161.drv,28732161_ESA:u28732161.drv,31088182,31088182_PTB:u31088182.drv,31088182_ESA:u31088182.drv

select BUG_NUMBER,BUG_ID,CREATION_DATE,LANGUAGE,CREATED_BY from ad_bugs where BUG_NUMBER in ('25452805','26052406','26521736','30433124','31349591','31800803','33346385','28732161','31088182')

USER DDL

Package Body

Package Specification

Tuning Advisor

View Backup