Ameer Khan

·       Command to create bucket Syntax: oci os bucket create –compartment-id <compartment id> –name <bucket name> Example: oci os bucket create –compartment-id ocid1.compartment.oc1..aaaaaaaacgen54z6eyimw7pnp4a553425kifsq –name TESTBUCKET ·       Command to delete bucket Syntax : oci os bucket delete –name <Bucket name> Example : oci os bucket delete –name TESTBUCKET ·       Command to list out all the objects inside a bucket… Continue Reading

We can use following query to get AD and TXK code level in EBS environment SQL>col ABBREVIATION for a20 SQL>set lines 300 SQL>col NAME for a40 SQL>col CODELEVEL for a20  SQL> SELECT ABBREVIATION,NAME,codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in (‘txk’,’ad’); ABBREVIATION         NAME                                     CODELEVEL ——————– —————————————- ——————– ad                   Applications DBA                     … Continue Reading

This script will run on standby database. It will basically check for  applied archives on standby database and it will keep last 100’s number of archives present and will delete rest of the archives that have been already applied. I have personally tested this script on my environment which is running on RHEL 7 and… Continue Reading

 Environment Details Hostname ebstest.wizer.com Database Version 12.1.0.2 E Business Suite Version R 12.2 OS OEL 7.7 R12 install base /u01/oracle/VIS Important:- Before changing the password for APPS, APPLSYS and APPS_NE the following tables should be backed up . 1. FND_USER 2. FND_ORACLE_USERID Step 1. Take backup SQL> create table FND_USER_291220 as select * from FND_USER… Continue Reading

Sometimes we land in a situation where we don’t have the weblogic url handly. So in this post I will show to find it just by extracting some parameters from the application  context file Go to application tier and invoke application run file system environment file [oracle@ebstest ]$cd /u01/oracle/VIS/fs1/EBSapps/appl [oracle@ebstest appl]$ . APPSVIS_ebstest.env [oracle@ebstest appl]$… Continue Reading

Environment details:- Hostname gg1.soumya.com Server IP 192.168.0.110 DB Version 19.3.0 Container DB SID TESTCDB PDB1 SID TESTPDB1 PDB2 SID TESTPDB2 ORACLE_HOME /u01/app/oracle/product/19.0.0/dbhome_1 vi $ORACLE_HOME/network/admin/listener.ora LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = gg1.soumya.com)(PORT = 1521))       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))     )   ) SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (GLOBAL_DBNAME… Continue Reading

Using this SQL Query we can find out number archive log generated per hour in last 30 days.. I used in where clause  “sysdate – 30” to find out the result of last 30 days. You can change the number of days as per your requirement.  set echo off; set pages 10000 set sqlbl on;… Continue Reading

Database Security Assessment Tool aka DBSAT is a free tool that basically scan your database and find out security loop holes and it also gives recommendation to mitigate those loop holes. DBSAT automatically collects information and displays it as HTML,Excel,Json or text format. How to Download:-   MOS Note:2138254.1 – Oracle Database Security Assessment Tool (DBSAT) You… Continue Reading

 In this topic I have explained the purpose of various script that we use for E business suite R12 instance Script Name Details addbctl.sh This script basically calls adstrtdb.sql to start the DB  or adstopdb.sql to stop the databaseExample:-To start DB :- sh addbctl.sh startTo Stop DB :-sh addbctl.sh stop normal | immediate|abortScript location :- $ORACLE_HOME/appsutil/script/<$CONTEXT_NAME> addlnctl.sh This… Continue Reading

Download Links:- V38500-01_1of2.zip – https://bit.ly/3492ynq V38500-01_2of2.zip –  https://bit.ly/37YIYMO Continue Reading