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
 
opatch napply

opatch napply

2007-08-14       - By Niall Litchfield

 Back
nah! error checking is for wimps...

more seriously the issue that I have is that opatch is for one-offs. Some
one offs require other setup steps than just opatch - and might require for
example earlier one-offs to be rolled back first. The whole idea of
performing multiple one-off patches to a db install just seems wrong to me.
If you've waited long enough for there to be multiple one offs can't you
wait long enough for the patchset?

Niall

On 8/14/07, Tanel Poder <tanel.poder.003@(protected)> wrote:
>
> Hi,
>
> Try something like that:
>
> for i in [0-9]* ; do cd $i ; opatch apply ; cd .. ; done
>
> Of course test this out first in some dummy environment, also you might
> want
> to add some error checking to the script..
>
> Tanel.
> http://blog.tanelpoder.com
>
>
> > -- --Original Message-- --
> > From: oracle-l-bounce@(protected)
> > [mailto:oracle-l-bounce@(protected)] On Behalf Of Joe Smith
> > Sent: Tuesday, August 14, 2007 21:53
> > To: oracle-l@(protected)
> > Subject: opatch napply
> >
> > Is there a way to force opatch to apply all patches with one command?
> >
> > With the chagne in opatch it installs numerous directories like below:
> >
> > -bash-3 (See http://ash-3.ora-code.com).00$ ls -ltr
> > total 214
> > -rw-r--r--   1 oracle   dba         2871 Jun 12 09:32 patchmd.xml
> > drwxr-xr-x   4 oracle   dba          512 Jul  4 11:42 6121268
> > drwxr-xr-x   4 oracle   dba          512 Jul  4 11:42 6121267
> > drwxr-xr-x   4 oracle   dba          512 Jul  4 11:42 6121266
> > drwxr-xr-x   4 oracle   dba          512 Jul  4 11:42 6121264
> > drwxr-xr-x   4 oracle   dba          512 Jul  4 11:42 6121263
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


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

nah! error checking is for wimps... <br><br>more seriously the issue that I
have is that opatch is for one-offs. Some one offs require other setup steps
than just opatch - and might require for example earlier one-offs to be rolled
back first. The whole idea of performing multiple one-off patches to a db
install just seems wrong to me. If you&#39;ve waited long enough for there to
be multiple one offs can&#39;t you wait long enough for the patchset?
<br><br>Niall<br><br><div><span class="gmail_quote">On 8/14/07, <b class="gmail
_sendername">Tanel Poder</b> &lt;<a href="mailto:tanel.poder.003@(protected)">tanel
.poder.003@(protected)</a>&gt; wrote:</span><blockquote class="gmail_quote" style=
"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding
-left: 1ex;">
Hi,<br><br>Try something like that:<br><br>for i in [0-9]* ; do cd $i ; opatch
apply ; cd .. ; done<br><br>Of course test this out first in some dummy
environment, also you might want<br>to add some error checking to the script..
<br><br>Tanel.<br><a href="http://blog.tanelpoder.com">http://blog.tanelpoder
.com</a><br><br><br>&gt; -- --Original Message-- --<br>&gt; From: <a href=
"mailto:oracle-l-bounce@(protected)">oracle-l-bounce@(protected)</a>
<br>&gt; [mailto:<a href="mailto:oracle-l-bounce@(protected)">oracle-l-bounce
@(protected)</a>] On Behalf Of Joe Smith<br>&gt; Sent: Tuesday, August 14,
2007 21:53<br>&gt; To: <a href="mailto:oracle-l@(protected)">oracle-l
@(protected)
</a><br>&gt; Subject: opatch napply<br>&gt;<br>&gt; Is there a way to force
opatch to apply all patches with one command?<br>&gt;<br>&gt; With the chagne
in opatch it installs numerous directories like below:<br>&gt;<br>&gt; -
bash-3 (See http://ash-3.ora-code.com).00$ ls -ltr<br>&gt; total 214<br>&gt; -rw-r--r--&nbsp;&nbsp; 1 oracle
&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2871 Jun 12 09
:32 patchmd.xml<br>&gt; drwxr-xr-x&nbsp;&nbsp; 4 oracle&nbsp;&nbsp; dba&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;512 Jul&nbsp;&nbsp;4 11:42
6121268<br>&gt; drwxr-xr-x&nbsp;&nbsp; 4 oracle&nbsp;&nbsp; dba&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;512 Jul&nbsp;&nbsp;4 11:42
6121267
<br>&gt; drwxr-xr-x&nbsp;&nbsp; 4 oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;512 Jul&nbsp;&nbsp;4 11:42 6121266<br>&gt;
drwxr-xr-x&nbsp;&nbsp; 4 oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;512 Jul&nbsp;&nbsp;4 11:42 6121264<br>&gt; drwxr
-xr-x&nbsp;&nbsp; 4 oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;512 Jul&nbsp;&nbsp;4 11:42 6121263<br><br>--<br>
<a href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</a><br><br><br></blockquote></div><br><br clear="all"><br>--
<br>Niall Litchfield<br>Oracle DBA<br><a href="http://www.orawin.info">
http://www.orawin.info</a>