AD_APPLIED_PATCHES 2004-06-04 - By Goulet, Dick
Mike,
Your sane. From Metalink:
* fact: Oracle Application Object Library 11.5.4
* fact: AIX 4.3.3 Based Systems (64-bit)
* symptom: Patch fails with error ORA-01400 (See ORA-01400.ora-code.com): cannot insert NULL into
( "APPLSYS ". "AD_APPLIED_PATCHES ". "PATCH_NAME ")
* symptom: Error while inserting into AD_APPLIED_PATCHES.
* symptom: Error in calling adphistCreatePatchMastObj().
* symptom: Error in calling adphistCreateAppliedPatch().
* symptom: Error while uploading patches into the database
* symptom: Encountered errors while uploading information from applptch.txt
into the
database!
* symptom: Renaming file '/devtr11i/devtappl/admin/DEVT/applptch.txt '
to '/devtr11i/devtappl/admin/DEVT/applptch_fail_101403081634.txt '...
* change: Applying Patch 2408149.
* cause: < Bug:2679427 <http://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&id=2679427 > >.
The version of adphist.lpc is lower than 115.77
* cause: The corrupted applptch.txt. It contained the entry like "begin
aru db ", "alr_help " which is not in a standard format and it
gave an error while inserting the patch history information in
AD_APPLIED_PATCHES table.
.
At least now you know where he got the name from!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-- --Original Message-- --
From: April Wells [mailto:AWells@(protected)]
Sent: Friday, June 04, 2004 9:21 AM
To: 'oracle-l@(protected) '
Subject: RE: AD_APPLIED_PATCHES
It is a Oracle 11i table, and APPLSYS is an Oracle11i schema.
Your auditor needs to read the documentation for Oracle8i and Oracle E-Business Suite 11i before he demands what you can 't possibly deliver... or better yet, give him access to an id with select any table rights and have him find it.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@ >-- >-- >--
"Few people really enjoy the simple pleasure of flying a kite "
Adam Wells age 11
"Imagination is the highest kite one can fly. "
Lauren Bacall
-- --Original Message-- --
From: Mike Hennesy [mailto:orcl9ps8dba@(protected)]
Sent: Friday, June 04, 2004 7:53 AM
To: oracle-l@(protected)
Subject: AD_APPLIED_PATCHES
I am running an Oracle 8.1.7.3 database and have an auditor who is requesting that I produce a listing of all the rows in the table APPLYSY.AD_APPLIED_PATCHES. The problem I have is that table doesn 't exist. We do NOT have Oracle applications and I believe that this is a table that comes with Oracle Apps 11i.
The auditor is insistent that the table should be there and is wondering what I 'm trying to hide. If you can confirm this is an Oracle Apps table for me or let me know what I should run if it is just a script that I should have run that I missed.
All replies will remain confidential; I 'm just trying to verify my sanity.
Thanks - Mike
__ __
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! <http://messenger.yahoo.com/ > Messenger
The information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.
Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML xmlns:o = "urn:schemas-microsoft-com:office:office " > <HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >
<META content= "MSHTML 6.00.2800.1400 " name=GENERATOR > </HEAD >
<BODY >
<DIV > <SPAN class=822074813-04062004 > <FONT face=Arial color=#0000ff
size=2 >Mike, </FONT > </SPAN > </DIV >
<DIV > <SPAN class=822074813-04062004 > <FONT face=Arial color=#0000ff
size=2 > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=822074813-04062004 > <FONT face=Arial
color=#0000ff size=2 >Your sane. From Metalink: </FONT > </SPAN > </DIV >
<DIV > <SPAN class=822074813-04062004 > <FONT face=Arial color=#0000ff
size=2 > </FONT > </SPAN > </DIV > <SPAN class=822074813-04062004 > <!--StartFragment -- > <PRE > <UL >
<LI >fact: Oracle Application Object Library 11.5.4
<LI >fact: AIX 4.3.3 Based Systems (64-bit)
<LI >symptom: Patch fails with error ORA-01400 (See ORA-01400.ora-code.com): cannot insert NULL into
( "APPLSYS ". "AD_APPLIED_PATCHES ". "PATCH_NAME ")
<LI >symptom: Error while inserting into AD_APPLIED_PATCHES.
<LI >symptom: Error in calling adphistCreatePatchMastObj().
<LI >symptom: Error in calling adphistCreateAppliedPatch().
<LI >symptom: Error while uploading patches into the database
<LI >symptom: Encountered errors while uploading information from applptch.txt
into the
database!
<LI >symptom: Renaming file '/devtr11i/devtappl/admin/DEVT/applptch.txt '
to '/devtr11i/devtappl/admin/DEVT/applptch_fail_101403081634.txt '...
<LI >change: Applying Patch 2408149.
<LI >cause: < <A href= "http://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&id=2679427 " target=corner >Bug:2679427 </A >>.
The version of adphist.lpc is lower than 115.77
<LI >cause: The corrupted applptch.txt. It contained the entry like "begin
aru db ", "alr_help " which is not in a standard format and it
gave an error while inserting the patch history information in
AD_APPLIED_PATCHES table. </LI > </UL > </PRE >
<DIV > <A name=bottom >. </A > </DIV >
<DIV > <FONT face=Arial color=#0000ff size=2 > </FONT > </DIV >
<DIV > </SPAN > <SPAN class=822074813-04062004 > <FONT face=Arial color=#0000ff
size=2 >At least now you know where he got the name from!! </FONT > </SPAN > </DIV >
<DIV > <FONT face=Arial color=#0000ff size=2 > </FONT > </DIV >
<P > <FONT size=2 >Dick Goulet <BR >Senior Oracle DBA <BR >Oracle Certified 8i
DBA </FONT > </P >
<BLOCKQUOTE >
<DIV class=OutlookMessageHeader dir=ltr align=left > <FONT face=Tahoma
size=2 >-- --Original Message-- -- <BR > <B >From: </B > April Wells
[mailto:AWells@(protected)] <BR > <B >Sent: </B > Friday, June 04, 2004 9:21
AM <BR > <B >To: </B > 'oracle-l@(protected) ' <BR > <B >Subject: </B > RE:
AD_APPLIED_PATCHES <BR > <BR > </FONT > </DIV >
<DIV > <FONT face=Arial color=#0000ff size=2 > <SPAN class=016311813-04062004 >It
is a Oracle 11i table, and APPLSYS is an Oracle11i
schema. </SPAN > </FONT > </DIV >
<DIV > <FONT face=Arial color=#0000ff size=2 > <SPAN
class=016311813-04062004 > </SPAN > </FONT > </DIV >
<DIV > <FONT face=Arial color=#0000ff size=2 > <SPAN class=016311813-04062004 >Your
auditor needs to read the documentation for Oracle8i and Oracle E-Business
Suite 11i before he demands what you can 't possibly deliver... or better yet,
give him access to an id with select any table rights and have him find
it. </SPAN > </FONT > </DIV >
<DIV > </DIV >
<P > <FONT face= "Comic Sans MS " size=2 >April Wells </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Oracle DBA/Oracle Apps DBA </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Corporate Systems </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Amarillo Texas </FONT > <BR > <FONT
face= "Times New Roman " > </FONT > <FONT face= "Comic Sans MS "
size=2 >@>-->-->-- </FONT > <BR > <FONT face= "Comic Sans MS " size=2 >“Few
people really enjoy the simple pleasure of flying a kite” </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Adam Wells age 11 </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 > "Imagination is the highest kite one can
fly. " </FONT > <BR > <FONT face= "Comic Sans MS " size=2 >Lauren Bacall </FONT > </P >
<BLOCKQUOTE >
<DIV class=OutlookMessageHeader dir=ltr align=left > <FONT face=Tahoma
size=2 >-- --Original Message-- -- <BR > <B >From: </B > Mike Hennesy
[mailto:orcl9ps8dba@(protected)] <BR > <B >Sent: </B > Friday, June 04, 2004 7:53
AM <BR > <B >To: </B > oracle-l@(protected) <BR > <B >Subject: </B >
AD_APPLIED_PATCHES <BR > <BR > </DIV > </FONT >
<P > <SPAN
style= "FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier; mso-bidi-font-family: Courier " >I
am running an Oracle 8.1.7.3 database and have an auditor who is requesting
that I produce a listing of all the rows in the table
APPLYSY.AD_APPLIED_PATCHES. The problem I have is that table doesn 't exist.
We do NOT have Oracle applications and I believe that this is a table that
comes with Oracle Apps 11i. </SPAN > <SPAN
style= "FONT-SIZE: 10pt; FONT-FAMILY: Arial " > <o:p > </o:p > </SPAN > </P >
<P > <SPAN
style= "FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier; mso-bidi-font-family: Courier " >The
auditor is insistent that the table should be there and is wondering what
I 'm trying to hide. If you can confirm this is an Oracle Apps table for me
or let me know what I should run if it is just a script that I should have
run that I missed. </SPAN > <SPAN
style= "FONT-SIZE: 10pt; FONT-FAMILY: Arial " > <o:p > </o:p > </SPAN > </P >
<P > <SPAN
style= "FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier; mso-bidi-font-family: Courier " >All
replies will remain confidential; I 'm just trying to verify my
sanity. </SPAN > <SPAN
style= "FONT-SIZE: 10pt; FONT-FAMILY: Arial " > <o:p > </o:p > </SPAN > </P >
<P >Thanks - Mike </P >
<P >
<HR SIZE=1 >
<FONT face=arial size=-1 >Do you Yahoo!? <BR >Friends. Fun. <A
href= "http://messenger.yahoo.com/ " >Try the all-new Yahoo!
Messenger </A > </FONT > </BLOCKQUOTE >
<TABLE >
<TBODY >
<TR >
<TD bgColor=#ffffff > <FONT color=#000000 >The information contained in
this communication, <BR >including attachments, is strictly confidential
<BR >and for the intended use of the addressee only; <BR >it may also
contain proprietary, price sensitive, <BR >or legally privileged
information. Notice is hereby <BR >given that any disclosure,
distribution, dissemination, <BR >use, or copying of the information by
anyone other <BR >than the intended recipient is strictly prohibited
<BR >and may be illegal. If you have received this communication <BR >in
error, please notify the sender immediately by <BR >reply e-mail, delete
this communication, and destroy <BR >all copies. <BR > <BR >Corporate
Systems, Inc. has taken reasonable precautions <BR >to ensure that any
attachment to this e-mail has been <BR >swept for viruses. We
specifically disclaim all liability <BR >and will accept no
responsibility for damage sustained <BR >as a result of software viruses
and advise you to carry <BR >out your own virus checks before opening any
attachment. <BR > </FONT > </TD > </TR > </TBODY > </TABLE > </BLOCKQUOTE > </BODY > </HTML >
|
|
