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 →]

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 →]

Went through following resources: Using Oracle Enterprise Manager to Administer Forms Services This one really open a door for me, it helped me understand how to deploy forms application in Forms 11g. Although the configuration file need to be edited are same as Forms 10g, but in Forms 11g they reside in different directory structure. [...]

[Read more →]

Today I had a situation at my client’s place which I need to tackle as soon as possible and I did tackle it nicely. I think so……. Any way let me explain the situation and how I tackle it. Lets assume there are two database one is prod (live one) and another one dev (development). [...]

[Read more →]

Today while creating the database manually for our development environment, I incurred following error. When I checked my alter log It showed me as follows: After that I checked parameter file which showed me value of undo tablespace as follows: After this I change the name in my create database script same as above i.e. [...]

[Read more →]

Yesterday suddenly I received a call from my guys that one of the database server at my client’s place  has only 56 MB space left in “C” drive. I was shocked to hear it as a day before yesterday it has 15GB of free space in the “C” drive. After investigation I found out that [...]

[Read more →]

First time when I installed Oracle Database Lite 10g Release 3 Mobile Server in development PC, I didn’t faced any problem and was very straight out of the box installation affair. Later when I tried installing same in my personal laptop, I faced lot of issues and in process I got to understand more about [...]

[Read more →]

Recently after I configured database on testing machine and configure the forms to run on middle tier on testing machine (all windows environment), I came across the error ORA-12638. After little bit of brains storming and checking online, I found out that one of the way to solve this error is to disable the Oracle [...]

[Read more →]