Rodrigo Silva e Silva

TNS-01151: Missing listener name, orcl, in LISTENER.ORA

Publicado em 10 de março de 2020 by rodrigosilvaesilva

Erro TNS-01151: Missing listener name, orcl, in LISTENER.ORA Causa Verificado que a porta foi alterada no listener.ora e no tnsnames.ora não foi alterada.

/u01/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

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

PROD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = bdora-prod.prod.local)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD)
    )
  )

/u01/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

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

# Generated by Oracle configuration tools.

PROD =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = bdora-prod.prod.local)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = PROD)

)

# listener.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = bdora-prod.prod.local)(PORT = 1522))
    )
  )

ADR_BASE_LISTENER = /u01/oracle

# listener.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = bdora-prod.prod.local)(PORT = 1522))

)

ADR_BASE_LISTENER = /u01/oracle

Solução. Acertar a porta no /u01/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# listener.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = bdora-prod.prod.local)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/oracle

# listener.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = bdora-prod.prod.local)(PORT = 1521))

)

ADR_BASE_LISTENER = /u01/oracle

Impdp erro ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39088: file name cannot contain a path specification

Publicado em 27 de fevereiro de 2020 by rodrigosilvaesilva

Erro ao realizar import Erro

[oracle@dbora bkp_logico]$ time impdp system/"senha"@OLTP  dumpfile='/u02/bkp_logico/OLTP.DMP' logfile=IMP_OLTP_27022020.log schemas=PROD,TESTE

Import: Release 19.0.0.0.0 - Production on Thu Feb 27 19:12:04 2020
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39088: file name cannot contain a path specification

[oracle@dbora bkp_logico]$ time impdp system/"senha"@OLTP dumpfile='/u02/bkp_logico/OLTP.DMP' logfile=IMP_OLTP_27022020.log schemas=PROD,TESTE

Import: Release 19.0.0.0.0 - Production on Thu Feb 27 19:12:04 2020

Version 19.5.0.0.0

Connected to: Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-39088: file name cannot contain a path specification

Causa Usuário sys sem permissão Solução

SYSTEM@OLTP > grant read, write on DIRECTORY DIRECTORY to sys;

Grant succeeded.

SYSTEM@OLTP > grant read, write on DIRECTORY DIRECTORY to sys;

Grant succeeded.

Resolvido!

Erro ORA-39213: Metadata processing is not available expdp Oracle 11

Publicado em 27 de fevereiro de 2020 by rodrigosilvaesilva

Erro ao realizar export Oracle 11.2.0.4 em Windows Server Problema:

C:\Users\Administrador>expdp '/ as sysdba' schemas=PROD,TESTE directory=BKPDIR statistics=none dumpfile=EXP_27022020.dmp logfile=EXP_27022020.log

Export: Release 11.2.0.2.0 - Production on Qui Fev 27 15:13:18 2020

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Conectado a: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Productio

ORA-39006: internal error
ORA-39213: Metadata processing is not available

C:\Users\Administrador>expdp '/ as sysdba' schemas=PROD,TESTE directory=BKPDIR statistics=none dumpfile=EXP_27022020.dmp logfile=EXP_27022020.log

Export: Release 11.2.0.2.0 - Production on Qui Fev 27 15:13:18 2020

Conectado a: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Productio

ORA-39006: internal error

ORA-39213: Metadata processing is not available

Causa: O datapump não consegue utilizar API Solução Conecte no sqlplus como sysdba e execute

execute sys.dbms_metadata_util.load_stylesheets;

1	execute sys.dbms_metadata_util.load_stylesheets;

Resolvido

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

Publicado em 12 de fevereiro de 2020 by rodrigosilvaesilva

Erro ao tentar conectar no Oracle 12.2.0.1 Causa Falha ao registar no listener Analisando o log do listener

less /u01/oracle/diag/tnslsnr/dbteste/listener/alert/log.xml


 </txt>
</msg>
<msg time='2020-02-12T13:39:42.367-02:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='bdoracle.local'
 host_addr='10.0.0.0' pid='8331'>
 <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 </txt>

less /u01/oracle/diag/tnslsnr/dbteste/listener/alert/log.xml

</txt>

</msg>

<msg time='2020-02-12T13:39:42.367-02:00' org_id='oracle' comp_id='tnslsnr'

type='UNKNOWN' level='16' host_id='bdoracle.local'

host_addr='10.0.0.0' pid='8331'>

<txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

</txt>

SQL> SHOW PARAMETER LOCAL LISTENER

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LISTENER_DBTESTE
parallel_force_local                 boolean     FALSE

SQL> SHOW PARAMETER LOCAL LISTENER

NAME TYPE VALUE

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

local_listener string LISTENER_DBTESTE

parallel_force_local boolean FALSE

Ajustando listener

SQL> alter system set LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.212)(PORT=1521))'scope=both;

1	SQL> alter system set LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.212)(PORT=1521))'scope=both;

Resolvido

[oracle@dbteste ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 12-FEB-2020 16:48:13

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                12-FEB-2020 16:36:42
Uptime                    0 days 0 hr. 11 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/oracle/diag/tnslsnr/dbteste/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.0)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "DBTESTE" has 1 instance(s).
  Instance "DBDIVESA", status READY, has 1 handler(s) for this service...
Service "DBTESTEXDB" has 1 instance(s).
  Instance "DBTESTE", status READY, has 1 handler(s) for this service...
The command completed successfully

[oracle@dbteste ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 12-FEB-2020 16:48:13

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.0)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production

Start Date 12-FEB-2020 16:36:42

Uptime 0 days 0 hr. 11 min. 30 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/oracle/diag/tnslsnr/dbteste/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.0)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "DBTESTE" has 1 instance(s).

Instance "DBDIVESA", status READY, has 1 handler(s) for this service...

Service "DBTESTEXDB" has 1 instance(s).

Instance "DBTESTE", status READY, has 1 handler(s) for this service...

The command completed successfully

ORA-12541: TNS:no listener, ORA-12518: TNS: listener could not hand off client connection

Publicado em 7 de fevereiro de 2020 by rodrigosilvaesilva

Problema: ORA-12541: TNS:no listener Causa Identificado que o arquivo listenet.log estava com 4.1GB Solução

echo >  /oracle/product/10.2.0/db_1/network/log/listener.log

1	echo > /oracle/product/10.2.0/db_1/network/log/listener.log

← Posts recentes Posts antigos →