Skip to content

Expert Oracle Posts

JSON Concepts – Oracle Cloud Orchestration

JSON (JavaScript Object Notation) is a lightweight data-interchange format. This simple language is used a lot in Oracle Cloud and many other new Oracle products like SOA and Oracle 12c. It is easy for humans to read and write this language. It is easy also for machines to parse and generate. JSON is a text format that is completely language independent which make JSON an ideal data-interchange language. The file type for JSON files is “.json”

Leave a Comment

Oracle Cloud Identity Domain – Concepts

Identity domain is synonymous to  tenant concept in Oracle Cloud. Oracle Cloud is a multitenant system, and each client is a tenant in the big Oracle Cloud system. It is just like the tenants of a building. So, an identity domain represents a slice of the Oracle Cloud, provisioned for a cloud tenant according to Client’s demand.

An Oracle Cloud service account is a unique customer account that can have multiple cloud services of different service types. Also an account can contain multiple Identity Domains, and each Identity Domain can contain multiple Database Cloud Services.  For example, you could have three different cloud services, such as Java Cloud Service, Database Cloud Service, and Infrastructure as a Service (IaaS) as part of a single Oracle Cloud service account.

Although an account can have one or more Identity Domains, but each Domain is separate and distinct.   Users in an identity domain can be granted different levels of access to each service associated with the domain.

Leave a Comment

Oracle Compute Cloud – Concepts

This post provide general overview of Oracle Compute Cloud and some of its main features.

Oracle’s enterprise-grade infrastructure service provides a Oracle compute cloud environment which can be provisioned rapidly. It provides flexible and scalable computing, block storage, and networking services on Oracle Cloud. You can now set up and manage your computing and storage workloads in the cloud, on demand, using a self-service portal. You can say that Oracle compute cloud is the foundation of Oracle’s Infrastructure as a Service (IaaS).

Leave a Comment

Cloud Computing – Basic Concepts

BASIC DEFINITION

Cloud computing which is usually referred to as simply “the cloud,” is the on-demand delivery of compute power, database storage, applications, and other IT resources through a cloud services platform via the internet with pay-as-you-go pricing.

Key word here is “on-demand”. You demand that you need some resource (CPU/Storage/Database/Platform/Apps etc) and you get it instantly by as simple as pressing couple of keys in your web hosted Cloud Panel.

Traditionally, you used to first order these resources through defined channels before started using them. Example, in your traditional setup, as a DBA if you required another 1 TB of disk for your database you may have to go to your UNIX Admins which in turn used to go to storage admins and Storage admins used to carve out the right size disk or order new capacity from the storage company. UNIX Admins then partition and extend the LV and then at last you will get the disk to increase your database size. This is very simple example of traditional system but explains that it takes resource. time and effort to get such repetitive things done. Cloud computing helps in overcoming such limitations.

Leave a Comment

Output Post Processor (OPP) related issues in 11i/R12

Concurrent processing uses the Output Post Processor (OPP) to enforce post-processing actions for concurrent requests. Post-processing actions are actions taken on concurrent request output. An example of a post-processing action is that used in publishing concurrent requests with XML Publisher.

Apps DBAs have to sometimes troubleshoot issues related to OPP. Many a times issues are related to java memory with error messages like below:

Leave a Comment

Key Reasons for Database Performance Issues

Some of the key reasons which attributes to database performance issues are mentioned below:

Below post is based on Oracle Documentation

1.Bad connection management

The application connects and disconnects for each database interaction. This problem is common with stateless middleware in application servers. It has over two orders of magnitude impact on performance, and is totally unscalable.

Leave a Comment

Oracle EBS R12 – Concurrent request log and output files display with delay

We faced one issue in our Oracle EBS R12  where users reported that Concurrent request log and output files are not displaying instantly but are showing up after few seconds of delay.

Same situation was faced when trying to open any manager log files. Since log/out were opening up fine, albeit with some delay, so RRA/FNDWR setup was evidently fine.

Leave a Comment