quinta-feira, 21 de março de 2013

Portal Shows Bad Performance And Hangs

Doc ID 1097532.1

terça-feira, 19 de março de 2013

Ajustando as permissões do Oracle Portal

Adjust Oracle Portal permissions


declare
 v_dn varchar2(2000);
 v_id number;
begin
for i in (select ID, OBJECT_TYPE_NAME, OWNER, NAME,
  GRANTEE_GROUP_ID, GRANTEE_USER_ID, GRANTEE_TYPE, PRIVILEGE,CREATED_BY_DBUSER,CREATED_BY_USER from PORTAL.WWSEC_SYS_PRIV$
where GRANTEE_GROUP_ID <> 0
) loop
 begin

  select dn
    into v_dn
    from wwsec_group$ where id=i.grantee_group_id;

  select max(id)
    into v_id
   from wwsec_group$ where dn = v_dn;
end;

begin
 
  update PORTAL.WWSEC_SYS_PRIV$
     set grantee_group_id = v_id
   where id=i.id;
 exception when others then
   dbms_output.put_line('erro '||i.id);
 end;
end loop;
commit;
end;

terça-feira, 12 de março de 2013

The Oracle Home /u01/app/oracle/product/as10g/MidTier is not registered with the Central Inventory. OPatch was not able to get details of the home from the inventory.

./runInstaller -silent -invPtrLoc /etc/oraInst.loc -attachHome ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME="MID_1013"

segunda-feira, 4 de março de 2013

EM12c - sudo: no tty present and no askpass program specified

Disable the 'requiretty' and visiblepw option in the 'sudoers' file and rerun the failed job.

Verify if you don't have:


oracle   ALL=(ALL)           ALL


12c: Credentials Fail - PAM authentication...PAM failed with error: libpam.so: cannot open shared object file: No such file or directory

DOC ID 1477095.1

cd /lib
ln -s libpam.so.0 libpam.so

cd /lib64
ln -s libpam.so.0 libpam.so

Alterando o tempo de inatividade do Oracle Enterprise Manager 12c

Changing Enterprise Manager 12c Default inactive Timeout

http://www.fuadarshad.com/2013/02/changing-enterprise-manager-12c-default.html