Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
{Disarmed} Role transition

{Disarmed} Role transition

2007-10-02       - By Niall Litchfield

 Back
On 10/2/07, Senthil Subramanian <skumar.sen@(protected)> wrote:
>
> Hi Carel-Jan,
>
> Thanks for your valuable input on this.
> I did try switching roles on a small 9i test database back in 2002, but
> never really implemented in a real production environment.
> We have a sound DR solution but never got a chance to test and implement
> the role transition.



Please don't take this personally - since the above is a fairly common thing
to happen, but if you never really tested in a real environment then how
(unless you have recently survived a disaster) do you know you have a sound
DR solution.

We have a 'sound' fire procedure where I work, when we actually tested it
about a year back we found it took 8 minutes to evacuate the (3 floor)
building and 20 to account for everyone. In other words testing the real
procedure in the real environment showed us some problems. DR is much the
same. You have to, regularly, test it for it to be worth the monetary
investment in setting it up.



--
Niall Litchfield
Oracle DBA
http://www.orawin.info

On 10/2/07, <b class="gmail_sendername">Senthil Subramanian</b> &lt;<a href=
"mailto:skumar.sen@(protected)">skumar.sen@(protected)</a>&gt; wrote:<div><span
class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left:
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Carel-Jan,<br><br>Thanks for your valuable input on this.<br>I did try
switching roles on a small 9i test database back in 2002, but never really
implemented in a real production environment.<br>We have a sound DR solution
but never got a chance to test and implement the role transition.
</blockquote><div><br>&nbsp;</div>Please don&#39;t take this personally - since
the above is a fairly common thing to happen, but if you never really tested in
a real environment then how (unless you have recently survived a disaster) do
you know you have a sound DR solution.
<br><br>We have a &#39;sound&#39; fire procedure where I work, when we actually
tested it about a year back we found it took 8 minutes to evacuate the (3 floor
) building and 20 to account for everyone. In other words testing the real
procedure in the real environment showed us some problems. DR is much the same.
You have to, regularly, test it for it to be worth the monetary investment in
setting it up.
<br></div><br><br clear="all"><br>-- <br>Niall Litchfield<br>Oracle DBA<br><a
href="http://www.orawin.info">http://www.orawin.info</a>