Tomcat - Erro no deploy

Mensagem de erro:

HTTP Status 500 -

---

type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception

java.lang.IllegalStateException: org.apache.tomcat.util.http.fileupload.FileUploadBase$SizeLimitExceededException: the request was rejected because its size (54526273) exceeds the configured maximum (52428800)
 org.apache.catalina.connector.Request.parseParts(Request.java:2666)
 org.apache.catalina.connector.Request.parseParameters(Request.java:2875)
 org.apache.catalina.connector.Request.getParameter(Request.java:1131)
 org.apache.catalina.connector.RequestFacade.getParameter(RequestFacade.java:384)
 org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:163)

root cause

org.apache.tomcat.util.http.fileupload.FileUploadBase$SizeLimitExceededException: the request was rejected because its size (54526273) exceeds the configured maximum (52428800)
 org.apache.tomcat.util.http.fileupload.FileUploadBase$FileItemIteratorImpl.<init>(FileUploadBase.java:799)
 org.apache.tomcat.util.http.fileupload.FileUploadBase.getItemIterator(FileUploadBase.java:282)
 org.apache.tomcat.util.http.fileupload.FileUploadBase.parseRequest(FileUploadBase.java:302)
 org.apache.tomcat.util.http.fileupload.servlet.ServletFileUpload.parseRequest(ServletFileUpload.java:129)
 org.apache.catalina.connector.Request.parseParts(Request.java:2638)
 org.apache.catalina.connector.Request.parseParameters(Request.java:2875)
 org.apache.catalina.connector.Request.getParameter(Request.java:1131)
 org.apache.catalina.connector.RequestFacade.getParameter(RequestFacade.java:384)
 org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:163)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.16 logs.

---

Apache Tomcat/7.0.16

 

 

Solução: 

Procure o arquivo "web.xml" do "manager application" (normalmente encontra-se em /tomcat7/webapps/manager/WEB-INF/web.xml)

Procure os parametros: "max-file-size" e "max-request-size"

<multipart-config>
<!– 50MB max –>
<max-file-size>52428800</max-file-size>
<max-request-size>52428800</max-request-size>
<file-size-threshold>0</file-size-threshold>
</multipart-config>

E aumente os valores do "max-file-size" e "max-request-size".

 

Comando Top 10 do SQL Server correspondente no Oracle

Exemplo MS SQL SERVER:

select top 10 * from tabela;


Exemplo ORACLE:

select * from tabela
where ROWNUM <= 10;

Oracle - ASM

--configurar o listner
netca (interface nova)
ou
netmgr (interface antiga)

obs.: mudar para instancia +ASM, antes para trabalhar com a base e voltar para ORCL para configurar a instancia

--------
Ferramentas:

. oraenv
determina qual base trabalhar, alternando entre elas


dba
cria e configurar um database

-------------------
sqlplus / as sysdba (entra com as credenciais do sistema operacional)
sqlplus sys/oracle as sysdba
sqlplus hr/senha
sqlplus /nolog (abre o sqlplus sem conectar-se)
sqlplus hr/senha@teste
sqlplus system/oracle@10.68.46.74:1521/orcl.localdomain
sqlplus hr (pedirá a senha para conectar-se)
sqlplus sys as sysdba (pedirá a senha para conectar)

---------

emctl start dbconsole
inicializa o enterprise manager

emctl stop dbconsole
para o enterprise manager

emctl status dbconsole
mostra o estado atual do enterprise manager

-------------------------
lsnrclt start (Inicia o listener)
lsnrclt stop (para o listener)
lsnrclt status (Verifica o status do listener)

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


--comandos para acessar o ASM, deve estar na base +ASM

asmcmd -p (utilizado para acessar os arquivos do ASM)

asmca (utilizado para configurar os discos do ASM)

Oracle - Ferramentas

sqlplus - acessar a base de dados

asmcmd - acessar o conteudo dos discos do ASM

asmca - criar os grupos de discos do ASM

dbca - criar base de dados

netmgr - ferramenta para gerenciamento de rede

netca - ferramenta para gerenciamento de rede

lsnrctl - ferramenta para gerenciar o listener

emctl - ferramenta para iniciar/parar o enterprise manager

srvctl - oracle Restart, permite executar uma série de comandos em apenas uma linha de prompt

orapwd - criar arquivo de senha da base, onde ficam indicados quais usuário acessam a base via sysdba com a base fechada.

Oracle formato - hora minuto segundo

Oracle date to hundredths of a second Oracle Tips by Burleson Consulting

Question:  In have incoming data that records hundredths of a second and I cannot find a DATE format (i.e. nls_date_format) to hold hundredths of a second.

Answer:  It's tempting to try the SSSS date format, but you annot use the "SSSS" format for milliseconds because SSSS is the number of seconds after midnight.

Instead, you need to use the TIMESTAMP datatype instead of the DATE datatype.  The TIMESTAMP datatype has fractional seconds, as noted by the FF notation:

     'DD-Mon-YYYY HH24:MI:SS.FF'

For example, you can define a TIMESTAMP column and store data into it, something like this:

create table t1 (timecol TIMESTAMP);

insert into T1 (timecol) values
   to_timestamp('200612251211000000','YYYYMMDDHHMISSFF')

this query will convert to fractional seconds:

select
   to_char(sysdate, 'DD-Mon-YYYY HH24:MI:SS'),
   localtimestamp(2),
   to_timestamp(
      to_char(
         sysdate, 'DD-Mon-YYYY HH24:MI:SS'
      )||'.55', 'DD-Mon-YYYY HH24:MI:SS.FF')
from
   dual;

Fonte: http://www.dba-oracle.com/t_date_format_hundredths_second.htm

Oracle - Diferenças em dias entre duas datas

Oracle - Exemplo para calcular a diferenças em dias entre duas datas 

SELECT TRUNC(sysdate) - TRUNC(t.hiredate) FROM myTable t; 

fonte: http://stackoverflow.com/questions/3129707/count-the-number-of-days-between-today-the-hiredate-in-oracle-sql