OracleBrains.Com header image 1

Creating New Report Server in Middle Tier of Oracle Reports 11g

May 23rd, 2012 by Rajender Singh · No Comments

I am writing this blog post on “How to create a new report server in Oracle Reports 11g Release 1 & 2″ as a note to myself, plus with a intention that it will help others. While creating the new report server in Oracle Reports 11g, I came up with following observation and steps: Step [...]

[

→ No CommentsTags: Uncategorized

Security Threat to Oracle datafiles

May 16th, 2012 by Rajender Singh · No Comments

Today post I will share about security threat to an Oracle datafile or can say blundly hacking oracle datafile. Yesterday I attended an OTN DBA Roundtable – Security Workshop in Melbourne at Oracle. While doing a discussion on security threat to Oracle Database, I learned how easy it is to read datafile without logging into [...]

[

→ No CommentsTags: Oracle Security

Java RunTime Environment was not found when running Oracle Universal Installer

April 30th, 2012 by Rajender Singh · No Comments

Today while deinstalling Oracle Forms 11g R2, I came across following error. It says “Java RunTime Environment was not found at…” or in simple works Oracle universal installer couldn’t find java runtime environment even though I have Java installed. I tried setting the local Java related variable but it didn’t help. The deinstaller keep taking [...]

[

→ No CommentsTags: Oracle Installation

Back to Upgrading to Oracle Forms 11g R2!

April 28th, 2012 by Rajender Singh · No Comments

While thinking about Oracle forms..I came across a blog post “Lessons Learned From Upgrading to Oracle Forms 11g R2 on WebLogic !” by Mila Urman. Now really inspired again, to get started on Oracle Forms 11g again… last time I did well but my heart couldn’t reach to actual production stage! Thanks Mia for sharing [...]

[

→ No CommentsTags: Oracle Forms

How ROWNUM Pseudocolumn works?

April 23rd, 2012 by Rajender Singh · No Comments

I keep coming across guys confused about “How ROWNUM Pseudocolumn works?” Even though ORACLE document clearly mentions “the ROWNUM pseudocolumn returns a number indicating the order in which ORACLE selects the row from a table or set of joined rows”, confusion still exists….may be we tend to google rather than going though ORACLE documents these [...]

[

→ No CommentsTags: SQL and PL/SQL

FAL[client, USER]: Error 1031….for fetching gap sequence

March 25th, 2011 by rajs · No Comments

Today one of my guys called me that log seq is not in sync with main db server. When I checked the alter log file of the standby server, I found following Media Recovery Waiting for thread 1 sequence 7752 Error 1031 received logging on to the standby FAL[client, USER]: Error 1031 connecting to bizwizdb [...]

[

→ No CommentsTags: Oracle Administration

Error ORA-03113: end-of-file on communication channel when opening database

February 19th, 2011 by Rajender Singh · 1 Comment

Today I faced following problem while starting the database. SQL> connect /  as sysdba Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 3891630080 bytes Fixed Size                  2181664 bytes Variable Size            2835351008 bytes Database Buffers         1040187392 bytes Redo Buffers               13910016 bytes Database mounted. SQL> alter database open; alter database [...]

[

→ 1 CommentTags: Oracle Administration

Upgrading Forms 10g R1 to Oracle 11g R1 – Day 4

July 30th, 2010 by Rajender Singh · 2 Comments

Today while restarting my WLS_FORMS server, I came across a error “The file store “WLS_DIAGNOSTICS” could not be opened because it contained a file with the invalid version 1. A file of version 2 was expected.” Part of Error Log was as follows: #### <> <> <> <1280499317750> There are 1 nested errors: weblogic.store.PersistentStoreException: [Store:280073]The [...]

[

→ 2 CommentsTags: Oracle Forms

Oracle Portal

July 27th, 2010 by MAhmad · 2 Comments

Hi Experts, I’m planning to install Oracle Portal. My pc OS is windows Vista and has oracle10g installed. Can anyone help tell some information about the guidelines on how to install this software and other system requirements? Where I can find all the required software to download? Please tell me software installations sequence and important [...]

[

→ 2 CommentsTags: Uncategorized

Oracle Application Express Release 4.0 is released :)

June 27th, 2010 by Rajender Singh · No Comments

Oracle Application Express Release 4.0 was released on June 23, 2010 …but I got to know on train just now while going from Melbourn to Warrnambool..excited and getting eager to check it out.. Little slow on Oracle Forms 11g research…as busy with project of mine….

[

→ No CommentsTags: Application Express