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

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

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

Recently while doing R&D, I came across the ADR Command Interpreter (ADRCI). Introduced in Oracle Database Release 11g, it is a command-line tool that one can use to manage diagnostic data. Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more. ADRCI has a rich command set, [...]

[Read more →]

Yesterday I was doing some r&d and tried to find trace file for my session. After lot of trouble I was able to find them. Last time its was a simple task, I just need to look at $ORACLE_BASE/SID/udump directory of the database server. But now trace files are stored in the the trace directory [...]

[Read more →]

As per my experience when working with PL/SQL code, DBMS_OUTPUT is one of the most frequently used package to display debugging information. But frequently when using 10G R1 and earlier versions, we come across something like as follows: ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line Single line limit of 255 bytes [...]

[Read more →]

Check out following: SQL> select * from test; COL1 ———- 1 1 1 1 1 SQL> alter table test add constraint test_idx primary key(col1) disable; Table altered. SQL> create index test_idx on test(col1); Index created. SQL> alter table test enable novalidate constraint test_idx; Table altered. SQL> insert into test values(1); insert into test values(1) * [...]

[Read more →]

When working with virtual columns recently I came across the following error: ORA-30553: The function is not deterministic Cause: The function on which the index is defined is not deterministic Action: If the function is deterministic, mark it DETERMINISTIC. If it is not deterministic (it depends on package state, database state, current time, or anything [...]

[Read more →]