rodrigosilvaesilva – Página: 7 – Rodrigo Silva e Silva

ORA-28374: typed master key not found in wallet

Publicado em 21 de junho de 2019 by rodrigosilvaesilva

Oracle Database 12c Standard Edition ERROR ORA-28374: typed master key not found in wallet ao criar tablespace

CREATE TABLESPACE TESTE DATAFILE  '/u02/app/oracle/oradata/TESTE/ERP/teste.dbf' size 1024M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet

CREATE TABLESPACE TESTE DATAFILE '/u02/app/oracle/oradata/TESTE/ERP/teste.dbf' size 1024M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;

ERROR at line 1:

ORA-28374: typed master key not found in wallet

Analisando o status da wallet do CDB$ROOT

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT

column WRL_PARAMETER format a40;
column STATUS format a10;
column WALLET_TYPE format a10;

SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;

WRL_PARAMETER                            STATUS     WALLET_TYP
---------------------------------------- ---------- ----------
/u01/app/oracle/admin/EXM/tde_wallet/    OPEN       AUTOLOGIN

SQL> show con_name;

CON_NAME

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

CDB$ROOT

column WRL_PARAMETER format a40;

column STATUS format a10;

column WALLET_TYPE format a10;

SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;

WRL_PARAMETER STATUS WALLET_TYP

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

/u01/app/oracle/admin/EXM/tde_wallet/ OPEN AUTOLOGIN

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE close;

keystore altered.

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE close;

keystore altered.

SET KEYSTORE

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE open IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" CONTAINER=ALL;

keystore altered.

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE open IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" CONTAINER=ALL;

keystore altered.

Acessando o PDB01

SQL> ALTER SESSION SET CONTAINER = PDB01;

Session altered.

SQL> ALTER SESSION SET CONTAINER = PDB01;

Session altered.

SET KEY

SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" with backup;

keystore altered.

SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" with backup;

keystore altered.

Create Tablespace

SQL> CREATE TABLESPACE TESTE DATAFILE  '/u02/app/oracle/oradata/EXM/SANKHYA/teste.dbf' size 10M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;

Tablespace created.

SQL> CREATE TABLESPACE TESTE DATAFILE '/u02/app/oracle/oradata/EXM/SANKHYA/teste.dbf' size 10M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;

Tablespace created.

Resolvido!

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

Publicado em 21 de junho de 2019 by rodrigosilvaesilva

Erro ao tentar conectar do Cliente 11g Servidor TS no Oracle Database 11g Release 11.2.0.4.0 em Real Application Clusters and Automatic Storage Management ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

oracle@bdora-11g ~]$ rlwrap sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 19 23:24:37 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

Verificando o nome do serviço 

SQL> select value from v$parameter where name='service_names';

VALUE
--------------------------------------------------------------------------------
BD11G_iad18f.privatesubnet.natvcn.oraclevcn.com

oracle@bdora-11g ~]$ rlwrap sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 19 23:24:37 2019

Connected to:

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

Verificando o nome do serviço

SQL> select value from v$parameter where name='service_names';

VALUE

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

BD11G_iad18f.privatesubnet.natvcn.oraclevcn.com

Ajustando tsnames Editar o /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

BD11G_IAD18F =
  (DESCRIPTION =
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = BD11G_iad18f.privatesubnet.natvcn.oraclevcn.com)
    )
  )

BD11G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = bdora-11g.privatesubnet.natvcn.oraclevcn.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = BD11G_iad18f.privatesubnet.natvcn.oraclevcn.com )
    )
  )

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

BD11G_IAD18F =

(DESCRIPTION =

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = BD11G_iad18f.privatesubnet.natvcn.oraclevcn.com)

)

BD11G =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = bdora-11g.privatesubnet.natvcn.oraclevcn.com)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = BD11G_iad18f.privatesubnet.natvcn.oraclevcn.com )

)

Resolvido!

netstat windows listando conexões porta 1521

Publicado em 21 de maio de 2019 by rodrigosilvaesilva

C:\Users\Administrator>netstat -aon | find /i "1521"
  TCP    0.0.0.0:1521           0.0.0.0:0              LISTENING       292
  TCP    192.168.16.210:1521    192.168.16.112:62761   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:49276   ESTABLISHED     1396
  TCP    192.168.16.210:1521    192.168.16.210:51222   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51273   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51274   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51275   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51276   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51277   TIME_WAIT       0
  TCP    192.168.16.210:1521    192.168.16.210:51281   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51289   TIME_WAIT       0
  TCP    192.168.16.210:1521    192.168.16.210:51290   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51291   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51292   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51293   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51294   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51360   TIME_WAIT       0
  TCP    192.168.16.210:1521    192.168.16.210:51365   TIME_WAIT       0
  TCP    192.168.16.210:1521    192.168.16.210:51367   ESTABLISHED     292
  TCP    192.168.16.210:1521    192.168.16.210:51380   TIME_WAIT       0
  TCP    192.168.16.210:1521    192.168.16.210:51381   TIME_WAIT       0
  TCP    192.168.16.210:1521    192.168.16.210:51388   ESTABLISHED     292
  TCP    192.168.16.210:49276   192.168.16.210:1521    ESTABLISHED     1268
  TCP    192.168.16.210:51222   192.168.16.210:1521    ESTABLISHED     1440
  TCP    192.168.16.210:51236   192.168.16.210:1521    TIME_WAIT       0
  TCP    192.168.16.210:51239   192.168.16.210:1521    TIME_WAIT       0
  TCP    192.168.16.210:51273   192.168.16.210:1521    ESTABLISHED     2032
  TCP    192.168.16.210:51274   192.168.16.210:1521    ESTABLISHED     2032
  TCP    192.168.16.210:51275   192.168.16.210:1521    ESTABLISHED     2032
  TCP    192.168.16.210:51276   192.168.16.210:1521    ESTABLISHED     2032
  TCP    192.168.16.210:51279   192.168.16.210:1521    TIME_WAIT       0

C:\Users\Administrator>netstat -aon | find /i "1521"

TCP 0.0.0.0:1521 0.0.0.0:0 LISTENING 292

TCP 192.168.16.210:1521 192.168.16.112:62761 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:49276 ESTABLISHED 1396

TCP 192.168.16.210:1521 192.168.16.210:51222 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51273 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51274 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51275 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51276 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51277 TIME_WAIT 0

TCP 192.168.16.210:1521 192.168.16.210:51281 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51289 TIME_WAIT 0

TCP 192.168.16.210:1521 192.168.16.210:51290 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51291 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51292 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51293 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51294 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51360 TIME_WAIT 0

TCP 192.168.16.210:1521 192.168.16.210:51365 TIME_WAIT 0

TCP 192.168.16.210:1521 192.168.16.210:51367 ESTABLISHED 292

TCP 192.168.16.210:1521 192.168.16.210:51380 TIME_WAIT 0

TCP 192.168.16.210:1521 192.168.16.210:51381 TIME_WAIT 0

TCP 192.168.16.210:1521 192.168.16.210:51388 ESTABLISHED 292

TCP 192.168.16.210:49276 192.168.16.210:1521 ESTABLISHED 1268

TCP 192.168.16.210:51222 192.168.16.210:1521 ESTABLISHED 1440

TCP 192.168.16.210:51236 192.168.16.210:1521 TIME_WAIT 0

TCP 192.168.16.210:51239 192.168.16.210:1521 TIME_WAIT 0

TCP 192.168.16.210:51273 192.168.16.210:1521 ESTABLISHED 2032

TCP 192.168.16.210:51274 192.168.16.210:1521 ESTABLISHED 2032

TCP 192.168.16.210:51275 192.168.16.210:1521 ESTABLISHED 2032

TCP 192.168.16.210:51276 192.168.16.210:1521 ESTABLISHED 2032

TCP 192.168.16.210:51279 192.168.16.210:1521 TIME_WAIT 0

Instabilidade LISTENER

Publicado em 21 de maio de 2019 by rodrigosilvaesilva

Boa noite pessoal! Hoje vivenciei um cliente com Oracle instalado em Windows…. com instabilidade para manter o listener ativo. Entrando no utilitário lsnrctl

C:\Users\Administrator>lsnrctl

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 21-MAI-2019 21:10
:00

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Bem vindo ao LSNRCTL, digite "help" para obter informaþ§es.

LSNRCTL>

C:\Users\Administrator>lsnrctl

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 21-MAI-2019 21:10

:00

Bem vindo ao LSNRCTL, digite "help" para obter informaþ§es.

LSNRCTL>

Identificando diretório de log

LSNRCTL> show log_file
Estabelecendo conexÒo com (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=GB-NBS-BD)(PORT=1521)))
LISTENER parÔmetro "log_file" definido como e:\app\diag\tnslsnr\BD-ORA\listener\alert\log.xml
O comando foi executado com Ûxito

LSNRCTL> show log_file

Estabelecendo conexÒo com (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=GB-NBS-BD)(PORT=1521)))

LISTENER parÔmetro "log_file" definido como e:\app\diag\tnslsnr\BD-ORA\listener\alert\log.xml

O comando foi executado com Ûxito

Analisando identifiquei que o diretório de Logs do listener estava com 178 arquivos de 10MB total 1,73GB Para resolver esse caso foi realizado o seguinte procedimento….

ORA-28014: cannot drop administrative users

Publicado em 16 de maio de 2019 by rodrigosilvaesilva

Erro ORA-28014: cannot drop administrative users

SYS@ORCL > drop user perfstat cascade;
drop user perfstat cascade
*
ERROR at line 1:
ORA-28014: cannot drop administrative users

SYS@ORCL > drop user perfstat cascade;

drop user perfstat cascade

ERROR at line 1:

ORA-28014: cannot drop administrative users

Alterando o parâmetro _oracle_script

SYS@ORCL > alter session set "_oracle_script"=TRUE;

Session altered.

SYS@ORCL > alter session set "_oracle_script"=TRUE;

Session altered.

Dropando

SQL> drop user perfstat cascade;
User dropped

1 2	SQL> drop user perfstat cascade; User dropped

Resolvido! Recomendo que volte depois o parâmetro para FALSE

SYS@ORCL > alter session set "_oracle_script"=FALSE; Session altered.

1	SYS@ORCL > alter session set "_oracle_script"=FALSE; Session altered.

← Posts recentes Posts antigos →