Oracle SID_LISTENET

WINDOWS:
SET ORACLE_SID=SAL1

sqlplus / as sysdba

SQL> show parameter local_listener

SQL> alter system set LOCAL_LISTENER=NOMBRE_LISTENER;

SQL> alter system register;

SQL> exit;

lsnrctl status

Obs:
1.- que en el listener.ora se encuentre los siguiente
ADR_BASE_LISTENER = D:\app\oracle
2.- editar C:\Windows\System32\drivers\etc\hosts
127.0.0.1 localhost
3.- alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))';

TOMCAT 8 - MEMORIA - CONFIGURACION

En el archivo catalina.bat

set JAVA_HOME=D:\app\jdk1.7x64
set JAVA_OPTS=-Dfile.encoding=UTF-8 -Xms328m -Xmx1024m -XX:PermSize=364m -XX:MaxPermSize=856m




MODO WINDOWS
-Xms328M
-Xmx1024M
-XX:PermSize=1024m
-XX:MaxPermSize=4096m

Initial memory pool : 1024
Maximun memory pool : 4096
Thred stack size : 2048

des-habilitar seguridad windows

Click start and type gpedit.msc to open the Policy Editor
Open Computer Configuration (left hand pane)
Open Windows Settings (left hand pane)
Open Security Settings (left hand pane)
Open Account Policies (left hand pane)
Open Password Policy (left hand pane)
Doubleclick on the Password must meet complexity requirements
Select Disabled
Press OK
Close the Policy Editor
Run gpupdate.exe

MAVEN - ignorar test

Por proyecto
=================
Project
Run as
Run Configuration

Ejercicio - Main - Goals - clean install -DskipTests



Por Codigo
===========
@Ignore

MYSQL restore database

mysql --user=root --database=sgdbsys --password= < d:\sgdbsys.sql

MYSQL - Listar objetos de esquemas

SELECT * FROM (
select TABLE_SCHEMA AS ESQUEMA, TABLE_TYPE AS TIPO, COUNT(1) AS CONTADOR from
INFORMATION_SCHEMA.TABLES
GROUP BY TABLE_SCHEMA, TABLE_TYPE
UNION ALL
select ROUTINE_SCHEMA AS ESQUEMA, ROUTINE_TYPE AS TIPO, COUNT(1) AS CONTADOR from
INFORMATION_SCHEMA.ROUTINES GROUP BY ROUTINE_SCHEMA, ROUTINE_TYPE) det
WHERE det.ESQUEMA='sgesquemasys'

Configurar JDNI en app web (Weblogic, Spring, Hibernate)

Archivo Aplication Spring:

<bean id="BeanDataSourceErp" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/jndi/dbErp" />
</bean>


Archivo web XML
<resource-ref>
<description>Oracle JNDI Data Source </description>
<res-ref-name>jndi/dbErp</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<mapped-name>jndi/dbErp</mapped-name>
</resource-ref>