DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, May 31, 2016

Report Builder is not working

Error in Report Builder :

While running the rwbuilder.sh it has thrown error.


Cause:
The domain home was not set properly in the rwbuilder.sh


Solution:

To run the report builder we changed the DOMAIN_HOME in the rwbuilder.sh

Vi rwbuilder.sh
Change the DOMAIN_HOME=$$domain_home$$
To 
DOMAIN_HOME=/u01/app/oracle/config/domain/frsdomain


ORA-27492: unable to run job “APEX_040200.ORACLE_APEX_MAIL_QUEUE”: scheduler unavailable

ISSUE:
----------------
ORA-27492: unable to run job “APEX_040200.ORACLE_APEX_MAIL_QUEUE”: scheduler unavailable


SOLUTIONS:
------------------------

Alter system set job_queue_processes=1000;

LOAD JAVA FILES TO THE DB USER

[oracle@localhost jlib]$ loadjava -user HR mail.jar

Password:
********                                                                                                                                                              
[oracle@localhost jlib]$ !sq
sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 28 14:35:20 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



SQL>  begin dbms_java.grant_permission( 'HR', 'SYS:java.net.SocketPermission','localhost:PORT','connect,resolve');end;
  2  /

PL/SQL procedure successfully completed.

SQL> BEGIN dbms_java.grant_permission( 'HR','SYS:java.net.SocketPermission', 'zpop.hybridzimbra.com', 'resolve' );end;
  2  /

PL/SQL procedure successfully completed.

REP-51019 system user authentication is missing in oracle reports 12c

REP-51019 system user authentication is missing

1)  In  rwservlet.properties confirm SSO is already disabled:
<singlesignon>no</singlesignon>


2) Disable JAZN security.  In rwserver.conf that belongs to the reports server you will use (in-process, standalone or both) change the following entry:
...
<security class="oracle.reports.server.RWJAZNSecurity" id="rwJaznSec"/>
...
<job jobType="report" engineId="rwEng" securityId="rwJaznSec"/>
...

Add "!--" at the beginning and "--" at the end, in order oracle.reports.server.RWJAZNSecurity is commented:

<!--security class="oracle.reports.server.RWJAZNSecurity" id="rwJaznSec"/-->

and delete securityId="rwJaznSec" in jobType="report":

<job jobType="report" engineId="rwEng"/>

Old Value:

<job jobType="report" engineId="rwEng" securityId="rwJaznSec"/>

New Value:

<job jobType="report" engineId="rwEng"/>

3) Restart the reports server to apply the changes.

 If it was the in-process reports server, or you applied changes in rwservlet.properties, you need to restart WLS_REPORTS.


FRM:18124 failed to start one button run HTTP server to run form on web

FRM:18124 failed to start one button run HTTP server to run form on web

Cause:
In the runtime preferences the default URL will be invalid. We have to enter the proper path of browser.

Solution:
Open form builder
[oracle@forms bin]$ frmbld

Go to Edit --> Preferences --> Runtime

The Application Server URL will be in default. We have to provide the path of browser installed.

The below provided paths can be given in the Application Server URL :

1) /usr/lib/firefox-3.6.9
2) http://forms.doyensys.com:9001/forms/frmservlet



REP-58100: An error occurred starting the internal Web server at port $$Self.OHSPort$$. Error: java.lang.NumberFormatException:For input string: "$$Self.OHSPort We faced this error when we run the report in weblayout.

ERROR:
----------
REP-58100: An error occurred starting the internal Web server at port $$Self.OHSPort$$.
Error: java.lang.NumberFormatException:For input string: "$$Self.OHSPort
We faced this error when we run the report in weblayout.

Cause:
This is a plugin parameter whic should be added in rwbuilder.conf file after report builder is installed.

Solution :

1) Go the the below location  u01/app/oracle/config/domain/frsdomain/config/fmwconfig/components/ReportsToolsComponent/report_server1

2) Vi rwbuilder.conf

3) Add the below parameter :

<webLayout port="9002" docroot="/u01/app/oracle/config/domain/frsdomain/servers/WLS_REPORTS/tmp/_WL_user/reports_12.2.1/5ah7s6/war"/>

4) Link for fixing the above problem.
https://docs.oracle.com/middleware/1221/formsandreports/install-fnr/install.htm#CIHGBBEH


ERROR WHILE IMPORTING THE SCHEMA

ERROR WHILE IMPORTING

ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20100810134502" and "" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1606
ORA-24203: operation failed, queue table SYS.KUPC$DATAPUMP_QUETAB has errors

CAUSE:

Due to invalid object of sys

SQL> select object_name from all_objects where owner = 'SYS' AND status != 'VALID' order by 1;

OBJECT_NAME
------------------------------
AQ$KUPC$DATAPUMP_QUETAB
AQ$_KUPC$DATAPUMP_QUETAB_E
AQ$_KUPC$DATAPUMP_QUETAB_F
AQ$_KUPC$DATAPUMP_QUETAB_V
KUPC$DATAPUMP_QUETAB
SYSNTK+Hp6PazTJaPOReVq6YXqQ==
SYSNTsDyaSCdvTmySdAs5Ztvhbw==
SYSNTWBJ9iDeeSuyp/p6B7f1iEg==

8 rows selected.

SOLUTION:

Recreate queue tables,that were invalid

SQL> exec dbms_aqadm.drop_queue_table(queue_table =>'SYS.KUPC$DATAPUMP_QUETAB', force=> TRUE);

PL/SQL procedure successfully completed.




SQL> BEGIN
  2  dbms_aqadm.create_queue_table(queue_table =>                                               'SYS.KUPC$DATAPUMP_QUETAB',
  3    multiple_consumers => TRUE,
  4    queue_payload_type =>'SYS.KUPC$_MESSAGE',
  5    comment => 'DataPump Queue Table',
  6    compatible=>'10.1.0');
  7  EXCEPTION
  8    WHEN OTHERS THEN
  9      IF SQLCODE = -24001 THEN NULL;
 10      ELSE RAISE;
 11      END IF;
 12  END;
 13  /

PL/SQL procedure successfully completed.

Let's check invalids again:

SQL> select object_name from all_objects where owner = 'SYS' AND status != 'VALID' order by 1;

no rows selected


Saturday, May 28, 2016

Error while running the pre-clone script on oracle application

When we run the pre-clone script we are getting the below error as follows,

$ perl adpreclone.pl dbTier

Perl lib version (v5.8.8) doesn't match executable version (v5.10.0) at <physical PATH>/perl_32/lib/5.8.8/IA64.ARCHREV_0-thread-multi/Config.pm line 46.
Compilation failed in require at <physical PATH>/db/tech_st/11.2.0/appsutil/clone/ouicli.pl line 35.
BEGIN failed--compilation aborted at <physical PATH>/db/tech_st/11.2.0/appsutil/clone/ouicli.pl line 35.


Cause:


The root cause has been identified with the template file 'adxdbctx.tmp' in Release 120.34.12010000.14 :

This template is used as part of the Contextfile generation, where it is pointing to Perl libraries in Release 5.8.3, which has been used for the Database in Release 10.2.x. With the Database Release 11.2.x the Perl Release referenced and used in the Environment to Release 5.10.

Part of the template file :
...
<PERL5LIB oa_var="s_perl5lib" osd="unix" default="%s_db_oh%%/%perl%/%lib%/%5.8.3:%s_db_oh%%/%perl%/%lib%/%site_perl%/%5.8.3:%s_db_oh%%/%appsutil%/%perl">%s_perl5lib%</PERL5LIB>
...

The PERL5LIB is pointing to Perl Release 5.8.3, which is producingthe failure.

This issue has been reported via unpublished Bug 10083614 - '12.2: CHANGE DEFAULT FOR VARIABLE S_PERL5LIB IN ADXDBCTX.TMP'. At this stage there is no Patch available.




Please use following workaround to get the failure fixed :

1. Make a backup copy of your existing Database Contextfile.

2. Modify the context file as shown.
BEFORE :

...
<PERL5LIB oa_var="s_perl5lib" osd="unix">/<complete path>/db/tech_st/11.2.0/perl/lib/5.8.3: \\
/<complete path>/db/tech_st/11.2.0/perl/lib/site_perl/5.8.3:/<complete path>/db/tech_st/11.2.0/appsutil/perl</PERL5LIB>
...

AFTER :

...
<PERL5LIB oa_var="s_perl5lib" osd="unix">/<complete path>/db/tech_st/11.2.0/perl/lib/5.10.0: \\
<complete path>/db/tech_st/11.2.0/perl/lib/site_perl/5.10.0:/<complete path>/db/tech_st/11.2.0/appsutil/perl</PERL5LIB>
...
3. Execute Autoconfig to get the modifications implemented.

4. Verify the Perl Release and the PER5LIB Environment Setting in your Enviornment :
4.1 perl -v
4.2 echo $PERL5LIB

The Perl release Information should be in synch with the Release used in the PERL5LIB Environment Setting.

Get the Invalid objects details before and after apply the ad patches in oracle application

Get the Invalid objects details before and after apply the ad patches in oracle application.

In order to validate the invalid object list before and after the apply the patch, we can get know from the below logfile as follows,

Before apply the patch:

$APPL_TOP/admin/SID/log/50066_preenv.*

After apply the patch:

$APPL_TOP/admin/SID/log/50066_postenv.*

In the above logfile you came to know the invalid list changes for the patch

Friday, May 20, 2016

Host Concurrent Program completed with error in oracle application


When we run the shell script as a concurrent program and its completed with error as follows,


ERROR:

The executable file /devapp/apps/apps_st/appl/XXHN/1.0.0/bin/XXHNMVFILEINT1 for this concurrent program cannot be executed.

Contact your system administrator or support representative.


Verify that the execution path to the executable file

Cause:

The program has not soft linked with Fnd executable

Solution:

Create a soft link with the program name and fnd_executable.

--> Go to XXHNMVFILEINT1.prog and create the below link as follows,

ln -s -f $FND_TOP/bin/fndcpesr XXHNMVFILEINT1

Now, Try to re-run the program and check...


Thursday, May 19, 2016

Concurrent Manager getting down with FDPCRQ encountered an ORACLE error in Cloned Instance

Concurrent Manger are getting down with the following error in the ICM log as follows,

Routine FDPCRQ encountered an ORACLE error. ORA-04031: unable to
allocate 32 bytes of shared memory ("shared pool".


Review your error messages for the cause of the error. (=<POINTER>)
.............................................................................


APP-FND-01388: Cannot read value for profile option FND_MGR_STRTUP_THRES_TIME in routine &ROUTINE.


List of errors encountered:
.............................................................................
_ 1 _
Routine AFPCAL received failure code while parsing or running your
concurrent program CPMGR

Review your concurrent request log file for more detailed information.
Make sure you are passing arguments in the correct format.


Cause:

 FND_NODES Table not cleaned up properly

Solution:


1) Connect to SQLPLUS as APPS user and run the following statement :

select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like 'FNDSM%';

2) If you found that FND_NODES table having incorrect node entries (old node from the Source Instance) then execute the below query to clean it up,

EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;

3) Then Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers and webtiers to repopulate the required system tables.

then make sure now you are able to see the correct entries in the FND_NODES table and then start the application services.






Sunday, May 15, 2016

Rman Format options




You can use format options with backup commands to specify a location and name for backup pieces
%F - combines database identifier (DBID), day, month, year and sequence number
%U - Specifies a system generated unique filename (default)
%u - specifies an 8 character name
%d - name of database
%s - backup set number
%t - backup set timestamp
%p - piece number within the backup set

ORA-03206: maximum file size of XXXX blocks in AUTOEXTEND clause is out of range


If you are creating SMALLFILE datafile (default) with 8k blocks with datafile size greater than 32 GB than oracle will pop up with ORA-03206 error.


Because oracle will allow only up to 32 GB of datafile size limit with 8k blocks, maximum data blocks per datafile : 2^22 -1 = 4194303. So oracle simply won’t allow you in this case.


More than 32 GB datafile with 8k blocks than your datafile should be create with BIGFILE keyword.

Calculations are as follows:

Oracle allows max number of datafile is 65533 and Maximum data blocks per datafile is 2^22 -1 = 4194303 blocks.

Saturday, May 14, 2016

Oracle Reports REP-0069: REP-57054: Error

When any concurrent requests with the execution method Oracle Reports are submitted, temp files are created under the path of

$INST_TOP/logs/ora/10.1.2/reports/cache

These files are not purged with the "Purge Concurrent Request and/or Manager Data" program.These files can be deleted manually.

Sometimes, concurrent programs fail with following error message

"REP-0069: Internal error
REP-57054: In-process job terminated:Finished successfully but output is voided"

As workaround , setting cachesize parameter to value bigger than 0 can be used. But this workaround disables Cache cleanup functionality which is deletion of temp report file after Concurrent request completed successfully.So manual cleanup of cache will be needed.

According to Metalink Note : 1237834.1 permanent fix is as follow,

1. Apply Patch 14374587

2. Add the following property names and values into $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf

<property name="cacheSize" value="0"/>
<property name="noVoidedOutputError" value="yes"/>

With patch and setting these properties , accumulation of temp files are prevented.

3. But Autoconfig will overwrite above these changes when executed.To prevent this ,

a. Create custom directory under $FND_TOP/admin/template
    mkdir $FND_TOP/admin/template/custom

b. Copy $FND_TOP/admin/template/rwbuilder_conf_1012.tmp to this new directory
    cp $FND_TOP/admin/template/rwbuilder_conf_1012.tmp $FND_TOP/admin/template/custom

c. Add same entries into rwbuilder_conf_1012.tmp as above

   <property name="cacheSize" value="0"/>
   <property name="noVoidedOutputError" value="yes"/>

RC-20010 Fatal: Could not find Info-ZIP version 2.3 in the PATH

RC-20010 Fatal: Could not find Info-ZIP version 2.3 in the PATH
                                               
When you run db Tier pre cloning steps at R12 and later

$perl adpreclone.pl dbTier
RC-20010: Fatal: Could not find Info-ZIP's zip version 2.3 in the PATH. Please make sure you have zip version 2.3 in your PATH and rerun the command.zip 2.3 is normally available in $ORACLE_HOME/bin/ or it can be downloaded from http://www.info-zip.org/Zip.html

Cause:

The error is due to the fact that Zip Version 3.0 is installed in you $ORACLE_HOME/bin/zip file, where the adpreclone.pl asks for zip 2.3. It is very likely to have zip 2.3 at your Linux system!

Solution:

First check if indeed you have the zip 2.3
[root@ebs6 bin]# rpm -qa zip
zip-2.31-2.el5
If you have it, rename the zip 3.0 to old, and use the zip 2.3
$mv $ORACLE_HOME/bin/zip $ORACLE_HOME/bin/zip.old
$cp /usr/bin/zip $ORACLE_HOME/bin/zip
$chown oracle:oinstall $ORACLE_HOME/bin/zip
If you don't have the zip 2.3 version, download it and install it in the $ORACLE_HOME/bin directory. After that run $>perl adpreclone.pl dbTier

If you want to use Zip 3 , then install Patch : 9171651 and apply all prerequisites patches.