maio 2019 – Rodrigo Silva e Silva

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.

ORA-28040: No matching authentication protocol

Publicado em 13 de maio de 2019 by rodrigosilvaesilva

Erro ao realizar conexão sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 13 19:06:57 2019

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

ERROR:
ORA-28040: No matching authentication protocol

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 13 19:06:57 2019

ERROR:

ORA-28040: No matching authentication protocol

Editar o arquivo sqlnet.ora e adicionar a linha abaixo

vi $ORACLE_HOME/network/admin/sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

vi $ORACLE_HOME/network/admin/sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Resolvido!

ORA-28003: password verification for the specified password failed ORA-20023: Password must contain at least 2 uppercase character(s)

Publicado em 13 de maio de 2019 by rodrigosilvaesilva

Erro ao criar usuário:

SQL> create user rsilva identified by password;
create user rsilva identified by password
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20023: Password must contain at least 2 uppercase character(s)

SQL> create user rsilva identified by password;

create user rsilva identified by password

ERROR at line 1:

ORA-28003: password verification for the specified password failed

ORA-20023: Password must contain at least 2 uppercase character(s)

Desabilitar senha complexa

SQL> alter profile default limit password_verify_function null;

1	SQL> alter profile default limit password_verify_function null;

Desabilitar tempo de reuso de senha

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME UNLIMITED;

1	SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME UNLIMITED;

Desabilitar máximo de reusos da senha

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX UNLIMITED;

1	SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX UNLIMITED;

Consultando alterações realizadas.

SQL> select * from dba_profiles where profile='DEFAULT';

PROFILE         RESOURCE_NAME                RESOURCE LIMIT      COM INH IMP
--------------- ---------------------------- -------- ---------- --- --- ---
DEFAULT         COMPOSITE_LIMIT              KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         SESSIONS_PER_USER            KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         CPU_PER_SESSION              KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         CPU_PER_CALL                 KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         LOGICAL_READS_PER_SESSION    KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         LOGICAL_READS_PER_CALL       KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         IDLE_TIME                    KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         CONNECT_TIME                 KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         PRIVATE_SGA                  KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         FAILED_LOGIN_ATTEMPTS        PASSWORD 3          NO  NO  NO
DEFAULT         PASSWORD_LIFE_TIME           PASSWORD 60         NO  NO  NO

PROFILE         RESOURCE_NAME                RESOURCE LIMIT      COM INH IMP
--------------- ---------------------------- -------- ---------- --- --- ---
DEFAULT         PASSWORD_REUSE_TIME          PASSWORD UNLIMITED  NO  NO  NO
DEFAULT         PASSWORD_REUSE_MAX           PASSWORD UNLIMITED  NO  NO  NO
DEFAULT         PASSWORD_VERIFY_FUNCTION     PASSWORD NULL       NO  NO  NO
DEFAULT         PASSWORD_LOCK_TIME           PASSWORD 1          NO  NO  NO
DEFAULT         PASSWORD_GRACE_TIME          PASSWORD 7          NO  NO  NO
DEFAULT         INACTIVE_ACCOUNT_TIME        PASSWORD UNLIMITED  NO  NO  NO

17 rows selected.

SQL> select * from dba_profiles where profile='DEFAULT';

PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP

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

DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NO

DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED NO NO NO

DEFAULT CPU_PER_SESSION KERNEL UNLIMITED NO NO NO

DEFAULT CPU_PER_CALL KERNEL UNLIMITED NO NO NO

DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NO

DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NO

DEFAULT IDLE_TIME KERNEL UNLIMITED NO NO NO

DEFAULT CONNECT_TIME KERNEL UNLIMITED NO NO NO

DEFAULT PRIVATE_SGA KERNEL UNLIMITED NO NO NO

DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 3 NO NO NO

DEFAULT PASSWORD_LIFE_TIME PASSWORD 60 NO NO NO

PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP

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

DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NO

DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NO

DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL NO NO NO

DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 NO NO NO

DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 NO NO NO

DEFAULT INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NO

17 rows selected.

Posts antigos →