Desculpem a Ausência !! Voltando a ativa !!

Olá Pessoal,

Desculpem minha ausência  projetos, suporte, vida pessoal, projetos pessoais acabaram me afastando do BLOG, em breve estarei postando todas as novidades que aprendi nesse meio tempo e cenários que me fizeram puxar os cabelos kkk.

Grande Abraço a todos,

Hey Guys,

Sorry my absence, you know, personal projects, wife, son, professional work/projects all of it pushed me away from the blog but I'm coming back with everything that I learned and some scenarios that made me take my hairs out kkkkkk

[]s,

Vinicius

Change IP Address of EBS R12

Hi Guys,

I’m taking care of a new EBS Solution (RapideSuite), I had top put gold image up and change IP, on release R11 was very boring change it, but in R12 it’s really easy, after change IP and change in /etc/hosts you just need to delete files below:

rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*

rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*

rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

Usually if you don't delete it you will face 500 error on EBS.

If you wish run auto config, for me was not necessary.

Thanks a lot,

EBS:FND_CANT_INSERT_USER_ROLE

Hey Guys,

Today I got this problem while trying to set Functional Administrator Responsibility for SYSADMIN.

ORA-20001 :  FND_CANT_INSERT_USER_ROLE

In order to fix:

Run concurrent: “Workflow DirectoryServices User/Role Validation” with parameters  

100000, Yes, Yes, No.

Well done.

Thanks !!

Vinicius

EBS: 500 error after fresh clone environment.

Hi Guys,

I just got this error.

After clone environment using rman backup to restore database and apply archivelogs some blocks become corrupt for WF_LOCAL_ROLES and after when I tried to startup ebs I got 500 internal error.

In order to fix it I used note 781413.1

Make sure your issue is this one:

select count(*) from APPLSYS.WF_LOCAL_USER_ROLES;

ORA-01578: ORACLE data block corrupted (file # 23, block # 221085)
ORA-01110: data file 23: '/RDBMS ORACLE_HOME/app/a_txn_data02.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option

In order to fix log as Apps:

set serveroutput on size 100000;
declare
begin
WF_LOCAL_SYNCH.BULKSYNCHRONIZATION(
P_ORIG_SYSTEM => 'ALL',
P_PARALLEL_PROCESSES => null,
P_LOGGING => null,
P_RAISEERRORS => TRUE);
exception
when others then
dbms_output.put_line('sqlerrm = ' || sqlerrm);
end;
/

Commit;

It's done.

Thanks !!

SQL to Check WF (workflow) Status

Hi Guys,

Find below SQL to check status of Workflow Notification Mailer.

SQL> SELECT COMPONENT_STATUS FROM APPS.FND_SVC_COMPONENTS WHERE COMPONENT_ID=10006;

Thanks !!
Papa

RMAN: ORA-21000: error number argument to raise_application_error

Hi guys,

I got this error while running backup configured with a catalog database.

executing command: SET COMMAND ID

starting full resync of recovery catalog

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of set command at 11/25/2012 10:41:23

RMAN-03014: implicit resync of recovery catalog failed

RMAN-03009: failure of full resync command on default channel at 11/25/2012 10:41:23

ORA-21000: error number argument to raise_application_error of -29999 is out of range

What I did:

Connect into catalog user:
sqlplus catalog/catalog@rmanprd

Unregister database from catalog.

SQL>  EXECUTE dbms_rcvcat.unregisterdatabase (db_key, db_id);

Where do I get db_key?

In catalog user: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcviews013.htm

Log into RMAN using target and catalog database.

RMAN> register database;

RMAN> backup database;

Done working !!

Thanks !! 

APPS: libzip.so: symbol errno, version GLIBC_2.0

Discoverer problem while running check script.

$ORACLE_HOME/8.0.6/discwb4/util> ./checkdiscoverer.sh

$ORACLE_HOME/8.0.6/jre1183o/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)

Unable to initialize threads: cannot find class java/lang/Thread

Could not create Java VM

Basically what I did was:

cd $ORACLE_HOME/

mv jre1183o jre1183o_old

mkdir jre1183o

cd jre1183o

cp -rp /usr/java/1.6_014/jre/* .

chmod -R 777 *

This Solution can be used for many errors of java.