abril 2019 – Página: 2 – Rodrigo Silva e Silva

Erro ao instalar oracle-rdbms-server-11gR2-preinstall

warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle


GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Acesse o diretório: cd /etc/yum.repos.d/ Faça o Download:

[root@bancora] wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle --no-check-certificate

1	[root@bancora] wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle --no-check-certificate

[root@bancora yum.repos.d]# wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle --no-check-certificate
--2019-04-11 19:27:25--  https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6
Resolving public-yum.oracle.com... 23.195.64.183
Connecting to public-yum.oracle.com|23.195.64.183|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1011 [text/plain]
Saving to: “/etc/pki/rpm-gpg/RPM-GPG-KEY-oracle”

100%[=============================================================================================>] 1,011       --.-K/s   in 0s

2019-04-11 19:27:27 (253 MB/s) - “/etc/pki/rpm-gpg/RPM-GPG-KEY-oracle” saved [1011/1011]

[root@bancora yum.repos.d]# wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle --no-check-certificate

--2019-04-11 19:27:25-- https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

Resolving public-yum.oracle.com... 23.195.64.183

Connecting to public-yum.oracle.com|23.195.64.183|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 1011 [text/plain]

Saving to: “/etc/pki/rpm-gpg/RPM-GPG-KEY-oracle”

100%[=============================================================================================>] 1,011 --.-K/s in 0s

2019-04-11 19:27:27 (253 MB/s) - “/etc/pki/rpm-gpg/RPM-GPG-KEY-oracle” saved [1011/1011]

Resolvido!

Erro ao criar ACL

begin
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
    acl => 'acl_http.xml',
    description => 'Allow acl_viacep',
    principal => 'CPD',
    is_grant => true,
    privilege => 'connect'
    );

  dbms_network_acl_admin.add_privilege (
  acl => 'acl_http.xml',
  principal => 'CPD',
  is_grant => true,
  privilege => 'resolve'
  );

  dbms_network_acl_admin.assign_acl(
  acl  => 'acl_http.xml',
  host => 'serasa.com.br'
  );
  commit;
end;
/

begin

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(

acl => 'acl_http.xml',

description => 'Allow acl_viacep',

principal => 'CPD',

is_grant => true,

privilege => 'connect'

);

dbms_network_acl_admin.add_privilege (

acl => 'acl_http.xml',

principal => 'CPD',

is_grant => true,

privilege => 'resolve'

);

dbms_network_acl_admin.assign_acl(

acl => 'acl_http.xml',

host => 'serasa.com.br'

);

commit;

end;

Erro

ORA-30554: function-based index XDB.XDB$ACL_XIDX is disabled
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 258
ORA-06512: at line 2

ORA-30554: function-based index XDB.XDB$ACL_XIDX is disabled

ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 258

ORA-06512: at line 2

Consultando index

column owner format a12;
column index_name format a18;
column status format a10;
column domidx_status format a10;
column domidx_opstatus format a10;
column funcidx_status format a10;


SQL> select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;

OWNER        INDEX_NAME         STATUS     DOMIDX_STA DOMIDX_OPS FUNCIDX_ST
------------ ------------------ ---------- ---------- ---------- ----------
XDB          XDBHI_IDX          VALID      VALID      VALID      ENABLED
XDB          XDB$ACL_XIDX       VALID      VALID      VALID      DISABLED

column owner format a12;

column index_name format a18;

column status format a10;

column domidx_status format a10;

column domidx_opstatus format a10;

column funcidx_status format a10;

SQL> select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;

OWNER INDEX_NAME STATUS DOMIDX_STA DOMIDX_OPS FUNCIDX_ST

------------ ------------------ ---------- ---------- ---------- ----------

XDB XDBHI_IDX VALID VALID VALID ENABLED

XDB XDB$ACL_XIDX VALID VALID VALID DISABLED

Recompilando Index

SQL>alter index XDB.XDB$ACL_XIDX rebuild;

Index altered.

SQL>alter index XDB.XDB$ACL_XIDX rebuild;

Index altered.

SQL> select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;

OWNER        INDEX_NAME         STATUS     DOMIDX_STA DOMIDX_OPS FUNCIDX_ST
------------ ------------------ ---------- ---------- ---------- ----------
XDB          XDBHI_IDX          VALID      VALID      VALID      ENABLED
XDB          XDB$ACL_XIDX       VALID      VALID      VALID      ENABLED

SQL> select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;

OWNER INDEX_NAME STATUS DOMIDX_STA DOMIDX_OPS FUNCIDX_ST

------------ ------------------ ---------- ---------- ---------- ----------

XDB XDBHI_IDX VALID VALID VALID ENABLED

XDB XDB$ACL_XIDX VALID VALID VALID ENABLED

Resolvido!