Rails patch for Oracle CLOB defaults

If you are using Rails 1.2.3 with Oracle database then you might find that text attributes (which map to Oracle CLOB data type) get invalid default values – e.g. you might find that when you create new record it will get “empty_clob()” as default text attribute value.

I found out that this issue is corrected in current edge Rails. As I still primarily use Rails 1.2.3 I created the following patch according to the changes that are done in edge Rails. You can put it in environment.rb file or better put into a separate (more...)

Recovering Corrupted Data Blocks

Last Week, I experienced a kernel crash using Oracle 10.2.0.3 on my Oracle Enterprise Linux 4 sandbox server. There was not a single reaction from the server, I had to reboot the box by pressing the reset button.
I happened to have a backup of this sandbox database, which gave me the opportunity to perform a media recovery.

The situation was that the undo Tablespace had a corrupt block.

Here is the alert log content:

Mon Aug 20 08:54:44 2007
SMON: enabling cache recovery
Mon Aug 20 08:54:45 2007
Errors in file /opt/oracle/app/oracle/admin/orcl/udump/orcl_ora_6733.trc:
ORA-01578: ORACLE data (more...)

How to explicitly set Oracle DATE column as Ruby Date attribute

As you probably have noticed Oracle has just one DATE type for table columns which is supposed both for storing just dates and dates with time. From the other side Ruby has different classes Date and Time. If you are using Rails then Rails tries to guess from the database column types what are the classes for corresponding object attributes in Ruby. And as both dates and dates with time appear as DATE columns Rails has difficulties to guess whether it should be Ruby Date or Ruby Time.

Current Rails Oracle adapter has the following workaround implemented:

# * Oracle  (more...)

How to setup Ruby and Oracle client on Intel Mac

UPDATE: New version of this instruction for Intel Macs with Leopard is available here.
New version of instructions for Snow Leopard is available here.

Introduction

I have been using Oracle technologies for many years but just some time ago discovered Ruby and Rails. As I had ideas how to make Ruby on Rails frontends for existing Oracle based systems I started to explore how to use Ruby on Rails together with Oracle databases.

Just recently I switched from PC notebook to MacBook Pro and unfortunately found out that Oracle Instant Client is not yet released for Intel Macs. As (more...)

EclipseLink Update: Source Checked in and team Blog

See the EclipseLink team blog for regular updates on the project.

Doug

Upgrading Application with Forms Patchset 18

Uncategorized
| Aug 17, 2007
Action Plan for Forms Patchset 18 Upgrade (4948577)


1. Take a backup of the the Printer File.

If you have customized the printer configuration file located in ORACLE_HOME/guicommon6/tk60/admin/uiprint.txt with your printer definitions, you will have to redo the configurations after applying the Developer 6i patch. Your previous uiprint.txt is backed up as $ORACLE_HOME/guicommon6/tk60/admin/uiprint.txt.PRE_P4948577

cp $ORACLE_HOME/guicommon6/tk60/admin/uiprint.txt $ORACLE_HOME/guicommon6/tk60/admin/uiprint.txt.PRE_P4948577

2. Apply the Main Patch 4948577
3. Apply the Apps Interop Patch 4888294 ----11i Patch


Apply the Additional Patches

a. Apply the Patch 4968700

To apply this patch, please follow the steps below:

1) Stop your web (more...)

Platform Migration from Sun-Solaris to HP-UX PA RISC

Uncategorized
| Aug 14, 2007
Pre-requisites
***************

Source
-------

----> For Customer Specific patch

1. Apply the Platform Migration patch 3453499 (ADX.F)
2. Make sure you have zip2.3 installed on Source Machine
3. Generate and upload the manifest of customet specific files.
- Log into source as applmgr user and source the APPL_TOP environment file.
- Generate the customer specific file manifest by executing the below command.It
generates the file adgenpsf.txt under $APPL_TOP/admin/$TWO_TASK/out

- perl $AD_TOP/bin/adgenpsf.pl
4. Go to http://updates.oracle.com/PlatformMigration and use your metalink username
and password and follow the instructions on the screen to upload the manifest
(more...)

Emulating string-to-table functionality using sql

Uncategorized
| Aug 11, 2007
Turning delimited strings into multiple records without PL/SQL. July 2005 (updated August 2007)

Welcome back

Our guest administrator "Splogger" has now left the building, along with his page of helpful links to items on Amazon.com and a range of gentlemen's health products.

Suspiciously, a couple of days before he arrived we were taken off air by Blogger's spambots, presumably alerted by the amount of irrelevant, repetitive, and nonsensical text and links to Viagra sites they found here. From what I read, it seems possible that the Blogger automated suspension to prevent blog spam might have actually left the account vulnerable to blog spammers. As ironies go, that is up there with rain on (more...)

Method 4 dynamic sql in pl/sql

Uncategorized
| Aug 8, 2007
Using ANYDATASET and pipelined functions to achieve native Method 4 Dynamic SQL. August 2007

Flexible pipelined functions

Uncategorized
| Aug 7, 2007
Combining pipelined functions, polymorphism and multi-table inserts. August 2007

Oracle APPS DBA Interview Questions

Uncategorized
| Aug 1, 2007
Q1. What is wdbsvr.app file used for? What's full path of this file? What's significance of this file ?

Ans: The wdbsvr.app is used by mod_plsql component of Apache to connect to
database. The File is located at $IAS_ORACLE_HOME/Apache/modplsql/cfg .

Q2. Where would i find .rf9 file, and what execatly it does ?

Ans: These files are used during restart of patch in case of patch failure because of some reason.

Q3. Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why its used?

Ans: This file is defined by environment variable FORMS60_WEB_CONFIG_FILE This is usually in directory $OA_HTML/bin on forms (more...)