Monthly Archives: May 2013

How to export/import faster with export data pump with parallel clause

Example: Create database directory for physical path for backup. SQL> create directory DBBACKUP as ‘/archive/backup/’; Directory created. Grant permission to everyone. SQL> grant read,write on directory DBBACKUP to public; Grant succeeded. SQL> Start expdp with parallel clause [oracle@dbsrv ~]$ expdp … Continue reading

Posted in Oracle backup & recovery | Leave a comment

DataPump Export (EXPDP) Is Hanging While Exporting A Table With LONG Column

Symptoms DataPump export (expdp) is hanging while exporting a table with LONG column. Cause The default method that DataPump uses for loading and unloading data is direct path, when the structure of a table allows it. Note that if the table … Continue reading

Posted in Oracle backup & recovery | Leave a comment

ORA-04063: package body “SYS.KUPW$WORKER” has errors

Import: Release 10.2.0.5.0 – 64bit Production on Wednesday, 15 October, 2013 21:11:16 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real … Continue reading

Posted in Oracle backup & recovery | Leave a comment

Quickly start report server in oracle 10g application server

Start Report server in oracle 10g application server set ORACLE_HOME=E:\oracle\FRHome_1 set PATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jdk\jre\bin\classic;%ORACLE_HOME%\jdk\jre\bin\classic;%ORACLE_HOME%\jlib;%ORACLE_HOME%\jdk\bin rwserver server=repsrvrr start

Posted in Oracle Application server | Leave a comment

Configure JRE for forms 10g

Oracle Jinitiator is no longer compatible with oracle forms services. By default, Oracle Forms services 10g uses Jinitiator 1.3.1.22 to run Forms applications. Jinitiator was compatible with Internet Explorer 6 and Firefox version 2.0. But latest internet explorer like IE … Continue reading

Posted in Oracle Application server | 2 Comments

Creating Your Own Custom Welcome Page

Creating Your Own Custom Welcome Page To deploy a new Welcome page for Oracle Application Server: 1. Create the new Welcome page you want to use. This page must be named index.html. 2. Save the new Welcome page in a … Continue reading

Posted in Oracle Application server | Leave a comment

How to add instance to oracle RAC database

I am having two nodes oracle RAC  , now I am adding 3rd instance to this database. SQL> startup pfile=’/archive/pfile-rman.ora’ ORACLE instance started. Total System Global Area 1.0737E+10 bytes Fixed Size                  2114104 bytes Variable Size            1560284616 bytes Database Buffers         9160359936 … Continue reading

Posted in Oracle RAC | Leave a comment