How to delete Virtual Machine from VirtualBox

Power off the Virtual Machine which you want to delete from the Virtual box 2) Select the VM to be deleted and then Click Machine on the top machine and choose remove from drop down menu 3) Below screen will come up Use delete all files option to remove the file which contains the virtual machine hard disk. This will free up all the space … Continue reading How to delete Virtual Machine from VirtualBox »

Step by Step R12.2.6 EBS installation on Virtual Box Part -2

We have already performed the installation of VirtualBox and download the VM appliance in the last post Now lets continue with the installation of 12.2.6 VM template in the Virtual box 1)  Check if the Hardware Virtualization is enabled in the Desktop of Laptop where you have installed the Virtualbox 2) Now Open the Virtual box  and click on Import Appliance 3) The Import Virtual Appliance … Continue reading Step by Step R12.2.6 EBS installation on Virtual Box Part -2 »

Enabling Virtualization in BIOS in Laptop or Desktop for Virtualbox VM

Virtual box VM will not be started  if Virtualization Technology (VT-x) is not enabled in BIOS. It will throw below error while starting the VM Reason for the Error The host system must support hardware virtualization. Your host system must have 64-bit CPUs that support Intel™ Virtualization Technology (Intel VT, first released in 2005) or AMD Virtualization (AMD-V™) Technology (first released in 2006) hardware-virtualization features. … Continue reading Enabling Virtualization in BIOS in Laptop or Desktop for Virtualbox VM »

Step by Step R12.2.6 EBS installation on Virtual Box

Oracle recently release VM template for R12.2.6 on Software delivery cloud. In this blogpost , we would be checking step by step how to build R12.2.6  with Virtual box on the Desktop or Laptop 1)  First install VirtualBox on the Desktop or Laptop. Check below post on how to do the installation Step by Step instructions for Oracle Virtual Box Installation 2)  Now download the … Continue reading Step by Step R12.2.6 EBS installation on Virtual Box »

How FNDFS (Oracle Report Review agent) works in EBS environment

Explaining how FNDFS working 1) The user selects ‘Request Output’, ‘Request Log’, or ‘Manager Log’ 2) The file name and nodename are selected from the database. Reports: SELECT outfile_name, outfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Logfiles: SELECT logfile_name, logfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Manager logs: SELECT logfile_name, node_name FROM fnd_concurrent_processes WHERE concurrent_process_id = :process_id; The client takes the nodename that was returned and … Continue reading How FNDFS (Oracle Report Review agent) works in EBS environment »

How to use external tables in Oracle with example

External table is one of the important feature in oracle , we will exploring external table in oracle with example in this post What are EXTERNAL TABLES in Oracle? 1)External tables are read only tables where the data is stored in flat files outside the database 2) You can user external table feature to access external files as if they are tables inside the database. 3)   … Continue reading How to use external tables in Oracle with example »

Step by Step instructions for Oracle Virtual Box Installation

VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use VirtualBox runs on Windows, Linux, Macintosh, and Solaris hosts and supports a large number of guest operating systems including but not limited to Windows (NT 4.0, 2000, XP, Server 2003, Vista, Windows 7, Windows 8, Windows 10), DOS/Windows 3.x, Linux (2.4, 2.6, 3.x and 4.x), Solaris and OpenSolaris, OS/2, … Continue reading Step by Step instructions for Oracle Virtual Box Installation »

Oracle Recovery Manager :RMAN cheatsheet

Oracle Recovery Manager(RMAN) is an important component of Oracle Database Software . It is a effective way to do the backup and recovery of the Oracle database. Oracle has added new features in RMAN in every new release. Here are some of the article,I have written on RMAN to understand it RMAN benefits over manual backup How to recover database using RMAN How to debug Oracle … Continue reading Oracle Recovery Manager :RMAN cheatsheet »

oracle apps dba training Part 4

oracle apps dba training This is in continuation of the Online oracle apps dba training Course  Series Training Course Part 1 Training Course Part 2 Training Course Part 3 Here  is  Online oracle apps dba training Course Part 4 . I will be discussing Ad utlities, Concurrent Manager ,Online patching Concepts, patching concepts Lets get started Autopatch and Ad Utilites Autopatch and Adutlities are used extensively … Continue reading oracle apps dba training Part 4 »

APPLSYSPUB schema

APPLSYSPUB  is the database schema. it is the first schema which is used in any connection in Oracle apps. Oracle forms, oacore  all connects to it first The APPLSYSPUB account should have only these grants – INSERT ON FND_UNSUCCESSFUL_LOGINS INSERT ON FND_SESSIONS EXECUTE ON FND_DISCONNECTED EXECUTE ON FND_MESSAGE EXECUTE ON FND_PUB_MESSAGE EXECUTE ON FND_SECURITY_PKG EXECUTE ON FND_SIGNON EXECUTE ON FND_WEBFILEPUB SELECT ON FND_APPLICATION SELECT ON … Continue reading APPLSYSPUB schema »

What you need to know about oracle create tablespace statement

oracle create tablespace statement

We will be discussing Oracle create tablespace statement/oracle create tablespace 11g in detail in this post. I will through light on all the option on create tablespace statement.I would also be discussing  how to check tablespace size in oracle. I hope you will like this post. I will be looking forward for  feedback on this post Table of content What is Oracle Tablespace and its … Continue reading What you need to know about oracle create tablespace statement »

Online Oracle Apps DBA Training Course Part 2

oracle apps online training This is in continuation of the Online Oracle Apps DBA Training Course  Series Training Course Part 1 Here  is  Online Oracle Apps DBA Training  Course Part 2 . I will be discussing Oracle Applications Technology LayerThe Oracle Applications technology layer lies between the Oracle Applications technology stack and the Oracle Applications product-specific modules. It provides features common to all Oracle Applications … Continue reading Online Oracle Apps DBA Training Course Part 2 »