Category: DDD(ORACLE)

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


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 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 (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


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




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
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 =
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.

  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

Connecting Oracle with MS-Access

MS-Access   and Oracle 10g Release  are used to illustrate the concepts. However, this procedure should work with Oracle 8i, 9i ,10g and upper databases, as well as various versions of MS-Access.

Step 1: Prepare the MS-Access environment

If you do not have a MS-Access environment, start by installing the required software and create a PubEvent table.

Continue reading

Hi Dear ,

I have faced this problem to a client server.I couldn’t open database and software then arise this problem.

ORA-16038: log 1 sequence# 35 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 1 thread 1:


—–Finally i had succeed flowing step :————-

****You can check the total and used size using below query

ORA-01033: ORACLE initialization or shutdown in progress :>>>>>

SQL> select status, database_status from v$instance;


SQL> select open_mode from v$database;
ERROR at line 1:
ORA-01507: database not mounted

SQL> alter database mount;
Database altered.
SQL> select status, database_status from v$instance;


SQL> select open_mode from v$database;



SQL> alter database open;
Database altered.
SQL> select status, database_status from v$instance;

SQL> select open_mode from v$database;
——-if database not altered then flow this process>>>>>>>>>
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[613], [42759], [42760], [], [], [], [], [], [], []

SQL> startup mount

ORACLE Instance started

SQL> recover database

Media recovery complete

SQL> alter database open

Database altered

****You can also  delete the  expired archive logs —

RMAN>connect target sys/sys@orcl;

RMAN>crosscheck archivelog all;

RMAN>delete expired archivelog all;

Also get problem try again bellow instruction :

SQL>  Show parameter control_files;

NAME                                 TYPE        VALUE

control_files                        string      C:\DB\ORADATA\ORCL\CONTROL01.C
SQL> select a.member,,b.status from v$logfile a ,v$log b where
2 and b.status=’CURRENT’;
MEMBER                                                       GROUP#   STATUS
C:\DB\ORADATA\ORCL\REDO01.LOG        1            CURRENT
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 2480971 generated at 12/08/2015 00:31:48 needed for thread 1
ORA-00289: suggestion :
ORA-00280: change 2480971 for thread 1 is in sequence #163
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:\DB\ORADATA\ORCL\REDO01.LOG  —-manually input this log file with locatin
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;

Database altered.

Thanks to all……………continue with me.