OracleBrains.Com header image 5

Entries Tagged as 'Oracle Database'

Security Threat to Oracle datafiles

May 16th, 2012 · 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 [...]

[

Tags: Oracle Security

Java RunTime Environment was not found when running Oracle Universal Installer

April 30th, 2012 · 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 [...]

[

Tags: Oracle Installation

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

March 25th, 2011 · 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 [...]

[

Tags: Oracle Administration

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

February 19th, 2011 · 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 [...]

[

Tags: Oracle Administration

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

June 7th, 2010 · 1 Comment

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

[

Tags: Oracle Forms · Oracle Installation · Oracle Reports

Database Link coming handy!!!

August 8th, 2009 · 4 Comments

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

[

Tags: Oracle Administration · Oracle Database

ORA-01092: ORACLE instance terminated. Disconnection forced, error while creating database manually!

December 8th, 2008 · 4 Comments

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

[

Tags: Oracle Database · Oracle Installation

What to do when database runs out of temp tablespace?

July 11th, 2008 · 1 Comment

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

[

Tags: Oracle Administration

Installing Oracle Database Lite 10g Release 3 Mobile Server

July 7th, 2008 · 3 Comments

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

[

Tags: Oracle Lite

ORA-12638 : Credential retrieval failed

May 4th, 2008 · 5 Comments

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

[

Tags: Oracle Administration · Oracle Installation