Archive

Archive for June, 2009

concurrent manager has timed out waiting for the Output Post-processor to finish this request

June 18th, 2009 sam No comments

The Following error had occured while running the xml report “concurrent manager has timed out waiting for the Output Post-processor to finish this request”

Cause:

Once the Output Post Processor picks up the request, the XML Publisher engine is invoked to generate the final output file. The time that this takes will depends on various elements such as:

  • size of the XML Data File
  • complexity of the template
  • performance of the server
  • ….

By default a timeout will occur if it takes longer then 300 seconds (5 min.) for the XML Publisher engine to generate the output file. The Concurrent Request will complete with status Warning and the Request log file will contain Error Message

Solution:


Increase the value (in seconds) for the profile option ‘Concurrent:OPP Process Timeout’.

Categories: Uncategorized Tags:

ORA-3113 While Installating OracleAS 10.1.2 Infrastructure

June 17th, 2009 sam No comments

I was Installating OracleAS 10.1.2 Infrastructure on Sun 10. I was getting this error ORA-3113,

I had raised SR then I came to know OracleAS 10.1.2 is having bug with Sun 10. I had followed this Doc id Note 335645.1. After applying the patch it was working fine.

Categories: DBA, Oracle Tags:

SQL PLUS Command Line History

June 10th, 2009 sam No comments

The rlwrap (readline wrapper) utility provides a command history and editing of keyboard input

for any other command. This is a really handy addition to SQL*Plus and RMAN .


Download the latest rlwrap software from the following URL.
http://utopia.knoware.nl/~hlub/uck/rlwrap/

Unzip and install the software using the following commands.

gunzip rlwrap*.gz
tar -xvf rlwrap*.tar
cd rlwrap*
./configure
make
make check
make install


Run the following commands, or better still append then to the “.bash_profile” of the

oracle software owner.

alias sqlplus=’rlwrap ${ORACLE_HOME}/bin/sqlplus’
alias rman=’rlwrap ${ORACLE_HOME}/bin/rman’
alias expdp=’rlwrap ${ORACLE_HOME}/bin/expdp’

You can now start SQL*Plus or RMAN using “sqlplus” and “rman” respectively, and you will have

a basic command history and the current line will be editable using the arrow and delete keys.

Categories: Uncategorized Tags: