Oracle – Página: 4 – Rodrigo Silva e Silva

Oracle error Prerequisite check “CheckActiveFilesAndExecutables” failed.

Publicado em 21 de julho de 2019 by rodrigosilvaesilva

Me deparei com o seguinte erro: Prerequisite check “CheckActiveFilesAndExecutables” failed. ao aplicar Patch no Oracle 12.2.0.1 Análise

[oracle@bdora-01 27105253]$  $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.12
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/oracle/product/12.2.0/dbhome_1
Central Inventory : /u01/oraInventory
   from           : /u01/oracle/product/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.2.0.1.4
Log file location : /u01/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-21_10-56-55AM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:


Following executables are active :
/u01/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-21_10-56-55AM_1.log

OPatch failed with error code 73

[oracle@bdora-01 27105253]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.12

Oracle Home : /u01/oracle/product/12.2.0/dbhome_1

Central Inventory : /u01/oraInventory

from : /u01/oracle/product/12.2.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.12

OUI version : 12.2.0.1.4

Log file location : /u01/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-21_10-56-55AM_1.log

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following executables are active :

/u01/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: /u01/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-21_10-56-55AM_1.log

OPatch failed with error code 73

Causa Processo utilizando a libclntsh.so.12.1

Following executables are active :
/u01/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1

1 2	Following executables are active : /u01/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1

Identificando pid do processo que está utilizando a libclntsh.so.12.1

[oracle@bdora-01 27105253]$ fuser /u01/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1
/u01/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1:  8947m

1 2	[oracle@bdora-01 27105253]$ fuser /u01/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1 /u01/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1: 8947m

Identificando no linux

[oracle@bdora-01 27105253]$ ps -ef |grep 8947
oracle    8947  8919  0 Jul20 pts/1    00:00:01 rman target /

1 2	[oracle@bdora-01 27105253]$ ps -ef \|grep 8947 oracle 8947 8919 0 Jul20 pts/1 00:00:01 rman target /

Solução

[oracle@bdora-01 27105253]$ kill -9 8947

1	[oracle@bdora-01 27105253]$ kill -9 8947

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!

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 →