Author: Sriram Sanka
-
AWS- EC2 : Error while changing the IP Address in EC2 Security Groups
Error while changing the IP Address in EC2 Security Groups. This happened ,as the user does not have access to change the IP in SG Group 2,after adding the below rule (Underlined Part) resolved this error. {“Version”: “2012-10-17″,”Statement”: [{“Sid”: “VisualEditor0″,”Effect”: “Allow”,”Action”: [“ec2:RevokeSecurityGroupIngress”,”ec2:AuthorizeSecurityGroupEgress”,”ec2:AuthorizeSecurityGroupIngress”,”ec2:RevokeSecurityGroupEgress”,”ec2:DeleteSecurityGroup”],”Resource”: [“arn:aws:ec2:::security-group/sg-Group1″,”arn:aws:ec2:::security-group/sg-Group2”]},{“Sid”: “VisualEditor1″,”Effect”: “Allow”,”Action”: [“ec2:DescribeSecurityGroupReferences”,”ec2:DescribeVpcs”,”ec2:DescribeSecurityGroups”,”ec2:DescribeStaleSecurityGroups”],”Resource”: “*”}]}
-
Install MySQL 8 Community Server (mysql-community-server) on Azure VM(IAAS) Linux 8 CentOS
Download and Add MySQL Yum Repository. wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm Install the downloaded release package. yum localinstall mysql80-community-release-el8-1.noarch.rpm You can check that the MySQL Yum repository has been successfully added by the following command (If Yum Is not available, you can use dnf , instead.) yum repolist enabled | grep “mysql.-community.” Installing MySQL Linux 8 includes a…
-
Script To Generate Alter Statements to Kill Locked Sessions in RDS
Script to generate Kill Locked Sessions in Oracle : In case of RDS , SELECT ‘exec rdsadmin.rdsadmin_util.kill(‘||s.sid ||’,’|| s.serial# ||’ );’FROM v$session s ,v$process p ,v$lock l ,dba_objects oWHEREs.paddr = p.addrAND l.sid = s.sidAND l.id1 = o.object_idAND s.username = ‘XXAPPS’ — Change as needed.AND object_name like (‘XXSC%’); — Change as needed.
-
FRM-10102: Cannot attach PL/SQL library
When you try to Open R12 Form template fmb files in Oracle forms, you may receive FRM-10102: Cannot attach PL/SQL library APPCORE . Unable to open Template.fmb. Getting following error FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved.FRM-10102: Cannot attach PL/SQL library APPDAYPK. This library attachment…
-
How to Install Python with Anaconda
Refer to the document for help with installing Anaconda successfully Installing+Python.1 You can Download the individual version from https://www.anaconda.com/products/individual I prefer Spider for the Sample Code snippets. Sample Code for Sudoku Submitted at https://www.geeksforgeeks.org/sudoku-backtracking-7/ Input : Output:
-
Quick Steps to Install Oracle 19c in Windows
Step 1 : Download Oracle 19c DB software for Windows using https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Step 2 : Unzip using 7-Zip to your Destination folder. Step 3 : Navigate to the Extracted Home Folder and Click on Setup.Exe. These 3 Simple Steps will launch “OUI” for Installing 19c , go-ahead and proceed with the Interactive…
-
How to Add Swap Memory using a file
Swap space in Linux is used when the amount of physical memory (RAM) is full. If the system needs more memory resources and the RAM is full, inactive pages in memory are moved to the swap space. Swap space can be a dedicated swap partition (recommended), a swap file, or a combination of swap partitions…
-
HOW-TOHow to Fix VirtualBox “UUID already exists” Errors
There are several ways to fix UUID Issues, One of the methods is to Clone the hard Disk Attached using the clonevdi When you are trying to Add a VM to your VBox, If it’s failed with Below Error, you can use clonevdi to clone the Hard disk using VBoxManage clonevdi <Source> <Target> and reattach…
-
Oracle VM Virtual Appliance for Oracle E-Business Suite 12.2.6 – Download and Create Staging Appliance
This Post is about How to Create Stage Area To Deploy Oracle VM Virtual Appliance for Oracle E-Business Suite 12.2.6 Step 1: Download the Oracle E-Business Suite Appliance from Oracle Software Delivery Cloud, Which Contains Below ZIP Files. V861124-01 Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) – (1 of 10) (Part…
-
Apache – No space left on device / Failed to create proxy Mutex
A Big Thanks to “https://help.directadmin.com/item.php?id=110” Restarting Apache in one of the Servers failed with “No Space left on the Device ” Error and we have enough space in all available partitions. This is something to deal with Server Kernel semaphores. “On Linux, A semaphore is a System V IPC object that is used to control utilization of…
Sriram Sanka 