All Blog Posts (871)

The basic function of a calculator is computing, which can be as simple as the four arithmetic operations and also as complex as the calculation for the next move in chess with Deep Blue. Among these, esCalc is a desktop data calculation tool for the business users to handle the occasional, complex, and business-related data computation. Such tools are named as the desktop BI software.



For example, a stock analyst is required to recommend some stocks to the clients urgently. Among…

1.PURPOSE AND SCOPE

When there is no hope to restore a database, i can suggest to use a internal program of oracle which named  DUL (…

The business computing always occurs in enterprises, which plays an important role in enterprises operations, and mainly handled by the business users. The key business computing is usually characterized with timeliness and weak predication. There is no ready answer in the ERP, CRM, and other business systems. For example, find out the materials whose inventory level is below the warning limit for 3 consecutive days in the recent 2 weeks. Among those materials, which are used to produce the…

BI (Business Intelligence) refers to the intelligence and ability to enhance the enterprises competitiveness, involving report presentation, reporting result calculation, OLAP analysis, business data calculation, data mining and predication. Among these, there are both the technician-oriented high-level systems, and the business user-oriented agile desktop BI tools. In this post, we only talk about agile desktop BI tools. But what is agile …

Hi All,

I am new to OAF. I need some help regarding OAF customizations. 

I am working on a R2 Upgrade project, there are some personalizations in Customer form(Receivables Manager). I need to implement those in R12.1.3. For that, I have set up Jedeveloper on my local machine, succesfully ran the Tutorial.



I have copied the necessary JAVA files, .xml files on to my local machine.



Added a custom controller and complied it. (Class file has been…

Introduction:

Oracle defines the ORA-7445 as an unhandled exception error that could be result of an Oracle bug. The ORA-7445 errors depend on the version of the Oracle software, OS version.

For more details about the error, you need to check the trace files generated. The ORA-7445 exception generates a trace file located under the CORE_DUMP_DEST directory for oracle versions prior to 11g and under the ADR Home / cdump (Automatic Diagnostic Repository) for 11g…

The fundamental requirement of Data warehousing and business intelligence systems is to keep data consistent and accurate throughout its lifecycle. Data stored in these systems must adhere to some business rules that dictate how particular segments of data relate and meet some set of predefined conditions. Data Integrity refers to maintaining such guidelines in order to ensure correctness of data. This is an…

"BI is not an upgrade to the spreadsheet", "Stop trying to use spreadsheet as the BI tool" - BI vendors are frequently heard to make such comments. People may thus assume that the spreadsheet is on the decline, and feel embarrassed by their Microsoft Excel, RaqSoft esCalc, LibreOffice Calc, and OpenOffice Calc tools…

Contact me for Oracle High Availability Class room Training / Online Classes - Chennai +91-8220304880.

1.PURPOSE AND SCOPE

In this article i am going to explation how to add new disk to the diskgroup which used by database.Before starting i wanted to give some informations about our steps. In this practice we had got a disk named DISK4 and this isnt belong to single diskgroup.First of all i am going to check the stability of DISK4, if disk success i am going to create a different diskgroup and try to add it there.If this step also succeed we are going to add this disk…

1.PURPOSE AND SCOPE

At another article of mine ,I explained  installation of Physical standby and this article we are going to convert physical standby database to logical standby.

2.PRACTICE

2.1. At primary database we need to execute a query to see…

Greetings from TutorsonInternet. I hope you must be doing good.

1.PURPOSE AND SCOPE

In this article, we are going to take user managed backup and try to restore it until spesific time.

2.PRACTICE

2.1. Lets start with backup side of user managed backup/restore.Before starting to copy tablespaces we need to changing the status of tablespaces.By the way you dont need to change the status of tablespaces like me by one by one, you can use “ALTER…

http://querycsm.wordpress.com/2012/12/02/how-to-send-your-jobs-to-background/

http://querycsm.wordpress.com/2013/01/02/ora-39142-incompatible-version/

http://querycsm.wordpress.com/2013/01/02/why-rman-daily-incremental-backups-are-taking-so-long/

http://querycsm.wordpress.com/2013/01/03/enable-bct-block-change-tracking/

http://querycsm.wordpress.com/2013/02/10/tracing-datapump-job/

http://querycsm.wordpress.com/2013/02/10/enabling-tracing-on-a-running-datapump-job/

http://querycsm.wordpress.com/2013/02/10/undocumented-datapump-parameters/