Today one of my guys called me that log seq is not in sync with main db server.
When I checked [...]
Entries Tagged as 'Oracle Database'
FAL[client, USER]: Error 1031….for fetching gap sequence
March 25th, 2011 · No Comments
Tags: Oracle Administration
Error ORA-03113: end-of-file on communication channel when opening database
February 19th, 2011 · No Comments
Today I faced following problem while starting the database.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance [...]
Tags: Oracle Administration
Upgrading Forms 10g R1 to Oracle 11g R1 – Day 2
June 7th, 2010 · No Comments
Went through following resources:
Using Oracle Enterprise Manager to Administer Forms Services
This one really open a door for me, it helped [...]
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 [...]
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 [...]
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 [...]
Tags: Oracle Administration
Installing Oracle Database Lite 10g Release 3 Mobile Server
July 7th, 2008 · 2 Comments
First time when I installed Oracle Database Lite 10g Release 3 Mobile Server in development PC, I didn’t faced any [...]
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 [...]
Tags: Oracle Administration · Oracle Installation
Bitmap Index in Oracle Express Edition
April 18th, 2008 · 2 Comments
Today while exporting I came to know that Oracle XE does not support Bitmap Indexes.
Then to test it out, I [...]
Tags: Oracle Concepts · Oracle Database
ADR Command Interpreter (ADRCI) a new tool in Oracle 11g
December 17th, 2007 · No Comments
Recently while doing R&D, I came across the ADR Command Interpreter (ADRCI).
Introduced in Oracle Database Release 11g, it is a [...]