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

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

Erro no PL/SQL Developer ORA-04088 ORA-01403 ORA-06512 ORA-01017

Publicado em 23 de setembro de 2019 by rodrigosilvaesilva

Erro ao conectar no PL/SQL Developer após migração RMAN Solução Crie um PASSWORD FILE $ export ORACLE_SID=TESTE orapwd file=/u01/app/oracle/product/11.2.0.4/db_1/dbs/orapwTESTE password=Senha123

ORA-01792: Maximum number of columns in a table or view is 1000

Publicado em 30 de julho de 2019 by rodrigosilvaesilva

Erro ORA-01792: Maximum number of columns in a table or view is 1000 Bug.27423662 Solução

09:47:09 SYS@ORCL > shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

09:47:09 SYS@ORCL > shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

Iniciar instância em nomount

SYS@ORCL > startup nomount;
ORACLE instance started.

Total System Global Area 2421825536 bytes
Fixed Size                  2255632 bytes
Variable Size             620758256 bytes
Database Buffers         1778384896 bytes
Redo Buffers               20426752 bytes

SYS@ORCL > startup nomount;

ORACLE instance started.

Total System Global Area 2421825536 bytes

Fixed Size 2255632 bytes

Variable Size 620758256 bytes

Database Buffers 1778384896 bytes

Redo Buffers 20426752 bytes

Alterar o parâmetro _fix_control

SYS@ORCL > alter system set "_fix_control"='17376322:OFF' scope=spfile;
System altered.

1 2	SYS@ORCL > alter system set "_fix_control"='17376322:OFF' scope=spfile; System altered.

SYS@ORCL > alter database mount;
Database altered.

1 2	SYS@ORCL > alter database mount; Database altered.

SYS@ORCL > alter database open;
Database altered.

1 2	SYS@ORCL > alter database open; Database altered.

Ou aplicar o Patch (19509982)

← Posts recentes Posts antigos →