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

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 86
ORA-06512: na "SYS.DBMS_METADATA", linha 1245
ORA-04067: n?o executado, package body "DMSYS.DBMS_DM_MODEL_EXP" n?o existe
ORA-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 86
ORA-06512: na "SYS.KUPW$WORKER", linha 8353


Solution: DELETE FROM exppkgact$ WHERE SCHEMA='DMSYS';

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

1. Apply patch 6880880 (OPatch utility release 11.1.0.8.3) for ORACLE_COMMON

2. 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 apply

3. Restart the OMS
$ $ORACLE_BASE/Middleware/oms11g/bin/emctl start oms

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 sysdba
3. Using the following syntax, enter the new password:
> @apxxepwd password