foalabs

How to mount a Folder from another Partition in Linux In case we want to mount a folder located in other partition, below steps can be followed. mkdir /stage mount --bind /u01/stage /stage To make this permanent add in your /etc/fstab like this: /u01/stage    /stage    none    bind Check the mount now. [himanshu@ebs122 ~]$ df -aTh Filesystem     Type         Size  Used Avail Use% Mounted on /dev/sda1      ext4         9.8G  3.6G  5.8G  39% / proc           proc            0     0     0    - /proc sysfs          sysfs           0     0     0    - /sys devpts         devpts        ...

Oracle APPS R12.2 Installation on Google Cloud VM In this post I am going to share steps to install Oracle Apps R12.2 in Google Cloud. Server Preparation: Google cloud VM creation with 500 GB storage and make sure host name length is small. I have used RHEL 6 image for Operation system. VNC server installation- Refer link to check the steps Once above tasks are done, we have to start with installation and pre-requisites. 1) I will install RPM's using oracle public repository. cd /etc/yum.repos.d Move all present repo files to backup directory. mkdir bkp mv * bkp/ Download oracle public repository repo file. wget http://public-yum.oracle.com/public-yum-ol6.rep o Using a text editor, change the field ‘enabled=0’ to ‘enabled=1’ for the repositories corresponding to the machine’s operating system while also enabling the ‘addons’ channel. Here’s an example of a repo file’s entries: [ol6_latest] name=Oracle Linux $releasever Latest (...

Adding a DISK on GOOGLE Cloud VM In this post we are going to see how to attach a DISK on Google Cloud VM. Steps: 1) Attaching a New Disk to VM Go to your Google Cloud Console and navigate to Compute >> VM Instances. Click the name of the instance where you want to add a disk. Click Edit, at the top of the instance details page. Scroll down to Additional disks and click Add item. Configure the disk’s properties and click Create. Scroll down to the bottom of the page and click Save to apply your changes to the instance and attach the new disk. 2) Check the new disk on VM. sbd is the new disk. [himanshu@ebs122 ~]$ sudo lsblk NAME   MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT sda      8:0    0   10G  0 disk  └─sda1   8:1    0   10G  0 part / sdb      8:16   0  400G  0 disk 3) Format the Disk ...

Installing VNC server on Google Cloud In this post we are going to see how can we setup GUI in google cloud VM using vncserver. I would be using the same for installing EBS R12.2 in future posts. Steps: 1. Setup a VM on Google Cloud. I am using RHEL 6. [himanshu@ebs122 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.10 (Santiago) 2. Install the required RPMS yum install tigervnc-server yum install twm yum install xterm yum install xsetroot yum install xclock 3. Start the VNC server using below command [himanshu@ebs122 ~]$ vncserver You will require a password to access your desktops. Password: Verify: xauth:  file /home/himanshu/.Xauthority does not exist New 'ebs122:1 (himanshu)' desktop is ebs122:1 Creating default startup script /home/himanshu/.vnc/xstartup Starting applications specified in /home/himanshu/.vnc/xstartup Log file is /home/himanshu/.vnc/ebs122:1.log 4. Now install any vnc viewer and try to acc...

Query to find Concurrent Program Details based on Program Name Scripts: SELECT     fcp.concurrent_program_id,     fcp.concurrent_program_name,     fcpt.user_concurrent_program_name,     fcpt.description,     fe.executable_name,     fet.user_executable_name,     fe.execution_file_name FROM     apps.fnd_concurrent_programs fcp,     apps.fnd_concurrent_programs_tl fcpt,     apps.fnd_executables fe,     apps.fnd_executables_tl fet WHERE         fe.executable_id = fet.executable_id     AND         fcp.concurrent_program_id = fcpt.concurrent_program_id     AND         fcpt.language = fet.language     AND         fcp.executable_id = fe.executable_id     AND         fcp.executable_application_id...

Query for Redo log Files and finding various details Script to find redo log file members. select GROUP#,TYPE,MEMBER from v$logfile; Script to find  redo log file size select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024 as "Size in MB",MEMBERS,STATUS from v$log; Script to find both log file and its size SELECT     a.group#,     a.thread#,     a.sequence#,     a.archived,     a.status,     b.member AS redolog_file_name,     ( a.bytes / 1024 / 1024 ) AS "Size in MB" FROM     v$log a     JOIN v$logfile b ON a.group# = b.group# ORDER BY a.group#