foalabs

Linux Commands | Sort | Uniq If you like please follow and comment

How to Create Bootable USB in Linux | Fedora bootable USB creation|UNetBootin 1) Download UNetbootin 2) Open  https://unetbootin.github.io/ 3) Download for Ubuntu sudo add-apt-repository ppa:gezakovacs/ppa sudo apt-get update sudo apt-get install unetbootin   If you like please follow and comment

Linux Commands |Pipe Operator If you like please follow and subscribe

File Read Write related Linux Commands| touch|echo|cat|tac|more|less|head|tail If you like please follow and comment

Linux Commands History | Easy Tips If you like please follow and comment

Linux Commands Part-3 | ls command If you like please follow and comment

Migrating  ASM file between diskgroups In this post, I am going to share how to move datafile between disk group.  Steps: 1) Fetch the data file name. Or we can get it for respective tablespace name. select    file_name from    dba_data_files;         select    file_name from    dba_data_files where tablespace_name='APP_DATA'; 2)  Note down the target diskgroup name. select    name from    v$asm_diskgroup; 3)  Take the old data file offline from sqlplus '/as sysdba' SQL> alter database datafile '+PROD_OLD/SID/app_data.718' offline; 4)  Copy the datafile to the new diskgroup (using RMAN) $ rman target / connected to target database PROD (DBID=3673298366) RMAN> copy datafile '+PROD_OLD/SID/app_data.718' to '+PROD_NEW'; 6) Find the new filename from asmcmd in +PROD_NEW diskgroup and SID/datafiles folder 7) Re-name the data file using sqlplus '/as sysdba' SQL> alter database ren...

Sharing My Approach to write a Shell Script|First Shell Script If you like please like and follow

My Preferences for Network Adapters in Virtual Box| Bridged|Host Only Adapters If you like please follow and comment

Understanding and Installing  Guest Addition in Virtual Box On RHEL/Centos before running below step yum -y install epel-release Run below on OEL/RHEL/Centos yum install kernel-uek-devel-$(uname -r) If you like please follow and comment.

Linux Understanding Absolute Relative Path If you like please follow and subscribe

Linux Basics Commands Part 2 | su|mkdir|rmdir|rm|cd If you like please like and follow

SQL query to search for Discoverer folders and items Find out which EUL There are multiple EUL owners so we need to determine which one. The following query shows us all the available EUL owners select owner from dba_tables where table_name = 'EUL5_OBJS'; For the current case, we are going to use the owner as 'EUL_US' SQL to search for Discoverer folders and items select i.exp_name item_name ,f.obj_name folder_name ,b.ba_name from EUL_US.EUL5_expressions i , EUL_US.EUL5_objs f , EUL_US.EUL5_ba_obj_links l , EUL_US.EUL5_bas b where f.obj_id= i.it_obj_id and f.obj_id= l.bol_obj_id and b.ba_id= l.bol_ba_id and upper(i.exp_name) like upper('%') --folder item and upper(b.ba_name) like upper('%')                     --business area and upper(f.obj_name) like upper('%)                     --folder order by b.ba_name,f.obj_name,i.exp_name If you like please follow and comment

Linux Basics Command to Work on any Linux Environment If you like please share and comment

How to check Total VDI size and the Actual Utilised size If you like please follow and comment

How to Use XCLIP in Linux for clipboard xclip  reads  text  from standard in or files and makes it available to other X applications for pasting as an X selection (traditionally with the middle mouse button). It reads from all files specified, or from  standard  in if no files are specified. xclip can also print the contents of a selection to standard out with the -o option. xclip  was designed to allow tighter integration of X applications and command line programs. The default action  is to silently wait in the background for X selection requests (pastes) until another X application places  data in  the clipboard, at which point xclip exits silently. You can use the -verbose option to see if and when xclip actually receives selection requests from other X applications. Install Xclip  in Linux Xclip program are available in the official repositories of most modern Linux distributions. On RHEL, CentOS: $ sudo dnf install epel-release $ s...

Export Import an Appliance In Oracle Virtual Box If you like please follow and comment

HTML redirect visitor from one URL to another URL automatically If we want to redirect a URL to a different URL we can use an HTTP redirect. Sample Syntax <meta http-equiv="refresh" content="time; URL=new_url" /> time represents the delay before the browser redirects the user to a different page. Define it in seconds, or enter a 0 if you need an immediate HTML redirect. new_url represents the URL address you need to redirect your user to after the delay. Let say I have an index.html and want to redirect it to a different page. We can use below sample code. <html> <head>   <meta http-equiv="refresh" content="10; URL=https://erp.funoracleapps.com/" /> </head> <body>   <h2>This URL is obselete,Please save the new URL in your favourites.   <p>You will be automatically redirected to new Dashbaord URL,If you are not redirected in ten seconds, <a href="https://erpfunoracleapps.com/">click ...

How to Download the Certificate used for jar signing from adkeystore If we want to download the certificate from adkeystore which was used for jar signing the keytool can be used for that. Steps: Note : You should know the keystore password. By default it is "puneet" 1)  Go to the location where the Keystore file is placed cd $APPL_TOP/admin 2) Check the list in the keystore keytool -list -keystore adkeystore.dat This will show you the output with various alias. 3) The key alias which is used for jar signing can be confirmed from the below file adsign.txt 4) Based on the alias download the required certificate. keytool -export -alias xyz_erp -keystore adkeystore.dat  -rfc -file jre_cert_may18.cert This creates the  jre_cert_may18.cert  file that contains a certificate signed with the private key in the  adkeystore.dat  . If you like please follow and comment

Install OpenBoard on Elementary OS From root user run below commands Enable snapd Snap can be installed on elementary OS from the command line. Open Terminal and type the following: sudo apt update sudo apt install snapd Restart the system Install OpenBoard To install OpenBoard, simply use the following command: sudo snap install openboard Restart the system If you like please follow and comment

Script to Monitor the Memory Usage on Server We can also schedule the script via cron to get regular notifications. This script is tested in OEL/RHEL/Centos. Script: TOT=`cat /proc/meminfo | grep MemTotal: | awk '{print $2}'` USED=`cat /proc/meminfo | grep Active: | awk '{print $2}'` HOSTNAME=`hostname -s` FREE=$[$TOT - $USED ] LOG=/tmp/mem_monitor.log echo > $LOG SEND=0 if [ "$USED" -gt "0" ]; then    USEDPERC=$[$USED * 100 / $TOT]    echo "Used Percentage      : $USEDPERC %"    TOTMB=$[$TOT / 1024 ]    USEDMB=$[$USED / 1024 ]    FREEMB=$[$TOTMB - $USEDMB ]    if [ "$USEDPERC" -gt "80" ]; then      SEND=1      STATUS="Warning"      echo "------------------------------------------------------------------" >> $LOG      echo `hostname`   >> $LOG      echo "-------------------------------------------------------------...

How to Download Oracle Enterprise Linux(OEL) You can also download from below links https://yum.oracle.com/oracle-linux-isos.html If you like please follow and comment

How to show app indicators on the system tray in elementary OS Linux Elementary OS Juno 5 doesn’t show app indicators in the system tray, How to enable this 1) First we need to enable ppa support in elementary OS, so open the Terminal, type the following command, and hit Enter: sudo apt install software-properties-common 2) Now we have to add a ppa, so type the following command, and hit Enter: sudo add-apt-repository ppa:yunnxx/elementary 3) Now update your system by typing the following command: sudo apt update 4) Now install the app indicator functionality, by typing the following command: sudo apt install indicator-application wingpanel-indicator-ayatana 5) Now we need to edit the file /etc/xdg/autostart/indicator-application.desktop. Type the following command to go to the autostart folder: cd /etc/xdg/autostart/ 6) Type the following command to edit the file: sudo vi indicator-application.desktop 7) Look for the line with the following content: OnlyShowIn=Unity;GNOME; 8) Add “Pan...

How to Manually Deploy the OEM agent on Server EMCLI Pre-Requisites: The Registration password should be created or enabled. Please refer below link on Registration_password. https://www.funoracleapps.com/2021/05/how-to-setup-agentregistrationpassword.html   OEM agent Manual deployment steps:   The Enterprise Manager Command Line Interface (EM CLI) enables users to access Enterprise Manager functionality through a command-line interface or scripts. It is accessible through classic programming language constructs, enabling tasks to be created and run either from the command-line or programmatically. EM CLI enables you to access Enterprise Manager Cloud Control functionality from text-based consoles (shells and command-line windows). EM CLI provides two installable kits - EM CLI Standard and EM CLI with Scripting mode. Both can be installed on any system within your managed network. We have to setup EMCLI first. The steps can also be seen from EM console. ...

How to setup AGENT_REGISTRATION_PASSWORD in OEM 12c/13c Registration Passwords are used by the Administrators to secure Oracle Management Agents against any OMS that uses this repository. Registration Passwords can be either Persistent or One-time. Persistent Registration Passwords can be used to register multiple agents whereas One-time passwords can only be used once after which they are deleted automatically from the repository. When defining any Registration Password, it is required to specify an expiry date after which the Registration Password will be invalidated. Steps: Setup –> security –> registration passwords –> create Fulfill the areas, and then the password has created. Persistent or One-time: ‘Persistent’ can be used for multiple agents. ‘One-time’ will be deleted once an agent uses it for registration. The expiry date for the password can be provided to make sure it is not open every time. We can also set the registration password from the command line. Go to th...

How to Download a specific version of the RPM package  along with its dependencies Use the –showduplicates to see all the installed packages and the available packages # yum --showduplicates list [package_name] root@funoel7:~# yum --showduplicates list httpd Loaded plugins: langpacks, ulninfo Installed Packages httpd.x86_64                                          2.4.6-45.0.1.el7_3.4                                           @ol7_latest Available Packages httpd.x86_64                                          2.4.6-80.0.1.el7                                        ...

How To Audit  and Monitor An Oracle Applications User in R12 Sign-On:Audit Level allows you to select a level at which to audit users who sign on to Oracle Applications and monitor. Overview: Users Activity in Oracle E-Business Suite can be monitored online (using a given form) or via reports available in the system administration responsibility. The online monitoring of user activity within Oracle Applications is achieved via the Monitor Users form (Form Name: FNDSCMON.fmx). In order to use this form and also to use the reports the profile option Sign-On: Audit Level must be set to an appropriate value. The available options are: -  • NONE: No monitoring performed on users’ activity. • USER: Only show a list of logged-in users. • RESPONSIBILITY: Will show the users logged in and the responsibility they are using. • FORM: show the most detailed level, it will show the User, Responsibility, and Form being accessed. The general overview of the process of monitoring user ...