Doc ID 1097532.1
quinta-feira, 21 de março de 2013
terça-feira, 19 de março de 2013
Ajustando as permissões do Oracle Portal
10:40
No comments
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;
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.
07:27
No comments
./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
10:59
No comments
Disable the 'requiretty' and visiblepw option in the 'sudoers' file and rerun the failed job.
Verify if you don't have:
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
05:38
No comments
DOC ID 1477095.1
cd /lib
ln -s libpam.so.0 libpam.so
cd /lib64
ln -s libpam.so.0 libpam.so
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
05:10
1 comment
Changing Enterprise Manager 12c Default inactive Timeout
http://www.fuadarshad.com/2013/02/changing-enterprise-manager-12c-default.html
http://www.fuadarshad.com/2013/02/changing-enterprise-manager-12c-default.html
