Friday, October 24, 2008

Resync Standby Using Automatic Gap Sequence fix

Shutdown standby and startup mount.
Do :

SELECT * FROM V$ARCHIVE_GAP;

THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 4115 4123

On primary if archives are not in the default path then use rman to restore them:
restore archivelog from sequence 4115 until sequence 4123;

Then on standby
alter database recover managed standby database disconnect;
To start the gap sequence fix and to apply all archives.

Wednesday, October 22, 2008

TNS-12516, ORA-12516,ORA-12519, TNS-12519 , ORA-12520

TNS-12516 TNS:listener could not find instance with matching protocol stack
ORA-12516, TNS:listener could not find available handler with matching protocol stack
TNS-12519 TNS: no appropriate service handler found

ORA-12519 TNS: no appropriate service handler found
ORA-12520 TNS:listener could not find available handler for requested type of server

If you see any of these errors you must increase the processes parameter.

Explanation

PMON is responsible for updating the listener with information about a particular instance such as load and dispatcher information. Maximum load for dedicated connections is determined by the PROCESSES parameter. The frequency at which PMON provides SERVICE_UPDATE is maximum at 10 minutes.

Since SERVICE_UPDATE can take as long as 10 minutes, there can be a difference between the current instance load according to the listener and the actual instance load.

When the listener believes the current number of connections has reached maximum
load, it may set the state of the service handler for an instance to "blocked"
and begin refusing incoming client connections with either of the following
errors:

TNS-12516 TNS:listener could not find instance with matching protocol stack
TNS-12519 TNS:no appropriate service handler found

Additionally, an ORA-12520 error may appear in the listener log.

The output of the LSNRCTL services command will likely show that the service handler is "blocked".

Tuesday, October 14, 2008

Index block splits

A nice article about index block split

http://www.confio.com/English/Tips/Index_Block_Split.php

Manually recreate dbconsole 10gR2

First remove repository and files:

Single Instance : $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop

RAC Database : $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop -cluster

Then create again :

Single Instance : $ORACLE_HOME/bin/emca -config dbcontrol db -repos create
RAC Database : $ORACLE_HOME/bin/emca -config dbcontrol db -repos create -cluster

Oracle 10g - Manually Create a Physical Standby Database Using Data Guard

A very nice link on OraFaq.

http://www.orafaq.com/node/2030

Friday, October 10, 2008

Hi to all again

I have months to update my blog. I had thoughts to change it from only Oracle blog to Systems & Oracle blog. 

Now plans have changed again and i will post Oracle issues again and more frequently i believe.