terça-feira, 30 de novembro de 2010

Oracle Validated rpm

Preparing a Linux box for Oracle Clusterware and RAC installation is made fast and simple with the help of the Oracle Validated Rpm. Downloading and installing the rpm that match you Linux Kernel, automatize the install of the numerous components required to setup OCW and RAC on Linux.http://blogs.oracle.com/AlejandroVargas/Installing-the-Oracle-Validated-rpm-on-EL5....

quarta-feira, 17 de novembro de 2010

KUPW$WORKER.GET_TABLE_DATA_OBJECTS

ORA-39126: Erro fatal inesperado do processo de trabalho em KUPW$WORKER.GET_TABLE_DATA_OBJECTS [] ORA-31642: falha na seguinte instruc?o de SQL: BEGIN "DMSYS"."DBMS_DM_MODEL_EXP".SCHEMA_CALLOUT(:1,0,1,'11.00.00.00.00'); END;ORA-06512: na "SYS.DBMS_SYS_ERROR", linha 86ORA-06512: na "SYS.DBMS_METADATA", linha 1245ORA-04067: n?o executado, package body "DMSYS.DBMS_DM_MODEL_EXP" n?o existeORA-06508: PL/SQL: n?o foi possivel encontrar a unidade de programa que esta a ser chamada : "DMSYS.DBMS_DM_MODEL_EXP"ORA-06512: na "SYS.DBMS_SYS_ERROR", linha 86ORA-06512:...

segunda-feira, 15 de novembro de 2010

FMW Welcome Page Application (11.1.0.0.) Down

Bug Title: BROKEN 'FMW WELCOME PAGE APPLICATION' APPLICATION DISCOVERED OUT-OF-BOX1. Apply patch 6880880 (OPatch utility release 11.1.0.8.3) for ORACLE_COMMON2. Apply patch 9431704- Stop OMS$ cd $ORACLE_BASE/Middleware/oms11g/bin$ ./emctl stop oms -all- Unzip patch 9431704$ cd /home/oracle$ unzip p9431704_111120_Generic.zip- Apply patch$ cd /home/oracle/9431704$ export $ORACLE_BASE/Middleware/oracle_common$ $ORACLE_BASE/Middleware/oracle_common/OPatch/opatch apply3. Restart the OMS$ $ORACLE_BASE/Middleware/oms11g/bin/emctl start ...

segunda-feira, 1 de novembro de 2010

Reset INTERNAL password in APEX

To change the password for the ADMIN account:1. Change your working directory to $ORACLE_HOME/apex.2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:$ sqlplus sys/SYS_password as sysdba3. Using the following syntax, enter the new password:> @apxxepwd passw...