Skip navigation.

Technical Articles

Technical Oracle Articles

Step by step recovery of oracle database on ORA-00214: control file incosistent

SQL> startup;
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL02.CTL' version 23659
inconsistent with file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL01.CTL'
version 2798

SQL> shutdown abort;
ORACLE instance shut down.

sQL>create pfile='c:/initnew.ora' from spfile;

File created.

SQL>shutdown abort;

-----E

ProC Code Performance Improvement (GCC - RHL)

Performance Improvement in Pro*C

Pro*C code compilation builds executable depends on the parameters passed while compiling a code on Linux OS. GCC compiler is widely used for compilation.

Parameters that it provides enables memory management and linking etc...
This means : Without changing Code GCC compilation parameter change can give significant improvement in performance without impacting functionality. Attached document contents details study of the same.

This document gives details about environment,deployment and pre-post change analysis.

Brgds,

Sanjay J. Sontakke

Pro*C Code Performance Improvement (GCC - RHL)

Performance Improvement in Pro*C

Pro*C code compilation builds executable depends on the parameters passed while compiling a code on Linux OS. GCC compiler is widely used for compilation.

Parameters that it provides enables memory management and linking etc...
This means : Without changing Code GCC compilation parameter change can give significant improvement in performance without impacting functionality. Attached document contents details study of the same.

This document gives details about environment,deployment and pre-post change analysis.

Brgds,

Sanjay J. Sontakke

Oracle 11g CONVERTING PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE

CONVERTING PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE

Step 1: Check if Flashback is enabled.

Exploring BI Publisher 11g : A simple report with DataModel Editor

If you have installed OBIEE 11g successfully, lets try to explore some of the new features and tools available with BI Publisher 11g.

Unlike 10g, where Report is a single entity and data sets are the part of Report definition, in 11g, Data Sets (which termed as Data Model in 11g) and Report definition are two separate entities.

Data Model, which drive/extract the xml data for report is the advance version of Data Template, So there is no Data Template in 11g, its all Data Model with a very nice Data Model editor to design simple to complex Data model. This support some new data source like, BC4J View Objects and EXCEL, which were not supported in earlier releases as data source.

Report definition includes the Data Model reference, Layout template and other report specific metadata required to render or generate the Report output.

For these many years, we are using RTF templates as main Layout Template, now there is new format available with 11g, it is xpt format, which looks like Oracle’s proprietary format. As claimed, it generates almost pixel perfect output and could be a good substitute for PDF Forms. A nice Report Designer is available to design these xpt reports.

As I mentioned earlier, the complete report consist of two main objects, Data Model and Report definition. Data Model should exist, before we start Report definition.

Before design the data model, make sure the required jdbc connection is setup through BI Publisher Administration UI. To access JDBC data source UI, click the Administration from the Top bar and select the Manage BI Publisher Administration from the Common Administration Page.
Read more..

Oracle Database 11g RMAN Backup Encryption

Security is gaining importance. As per the reports in the year 2008, loss of confidential information has increased to 63%. This loss of confidential information is a breach of Service Level Agreement (SLA). Organizations will have to compensate these loses in the form of financial penalties.
A recent information protection law from a state in U.S.A claims that information of residents of this state stored in databases across the globe will have to be encrypted. Upon failure, the database owners will have to pay $5000 penalty.

Trasliteration - Conversion of double/triple byte characters to single byte characters for various requirements

I recently came across a document where the requirement was to convert from triple/double byte characters to single byte characters to send it for export complaince check as the export compliance system can accept only single byte characters.
Basically the useful thing about this was they were using IBM ICU project(an open source project) for this process,so in a way making it more open to developers.
These were the pros and cons for IBM identified by them.
Pros
- No interface needed (written in Java, integrable in Oracle)
- High level of portability, flexibility and scalability
- No int

Heartbeat failed to connect to standby-11g Dataguard

Error:Heartbeat failed to connect to standby Error 12541
By using rdist command, one can copy Oracle's password file from primary site to physical standby site.

How to enter a single quotation mark in Oracle?

tlananthu's picture

Answer: Although this may be a undervalued question, I got many a search for my blog with this question. This is where I wanted to address this question elaborately or rather in multiple ways.

A Simple Introduction To XML

XML: XML is an acronym for ‘Extensible Markup Language’. It is used for defining data
elements on a webpage and business to business document. XML uses a similar tag
structure as HTML; however, whereas HTML defines how the elements are displayed,
XML defines what those elements contain.