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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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….

[Read more →]