Category Archives: Oracle

ORACLE TUTORIALS

Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

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 »

Online Oracle Apps DBA Training Course Part 1

Oracle’s E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications Oracle applications is the widely used EBS application in the world.Oracle’s E-Business Suite requires extensive work from Oracle Application Database Administrator(Oracle apps DBA). So Oracle Application Database Administrator is a rewarding career with great potential to scale … Continue reading Online Oracle Apps DBA Training Course Part 1 »

Oracle Create table Syntax,Tip and Examples

This article talks how to create table in Oracle,create table syntax in oracle,oracle create table example, Oracle is the most RDBMS used everywhere for system Table of content What is Oracle database Table How to create table in oracle create table syntax in oracle Privilege required to create table Other characteristics associated with table How to modify the oracle database table Creation of table using sub … Continue reading Oracle Create table Syntax,Tip and Examples »