Latest Entries »


Using the default settings in rwservlet.properties in Oracle Forms & Reports 11.1.2.1 (released December 2012) has an issue where any generated PDF report (using getjobid) results in the following error:

REP-52262

The same error is reached if you try to access any other utility in rwservlet such as showenv, showjobs, etc. In older Oracle Forms 11g and 11gR2 releases, not having the parameter <webcommandaccess> set in rwservlet.properties is the equivalence to setting the parameter to L0 which means to block all rwservlet access.

To fix this error, you will need to apply the following:

  1. Go to %DOMAIN_HOME%configfmwconfigserversWLS_REPORTSapplicationsreports_11.1.2configuration and open rwservlet.properties (make a backup first).
  2. Add the following parameter below the <inprocess> parameter:
    1. <webcommandaccess>L2</webcommandaccess>
  3. Save and close the file
  4. Restart WLS_REPORTS

image

After applying the fix above, you should be able to view generated PDF reports when running Oracle Forms & Reports 11.1.2.1


 

 

rp

This Problem occurred for os 64 bit of 11g developer:

Step1.Go to Form builder/Report Builder Installed location Drive for finding cauprefs.ora file.Such As
Go to %ORACLE_INSTANCE%config\FRComponent\frcommon\TOOLS\admin
or
C:\Oracle\Middleware\asinst_1\config\FRComponent\frcommon\tools\admin
Step2.Make a backup of cauprefs.ora file to cauprefs.ora.bak
Step3.Edit cauprefs.ora in a text editor.
Step4.Find the following lines:
Reports.PluggableDataSourceFactories =
(“oracle.reports.plugin.datasource.xmlpds.XMLDataSourceFactory”,
“oracle.reports.plugin.datasource.jdbcpds.JDBCDataSourceFactory”,
“oracle.reports.plugin.datasource.textpds.TextDataSourceFactory”)
Step5.Replace the above line value to :Reports.PluggableDataSourceFactories = ()

NOTE: If you happen to use Pluggable Data Sources (PDS) in your reports, the workaround will not work.
Reference: See Oracle Support note 1395965.1 for more information.

Apex Install 5.2


Please flow flowing step to install apex 5.2 :

** Apex 5.2 installation you must need db 11g . Other version (lower from 5.2) support 10g or less.

1.Apex software folder keep desired drive (c,d,e,f) where u want to install apex software

I install my apex folder in “c” drive for your advantage & my apex folder name is “apex”.

Open cmd –>

cd C:\apex  [drive name:\apex software folder name]

  1. Your screen show as like after read desired folder bellow:

c:\apex [this is valid format for read apex folder]

connect to sqlplus as like –> sqlplus /nolog

  1. Connect sqlplus as sys dba –>  conn / as sysdba
  2. create a table-space for your apex user

SQL> CREATE TABLESPACE APEX_DATA datafile
‘C:\apex\APEX_data.DBF’
SIZE 1g;

  1.  SQL> @apexins APEX_DATA APEX_DATA TEMP /i/

20/25 min needs for installation.

  1. SQL> @apxldimg.sql [after this command show bellow message for give location image folder]

enter vavue 1: C:\ [if install “C” drive] or D:\apex or D:\apex\images [if install except “C” drive]

  1. Without any error image directory created then run flowing script:

SQL> @apxconf.sql [if install “C” drive] or @\apex\apxconf.sql [if install except “C” drive]

8 . You need to create apex user [admin user show as default] and password

[password must be contain Upper case,Special character ,lower character & number as like “Test!1”

Default port generated “8080”  [if you don’t change port then enter for next step .

  1. After this step you need to some alter statement:
    SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

User altered.

SQL> ALTER USER XDB ACCOUNT UNLOCK;

User altered.

SQL> ALTER USER APEX_040200 ACCOUNT UNLOCK; –version of release

User altered.

SQL> ALTER USER FLOWS_FILES ACCOUNT UNLOCK;

User altered.

SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

User altere

sql> exit

N.B : All sql statement must be connect sysdba connection with sql.

Your Apex software install completed.

  1. For enjoying finally test your connection go to your web browser & write this port for apex test :

localhost:8080/apex

11.There are issues with the configuration of the Static Files in your environment.
Please consult the “Configuring Static File Support” section in the Application Express Installation Guide
N.B :If u face flowing above error then —–>
conn / as sysdba —> Run apex_epg_config.sql. For example:

sql> @apex_epg_config.sql
—>enter value 1: C:\ [if install “C” drive] or D:\apex or D:\apex\images [if install except “C” drive]

  1. If you want to uninstall apex software connect with sysdba and run this script:

–> SQL>  @apxremov.sql

Please tuning with me for next tutorial on apex….


  1. All Data Import From User:

imp hr/hr@orcl fromuser=hr touser=hr file=G:\beckup\hr.dmp

2.All Data Export From User :

exp hr /hr @orcl file=D:\hr \Backup_Database\Delta1.dmp


Every Intern submit their document of internship-requisition-form,Monthly bill and Progress Report for monthly bill tk 4,800 for 6 months from Bangladesh Computer council under  Bangladesh National ICT Internship Programme.You can download from this site necessary paper to submit to BCC.

bcc_internship-requisition-form

bcc_monthly_bill

bcc_progress_report

%d bloggers like this: