tag:blogger.com,1999:blog-72143374629036522732024-03-13T07:38:22.108-07:00New To Apps DBASaravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.comBlogger109125tag:blogger.com,1999:blog-7214337462903652273.post-34916134547388355092022-05-30T08:13:00.000-07:002022-05-30T08:13:07.860-07:00An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_Hostname.<p><span style="font-family: inherit;"> </span></p><h3 class="post-title entry-title" itemprop="name" style="margin: 20px 0px 0px; position: relative;"><b><span style="font-family: inherit; font-size: medium;">Error:</span></b></h3><div class="post-body entry-content" id="post-body-7108617695729742374" itemprop="articleBody" style="line-height: 1.4; position: relative; width: 768px;"><p><b><span style="font-family: inherit;">"An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_<hostname>. There may be a network configuration problem, or the TNS listener on node FNDFS_<hostname> may not be running. Please contact your system administrator."</span></b></p><p><b><span style="font-family: inherit;"><br /></span></b></p><p><b><span style="font-family: inherit; font-size: medium;">Environment:</span></b></p><p><span style="font-family: inherit;">1) 19c database and 12.2.9 environment , Three node database and 2 Node (PCP)</span></p><p><b><span style="font-family: inherit;"><br /></span></b></p><p><b><span style="font-family: inherit; font-size: medium;">Recent Changes</span></b></p><p><span style="font-family: inherit;">Ran Auto config in all db and application node as a part of patching.</span></p><p><span style="font-family: inherit;"><br /></span></p><p><b><span style="font-family: inherit; font-size: medium;">Issue:</span></b></p><p><span style="font-family: inherit;">1) After starting all database and application services,</span></p><p><span style="font-family: inherit;">2) We are not able to see output and logs from the front end.</span></p><p><span style="font-family: inherit;">3) All application services started without error.</span></p><p><b><span style="font-family: inherit;"><br /></span></b></p><p><b><span style="font-family: inherit; font-size: medium;">Solution:</span></b></p><p><span style="font-family: inherit;">As the TNS and Context file has been backed up already before patching, We restore the whole TNS with the permission 755 and then the issue gets resolved.</span></p><p><br /></p></div>Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-78455657110887834552018-06-26T14:18:00.000-07:002018-06-26T14:18:01.653-07:00<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Scenario:</b><br />
<br />
Encountered the following error in Apps Front end while trying to access concurrent program logs/Output files which are generated before switch over.<br />
<br />
<b><span style="color: red;">Error:</span></b><br />
An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_STBYAPP2. There may be a network configuration problem, or the TNS listener on node FNDFS_STBYAPP2 may not be running. Please contact your system administrator.<br />
<br />
<span style="color: blue;"><b>Reason:</b></span><br />
<br />
The log and output file is pointing to the DR Apps Node, As it was generated during the DR was Primary. But the current log and ouput files has no issues in viewing.<br />
<br />
<span style="color: lime;"><b>Solution:</b></span><br />
<br />
Update the node name for Log and Output files with current App server Node Name<br />
<br />
select count(*) from fnd_concurrent_requests where LOGFILE_NODE_NAME = 'STBYAPP1';<br />
update fnd_concurrent_requests set LOGFILE_NODE_NAME = 'PRIMAPP1' where LOGFILE_NODE_NAME = 'STBYAPP1';<br />
<br />
select count(*) from fnd_concurrent_requests where LOGFILE_NODE_NAME = 'STBYAPP2';<br />
update fnd_concurrent_requests set LOGFILE_NODE_NAME = 'PRIMAPP2' where LOGFILE_NODE_NAME = 'STBYAPP2';<br />
<br />
select count(*) from fnd_concurrent_requests where OUTFILE_NODE_NAME = 'STBYAPP1';<br />
update fnd_concurrent_requests set OUTFILE_NODE_NAME = 'PRIMAPP1' where OUTFILE_NODE_NAME = 'STBYAPP1';<br />
<br />
select count(*) from fnd_concurrent_requests where OUTFILE_NODE_NAME = 'STBYAPP2';<br />
update fnd_concurrent_requests set OUTFILE_NODE_NAME = 'PRIMAPP2' where OUTFILE_NODE_NAME = 'STBYAPP2';</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-57649913997096412852017-12-21T08:50:00.000-08:002017-12-21T08:51:02.201-08:00Oracle EBS Forms Not opening in IE 11<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana, sans-serif;"><span style="font-family: Times, Times New Roman, serif;"><br /></span>
<b><span style="font-family: Times, Times New Roman, serif;">Env Details :</span></b></span><br />
<span style="font-family: Verdana, sans-serif;"><span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;">Oracle EBS version 12.1.3</span></span><br />
<span style="font-family: Verdana, sans-serif;">Windows 7 Prof SP1</span><br />
<span style="font-family: Verdana, sans-serif;">Java installed 8.151 - 32 bit installed in the path C:\Program Files (x86)\Java\jre1.8.0_151\bin\javaw.exe</span><br />
<span style="font-family: Verdana, sans-serif;">IE - 11 </span><br />
<span style="font-family: Verdana, sans-serif;"><span style="color: #38761d; font-family: Times, Times New Roman, serif;"><br /></span>
<b><span style="color: #38761d; font-family: Times, Times New Roman, serif;">Solution :</span></b></span><br />
<span style="font-family: Verdana, sans-serif;"><span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;">Needs to check the following if your forms did not open and asks every time to install the 7 u65 version of jre.</span></span><br />
<span style="font-family: Verdana, sans-serif;"><span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;">1. Install the 32 bit 8.151 version of JRE though you the 64 bit version of windows 7.</span></span><br />
<span style="font-family: Verdana, sans-serif;">2. While installing , Right click -> Run as a Administrator.</span><br />
<span style="font-family: Verdana, sans-serif;">3. Give necessary permission for java folder to the users as well to run and execute - If it is not there.</span><br />
<span style="font-family: Verdana, sans-serif;">4. Go to C:\Program Files (x86)\Java\jre1.8.0_151\bin -> Right click on Java, Javacpl, javaws -> Compatibility -> Run this Program in Comatibilty mode and select Win 7 asnd check privilege level as Run as Administrator. And change setting for all users as well.</span><br />
<span style="font-family: Verdana, sans-serif;">5. Control Panel -> Java -> General -> Settings (under Temporary Files Settings) "Delete Files".</span><br />
<span style="font-family: Verdana, sans-serif;">6. In the internet explorer 11 , navigate to settings –> Compatibility View Settings . Then add Domain name in the URL(ex: saravana.com) using Add this website option.</span><br />
<span style="font-family: Verdana, sans-serif;">7. Navigate to settings –> Internet options –> Security -> internet -> and Change the Custom level to minimum and change the option Enable XSS filter to Disable and Use Pop-up Blocker Disabled. Also make the ActiveX controls to enabled.</span><br />
<span style="font-family: Verdana, sans-serif;">8. Now Try to open the forms.</span></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com2tag:blogger.com,1999:blog-7214337462903652273.post-75811623276016657552017-06-22T18:09:00.003-07:002017-06-22T18:09:55.223-07:00ORA-04063: rule set "APPLSYS.WF_JAVA_DEFERRED_R" has errors<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Scenario:</b><br />
<b>------------</b><br />
<br />
Got the Forms error while adding responsibility to a user in R12.2.5. So, I did the workflow sync validation and it does not fixed. So, I ran autoconfig in Apps tier and it end up with Error and ran in db node and that too endup with the same error.<br />
<br />
1. Auto config in apps Node completed with the following Error:<br />
<br />
WARNING: [AutoConfig Error Report]<br />
The following report lists errors AutoConfig encountered during each<br />
phase of its execution. Errors are grouped by directory and phase.<br />
The report format is:<br />
<filename> <phase> <return appropriate="" code="" where=""></return></phase></filename><br />
<br />
[PROFILE PHASE]<br />
AutoConfig could not successfully execute the following scripts:<br />
Directory: /u01/app/DOYEN/fs2/FMW_Home/webtier/perl/bin/perl -I /u01/app/DOYEN/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/app/DOYEN/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/app/DOYEN/fs2/EBSapps/appl/au/12.0.0/perl -I /u01/app/DOYEN/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/app/DOYEN/fs2/inst/apps/DOYEN_sysapp02/admin/scripts/adexecsql.pl sqlfile=/u01/app/DOYEN/fs2/inst/apps/DOYEN_sysapp02/admin/install<br />
afwebprf.sql INSTE8_PRF 1<br />
<br />
AutoConfig is exiting with status 1<br />
<br />
2. Autoconfig in the DB node completed with the following error:<br />
<br />
WARNING: [AutoConfig Error Report]<br />
The following report lists errors AutoConfig encountered during each<br />
phase of its execution. Errors are grouped by directory and phase.<br />
The report format is:<br />
<filename> <phase> <return appropriate="" code="" where=""></return></phase></filename><br />
<br />
[PROFILE PHASE]<br />
AutoConfig could not successfully execute the following scripts:<br />
Directory: /u01/orahome/u01db/11.2.0.4/appsutil/install/DOYEN_system01<br />
afdbprf.sh INSTE8_PRF 1<br />
<br />
AutoConfig is exiting with status 1<br />
<br />
<br />
Now when i tried running the script (afwebprf.sql) manually which errored out in apps autoconfig and i faced the same error which we got in forms.<br />
<br />
Now i tried running the script (afdbprf.sh) manually which errored out in db node and found the same error:<br />
<br />
[orau01@system01:DOYEN_system01]# sh afdbprf.sh<br />
<br />
afdbprf.sh started at Thu Jun 22 19:54:29 IDT 2017<br />
<br />
The environment settings are as follows ...<br />
<br />
ORACLE_HOME : /u01/orahome/u01db/11.2.0.4<br />
ORACLE_SID : DOYEN<br />
PATH : /u01/orahome/u01db/11.2.0.4/perl/bin:/u01/orahome/u01db/11.2.0.4/perl/bin:/u01/orahome/u01db/11.2.0.4/bin:/usr/bin:/usr/sbin:/u01/orahome/u01db/11.2.0.4/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:.:.<br />
Library Path : /u01/orahome/u01db/11.2.0.4/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/orahome/u01db/11.2.0.4/lib:/usr/dt/lib:/u01/orahome/u01db/11.2.0.4/ctx/lib<br />
<br />
Executable : /u01/orahome/u01db/11.2.0.4/bin/sqlplus<br />
<br />
Enter the APPS username: apps<br />
Enter the APPS password:<br />
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 22 19:54:33 2017<br />
Copyright (c) 1982, 2013, Oracle. All rights reserved.<br />
<br />
Enter value for 1: Enter value for 2: Enter value for 3: Connected.<br />
[ FND_DB_WALLET_DIR ]<br />
Application Id : 0<br />
Profile Value : /u01/orahome/u01db/11.2.0.4/appsutil/wallet<br />
Level Name: SITE<br />
INFO<span class="Apple-tab-span" style="white-space: pre;"> </span> : Updated/created profile option value.<br />
.<br />
[ ECX_UTL_XSLT_DIR ]<br />
Application Id : 174<br />
Profile Value : /usr/tmp<br />
Level Name: SITE<br />
INFO<span class="Apple-tab-span" style="white-space: pre;"> </span> : Updated/created profile option value.<br />
.<br />
[ ECX_UTL_LOG_DIR ]<br />
Application Id : 174<br />
Profile Value : /usr/tmp<br />
Level Name: SITE<br />
INFO<span class="Apple-tab-span" style="white-space: pre;"> </span> : Updated/created profile option value.<br />
.<br />
[ BIS_DEBUG_LOG_DIRECTORY ]<br />
Application Id : 0<br />
Profile Value : /usr/tmp<br />
Level Name: SITE<br />
INFO<span class="Apple-tab-span" style="white-space: pre;"> </span> : Updated/created profile option value.<br />
.<br />
[ UTL_FILE_LOG ]<br />
Application Id : 1<br />
Profile Value : /usr/tmp, /u01/logout/tmp, /tmp/, /u01/oratmp/tempdata,<br />
/u01/logout/Agile, /u01/logout/Agile/in, /u01/logout/Agile/out,<br />
/u01/winshare/APAC/AP, /u01/winshare/crm/scorecard,<br />
/u01/winshare/APAC/WESTPAC, /u01/logout/cm,<br />
/u01/orahome/u01db/11.2.0.4/appsutil/outbound/DOYEN_system01<br />
Level Name : SITE<br />
INFO<span class="Apple-tab-span" style="white-space: pre;"> </span> : Error updating/creating profile option value.<br />
.<br />
begin<br />
*<br />
ERROR at line 1:<br />
ORA-04063: rule set "APPLSYS.WF_JAVA_DEFERRED_R" has errors<br />
ORA-06512: at "APPS.WF_EVENT", line 1194<br />
ORA-06512: at "APPS.FND_WF_ENGINE", line 1025<br />
ORA-06512: at "APPS.FND_PROFILE", line 1102<br />
ORA-06512: at "APPS.FND_PROFILE", line 2353<br />
ORA-06512: at "APPS.ADX_PRF_PKG", line 192<br />
ORA-06512: at line 42<br />
<br />
The above error seems to be an issue with the WF Ruleset.<br />
<br />
<b><span style="color: #38761d;">Solution:</span></b><br />
<b><span style="color: #38761d;">-----------</span></b><br />
<br />
Checked the following Rule Set is valid and found to be invalid.<br />
<br />
select object_name, object_type, status from dba_objects where object_name='WF_JAVA_DEFERRED_R';<br />
<br />
WF_JAVA_DEFERRED_R<span class="Apple-tab-span" style="white-space: pre;"> </span>RULE SET<span class="Apple-tab-span" style="white-space: pre;"> </span>INVALID<br />
<br />
<br />
This is because of the issues with the Workflow queues. So i did the clean up and enque processes as suggested in the below Note id.<br />
<br />
After following the following noteid , It fixed the issue:<br />
<br />
Fixing Invalid Workflow Rule Sets such as WF_DEFERRED_R and Related Errors on Workflow Queues:ORA-24033 (Doc ID 337294.1)<br />
<br />
Once it is done, I have checked the status of the Ruleset and it is valid.<br />
<br />
select object_name, object_type, status from dba_objects where object_name='WF_JAVA_DEFERRED_R';<br />
<br />
WF_JAVA_DEFERRED_R<span class="Apple-tab-span" style="white-space: pre;"> </span>RULE SET<span class="Apple-tab-span" style="white-space: pre;"> </span>VALID<br />
<br />
<br />
Now , Ran the Autoconfig and it has completed Normal.<br />
<br />
<br />
<br />
<br /></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-37468697981407526002017-06-14T06:01:00.003-07:002017-06-14T06:01:59.799-07:00Cause: cleanup_node failed due to ORA-01427<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Scenario:</b><br />
<b>------------</b><br />
<br />
The concurrent requests are going to Error in R12.2.5 and cannot view the log files as well.<br />
<br />
<span style="color: red;"><br /></span>
<b><span style="color: red;">Error:</span></b><br />
<b><span style="color: red;">------</span></b><br />
<br />
Cause: cleanup_node failed due to ORA-01427: single-row subquery returns more than one row<br />
ORA-06512: at "APPS.FND_CP_FNDSM", line 91<br />
ORA-06512: at line 1.<br />
<br />
The SQL statement being executed at the time of the error was: begin fnd_cp_fndsm.mark_killed_fndsm(:nn); end; and was executed from the file &ERRFILE.<br />
Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /test/app/fs2/EBSapps/appl/fnd/12.0.0/bin/FNDLIBR.<br />
<br />
Check that your system has enough resources to start a concurrent manager process. Contact your system : 13-JUN-2017 22:28:18<br />
Starting STANDARD Concurrent Manager : 13-JUN-2017 22:28:18<br />
<br />
Could not initialize the Service Manager FNDSM_DOYSER_DEV. Verify that DOYSER has been registered for concurrent processing.<br />
An error occured in client-side routine afpsmcsm for Service Manager FNDSM_DOYSER_DEV. The routine returned code 126.<br />
<br />
Check for preceding errors and as well as the service manager log file for further details."<br />
<br />
ORACLE error 1427 in cleanup_node<br />
<br />
<br />
<b>Cause:</b><br />
<b>---------</b><br />
<br />
After clone the node is not cleaned up which has the old values.<br />
<b><br /></b>
<b><span style="color: lime;">Solution:</span></b><br />
<b><span style="color: lime;">----------</span></b><br />
<br />
1. Shutdown the apps node.<br />
2. login to db node and run the following.<br />
<br />
sqlplus apps/apps<br />
<br />
sql>exec fnd_conc_clone.setup_clean;<br />
<br />
commit;<br />
<br />
sql>@cmclean.sql<br />
<br />
3. Run autoconfig in db tier.<br />
4. Run autoconfig in the apps tier and start the services.<br />
<br />
This should be fixed.<br />
<div>
<br /></div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-86600559142627696642017-05-31T14:35:00.002-07:002017-05-31T14:35:43.358-07:00ORA-20100 : Temporary file creation for FND_FILE failed.<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Scenario:</b><br />
<b>---------</b><br />
<br />
Request completed with the following error:<br />
<br />
ORA-20100 : Temporary file creation for FND_FILE failed.<br />
<br />
<b>Log file shows the following :</b><br />
<b>------------------------------------</b><br />
+---------------------------------------------------------------------------+<br />
Application Object Library: Version : 12.2<br />
<br />
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.<br />
<br />
FNDOAMCOL: OAM Applications Dashboard Collection<br />
+---------------------------------------------------------------------------+<br />
<br />
Updated system property java.protocol.handler.pkgs to HTTPClient<br />
Refreshing All ...<br />
Refreshing Applications System Status ...<br />
Refreshing Activity ...<br />
Refreshing Configuration Changes ...<br />
Refreshing Throughput ...<br />
Refreshing Exceptions Summary ...<br />
Refreshing User Alert Summary ...<br />
Collecting metric values for each aplication tier node ...<br />
Collecting metric values for each database instance ...<br />
Done Refreshing All ...<br />
Checking collected data for alerting ...<br />
Checking long running requests for alerting ...<br />
SQLException:<br />
java.sql.SQLException: ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.<br />
Directory &FILE_DIR is invalid, contact your system administrator.<br />
<br />
Action: Check that the directory is a valid directory with write permissions on the database server node and is listed under utl_file_dir para<br />
ORA-06512: at "APPS.FND_FILE", line 319<br />
ORA-06512: at "APPS.FND_FILE", line 364<br />
ORA-06512: at "APPS.FND_FILE", line 421<br />
ORA-06512: at "APPS.FND_OAM_COLLECTION", line 2786<br />
ORA-06512: at line 1<br />
<br />
Oracle error : An unexpected system error has been detected in Application code. Please contact System Administrator for assistance.Successfully resubmitted concurrent program FNDOAMCOL with request ID 84242340 to start at 31-MAY-2017 23:45:52 (ROUTINE=AFPSRS)<br />
<br />
+---------------------------------------------------------------------------+<br />
No completion options were requested.<br />
<br />
Output file size:<br />
----------------------------------------------------------------------------+<br />
<br />
<b>Reason:</b><br />
<b>---------</b><br />
<br />
The APPLPTEMP location points to a directory which is not in the utl_file directory in the database. So when the application user is trying to create a temp file in the location it is not allowed.<br />
<br />
<br />
grep -i APPLPTMP $CONTEXT_FILE<br />
<applptmp oa_var="s_applptmp" osd="UNIX">/doyen/app/DOYENSYS/fs2/inst/apps/DOYENSYS_sara1/temp</applptmp><br />
<br />
<br />
when i check the utl_file, It shows the following :<br />
<br />
/usr/tmp<br />
<br />
<br />
<b> Solution:</b><br />
=======<br />
<br />
1. Either add the following location in utl_file dir and restart the db /doyen/app/DOYENSYS/fs2/inst/apps/DOYENSYS_sara1/temp or<br />
2. Change the s_applptmp value to /usr/tmp and run autoconfig and try running the report again.<br />
<br />
<br /></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-30168179868047236242017-05-26T20:38:00.001-07:002017-06-20T17:35:23.078-07:00Configure Patch fs in R12.2<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b>Scenario:</b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Assuming the Run and Patch fs are going to be in single node and the Run fs is already configured and the instance is up and running.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Steps to configure the patch File system in R12.2</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Now to configure the patch fs. Do the following</div>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
1.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Run the preclone in the Run fs.<o:p></o:p></div>
<div class="MsoNormal">
[appdoyen@doyserv1 scripts]$ pwd<o:p></o:p></div>
<div class="MsoNormal">
/test/app/TEST/fs2/inst/apps/TEST_doyserv1/admin/scripts<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
[appdoyen@doyserv1 scripts]$ adpreclone.pl appsTier<o:p></o:p></div>
<div class="MsoNormal">
Copyright (c) 2011, 2014 Oracle Corporation<o:p></o:p></div>
<div class="MsoNormal">
Redwood Shores, California, USA<o:p></o:p></div>
<div class="MsoNormal">
Oracle E-Business Suite Rapid Clone<o:p></o:p></div>
<div class="MsoNormal">
Version 12.2<o:p></o:p></div>
<div class="MsoNormal">
adpreclone Version 120.31.12020000.20<o:p></o:p></div>
<div class="MsoNormal">
Enter the APPS User Password:<o:p></o:p></div>
<div class="MsoNormal">
Enter the Weblogic AdminServer password :<o:p></o:p></div>
<div class="MsoNormal">
Checking the status of the Oracle WebLogic Administration Server....<o:p></o:p></div>
<div class="MsoNormal">
Running perl /test/app/TEST/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/test/app/TEST/fs2/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml -servername=AdminServer -promptmsg=hide<o:p></o:p></div>
<div class="MsoNormal">
The Oracle WebLogic Administration Server is up.<o:p></o:p></div>
<div class="MsoNormal">
Running:<o:p></o:p></div>
<div class="MsoNormal">
perl /test/app/TEST/fs2/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/test/app/TEST/fs2/EBSapps/comn/util/jdk64 mode=stage stage=/test/app/TEST/fs2/EBSapps/comn/clone component=appsTier method= appctx=/test/app/TEST/fs2/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml showProgress<o:p></o:p></div>
<div class="MsoNormal">
Setting the wls environment<o:p></o:p></div>
<div class="MsoNormal">
Beginning application tier Stage - Mon May 22 18:39:00 2017<o:p></o:p></div>
<div class="MsoNormal">
/test/app/TEST/fs2/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /test/app/TEST/fs2/FMW_Home/webtier/lib/xmlparserv2.jar:/test/app/TEST/fs2/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/test/app/TEST/fs2/EBSapps/comn/java/classes:/test/app/TEST/fs2/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/test/app/TEST/fs2/FMW_Home/webtier/oui/jlib/ewt3.jar:/test/app/TEST/fs2/FMW_Home/webtier/oui/jlib/share.jar:/test/app/TEST/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/test/app/TEST/fs2/FMW_Home/webtier/jlib/ojmisc.jar:/test/app/TEST/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/test/app/TEST/fs2/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /test/app/TEST/fs2/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml -stage /test/app/TEST/fs2/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg<o:p></o:p></div>
<div class="MsoListParagraphCxSpFirst">
Log file located at /test/app/TEST/fs2/inst/apps/TEST_doyserv1/admin/log/clone/StageAppsTier_05221839.log<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
/ 20% completed<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Completed Stage...<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
2.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Now create a empty patch fs directory in our case (fs1).<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
/test/app/TEST/fs1<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
3.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Now shut down the runfs (fs2) and copy the EBS directory from run to patch fs<o:p></o:p><br />
<br />
Note: Now you can startall services in the run fs.<br />
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
[appdoyen@doyserv1 scripts]$ cd $RUN_BASE<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
[appdoyen@doyserv1 fs2]$ pwd<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
/test/app/TEST/fs2<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
[appdoyen@doyserv1 fs2]$ cp -rp EBSapps /test/app/TEST/fs1/<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
4.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Unset the env if anything is set already.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
5.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Go inside /test/app/TEST/fs1/EBSapps/comn/clone/bin of Patch fs ie) fs1 here , and run adcfgclone.pl<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
6.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Run perl adcfgclone.pl appsTier<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
7.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Give the port pool incremented by one on the run fs. for ex. If run fs is running in port pool 36 you can give as 37. Also check if it is already allcated by using <o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoNormal">
netstat -an|grep -i 8037</div>
<div class="MsoNormal">
</div>
<div class="MsoListParagraphCxSpFirst">
[appdoyen@doyserv1 bin]$ perl adcfgclone.pl appsTier</div>
<div class="MsoListParagraphCxSpMiddle">
<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Copyright (c) 2002, 2015 Oracle Corporation<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
Redwood Shores, California, USA<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Oracle E-Business Suite Rapid Clone<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Version 12.2<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
adcfgclone Version 120.63.12020000.56<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
***********************************************************<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
In AD-TXK Delta 7, we recommend you clone the run and patch<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
file systems in a single operation using the 'dualfs' option.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
Separate cloning of the run and patch file systems will be deprecated<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
************************************************************<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Enter the APPS password :<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Enter the Weblogic AdminServer password :<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Do you want to add a node (yes/no) [no] :<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<o:p> </o:p>Running: Context clone...</div>
<div class="MsoListParagraphCxSpMiddle">
<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<o:p> </o:p>Log file located at /test/app/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0522221213.log</div>
<div class="MsoListParagraphCxSpMiddle">
<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Target System File Edition type [run] : patch<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Enter the full path of Run File System Context file : /test/app/TEST/fs2/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Provide the values required for creation of the new APPL_TOP Context file.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Target System Fusion Middleware Home set to /test/app/TEST/fs1/FMW_Home<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Target System Web Oracle Home set to /test/app/TEST/fs1/FMW_Home/webtier<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Target System Appl TOP set to /test/app/TEST/fs1/EBSapps/appl<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Target System COMMON TOP set to /test/app/TEST/fs1/EBSapps/comn<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Target System Instance Top set to /test/app/TEST/fs1/inst/apps/TEST_doyserv1<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Target System Port Pool [0-99] : 37</div>
<div class="MsoListParagraphCxSpMiddle">
<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Checking the port pool 37<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
done: Port Pool 37 is free<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
Report file located at /test/app/TEST/fs1/inst/apps/TEST_doyserv1/admin/out/portpool.lst<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
The new APPL_TOP context file has been created :<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
/test/app/TEST/fs1/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
Check Clone Context logfile /test/app/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_05348.log for details.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Running Rapid Clone with command:<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Running:<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
perl /test/app/TEST/fs1/EBSapps/comn/clone/bin/adclone.pl java=/test/app/TEST/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/test/app/TEST/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/test/app/TEST/fs1/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml showProgress contextValidated=true<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<o:p> </o:p> </div>
<div class="MsoListParagraphCxSpMiddle">
FMW Pre-requisite check log file location : /test/app/TEST/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Running: /test/app/TEST/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/test/app/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /test/app/TEST/fs1/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml -stage /test/app/TEST/fs1/EBSapps/comn/clone -log /test/app/TEST/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Beginning application tier Apply - Mon Feb 22 22:20:59 2016<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
/test/app/TEST/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /test/app/TEST/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/java:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/test/app/TEST/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/test/app/TEST/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/test/app/TEST/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /test/app/TEST/fs1/inst/apps/TEST_doyserv1/appl/admin/TEST_doyserv1.xml -stage /test/app/TEST/fs1/EBSapps/comn/clone -showProgress -nopromptmsg<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
Log file located at /test/app/TEST/fs1/inst/apps/TEST_doyserv1/admin/log/clone/ApplyAppsTier_05222221.log<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
\ 100% completed<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Completed Apply...<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
Mon Feb 22 23:10:14 2016<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
Looking for incomplete CLONE record in ad_adop_session_patches table<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
The CLONE record status is COMPLETED<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
8.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Now source the env and startall .<o:p></o:p></div>
<br />
<div class="MsoNormal">
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com2tag:blogger.com,1999:blog-7214337462903652273.post-42516136179741958942016-10-20T12:11:00.000-07:002016-10-20T12:11:48.854-07:00AWR Snapshots are not generated Automatically<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Scenario:</b><br />
<b>------------</b><br />
<br />
Oracle Database 11.2.0.4. My AWR Snapshots were not being generated even though it was full enabled.<br />
<br />
Basic Checks done:<br />
------------------------<br />
<br />
1. Checked that I had enough free space on SYSAUX tablespace. I was using only 5GB of the total 20GB.<br />
2. System Parameter statistics_level was TYPICAL.<br />
3. DBMS_STATS.GET_STATS_HISTORY_RETENTION was to 30 days.<br />
4. The snapshot Interval was 60 minutes and Retention was 8 days.<br />
<br />
<b>Query Check the AWR intervals</b>:<br />
=========================<br />
select<br />
extract( day from snap_interval) *24*60+<br />
extract( hour from snap_interval) *60+<br />
extract( minute from snap_interval ) "Snapshot Interval",<br />
extract( day from retention) *24*60+<br />
extract( hour from retention) *60+<br />
extract( minute from retention ) "Retention Interval"<br />
from<br />
dba_hist_wr_control;<br />
<br />
5. Everything was OK,So finally checked the process responsible for AWR collection ie) MMON<br />
<br />
Now <span style="color: red;">MMON was not running.</span><br />
<br />
Now it is a critical system and CRP testing is going, So i cannot bring down the system but i need to spawn the MMON process.<br />
<br />
<b><span style="color: #6aa84f;">Here is the workaround :</span></b><br />
<b><span style="color: #6aa84f;">-------------------------------</span></b><br />
<br />
Just enable and disable the restricted sessions.<br />
<br />
SQL> alter system enable restricted session;<br />
<br />
System altered.<br />
<br />
SQL> alter system disable restricted session;<br />
<br />
System altered.<br />
<br />
Now check the MMON.<br />
<br />
[oradoyen@saravanadb trace]$ ps -ef|grep mmon<br />
oradoy 9732 1 3 18:46 ? 00:00:00 ora_mmon_ORADOY<br />
oradoy 9977 50953 0 18:47 pts/8 00:00:00 grep mmon<br />
oradoy 28182 1 0 Oct10 ? 00:11:40 ora_mmon_DEV<br />
<br />
Now AWR snapshots started generating.<br />
<br />
<b>Note</b> :<br />
<span style="color: lime;">Actually this is a bug in 11.2.0.4 and it is fixed by a patch 19565533.</span><br />
<br />
<b>Note id </b>: 2023652.1 AWR Snapshots Are Not Being Created Because MMON Is Not Being Respawned<br />
<br />
<br /></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-89284322290674914952016-10-06T12:29:00.002-07:002016-10-06T12:30:02.155-07:00ORA-20100: Temporary file creation for FND_FILE failed<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Scenario:</b><br />
<b>-----------</b><br />
<br />
While running a report in Payables or any of the program errored out and the log file shows the following error in R12.2.4<br />
<br />
<b>ORA-20100: Temporary file creation for FND_FILE failed</b><br />
<br />
<b><span style="color: red;">Error in Log file :</span></b><br />
<b><span style="color: red;">----------------------</span></b><br />
<br />
Enter Password:<br />
MSG-00101: Error occured in BATCH_APPROVAL()<br />
MSG-00102: Error Code : -20100<br />
MSG-00103: Error Message : ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.<br />
Directory &FILE_DIR is invalid, contact your system administrator.<br />
<br />
Action: Check that the directory is a valid directory with write permissions on the database server node and is listed under utl_file_dir para<br />
ORA-06512: at "APPS.FND_FILE", line 319<br />
ORA-06512: at "APPS.FND_FILE", line 364<br />
ORA-06512: at "APPS.FND_FILE", line 421<br />
ORA-06512: at "APPS.AP_APPROVAL_PKG", line 10672<br />
MSG-00000: When Others:User-Defined Exception<br />
REP-1419: 'beforereport': PL/SQL program aborted.<br />
REP-0069: Internal error<br />
REP-57054: In-process job terminated:Terminated with error:<br />
REP-1419: MSG-00101: Error occured in BATCH_APPROVAL()<br />
MSG-00102: Error Code : -20100<br />
MSG-00103: Error Message : ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.<br />
Directory &FILE_DIR is invalid, contact your system administrator.<br />
Action: Check that the directory is a valid directory with write permissions on the database server node and is listed under utl_file_dir para<br />
ORA-06512: at "APPS.FND_FILE", lin<br />
<br />
<b><span style="color: #38761d;">Solution:</span></b><br />
<b><span style="color: #38761d;">-----------</span></b><br />
<br />
1. Check the APPLPTMP for ex. /usr/tmp/SARA<br />
2. check whether that exsists in utl_file_directory.<br />
Note : Better to check with gv$ view like below<br />
select name,value FROM gv$parameter2 WHERE name='utl_file_dir' and value like '%SAR%';<br />
<br />
If it is not same which is in APPLPTMP. then<br />
<br />
a) Change the APPLPTMP location to any one location which is there in UTL file in env file and XML and bounce the concurrent<br />
or<br />
b) Add the same value which is in APPLPTMP to the UTL file location and bounce the db.<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-87113657016307369322016-09-13T07:10:00.000-07:002016-09-13T07:10:00.400-07:00XML-20201: (Fatal Error) Expected name instead of .<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="color: red;">Error </span></b>:<br />
-------<br />
<br />
Output post processor failed with below error processing report output<br />
<br />
Caused by: org.xml.sax.SAXParseException: <line 17018="" 25="" column="">: XML-20201: (Fatal Error) Expected name instead of .</line><br />
<br />
<span style="color: red;">Concurrent Log file Error</span>:<br />
-------------------------------<br />
<br />
Inserting invoice IDs into Temp Table<br />
SQL STATEMENT : INSERT into xxdn.xxdn_ACCOUNT_ANALYSIS_INVTEMP SELECT pv.VENDOR_NAME supplier_name, ai.invoice_num invoice_number, ab.INVOICE_DATE invoice_date, ab.invoice_amount invoice_amount, ab.invoice_id SOURCE_INVOICE_ID, ab.ORG_ID, ab.SET_OF_BOOKS_ID FROM hr_organization_information oi, hr_all_organization_units_tl ae, AND ae.language = USERENV('LANG') AND NVL(ORG_ID,85 ) = 85<br />
<br />
Inserted records into Temp Table successfully..<br />
<br />
+------------- 1) PUBLISH -------------+<br />
Beginning post-processing of request 321496451 on node USWS1HMSDVCM02 at 12-SEP-2016 16:48:24.<br />
Post-processing of request 321496451 failed at 12-SEP-2016 16:48:28 with the error message:<br />
One or more post-processing actions failed. Consult the OPP service log for details.<br />
<br />
<b><span style="color: red;">OPP Log file shows the following error</span>:</b><br />
--------------------------------------------------<br />
[9/12/16 4:48:28 PM] [UNEXPECTED] [2058679:RT321496451] java.lang.reflect.InvocationTargetException<br />
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br />
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
at java.lang.reflect.Method.invoke(Method.java:597)<br />
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)<br />
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5943)<br />
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)<br />
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)<br />
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:290)<br />
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)<br />
Caused by: org.xml.sax.SAXParseException: <line 17018="" 25="" column="">: XML-20201: (Fatal Error) Expected name instead of .</line><br />
at oracle.xdo.parser.v2.XMLError.flushErrorHandler(XMLError.java:441)<br />
at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:303)<br />
at oracle.xdo.parser.v2.XMLReader.scanNameChars(XMLReader.java:1061)<br />
at oracle.xdo.parser.v2.XMLReader.scanQName(XMLReader.java:1871)<br />
at oracle.xdo.parser.v2.XMLReader.getEntity(XMLReader.java:2125)<br />
at oracle.xdo.parser.v2.NonValidatingParser.parseContentEntityRef(NonValidatingParser.java:1654)<br />
at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1272)<br />
at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338)<br />
at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)<br />
at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)<br />
... 17 more<br />
<br />
<br />
<b><span style="color: #38761d;">Solution</span>:</b><br />
-----------<br />
<br />
select invoice_number from xxdn_ACCOUNT_ANALYSIS_INVTEMP where invoice_number like '%&%';<br />
<br />
The above table is taken from the output file of the concurrent request and this gives the output column in which the "&" is included in the value which is supposed to be removed.<br />
<br />
Checking output xml file Line 17018, we notice “&”, which is causing the issue.<br />
<invoice_num>2016-0402 & 2016-5829</invoice_num><br />
<br />
You will have to run a data fix for this particular output or check with the developers to fix this.<br />
<div>
<br /></div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-21553072942805671272016-04-07T07:49:00.001-07:002016-04-07T07:49:23.037-07:00 OPM:Can not find one alive process, Page cannot be displayed in 11i after running ADCFGCLONE <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: red;"><b>Issue</b></span> :<br />
<br />
After running adcfgclone in apps Tier in 11i , It got completed without any error and When we tried to login the First page comes but when we try to click on homepage, it redirects to blank page which says "<span style="color: red;">Page cannot be displayed</span>" instead of login page.<br />
<br />
<b>In Apache Error log</b>:<br />
--------------------------<br />
<br />
iAS Home/Apache/Apache/logs :<br />
<br />
[Tue Apr 5 20:41:43 2016] [error] [client 10.1.163.122] File does not exist:<br />
[Tue Apr 5 20:45:05 2016] [error] [client 10.1.163.122] File does not exist: /u01/app/doyen/doyencomn/html/US/ICXINDEX_doyen_usws1rdvcm04.htm<br />
[Tue Apr 5 20:45:22 2016] [error] OPM:Can not find one alive process<br />
[Tue Apr 5 20:45:22 2016] [error] [client 10.1.163.122] File does not exist: /servlets/weboam/oam/oamLogin/oam/oamLogin<br />
[Tue Apr 5 20:51:13 2016] [error] OPM: EW: Fail to start process with mod=JServ and grp=DiscoGroup, it's possible that your configuration file is not correct.<br />
[Tue Apr 5 20:51:13 2016] [error] OPM: EW: Fail to start process with mod=JServ and grp=OACoreGroup, it's possible that your configuration file is not correct.<br />
[Tue Apr 5 20:51:13 2016] [error] OPM: EW: Fail to start process with mod=JServ and grp=OACoreGroup, it's possible that your configuration file is<br />
[Tue Apr 5 21:12:18 2016] [notice] Oracle HTTP Server Powered by Apache/1.3.19 configured -- resuming normal operations<br />
[Tue Apr 5 21:25:42 2016] [error] [client 10.1.163.122] File does not exist: /u01/app/doyen/doyencomn/portal/doyen_doyendb02/favicon.ico<br />
[Tue Apr 5 21:25:45 2016] [error] [client 10.1.163.122] File does not exist: /u01/app/doyen/doyencomn/portal/doyen_doyendb02/favicon.ico<br />
[Tue Apr 5 21:25:45 2016] [error] OPM:Can not find one alive process<br />
<br />
In Jserv Logs:<br />
----------------<br />
<br />
[apdoyen@doyendb02 jvm]$ pwd<br />
/u01/app/doyen/doyenora/iAS/Apache/Jserv/logs/jvm<br />
<br />
vi OACoreGroup.4.stderr<br />
<br />
Please use CMSClassUnloadingEnabled in place of CMSPermGenSweepingEnabled in the future<br />
Could not create the Java virtual machine.<br />
<br />
vi XmlSvcsGrp.0.stdout<br />
<br />
/usr/bin/jdk1.6.0_30/jre/bin/java -DCLIENT_PROCESSID=8314 -verbose:gc -Xmx1600M -Xms1600M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:<br />
+PrintClassHistogram -XX:+UseTLAB -XX:+CMSPermGenSweepingEnabled -XX:+CMSClassUnloadingEnabled -Djava.awt.headless=false -DFND_TOP=/u01/app/doyen/doyenappl/fnd/11.5.0 -OA_HTML=/u01/app/doyen/doyencomn/html/ -DOA_MEDIA=/u01/app/doyen/doyencomn/java/oracle/apps/media/ -DOASMTPServer=doyendb02.hrbl.net -DWebProxyHost=doyendb02.hrbl.net -<br />
DWebProxyPort=80 -DWebProxyByPassDomain=hrbl.net -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.ssl=false -<br />
DOASSLCACertFile=/u01/app/doyen/doyenora/iAS/Apache/Apache/conf/ssl.crt/ca-bundle.crt -DOXTAInPoolSize=1 -DOXTAOutThreads=1 -DOXTAOutUseProxy=false -<br />
DOXTAOutProxyHost=doyendb02.hrbl.net -DOXTAOutProxyPort=80 -DCOMMON_TOP=/u01/app/doyen/doyencomn -DOXTALogDebugMsg=false -DEXTERNAL_URL=http://doyendb02.hrbl.net:8016 -<br />
Djbo.323.compatible=true -DAPPLRGF=/u01/app/doyen/doyencomn/rgf/doyen_doyendb02 -DJTFDBCFILE=/u01/app/doyen/doyenappl/fnd/11.5.0/secure/doyenapps01_doyen.dbc -<br />
Dservice.Logging.common.filename=/u01/app/doyen/doyencomn/temp/ibe.log -Dframework.Logging.system.filename=/u01/app/doyen/doyencomn/temp/fwsys.log -<br />
DIMT_COM_PROPERTY_FILE=/u01/app/doyen/doyenappl/imt/11.5.0/admin/scripts/imtjserv.properties -Dpoolsize=100 -Dminpoolsize=10 -Dpoolincrement=10 -Dpooldelayincrement=3 -<br />
DBNEDBCFILE=/u01/app/doyen/doyenappl/fnd/11.5.0/secure/doyenapps01_doyen.dbc -Djserv.session.getValue.instrument=false org.apache.jserv.JServ -opmpropfile<br />
/u01/app/doyen/doyenora/iAS/Apache/Jserv/etc/xmlsvcs.properties -opmhost doyendb02.hrbl.net -opmport 8116 -opmgrp XmlSvcsGrp -opmindex 0 -opmprocid 7<br />
-------------------------------<br />
Error occurred during initialization of VM<br />
<b>Could not reserve enough space for object heap</b><br />
---------------------------------------------------<br />
<br />
<span style="color: #38761d;"><b>Solution</b></span> :<br />
-----------<br />
<b>Cause </b>:<br />
---------<br />
<br />
System was unable to reserve 1600M java heap memory for the jvm …<br />
<br />
<b><span style="color: #6aa84f;">Solution :</span> </b><br />
<br />
Reduced the java heap memory to be used by the jvm to 512M (updated the s_jvm_options in the CONTEXT_FILE and ran autoconfig)<br />
<br />
<br />
<b>Before:</b><br />
<jvm_options oa_var="s_jvm_options" osd="Linux">-verbose:gc –Xmx1600M –Xms1600M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:</jvm_options><br />
+PrintClassHistogram -XX:+UseTLAB -XX:+CMSClassUnloadingEnabled</div>
<br />
<b>After:</b><br />
<b><br /></b>
<jvm_options oa_var="s_jvm_options" osd="Linux">-verbose:gc -Xmx512M -Xms512M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -</jvm_options><br />
XX:+PrintClassHistogram -XX:+UseTLAB -XX:+CMSClassUnloadingEnabled<br />
<br />
After this Run Autoconfig and retest the issue.<br />
<br />
<b>Reference</b> : Error 'Could not reserve enough space for object heap' During Initialization of JVM (Doc ID 1028915.1)Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-17013858603278708172016-03-29T14:31:00.001-07:002016-03-29T14:31:39.976-07:00Cause: The field PARAMETER.CONFIG could not be located or read in R12.2.4<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem Summary</b><br />
------------------------<br />
<br />
In R12.2.4 After clone , the concurrent ouput/log file shows the error Cannot read value from field PARAMETER.CONFIG<br />
<br />
<br />
Problem Description<br />
-------------------------<br />
<br />
After clone we get the following error in log and output file , but the request completed Normal<br />
<br />
<br />
<span style="color: red;">Error in the Output/log file</span> :<br />
---------------------------------<br />
<br />
Cause: The field PARAMETER.CONFIG could not be located or read.<br />
<br />
Action: This error is normally the result of an incorrectly-entered field name string in a trigger, or a field name string that does not uniquely specify a field in your form.<br />
<br />
Correct your trigger logic to precisely specify a valid field.<br />
<br />
<br />
<b><span style="color: cyan;">Env Details</span></b>:<br />
--------------<br />
<br />
2 DB node , 2 CM nodes , 2 APP nodes<br />
<br />
<b><br /></b>
<b>To find out the issue</b> :<br />
-------------------------<br />
<br />
<b>Enable Trace for FNDFS in all the nodes (CM) in listener file</b> :<br />
--------------------------------------------------------------------------<br />
<br />
( SID_DESC = ( SID_NAME = FNDFS )<br />
( ORACLE_HOME = /u01/app/doyuat/fs1/EBSapps/10.1.2 )<br />
( PROGRAM = /u01/app/DOYuat/fs1/EBSapps/appl/fnd/12.0.0/bin/FNDFS )<br />
(<br />
<br />
envs='EPC_DISABLED=TRUE,NLS_LANG=American_America.UTF8,LD_LIBRARY_PATH=/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib32:/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/app/DOYuat/fs1/EBSapps/appl/sht/12.0.0/lib,SHLIB_PATH=/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib32:/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/app/DOYuat/fs1/EBSapps/appl/sht/12.0.0/lib,LIBPATH=/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib32:/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/app/DOYuat/fs1/EBSapps/appl/sht/12.0.0/lib,APPLFSTT=DOYUAT_806_BALANCE;DOYUATB_FO;DOYUATB;DOYUAT;DOYUATA;DOYUAT_FO;DOYUATA_FO,APPLFSWD=/u01/app/DOYuat/fs1/inst/apps/DOYUAT_doyensys01/appl/admin;/u01/app/DOYuat/fs1/inst/apps/DOYUAT_doyensys01/appltmp;/u01/app/DOYuat/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/html/oam/nonUix/launchMode/restricted,<b>FNDFS_LOGGING=ON,FNDFS_LOGFILE=/u01/app/DOYuat/fs1/inst/apps/DOYUAT_doyensys01/logs/ora/10.1.2/network/FNDFS_DOYuat.log'</b> )))<br />
<br />
<br />
<b>Line to be added in the listener for enabling trace and path of the log file</b> :<br />
---------------------------------------------------------------------------<br />
<br />
FNDFS_LOGGING=ON,FNDFS_LOGFILE=/u01/app/doyuat/fs1/inst/apps/DOYUAT_doyensys01/logs/ora/10.1.2/network/FNDFS_doyuat.log'<br />
<br />
Now bounce the listener and check for the request log/output files.<br />
<br />
a) Retest the issue .<br />
<br />
b) You will get the FNDFS log output in the specified location as mentioned in the listener (In the node in which the particular request try to fetch log/output file).<br />
<br />
c) Now the error in the log file shows when connecting to the Node using the TWO_TASK it errored out.<br />
<br />
<br />
<span style="color: #38761d;"><b>Solution </b></span>:<br />
-----------<br />
<br />
1. Check the TWO_TASK in Application nodes.(ex.It can be DOYUAT_BALANCE)<br />
2. Check the listener file entry in Application Tier for the parameter APPLFSTT for which the TWO_TASK is included.<br />
3. The same two_task entry should be included in both the CM nodes APPLFSTT value in listener file.<br />
4. The Two_TASK value for CM nodes may be different like DOYUAT1 and DOYUAT2 for each nodes. But listener file should have included the Application's TWO_TASK for APPLFSTT.<br />
5. The same value should be added in TNSNAMES file in both the CM NODES through which the Application node will connect to the CM node.<br />
6. As a permenent fix change the value of APPLFSTT in XML file and run Autoconfig in CM node.<br />
<br />
<br />
Following tns entry needs to be added in the tnsnames.ora in Both CM Nodes :<br />
-------------------------------------------------------------------------------<br />
<br />
<b>DOYUAT_BALANCE</b>=<br />
(DESCRIPTION=<br />
(ADDRESS_LIST=<br />
(LOAD_BALANCE=YES)<br />
(FAILOVER=YES)<br />
(ADDRESS=(PROTOCOL=tcp)(HOST=doyensys02.doyen.net)(PORT=1526))<br />
(ADDRESS=(PROTOCOL=tcp)(HOST=doyensys01.doyen.net)(PORT=1526))<br />
)<br />
(CONNECT_DATA=<br />
(SERVICE_NAME=DOYUAT)<br />
)<br />
)<br />
<br />
<br />
After making the Entry in parameter (APPLFSTT) in listener file in Both CM nodes :<br />
<br />
<br />
( SID_DESC = ( SID_NAME = FNDFS )<br />
( ORACLE_HOME = /u01/app/doyuat/fs1/EBSapps/10.1.2 )<br />
( PROGRAM = /u01/app/DOYuat/fs1/EBSapps/appl/fnd/12.0.0/bin/FNDFS )<br />
(envs='EPC_DISABLED=TRUE,NLS_LANG=American_America.UTF8,LD_LIBRARY_PATH=/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib32:/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/app/DOYuat/fs1/EBSapps/appl/sht/12.0.0/lib,SHLIB_PATH=/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib32:/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/app/DOYuat/fs1/EBSapps/appl/sht/12.0.0/lib,LIBPATH=/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib32:/u01/app/DOYuat/fs1/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/app/DOYuat/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/app/DOYuat/fs1/EBSapps/appl/sht/12.0.0/lib,<b>APPLFSTT=DOYUAT_BALANCE</b>;DOYUAT_806_BALANCE;DOYUATB_FO;DOYUATB;DOYUAT;DOYUATA;DOYUAT_FO;DOYUATA_FO,APPLFSWD=/u01/app/DOYuat/fs1/inst/apps/DOYUAT_doyensys01/appl/admin;/u01/app/DOYuat/fs1/inst/apps/DOYUAT_doyensys01/appltmp;/u01/app/DOYuat/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/html/oam/nonUix/launchMode/restricted,FNDFS_LOGGING=ON,FNDFS_LOGFILE=/u01/app/DOYuat/fs1/inst/apps/DOYUAT_doyensys01/logs/ora/10.1.2/network/FNDFS_DOYuat.log' ) ) )<br />
<br />
<br /></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-30040941117836506282015-07-20T00:07:00.003-07:002015-07-20T00:07:56.262-07:00ORA-02085: database link DOYEN_REMOTEDB.DOYENSYS@USERNAME connects to DOYEN_REMOTEDB<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 class="post-title entry-title" itemprop="name">
</h3>
<div class="post-header">
</div>
<div dir="ltr" style="text-align: left;">
ERROR:<br />=====<br /><br />ORA-02085: database link DOYEN_REMOTEDB.DOYENSYS@USERNAME connects to DOYEN_REMOTEDB<br /><br />SCENARIO:<br />========<br /><br />SQL> select * from dual@DOYEN_REMOTEDB@USERNAME;<br />select * from dual@DOYEN_REMOTEDB@USERNAME<br /><br />ERROR in líne 1:<br /><br />ORA-02085: database link DOYEN_REMOTEDB.DOYENSYS@USERNAME connects to DOYEN_REMOTEDB<br /><br />REASON :<br />=======<br /><br />Global name in the database connecting to the remote is set to TRUE.<br /><br />select name, value from v$parameter where name in ('db_name', 'db_domain', 'global_names');<br />NAME VALUE<br />-------------------- ----------------------------------------<br />db_domain<br />global_names TRUE<br />db_name mydb<br /><br />SOLUTION :<br />=========<br /><br />Simply at local db set<br /><br />alter system set global_Names = FALSE;<br /><br />Now it will work fine. </div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-67170529609194140062015-05-27T07:01:00.000-07:002015-05-27T07:01:08.972-07:00ORA-04031: unable to allocate bytes of shared memory ("","","","")<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
<br /></div>
<div>
Problem Description:</div>
<div>
===============</div>
<div>
<br /></div>
<div>
Archive log has been shipped from primary but not able to apply in standby.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Error in DB Alert log:</div>
<div>
================</div>
<div>
<br /></div>
<div>
Completed Media Recovery</div>
<div>
Checking to start in-flux buffer recovery from SCN 1504.3738248416 to SCN (non-inclusive) 1504.3738248416</div>
<div>
<br /></div>
<div>
ORA-00283: recovery session canceled due to errors</div>
<div>
ORA-01237: cannot extend datafile 113</div>
<div>
ORA-01110: data file 113: '+DATA/doyensys_p/datafile/sysaux.408.874229253'</div>
<div>
ORA-17505: ksfdrsz:1 Failed to resize file to size 1126400 blocks</div>
<div>
ORA-00569: Failed to acquire global enqueue.</div>
<div>
Slave exiting with ORA-283 exception</div>
<div>
ORA-00283: recovery session canceled due to errors</div>
<div>
ORA-01237: cannot extend datafile 113</div>
<div>
ORA-01110: data file 113: '+DATA/doyensys_p/datafile/sysaux.408.874229253'</div>
<div>
ORA-17505: ksfdrsz:1 Failed to resize file to size 1126400 blocks</div>
<div>
ORA-00569: Failed to acquire global enqueue.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
When we checked for the size, We have enough size in the Disk. But still it shows the above error. So we checked for the asm log.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Asm alert log :</div>
<div>
===========</div>
<div>
<br /></div>
<div>
Wed May 20 19:55:29 2015</div>
<div>
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_ora_95265.trc (incident=353797):</div>
<div>
ORA-04031: unable to allocate bytes of shared memory ("","","","")</div>
<div>
Incident details in: /u01/app/oracle/diag/asm/+asm/+ASM1/incident/incdir_353797/+ASM1_ora_95265_i353797.trc</div>
<div>
Wed May 20 19:55:30 2015</div>
<div>
<br /></div>
<div>
Solution:</div>
<div>
========</div>
<div>
<br /></div>
<div>
There was some memory issue happened in the asm instance though it has the enough memory.So we have just bounced the asm instance.</div>
<div>
<br /></div>
<div>
1. Recovery needs to be cancelled, But it has already been done.</div>
<div>
2. shut down the database</div>
<div>
3. connect to asm instance</div>
<div>
4. srvctl stop asm -n nodename</div>
<div>
5. srvctl start asm -n nodename</div>
<div>
6. Now start the database in mount and started the recovery.</div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-25700621914063872262014-12-02T09:00:00.000-08:002014-12-02T09:11:38.893-08:00ORA-28000 "the account is locked" in the standby database<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<div>
<span style="color: red; font-family: Times, Times New Roman, serif;"><b>Scenario:</b></span></div>
<div>
<span style="color: red; font-family: Times, Times New Roman, serif;"><b>=======</b></span><br />
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">The user attempts to logon and gets an error ORA-28000 "the account is locked" in the primary database which is configure with Dataguard. The database </span><span style="font-family: Times, 'Times New Roman', serif;">administrator unlock this user's account in the primary database. Still, the user cannot connect to the standby, getting the same error <span style="color: red;">ORA-28000 </span>for the </span><span style="font-family: Times, 'Times New Roman', serif;">particular user, But the account status shows open in the standby.</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, 'Times New Roman', serif;"><b>In Standby :</b></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><b>=========</b></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">SYS@DOYEN > conn SARAVANA/saravana123123</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">ERROR:</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">ORA-28000: the account is locked</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">Warning: You are no longer connected to ORACLE.</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">SYS@DOYEN> select username,account_status from dba_users where username='SARAVANA';</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">USERNAME ACCOUNT_STATUS</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">------------------------------------------------------------------------------------------ </span></div>
<div>
<span style="font-family: Times, 'Times New Roman', serif;">SARAVANA OPEN</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, 'Times New Roman', serif;">SYS@DOYEN > @check_db</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"> Remote</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"> DbId Name Log Mode Open Mode Database Role Created Resetlogs Archive</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">----------- --------- ------------ -------------------- ---------------- ------------------- ------------------- --------</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"> 603299473 DOYEN ARCHIVELOG READ ONLY WITH APPLY PHYSICAL STANDBY 11/16/2013 20:16:17 07/22/2014 03:54:21 ENABLED</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: #38761d; font-family: Times, Times New Roman, serif;"><b>Solution :</b></span></div>
<div>
<span style="color: #38761d; font-family: Times, Times New Roman, serif;"><b>=======</b></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="background-color: white; color: #3d3d3d; line-height: 19.5px;"><span style="font-family: Times, Times New Roman, serif;"> This is because the standby is open read-only and cannot update any tables. When a user's account has to be locked on the standby database, it is locked only in memory there.</span></span><br />
<span style="background-color: white; color: #3d3d3d; line-height: 19.5px;"><span style="font-family: Times, Times New Roman, serif;"><br /></span></span>
<span style="background-color: white; color: #3d3d3d; line-height: 19.5px;"><span style="font-family: Times, Times New Roman, serif;">A privileged user (sysdba, the database administrator) must logon to the standby and unlock the account there. A message ORA-28015 "Account unlocked, but the database is open for read-only access" confirms that the account is now unlocked in the standby database. From then on, the user can logon to the standby database without getting any error.</span></span><br />
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">SYS@DOYEN > ALTER USER SARAVANA ACCOUNT UNLOCK;</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">ALTER USER SARAVANA ACCOUNT UNLOCK</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">*</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">ERROR at line 1:</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">ORA-28015: Account unlocked, but the database is open for read-only access</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">SYS@DOYEN > conn SARAVANA/saravana123123</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">Connected.</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, 'Times New Roman', serif;">Reference :</span><br />
<span style="font-family: Times, 'Times New Roman', serif;">========</span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Times, Times New Roman, serif;">ORA-28000 "the account is locked" in the standby database, even after the account was unlocked in the primary. (Doc ID 1600401.1)</span></div>
</div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-13646621384994127012014-09-26T09:08:00.000-07:002015-05-27T10:20:56.892-07:00ERROR: NMO not setuid-root (Unix-only)<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: red;"><b>ERROR:</b></span><br />
<br />
NMO not setuid-root (Unix-only).<br />
<br />
2014-09-26 08:48:57,680 [14768:EDA3E961:GC.SysExecutor.23 (NmoHealthTask)] INFO - Job Attributes: {JobID=AgentHealthMonitor:14117357376<br />
80, KeepAliveRequest=false} Job Command: {/u01/app/oracle/product/agent12c/sbin/nmo}<br />
2014-09-26 08:48:57,714 [14768:EDA3E961] WARN - NmoStatus: Unable to verify nmo.<br />
oracle.sysman.gcagent.target.interaction.execution.JobExecutionMgr$AuthenticatedJobExecutionException: ERROR: NMO not setuid-root (Unix-only)<br />
<br />
<b>The above error can result with the the below error:</b><br />
<br />
EM Event: Warning:DOYEN.com - Agent has stopped monitoring. The following errors are reported : Read timed out.<br />
<br />
<b>Cause 1: </b><br />
<br />
The <agent_home>/root.sh script was not run after the Agent installation. So, the owner of the nmo, nmb and nmo executables is not the root user:</agent_home><br />
<br />
$ cd <agent_base>/sbin</agent_base><br />
$ ls -ltr nm*<br />
<br />
<br />
For Example:<br />
<br />
$ cd /u03/cloud12c/agent12c/sbin<br />
$ ls -al nm*<br />
-rwxr-xr-x 1 oracle oracle 22754 Feb 11 11:08 nmb<br />
-rwxr-xr-x 1 oracle oracle 57835 Feb 11 11:10 nmhs<br />
-rwxr-xr-x 1 oracle oracle 40478 Jan 31 16:57 nmo<br />
...<br />
The correct permissions should have been set by executing the file <agent_home>/root.sh as root at the Agent installation/deployment time.</agent_home><br />
<br />
Note :<br />
=====<br />
After running the root.sh the following file will be created. Do confirm the same.<br />
<br />
/etc/oragchomelist<br />
<br />
<br />
You should get:<br />
<br />
$ ls -al nm*<br />
-rwxr-xr-x 1 root oracle 585242 Jul 6 2013 nmosudo<br />
-rws--x--- 1 root oracle 40007 Jul 6 2013 nmo<br />
-rws--x--- 1 root oracle 57835 Jul 6 2013 nmhs<br />
-rws--x--- 1 root oracle 22754 Jul 6 2013 nmb<br />
-rwxr-xr-x 1 root oracle 43494 Jul 6 2013 nmgsshe<br />
<br />
<br />
<b>Cause 2 :</b><br />
<br />
The root.sh script may have been run but the mount point for the <agent_home> is set with a 'nosuid' / 'nosetuid' option.</agent_home><br />
<br />
This can be verified by doing the mount command:<br />
<br />
mount<br />
or<br />
mount | grep nosuid<br />
and<br />
mount | grep nosetuid<br />
or<br />
check the entries in files: /etc/vfstab, /etc/fstab<br />
<br />
The 'nosetuid' option prevents mounted programs that have setuid permission to run with the permissions of their owners, regardless of who starts them. Without this<br />
<br />
option, if a program with setuid permission is owned by root, it will run with root permissions, regardless of who starts it.<br />
Sometimes 'nosuid' option is specified to protect the system against setuid programs that may run as root and damage the system.<br />
<b style="color: #38761d;"><br /></b>
<b style="color: #38761d;">SOLUTION :</b><br />
<br />
<b>Solution for Cause 1 :</b><br />
<br />
Login to the Cloud Control Agent host as root.<br />
Go to the Cloud Control Agent ORACLE_HOME directory<br />
<br />
Example: /u01/app/oracle/product/Middleware/agent/core/12.1.0.1.0<br />
<br />
Execute the root.sh script:<br />
<br />
# ./root.sh<br />
Log in to the Cloud Control Agent host as the Agent binaries owner (oracle for example)<br />
Check that the permissions are now correct:<br />
<br />
$ ls -ltr<br />
....<br />
-rwxr-xr-x 1 root em 585242 Jul 6 2013 nmosudo<br />
-rws--x--- 1 root em 40007 Jul 6 2013 nmo<br />
-rws--x--- 1 root em 57835 Jul 6 2013 nmhs<br />
-rws--x--- 1 root em 22754 Jul 6 2013 nmb<br />
-rwxr-xr-x 1 root em 43494 Jul 6 2013 nmgsshe<br />
Stop and restart the Cloud Control Agent:<br />
<br />
Example<br />
$ cd /u01/app/oracle/product/Middleware/agent/core/12.1.0.1.0/bin<br />
$ ./emctl stop agent<br />
$ ./emctl start agent<br />
<br />
<br />
<b>Solution for Cause 2</b><br />
<br />
If the mount point has nosuid option set, this problem should be corrected by the system administrator of the Unix system:<br />
<br />
Backup, edit and save the file /etc/vfstab or /etc/fstab for the mount point where the Agent has been installed and remove the 'nosuid' / 'nosetuid' option.<br />
On AIX operating system edit thefile /etc/filesystems.<br />
(u01 in our example)<br />
Stop and restart the Cloud Control Agent<br />
<br />
$ cd $ORACLE_HOME/bin<br />
<br />
Example<br />
<br />
$ cd /u01/app/oracle/product/Middleware/agent/core/12.1.0.1.0/bin<br />
$ ./emctl stop agent<br />
$ ./emctl start agent<br />
<br />
<br />
<b>Reference :</b><br />
<b>========</b><br />
<br />
Fix the Cloud Control Agent 12c error 'ERROR: NMO Not Setuid-root (Unix-only)' (Doc ID 146527)<br />
<br />
<br />
<br /></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com1tag:blogger.com,1999:blog-7214337462903652273.post-81937786591906842632014-09-05T11:12:00.001-07:002014-09-05T11:13:07.102-07:00Enable Auditing for DB user login attempts in 11g<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
1 - Add initialization parameters & bounce instance:<br />
<br />
alter system set audit_trail=db scope=spfile;<br />
audit_file_dest='/u01/app/oracle/mysid/mydir/'<br />
<br />
<br />
2 - Enable auditing of failed logion attempts :<br />
<br />
SQL> audit create session whenever not successful;<br />
<br />
<br />
To view all the login attempts either success or failure :<br />
========================================<br />
<br />
col os_username format a15<br />
col username format a15<br />
col terminal format a15<br />
col to_char(timestamp) format a35<br />
select os_username,username,terminal,to_char(timestamp,'MM-DD-YYYY HH24:MI:SS') from dba_audit_trail;<br />
<br />
<br />
To view the failed login attempts:<br />
========================<br />
<br />
set lines 130<br />
col OS_USERNAME for a20<br />
col USERNAME for a20<br />
col USERHOST for a20<br />
select OS_USERNAME,USERNAME,USERHOST,to_char(timestamp,'MM-DD-YYYY HH24:MI:SS'), returncode<br />
from dba_audit_trail<br />
where returncode > 0;<br />
<br />
<br />
<br />
Also we can able to see the sys failed and succesful login attempts in audit_file_dest files.</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-28949822632209232962014-08-16T06:19:00.001-07:002014-08-16T06:19:42.557-07:00HUNG IN AUTO SQL TUNING TASK<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<b>Scenario:</b><br />
<br />
In 11.2.0.3 database , we get alert in EM related to metric “Generic Operational Error” or "Generic Operational Error Status ". Occasionally when running Automatic SQL Tuning the following messages may appear in the alert log:<br />
<br />
<br />
<b>Error :</b><br />
<br />
Sat Aug 16 07:10:54 2014<br />
Process 0x0x85865e800 appears to be hung in Auto SQL Tuning task<br />
Current time = 1408187453, process death time = 1408187402<br />
Attempting to kill process 0x0x85865e800 with OS pid = 2289<br />
OSD kill succeeded for process 0x85865e800<br />
Sat Aug 16 07:13:00 2014<br />
<br />
<b>Solution:</b><br />
<br />
The explanation is that the AUTO SQL TUNING TASK has been over-running and as a protective measure it is auto killed. As thus, there is no fix for this and the solution is to disable this job and eventually manually execute it when<br />
<br />
needed. Here is how to do that:<br />
<br />
<b>To Disable the job:</b><br />
<br />
BEGIN<br />
DBMS_AUTO_TASK_ADMIN.DISABLE(<br />
client_name => ‘sql tuning advisor’,<br />
operation => NULL,<br />
window_name => NULL);<br />
END;<br />
/<br />
<br />
<br />
<b>To Enable it when needed.</b><br />
<br />
BEGIN<br />
DBMS_AUTO_TASK_ADMIN.ENABLE(<br />
client_name => 'sql tuning advisor',<br />
operation => NULL,<br />
window_name => NULL);<br />
END;<br />
/<br />
<br />
<br />
<b>Reference:</b><br />
<br />
“How to Avoid or Prevent Hung Auto Tuning Task Messages [ID 1344499.1]”</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-7292098089913858162014-04-17T07:47:00.004-07:002014-04-17T07:47:45.370-07:00ORA-00600: internal error code, arguments: [4194]<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">ERROR:</span></b></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">======</span></b></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">ORA-00600: internal error code, arguments: [4194], [#], [#], [], [], [], [], []</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">CAUSE:</span></b></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">======</span></b></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">This also can be cause by the following defect</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Bug 8240762 Abstract: Undo corruptions with ORA-600 [4193]/ORA-600 [4194] or ORA-600 [4137] after SHRINK</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Details:</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Undo corruption may be caused after a shrink and the same undo block may be used</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">for two different transactions causing several internal errors like:</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">SOLUTION:</span></b></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">=========</span></b></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">startup mount</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">SQL> select * from v$logfile;</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"> GROUP# STATUS TYPE</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">---------- ------- -------</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">MEMBER</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">--------------------------------------------------------------------------------</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">IS_</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">---</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"> 3 ONLINE</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">/u03/app/oracle/oradata/star/redo03.log</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">NO</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"> 2 ONLINE</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">/u03/app/oracle/oradata/star/redo02.log</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">NO</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"> GROUP# STATUS TYPE</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">---------- ------- -------</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">MEMBER</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">--------------------------------------------------------------------------------</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">IS_</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">---</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"> 1 ONLINE</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">/u03/app/oracle/oradata/star/redo01.log</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">NO</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">/u03/app/oracle/oradata/star/undotbs01.dbf</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">SQL> show parameter undo</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">NAME TYPE VALUE</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">------------------------------------ ----------- ------------------------------</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">undo_management string AUTO</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">undo_retention integer 900</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">undo_tablespace string UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><b>If We are using pfile then edit pfile and change the parameter :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><b>=========================================</b></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">undo_management=MANUAL</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">If you are using spfile then</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">====================</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">alter system set undo_management = MANUAL scope=spfile;</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">alter database open;</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Now drop the undo file</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">================</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">alter database datafile '/u03/app/oracle/oradata/star/undotbs01.dbf' offline drop;</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Drop the tablespace :</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">=============</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">drop tablespace UNDOTBS1;</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Got the following error while droping the tablespace:</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">===================================</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">ERROR at line 1:</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">ORA-01548: active rollback segment ‘_SYSSMU11$’ found, terminate dropping tablespace</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Inorder to ignore this error,</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">==================</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">SQL> select segment_name,status,tablespace_name from dba_rollback_segs where status='NEEDS RECOVERY';</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">SEGMENT_NAME STATUS TABLESPACE_NAME</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">------------------------------ ---------------- ------------------------------</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU1_3780397527$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU2_2232571081$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU3_2097677531$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU4_1152005954$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU5_1527469038$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU6_2443381498$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU7_3286610060$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU8_2012382730$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU9_1424341975$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_SYSSMU10_3550978943$ NEEDS RECOVERY UNDOTBS1</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">10 rows selected.</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Now shut down the database.</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">Add the lines in pfile inorder to ignore the segments that are used :</span></b></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">=================================================</span></b></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">_corrupted_rollback_segments =</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">('_SYSSMU1_3780397527$','_SYSSMU2_2232571081$','_SYSSMU3_2097677531$','_SYSSMU4_1152005954$','_SYSSMU5_1527469038$','_SYSSMU6_2443381498$','_SYSSMU7_32866100</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">60$','_SYSSMU8_2012382730$','_SYSSMU9_1424341975$','_SYSSMU10_3550978943$')</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">SQL> STARTUP MOUNT pfile='/u03/app/oracle/product/11.2.0/db_1/dbs/initstar.ora'</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">ORACLE instance started.</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Total System Global Area 242208768 bytes</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Fixed Size 2212168 bytes</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Variable Size 184553144 bytes</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Database Buffers 50331648 bytes</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Redo Buffers 5111808 bytes</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Database mounted.</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">SQL> alter database open;</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Database altered.</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">drop tablespace UNDOTBS1;</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">Now create the new undo tablespace with datafile.</span></b></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">====================================</span></b></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></b></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">create UNDO tablespace undotbs1 datafile '/u03/app/oracle/oradata/star/undotbs01_1.dbf' size 25m autoextend on next 1m maxsize 1024m;</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Now start with spfile and make undo_management AUTO.</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">alter system set undo_management = AUTO scope=spfile;</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">REFERENCE :</span></b></div>
<div style="text-align: left;">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">========</span></b></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Step by step to resolve ORA-600 4194 4193 4197 on database crash (Doc ID 1428786.1)</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<br /></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-76943750941347055892013-09-02T22:33:00.000-07:002013-09-02T22:33:16.266-07:00ORA-01741: illegal zero-length identifier<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Scenario:</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">While adding multiple schemas to a single workspace, we get the following error in Apex version 4.1 which is identified as a Bug in the version</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Error Faced :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>===========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"> "ORA-01741: illegal zero-length identifier"</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Solution:</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Run the following in the command prompt to add the schema</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b><br /></b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>SYNTAX:</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>======</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b><br /></b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">EXEC apex_instance_admin.add_schema( 'WORKSPACE_NAME', 'SCHEMA_TO_BE_ADDED' );</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">or </span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: 'Courier New', Courier, monospace;">conn as sysdba and Run the following </span></div>
<div style="text-align: left;">
<span style="font-family: 'Courier New', Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">BEGIN</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"> APEX_INSTANCE_ADMIN.ADD_SCHEMA( 'WORKSPACE_NAME', 'SCHEMA_TO_BE_ADDED');</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">END;</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">/</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: 'Courier New', Courier, monospace;"><b>Example :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">EXEC apex_instance_admin.add_schema( 'TEST', 'APEX_USER' );</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">PL/SQL procedure successfully completed.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Bug Reference :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>=============</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">http://www.inside-oracle-apex.com/</span></div>
<br /></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-90912595214628807532013-07-31T23:37:00.000-07:002013-07-31T23:37:50.686-07:00ORA-10873: file 1 needs to be either taken out of backup mode or media recovered<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Courier New, Courier, monospace;"><b>Scenario :</b></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br />Database went down due to power fluctuation and during that time hot backup was running.So once we started the database we face the following issue.<br /></span><br />
<span style="font-family: Courier New, Courier, monospace;"><b>Error:</b></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;">ORA-10873:
file 1 needs to be either taken out of backup mode or media recovered</span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;">ORA-01110:
data file 1: '/system/PROD/system01.dbf'</span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;"><b>Cause:</b><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;">Database in backup mode while it went down.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;"><b>Solution:</b><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;">Step 1 : Sqlplus
‘/as sysdba’<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;">Step 2 : startup mount<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;">Step 3 : Check
backup file using below command.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;"> select * from V$BACKUP<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;">Step 4 : The following command can be used to take all of
the data files out of hot backup mode:<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;"> ALTER DATABASE END BACKUP;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: Courier New, Courier, monospace;">Step 5 : Alter database open</span><span style="color: #002060;"><o:p></o:p></span></div>
</div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-37469358084429569872013-07-09T22:28:00.004-07:002013-07-09T22:28:48.097-07:00ORA-06508 : PL/SQL: Could not find the program unit being called in Package AHL_UMP_SR_GRP Procedure Create_SR_Unit_Effectivity<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;">When we run Depot report in 12.1.3, we end up with the following error.</span></div>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div class="MsoNormal">
<span style="color: red; font-family: Courier New, Courier, monospace;"><b>Error:</b></span></div>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div>
</div>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;">ORA-06508 : PL/SQL: Could not find the program unit being called in Package AHL_UMP_SR_GRP Procedure Create_SR_Unit_Effectivity.</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-7zwIxyjV9_o/UdzwyX5a92I/AAAAAAAAAXg/gM35dNi1KX8/s1600/error.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="167" src="http://1.bp.blogspot.com/-7zwIxyjV9_o/UdzwyX5a92I/AAAAAAAAAXg/gM35dNi1KX8/s320/error.png" width="320" /></a></div>
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;"><b>Cause :</b></span></div>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;">The following package AHL_UMP_SR_GRP is invalid or the dependent one is invalid.</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #38761d; font-family: Courier New, Courier, monospace;"><b>Solution:</b></span></div>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;">Check for those package and validate it and also compile the package body.</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: blue; font-family: Courier New, Courier, monospace;"><b>Reference :</b></span></div>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<span style="font-family: Courier New, Courier, monospace;">Service Request Tab: ORA-06508 Error In Package AHL_UMP_SR_GRP When Saving New Service Requests [ID 1069550.1]</span></div>
</div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-5534430909092088022013-07-04T04:15:00.001-07:002013-07-04T04:17:09.104-07:00Namespace prefix 'crosstab' used but not declared<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Courier New, Courier, monospace;">Report Completed with Warning which shows the OPP error in the log file in R12.1.1</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: blue; font-family: Courier New, Courier, monospace;"><b>Scenario </b></span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace;"><b>========</b></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">When we tried to run an cutom report using RTF we get the following error.</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: red; font-family: Courier New, Courier, monospace;"><b>OPP Error LOG</b></span><br />
<span style="color: red; font-family: Courier New, Courier, monospace;"><b>=============</b></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">Template code: XX_DOYEN_DEMO</span><br />
<span style="font-family: Courier New, Courier, monospace;">Template app: SQLAP</span><br />
<span style="font-family: Courier New, Courier, monospace;">Language: en</span><br />
<span style="font-family: Courier New, Courier, monospace;">Territory: US</span><br />
<span style="font-family: Courier New, Courier, monospace;">Output type: EXCEL</span><br />
<span style="font-family: Courier New, Courier, monospace;">[7/4/13 2:43:34 PM] [UNEXPECTED] [2036125:RT5861522] java.lang.reflect.InvocationTargetException</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at java.lang.reflect.Method.invoke(Method.java:597)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(XSLT10gR1.java:558)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:228)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:285)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:173)</span><br />
<span style="font-family: Courier New, Courier, monospace;">Caused by: oracle.xdo.parser.v2.XPathException: Namespace prefix 'crosstab' used but not declared.</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.xdo.parser.v2.XSLProcessor.reportException(XSLProcessor.java:806)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:571)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> ... 16 more</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: #38761d; font-family: Courier New, Courier, monospace;"><b>Solution:</b></span><br />
<span style="color: #38761d; font-family: Courier New, Courier, monospace;"><b>========</b></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">Pivot table is used in the RTF Template which is not supported on the latest version of BI . BI Publisher embedded with E-Business is based on 5.6.3 version has limited functionality. </span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">1. Please install Patch 12395372 - Update For BI Publisher Desktop 10.1.3.2.1 (5.6.3) for the E-business Publisher Desktop Utility.</span><span style="font-family: 'Courier New', Courier, monospace;">Ensure no Windows applications such as Outlook are running when installing the Utility. </span><br />
<span style="font-family: Courier New, Courier, monospace;">2. Select the Add-Ins tab.</span><br />
<span style="font-family: Courier New, Courier, monospace;">3. Select Insert - Crosstab.</span><br />
<span style="font-family: Courier New, Courier, monospace;">4. Create the Crosstab there using the Crosstab Wizard.</span><br />
<span style="font-family: Courier New, Courier, monospace;">5. After Crosstab is created, Validate Template to ensure it runs successfully.</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">OR</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;"><b>Work Around :</b></span><br />
<span style="font-family: Courier New, Courier, monospace;"><b>===========</b></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">Remove the Pivot table in the RTF Template and test by running the report</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;"><b>Reference :</b></span><br />
<span style="font-family: Courier New, Courier, monospace;"><b>=========</b></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">Note :1 Oracle.Xdo.Parser.V2.Xpathexception: Namespace Prefix 'Crosstab' Used But Not Declared [ID 743882.1]</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">Note :2 How to Create Crosstab Report In XML Publisher In E-Business Suite Publisher Desktop Utility? [ID 1313546.1]</span></div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-37217482790502720142013-07-03T00:03:00.001-07:002013-07-03T00:03:50.573-07:00REP-57054: In-process job terminated:Terminated with error<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="color: blue; font-family: Courier New, Courier, monospace;"><b>Scenario:</b></span></div>
<div style="text-align: left;">
<span style="color: blue; font-family: Courier New, Courier, monospace;"><b>=========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Active Users concurrent request Errored out.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="color: red; font-family: Courier New, Courier, monospace;"><b>Log file shows the following error:</b></span></div>
<div style="text-align: left;">
<span style="color: red; font-family: Courier New, Courier, monospace;"><b>==================================</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">APPLLCSP Environment Variable set to :</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">American_America.UTF8</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">'.,'</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Enter Password:</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">REP-3000: Internal error starting Oracle Toolkit.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">REP-3000: Internal error starting Oracle Toolkit.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">REP-0069: Internal error</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">REP-57054: In-process job terminated:Terminated with error:</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">REP-3000: Internal error starting Oracle Toolkit.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Following things needs to be checked :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>====================================</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Check $CONTEXT_FILE display variable. If this is correct we can ignore this and if there is any change then run autoconfig.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Now check the reports.sh file inside the apps $ORACLE_HOME/bin</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Display variable to set DISPLAY=192.168.1.20:1.0; export DISPLAY</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">If still issue persists then follow the below step.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="color: #38761d; font-family: Courier New, Courier, monospace;"><b>Solution:</b></span></div>
<div style="text-align: left;">
<span style="color: #38761d; font-family: Courier New, Courier, monospace;"><b>=========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">1. From Unix Run the following command:</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">$ /usr/lpp/X11/bin/xinit /usr/lpp/X11/bin/mwm -multiscreen -- :1 -vfb -force -x abx -x dbe -x GLX &</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">2. Bounce the Applications service/report server to take effect.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Note Id :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>=========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">After Upgrade to R 12.1.2 Running Any PDF Reports: Get: REP-3000,REP-0069 and REP-57054 [ID 1204553.1]</span></div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0tag:blogger.com,1999:blog-7214337462903652273.post-74856304711834765462013-07-01T03:17:00.006-07:002013-07-01T03:17:49.811-07:00Extension function error: Method not found 'xdo_format_currency'<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="color: blue; font-family: Courier New, Courier, monospace;"><b>Scenario :</b></span></div>
<div style="text-align: left;">
<span style="color: blue; font-family: Courier New, Courier, monospace;"><b>========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">After the upgrade from 12.0.4 to 12.1.3 the custom reports are completed with warning and the request log file show there was an error in OPP and OPP log file shows the following error</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="color: red; font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="color: red; font-family: Courier New, Courier, monospace;"><b>OPP Log file error :</b></span></div>
<div style="text-align: left;">
<span style="color: red; font-family: Courier New, Courier, monospace;"><b>=================</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Output file was found but is zero sized - Deleted</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Request log file :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>==============</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">DOYNODC module: DOYN-Print PO Stand</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Current system time is 13-JUN-2013 15:39:25</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">| Starting concurrent program execution...</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+-----------------------------</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Arguments</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">------------</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">p_po_num='1239'</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">p_po_num_to='1239'</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">------------</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"> APPLLCSP Environment Variable set to :</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"> Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">American_America.UTF8</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">'.,'</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Enter Password: </span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Report Builder: Release 10.1.2.3.0 - Production on Thu Jun 13 15:39:32 2013</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Copyright (c) 1982, 2005, Oracle. All rights reserved.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Start of log messages from FND_FILE</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">End of log messages from FND_FILE</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Executing request completion options...</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Output file size: </span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">111825</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+------------- 1) PUBLISH -------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Beginning post-processing of request 12668087 on node DEVSERVER at 13-JUN-2013 15:39:34.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Post-processing of request 12668087 failed at 13-JUN-2013 15:39:36 with the error message:</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">One or more post-processing actions failed. Consult the OPP service log for details.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+--------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+------------- 2) PRINT -------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Not printing the output of this request because post-processing failed.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+--------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Finished executing request completion options.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Concurrent request completed</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Current system time is 13-JUN-2013 15:39:36</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="color: red; font-family: Courier New, Courier, monospace;"><b>OPP log shows the following error :</b></span></div>
<div style="text-align: left;">
<span style="color: red; font-family: Courier New, Courier, monospace;"><b>==================================</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">[6/13/13 3:09:21 PM] [1651373:RT12668079] Completed post-processing actions for request 12668079.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">[6/13/13 3:38:53 PM] [OPPServiceThread1] Post-processing request 12668083.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">[6/13/13 3:39:34 PM] [OPPServiceThread0] Post-processing request 12668087.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">[6/13/13 3:39:35 PM] [1651373:RT12668087] Executing post-processing actions for request 12668087.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">[6/13/13 3:39:35 PM] [1651373:RT12668087] Starting XML Publisher post-processing action.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">[6/13/13 3:39:35 PM] [1651373:RT12668087] </span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Template code: XXDNPODC</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Template app: XXDN</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Language: en</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Territory: 00</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Output type: RTF</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">[6/13/13 3:39:36 PM] [1651373:RT12668087] Output file was found but is zero sized - Deleted</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">[6/13/13 3:39:36 PM] [UNEXPECTED] [1651373:RT12668087] java.lang.reflect.InvocationTargetException</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:599)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(XSLT10gR1.java:677)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:425)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:244)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Method not found 'xdo_format_currency'</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><span class="Apple-tab-span" style="white-space: pre;"> </span>... 18 more</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Cause :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>=======</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Templates were not regenerated properly.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="color: #38761d; font-family: Courier New, Courier, monospace;"><b>Solution :</b></span></div>
<div style="text-align: left;">
<span style="color: #38761d; font-family: Courier New, Courier, monospace;"><b>========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Regenerate templates and try again.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Steps to regenerate templates :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>=============================</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Responsibility: XML Publisher Administrator</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Navigation: Request > Run</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Submit Concurrent Process = XML Publisher Template Re-Generator </span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Select 'ALL'</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">Once templates are regenerated test the report again to see if issue is resolved.</span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>Reference :</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><b>==========</b></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Courier New, Courier, monospace;">AR to GL Reconciliation Report Error: Method not found 'xdo_format_currency' [ID 787974.1]</span></div>
</div>
Saravananhttp://www.blogger.com/profile/07598366078424067045noreply@blogger.com0