julho 2019 – Rodrigo Silva e Silva

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)

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

Firebird error xinetd per_source limit issues

Publicado em 11 de julho de 2019 by rodrigosilvaesilva

Error ao conectar no Firebird Análise: Ao verificar o log do firebird idetificado erro xinetd per_source limit issues Causa Excedido o número de conexões. Solução Ao analisar o /etc/xinetd.conf verificado que o per_source estava padrão

per_source = 10

1	per_source = 10

Aumentar o per_source

per_source = 100

ou

per_source = UNLIMITED

per_source = 100

per_source = UNLIMITED

Resolvido!

ROUTE: route addition failed using CreateIpForwardEntry

Publicado em 8 de julho de 2019 by rodrigosilvaesilva

Erro ao Conectar client OpenVPN Gui Windows 7/8/10

ROUTE: route addition failed using CreateIpForwardEntry: The parameter is incorrect.   [status=87 if_index=14]

1	ROUTE: route addition failed using CreateIpForwardEntry: The parameter is incorrect. [status=87 if_index=14]

Resolvendo Adicione as seguintes linhas no conf do client.

route-method exe
route-delay

1 2	route-method exe route-delay

Could not obtain exclusive lock on database ‘model’. Retry the operation later.

Publicado em 6 de julho de 2019 by rodrigosilvaesilva

Erro ao criar uma database teste no SQL Server

CREATE DATABASE TESTE2
GO

1 2	CREATE DATABASE TESTE2 GO

Erro

Msg 1807, Level 16, State 3, Line 1
Could not obtain exclusive lock on database 'model'. Retry the operation later.
Msg 1802, Level 16, State 4, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Msg 1807, Level 16, State 3, Line 1

Could not obtain exclusive lock on database 'model'. Retry the operation later.

Msg 1802, Level 16, State 4, Line 1

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Solução Tinha outra seção lockando a database ‘model’