1, check your database alert log file if found and table space error please resolve first
2,stop your application service
3,relink all modules
4,stop your database services
3, restart your machine then start the all services .
4,then try adadmin
Hi,
I have already raised the SR below detail .
Oracle Support - November 22, 2010 2:04:23 PM GMT+05:30 [ODM Action Plan]
Hi
Thank you for your update
.
=== ODM Action Plan ===
1) Please upload the adadmin regarding relink ad module
2) Have you try to bounce your machine/server ?
3) Please check this
select * from ad_bugs where bug_number='7461070';
4) If nothing help, please backup your environment and apply patch '8502056','R12.AD.B.delta.2'
after re-try adadmin compile apps schema
Best Regards
Valerie
M.SENTHILKUMAR@CHAIN-SYS.COM - November 20, 2010 1:43:46 AM GMT+05:30 [Update from Customer]
Hi,
I have run the below query in apps/apps user only the output is no row selected .I have relinked all the file . still same problem .
please give the immediate soliution . some work is pending on related to this issue .
Regards,
Senthil
Oracle Support - November 19, 2010 2:24:23 PM GMT+05:30 [ODM Action Plan]
Hi
Thank you for your update
.
=== ODM Action Plan ===
1) According to adadmin.log file :
Connecting to APPLSYS......Connected successfully.
AD code level : [B.1]
Connecting to SYSTEM......Connected successfully.
the following select
SELECT bug_number,
decode(bug_number,
'9239089','R12.AD.B.delta.3',
'8502056','R12.AD.B.delta.2',
'7461070','R12.AD.B.1'
) n_patch ,
last_update_date
FROM ad_bugs
WHERE bug_number IN ('9239089','8502056','7461070');
should return something, how have you run the select, via sqlplus apps/apps ?
2) Please try to bounce your server/machine and re-try adadamin
3) Try relink AD module via adadmin
Best Regards
Valerie
M.SENTHILKUMAR@CHAIN-SYS.COM - November 18, 2010 10:21:31 PM GMT+05:30 [Update from Customer]
Hi,
I have executed the below query . output is no row selected
Previously adadmin is working fine No changes in my env .
Regards,
Senthil
Oracle Support - November 18, 2010 7:09:14 PM GMT+05:30 [ODM Action Plan]
Hi
Thank you for your update
.
=== ODM Action Plan ===
1) Please execute the following query
SELECT bug_number,
decode(bug_number,
'9239089','R12.AD.B.delta.3',
'8502056','R12.AD.B.delta.2',
'7461070','R12.AD.B.1'
) n_patch ,
last_update_date
FROM ad_bugs
WHERE bug_number IN ('9239089','8502056','7461070');
2) Does adadmin working fine previously ? If yes, what change on your environment ?
Best Regards
Valerie
M.SENTHILKUMAR@CHAIN-SYS.COM - November 18, 2010 6:31:37 PM GMT+05:30 [Update from Customer]
Hi,
1) Please could you details, why you are thinking that adadmin doens't work ? Have you wait long time ? It's take a lot of time to compile all objects in APPS schema
I understand it takes a long time, but I have already waited for 2 days .
Regards,
Senthil
M.SENTHILKUMAR@CHAIN-SYS.COM - November 18, 2010 5:46:17 PM GMT+05:30 [Update from Customer]
Hi,
I have already uploded the adadmin log below query output .
3) Please run the following query and provide the result
SQL> select product_group_id, product_group_name, release_name,product_group_type, argument1 from fnd_product_groups;
PRODUCT_GROUP_ID PRODUCT_GROUP_NAME
------------------------------------------------------------
RELEASE_NAME
PRODUCT_GROUP_TYPE ARGUMENT1
------------------------------
1 Default product group
12.1.1
Standard
4) Please run the following queries and provide the result
No row selected
Oracle Support - November 18, 2010 4:56:59 PM GMT+05:30 [ODM Action Plan]
Hi
Thank you for using My Oracle Support, I receive your service request, my name is Valerie dijon senior support engineer from ICM (Install and Configuration Management) team and I will be helping you with your issue.
.
=== ODM Action Plan ===
1) Please could you details, why you are thinking that adadmin doens't work ? Have you wait long time ? It's take a lot of time to compile all objects in APPS schema
2) Please upload your adadmin.log file for my review
3) Please run the following query and provide the result
select product_group_id, product_group_name, release_name,
product_group_type, argument1
from fnd_product_groups;
4) Please run the following queries and provide the result
SELECT bug_number, decode(bug_number,
'3438354', '11i.ATG_PF.H - BASE',
'4017300', '11i.ATG_PF.H RUP1',
'4125550', '11i.ATG_PF.H RUP2',
'4334965', '11i.ATG_PF.H RUP3',
'4676589', '11i.ATG_PF.H RUP4',
'5473858','11i.ATG_PF.H.delta.5',
'5903765','11i.ATG_PF.H.delta.6',
'6241631','11i.ATG_PF.H.delta.7'
) n_patch ,
last_update_date
FROM ad_bugs
WHERE bug_number IN (
'3438354', '4017300', '4125550', '4334965', '4676589','5473858', '5903765', '6241631');
SELECT bug_number, decode(bug_number,
'2141471', 'Applications DBA 11i.AD.F Mini Pack',
'2344175', 'Applications DBA 11i.AD.G Mini Pack',
'2673262', 'Applications DBA 11i.AD.H Mini Pack',
'4038964', 'Applications DBA 11i.AD.I.1 Mini Pack',
'4337683', 'Applications DBA 11i.AD.I.2 Mini Pack',
'4229931', '11i.AD.I.delta.2',
'4502904', 'Applications DBA 11i.AD.I.delta3 Post AD.I Consolidated 09/01/05',
'4712852', 'Minipack 11i.AD.I.4',
'4605654', 'Minipack 11i.AD.I. delta4',
'5161676', 'Minipack 11i.AD.I.5',
'5161680', 'Minipack 11i.AD.I.delta 5',
'6502082', 'Minipack 11i.AD.I.6',
'6502079', 'Minipack 11i.AD.I.delta.6',
'7429271', 'Minipack 11i AD.I.7'
) n_patch ,
last_update_date
FROM ad_bugs
WHERE bug_number IN (
'2141471','2344175','2673262','4038964','4337683','4229931','4502904','4712852','4605654','5161676','5161680','6502082','6502079','7429271');
Best Regards
Valerie
M.SENTHILKUMAR@CHAIN-SYS.COM - November 18, 2010 4:05:40 PM GMT+05:30 [Update from Customer]
Hi,
please find the below output . but i am using adadmin utlrp.sql is working fine .adadmin only not working .
OWNER COUNT(*)
----------
BILT 15
APPS 13
Regards,
Senthil
Oracle Support - November 18, 2010 3:25:31 PM GMT+05:30 [Notes]
Generic Note
Hi,
Please connect to the database as sys and run:
SQL> select owner, count(*) from dba_objects where status='INVALID' group by owner;
-- provide the output.
Thanks,
Marius
No comments:
Post a Comment