foalabs

How to Install Rar/Unrar in Linux RAR is tool for creating/extracting compressed archive (.rar) files.  Steps to Install on RHEL/Centos # cd /usr/src (Or any other folder) # wget https://www.rarlab.com/rar/rarlinux-x64-5.6.0.tar.gz # tar -zxvf rarlinux-x64-5.6.0.tar.gz # cd rar # sudo cp -v rar unrar /usr/local/bin/ Steps to install on Debian and Ubuntu based distributions $ sudo apt-get install unrar or $ sudo apt install unrar

How to find the current patchset levels for products in Oracle Apps To obtain the current patchset levels for each specific E-Business Suite functional product test the following steps: 1. Log into OAM. (Responsibility System Administrator,"Oracle Applications Manager", menu "OAM Support Cart")  and Navigate: 2. Support Cart --> Applications Signature --> Collect --> Check "Product Information" box --> Click on "View" (eyeglasses) This will display the following patchset information: Application Name Current Patch Level Product Version Status (Installed, Shared Product, Inactive) 3. The patchset level information can be retrieved directly from sqlplus with the following diagnostic script: $AD_TOP/sql/adutconf.sql

Important Queries Related to Undo in Oracle To find retention guarantee for undo tablespace select tablespace_name,status,contents,retention from dba_tablespaces where tablespace_name like '%UNDO%'; To find Undo Space Availability select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB - USAGEMB) FREEMB from (select sum(bytes) / 1024 / 1024 SIZEMB, b.tablespace_name from dba_data_files a, dba_tablespaces b where a.tablespace_name = b.tablespace_name and b.contents = 'UNDO' group by b.tablespace_name) a, (select c.tablespace_name, sum(bytes) / 1024 / 1024 USAGEMB from DBA_UNDO_EXTENTS c where status <> 'EXPIRED' group by c.tablespace_name) b where a.tablespace_name = b.tablespace_name; To show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace select status,   round(sum_bytes / (1024*1024), 0) as MB,   round((sum_bytes / undo_size) * 100, 0) as PERC from (   select status, sum(bytes) sum_bytes   from dba_undo_extents   group by status ), (   select sum(a.b...

ORA-01110: data file has been detected in MO_GLOBAL.INIT in Oracle Apps Error: ORA-01110: data file has been detected in MO_GLOBAL.INIT in Oracle Apps when running the concurrent jobs . Solution: From v$tempfile , Files are there but still I am getting the issue   This issue occurred due to one of temporary tablespace group temp file not there. SQL> select tablespace_name, group_name from DBA_TABLESPACE_GROUPS; 2 3 4 TABLESPACE_NAME GROUP_NAME —————————— —————————— TEMP1 TEMP TEMP2 TEMP select file_name from dba_temp_files where TABLESPACE_NAME=’TEMP2′; no rows selected   Add tempfile to temp2 also SQL> alter tablespace temp2 add tempfile ‘/u01/apps/db/apps_st/data/temp02.dbf’ size 5G autoextend on; Tablespace altered. If you like please follow and comment

Locking and Disabling User Accounts in Linux 1. Locking the user account To lock a user account use the command usermod -L or passwd -l. Both the commands adds an exclamation mark (“!”) in the second field of the file /etc/shadow.It has to be executed by either bob/privilaged user. It will deny any access which would be done directly using su or with ssh. # usermod -L bob or   # passwd -l bob Verify if the user account is locked. Check for the flag *LK* in the below command output which indicates that the account is locked. # passwd --status bob bob *LK* 2020-05-01 0 45 7 -1 (Password set, SHA512 crypt.) Try to Login [himanshu@lcfs ~]$ su - bob Password:  su: Authentication failure But with SSH key still connecting [himanshu@lcfs ~]$ ssh bob@lcfs.lab Welcome to Himanshu's Server Remote Login! Last failed login: Fri May 15 17:52:08 IST 2020 on pts/1 There was 1 failed login attempt since the last successful login. Last login: Fri May 15 17:51:07 2020 from lcfs.lab 2. Expiring t...

Error: oracle.apps.xdo.XDOException: Java heap space in OPP reports Error: EBS R12.1.3  all reports started going into a warning. Logs of opp were showing oracle.apps.xdo.XDOException: Java heap space Solution 1: Restart OPP services Solution 2: 1. Determine what the heap size per OPP process is currently: select DEVELOPER_PARAMETERS from FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP'); 2. The default should be:   J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m 3. Increase the Heap Space per Process to 1024: ( 1024 = If you want to increase the Heap Memory to 1GB)    update FND_CP_SERVICES set DEVELOPER_PARAMETERS = 'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m' where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');   4. Bounce the Concurrent services. If you like please follow and comment

Globbing/Wildcards in Linux Globbing in linux is referred to the use of wildcards. Wildcards, in the Linux file system, allow you to refer to files in a flexible way.  Types of  Wildcards  in Linux 1) * - Star is for everything. Unlimited number of characters.  example: ls * It will give all file names in the current directory, no matter how long they are.  ls a* All files starting with a 2) ? - Question mark is for one single character.  example: ls ? It will give all filesname with single character 3) [] - Square brackets, you can specify a range.  example: ls [a-c] It will search with filenames as a, b, or c. It's a range.  We can combine them with other wildcards as well. example: ls [a-c]* It will show all files names starting with a or b or c. example: ls ?[z-s]* It will show you all files where the second character is a z or an s.  example: ls *? star already covers all characters and if we put anything behind a star, that makes no s...

Installing and Removing Packages in Linux using Yum To install/remove a package in linux using yum we have to use root or privilaged user.Package will install all the dependencies as well. Install package yum install <package name> yum install zip Only Download RPM yum install --downloadonly --downloaddir=/tmp Install from local rpm yum localinstall  <rpm name> Re-install a package yum reinstall <package name> Re-install while skipping a dependencies which is not available in repository yum reinstall  --skip-broken <package name> Upgrade a package yum upgrade <package name> Remove a package It will only remove package and dont remove any dependency yum remove <package name> Remove package and its dependencies yum autoremove <package name>

Understanding Yum in Linux Yum overview RPM knows what its dependencies are, and has the ability to download software from FTP and web servers.  Yum was created by Yellowdog Linux, and has since been adopted by many Red Hat-based distributions including Fedora and CentOS.  Yum resolves dependencies automatically. This means it downloads and installs all software packages necessary.  This includes packages that the user didn't specify, if the chosen package requires them. Y Yum has also the concept of software package groups. A group is a list of software that is usually installed together.  For instance, we could have a web server group that included the web server, and other tools commonly installed with it. Yum repositories contain RPM software packages.  The Yum client maintains a local list of software repositories. Users can add repositories by just adding a new Yum configuration file for them.  The Yum client also maintains a local list of all availab...

Restore the Original Permissions of Files using RPM If in any case the package configuration files permissions or get changed in Linux, we can use rpm to restore the permissions. I have changed the permission manully. [root@lcfs packages]# rpm -qc wget /etc/wgetrc [root@lcfs packages]# ls -ltr /etc/wgetrc -rw-r--r--. 1 root root 4479 May 16  2019 /etc/wgetrc [root@lcfs packages]# chmod 777 /etc/wgetrc [root@lcfs packages]# chown himanshu:himanshu /etc/wgetrc [root@lcfs packages]# ls -ltr /etc/wgetrc -rwxrwxrwx. 1 himanshu himanshu 4479 May 16  2019 /etc/wgetrc Now lets restore original permissions using setperms: [root@lcfs packages]# rpm -setperms wget [root@lcfs packages]# ls -ltr /etc/wgetrc -rw-r--r--. 1 himanshu himanshu 4479 May 16  2019 /etc/wgetrc Also we can restore the original ownership as well using setugids: [root@lcfs packages]# rpm -setugids wget [root@lcfs packages]# ls -ltr /etc/wgetrc -rw-r--r--. 1 ...

Install|Remove|Upgrade|Re-Install|Verify|Validate Packages using RPM in Linux Installing a Package: rpm -ivh rpm -ivh httpd-2.4.6-93.el7.centos.x86_64.rpm Please note if any dependent package is notinstalled it will fail and you have first install the dependent package. Uninstalling a Package: rpm -ev rpm -ev httpd Please note this will not remove any dependent package that was installed as part of the "httpd" installation. Upgrading a Package: rpm -Uvh To find out which package need to be upgraded we will use below command and all the packages mentioned in bold would be eligible for upgrade. yum list installed I ran the command and found below 2 packages. tzdata.noarch                       tzdata-java.noarch  Note: I have already downloaded the rpm. Now we will upgrade packages, it will cleanup old version and install new rpm. [root@lcfs packages]# rp...

Understanding RPM Tags in Linux All rpm package comes with certain tags and can be used for better formatting and fetching the output as required by a Admin or day to day basis. If we wanna see all the tags we can use rpm --querytags Some examples for using these tags are as below 1) Finding only name and version we can use rpm -qa --queryformat "%{NAME} %{VERSION}\n" 2) Make output in better format in above command rpm -qa --queryformat "%-30{NAME} %-10{VERSION}\n" 3) Find file names in a package with better format rpm -ql --queryformat "%{FILENAMES}\n" bash 4) Find file names with size rpm -ql --queryformat "[%{FILENAMES} %{FILESIZES}\n]" zip 5) Find package install date  rpm -q --queryformat "%{NAME} %{INSTALLTIME:date}\n" zip 6) File files in a package and the permissions  rpm -q --queryformat "%{FILEMODES:perms} %{FILENAMES}\n" zip

Understanding and Managing RPM in Linux RPM is a package manager which is used on Linux based OS. It can help in package installation from FTP/HTTP site as well. Few Feature of RPM Install Software Upgrade Software Remove Software Query Package Database Check Package Dependencies Disadvantages: RPM can detect package dependecies but cannot install those during main package installation. For this we use other tools like yum Important queries related to installed packages 1) Check all installed pcakages  rpm -qa 2) List packages in Sorted way  rpm -qa|sort 3) Information about a package installed  rpm -qi zip  Sample Output  [root@lcfs ~]# rpm -qi zip Name        : zip Version     : 3.0 Release     : 11.el7 Architecture: x86_64 Install Date: Thursday 09 April 2020 07:18:33 AM IST Group       : Applications/Archivi...

Oracle Apps Web ADI Error: Web ADI Invalid Integrator Key Error:  Web ADI Invalid Integrator Key Cause: For Specific user level, we have to set the following profile option ' YES ', If user not having System Administrator Responsibility Solution: ' BNE Allow No Security Rule ' as  Yes  at the User level

How to Migrate Web ADI template from one EBS Instance to other EBS instance Following are the components that are associated to the Web ADI that can be migrated from one instance to another: Integrators Layouts Mappings Contents Integrators: Identify the Integrator to migrate as below, select integrator_code, application_short_name   from apps.bne_integrators_vl  bnv       ,apps.fnd_application_vl  fav  where bnv.user_name = &integrator_name    and fav.application_id = bnv.application_id; Download the Integrator: FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct INTEGRATOR_LDTFILE.ldt BNE_INTEGRATORS INTEGRATOR_ASN="appl_short_name" INTEGRATOR_CODE="integrator_name" Upload the Integrator: FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct INTEGRATOR_LDTFILE.ldt Layouts: Identify the Layout to migrate as...