foalabs

How to use SSH Keys With PuTTY On Windows and Connect Linux Server The SSH key pair establishes trust between the client and server, thereby removing the need for a password during authentication. The PuTTY SSH client for Microsoft Windows does not share the same key format as the OpenSSH client. Therefore, it is necessary to create a new SSH public and private key using the PuTTYgen tool or convert an existing OpenSSH private key. Steps: 1) Install PuTTY And PuTTYgen Download from https://putty.org/ 2) Open PuTTYgen in the Windows  Create New Public And Private Keys Under Parameters, increase the Number of bits in a generated key: to a minimum value of 2048. Under Actions / Generate a public/private key pair, click Generate. You will be instructed to move the mouse cursor around within the PuTTY Key Generator window as a randomizer to generate the private key. Once the key information appears, click Save private key under Actions / Save the generated key. Also Save the public key ...

Script to Rebuild an Index in a Schema in Oracle Database Script: SET PAGESIZE 0 SET LINESIZE 100 SET FEEDBACK OFF SET VERIFY OFF spool index_rebuild_script.sql select 'alter index '||owner||'.'||index_name ||' rebuild online parallel 4 nologging;' from dba_indexes where owner=upper('USERS'); spool off If you like please follow and comment

Azure Learning |Implementing ​ORACLE EBS R12.2.0​ on ​Microsoft Azure Infrastructure |Part 2 If you like please follow and comment

Azure Learning | Implementing ​ORACLE EBS R12.2.0​ on ​Microsoft Azure Infrastructure Part 1 if you like please follow and comment

Install VNC server on Azure Linux VM(RHEL/OEL/CENTOS) with Demo Video In this post I am going to share how to install vnc server on a Azure VM having Linux OS(RHEL/Centos/OEL). This can be performed on on-premises Linux servers as well. Steps: All steps I have performed using root user. 1) Install the required RPMS yum install tigervnc-server yum install xterm yum install xclock 2)Install the GUI Graphic mode in Linux by default its not installed. It will take 15-20 minutes (optional only) yum -y group install GNOME base-x 3)Set the Password for VNC for current User. $ vncpasswd Example: [root@myebs1 ~]$ vncpasswd Password: Verify: Would you like to enter a view-only password (y/n)? n A view-only password is not used [root@myebs1 ~]$ 4) Enable the firewall for the 5901 ports. firewall-cmd --permanent --add-port=5901/tcp firewall-cmd --reload Example: [root@myebs1 ~]$ firewall-cmd --permanent --add-port=5901/tcp success [root@myebs1 ~]$ firewall-cmd --reload success 5) Start the VNCSERV...

Add Swap Space to in your Azure  Linux Machine Instance By default in Azure if you check the the swap would be 0. We can set this by using the Azure Linux Agent Open an SSH session to your Azure Linux instance and run these commands as root or using sudo: Steps: 1) Test the available disk space for your instance: df -h 2) Edit the Azure Linux Agent configuration file: vi /etc/waagent.conf Update these parameters: ResourceDisk.Format=y ResourceDisk.EnableSwap=y ResourceDisk.SwapSizeMB=16384 Set the “ResourceDisk.SwapSizeMB” value to the number of megabytes to allocate to the swap file. Usually this value can be up to the size of the installed system memory. Make sure you have sufficient available space on the disk to do this. 3) Restart the Azure Linux Agent service: service waagent restart 4) Verify that your swap file is available: swapon -s If you like please follow and comment

Azure Learning|Deleting a VM and its resources in Azure| Session 12 if you like please follow and  comment

How To Run The XML Publisher Template Re-Generator in Oracle Apps RTF layout templates are available via the Template Manager. Internally, the application stores a second copy of these templates in a converted XSL-FO format. It is this XSL-FO layout template that is used at runtime for generating reports. Therefore, in case of a significant code change in the RTF parser, it may be required to run the XML Publisher Template Re-Generator in order to regenerate the internal XSL-FO templates. Steps: Perform the following steps to run the XML Publisher Template Re-Generator concurrent program: Login to the application as <SYSADMIN_user> Responsibility: XML Publisher Administrator Function: Request --> Run Pick the option Single Request Concurrent Program Name: XML Publisher Template Re-Generator Set the parameter Re-Generation Criteria to ALL Click on OK Submit the request If you like please follow and comment

Azure Learning|Creating a Windows Virtual Machine and Connecting Through RDP| Session 11 if you like please follow and comment

Azure Learning| Creating a Linux Machine and Connecting Using Putty| Session 10 if you like please follow and commen t

Azure Learning| Dash Boards, Create Custom Dashboard, Recover a Deleted DashBoard| Session 9 if you like please follow and comment

How to Resize an Undo tablespace in Oracle Check current undo tablespace connect as sysdba  and do  SQL> SHOW parameter UNDO_TABLESPACE undo_tablespace string UNDOTBS1 To resize an Undo tablespace we have  to switch to a new Undo tablespace and drop the old Undo tablespace. Steps 1. Create a new undo tablespace of the same size (larger or smaller) depending on your database requirements. SQL> create undo tablespace UNDOTBS2 datafile '+TEST1' size 1000M; 2. Switch to the new Undo tablespace: SQL> ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS2 SCOPE=BOTH; 3. Check the status of the undo segments and determine if all the segments in the old undo tablespace are offline. SQL> select tablespace_name, status, count(*) from dba_rollback_segs group by tablespace_name, status; If there are Undo segments with a status other than OFFLINE in the tablespace to be dropped, we need to wait till they become OFFLINE.  We may have to wait for the duration of the tuned_undorete...

Azure Learning|Navigating and Understanding the Azure Portal| Session 8 if you like please follow and comment

Shell script to Calculate the bitwise binary calculation AND,OR and XOR for a Input String Detailed Video Explanation is Below of the Script Script #!/bin/bash #set -x ############################################# #taking string from user# echo "Please enter a string with binary calculation" read v_str #####Now check the string length is odd or even######## v_str_len=`echo ${#v_str}` ####check if  the lenght is odd or even########### if [ ! -z $v_str ] then if [ $((v_str_len%2)) -eq 0 ] then   echo "lenght is even." echo "exiting" exit 1; else   echo "Number is odd." echo "Moving Ahead" fi else echo "Empty string passed" echo "exiting Bye!!" exit 1; fi while [ ${#v_str} -gt 1 ] do v_last3=${v_str: -3} v_char1=`echo $v_last3 |cut -c 1` v_char2=`echo $v_last3 |cut -c 2` v_char3=`echo $v_last3 |cut -c 3` if [ "$v_char2" = "A" ] then z=$(( $v_char1 & $v_char3 )) elif [ "$v_char2"...

Azure Learning| Create Free Azure Account| Session 7 If you like please follow and comment

How to clean SYSAUX Optimizer Statistics History Many times we come across the SYSAUX tablespace getting full. We can find what is consuming the most space and can clean up. When new optimizer statistics are collected for a database object, old statistics are sent to SYSAUX tablespace. This information is stored in the "Server Manageability - Optimizer Statistics History" component of SYSAUX tablespace. This feature is used for DBMS_STATS.RESTORE   procedures. The default retention for Optimizer Statistics History is 31 days.  Old information is automatically deleted by Oracle Database, Without any manual intervention based on the retention. 1) Find SYSAUX components and their sizes. select * from v$sysaux_occupants order by space_usage_kbytes desc; 2)Find biggest segments in SYSAUX select tablespace_name,owner,segment_name,partition_name,segment_type,trunc((bytes/1024/1024/1024),2) "GB"  from dba_segments where tablespace_name = 'SYSAUX' order by bytes desc...

Error: Cannot view XML input using XSL style sheet We are getting an error when trying to review report output in XML type text/XML URL http://server.domain:port/OA_CGI/FNDWRR.exe?temp_id=35619285 Error The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. -------------------------------------------------------------------------------- An invalid character was found in text content. Error processing resource 'http://server.domain:port/OA_CGI/FNDWRR.ex... CAUSE Wrong setup for profile options "FND: NATIVE CLIENT ENCODING" which need to be set to "UTF8" Check that setup is correct for this profile option at every level and not only at site level, because other level are overwriting Site level. SOLUTION Run the following sqlplus statement from sqlplus as the apps user to check that the profile is set as UTF8 at all levels:         SELECT   po.user_profile_op...

Adding Mutiple Responsibilty to User from Back End in Oracle Apps This script can to used to assign multiple responsibilities to a user in Oracle Apps SCRIPT: /*************************************************************************** -- AUTHOR NAME : Himanshu Singh -- DATE WRITTEN : 09-AUG-2021 -- DESCRIPTION : This Script would add the Responsibility to the User. -- MAINTAINANCE HISTORY : -- DATE NAME REMARKS  --------- --------- ---------  ***************************************************************************/ DECLARE  v_user_name VARCHAR2 (20) := 'HISINGH';  v_description VARCHAR2 (100)  := 'Adding Responsibility to user using script';  v_appl_shrt_name VARCHAR2 (20);  v_appl_name VARCHAR2 (50);  v_resp_key VARCHAR2 (50);  l_count NUMBER := 0;  -- List of Responsibility that would be added  CURSOR cur_resp_names  IS  SELECT 'Application developer' RESP_NAME FROM DUAL  UNION  SELECT 'iProcurement' F...

GUI to Check Hardware Information in Linux - HardInfo HardInfo (in short for “hardware information“) is a system profiler and benchmark graphical tool for Linux systems, that is able to gather information from both hardware and some software and organise it in an easy to use GUI tool Installing HardInfo HardInfo is available to install in all major Linux distributions from the default repository. Debian, Ubuntu, and Mint sudo apt install hardinfo Fedora/CentOS Linux # dnf install glib-devel gtk+-devel zlib-devel libsoup-devel $ cd Downloads $ git clone https://github.com/lpereira/hardinfo.git $ cd hardinfo $ mkdir build $ cd build $ cmake .. $ make # make install Arch and Manjaro Linux sudo pacman -S hardinfo OpenSUSE sudo zypper in hardinfo How to open Hardinfo on your computer It’s a graphical application, and it should be categorised under System by name System Profiler and Benchmark in your distribution’s launcher. It can also be used to generated HTML reports. If you like please f...

Azure Learning|Regions,Availability Zones| Session 6 if you like please follow and comment

How to supress ssh from prompting key passphrase for passwordless logins Generating authentication key pairs Use the ssh-keygen command to generate authentication key pairs as described below. Provide a passphrase, for example "password", when creating the key pairs. # ssh-keygen  Generating public/private rsa key pair. Enter file in which to save the key (/home/himanshu /.ssh/id_rsa):  Enter passphrase (empty for no passphrase):  Enter same passphrase again:  Your identification has been saved in /home/himanshu/.ssh/id_rsa. Your public key has been saved in /home/himanshu/.ssh/id_rsa.pub. The key fingerprint is: SHA256:4lYqkqgXmhIxoyMdT+ZfGFCxeMUqTnXLjrRQKjbEC/U root@funebslab The key's randomart image is: +---[RSA 2048]----+ | o.  .oo.        | |. o...ooo        | | o .E=o+ .       | |+ * D.+ o        | |.* @ +.*S        | |o.          ...