Skip to content

Instantly share code, notes, and snippets.

View arbo-hacker's full-sized avatar

Alejandro Barreto arbo-hacker

23 followers · 48 following
View GitHub Profile
@arbo-hacker
arbo-hacker / find-object-error.sql
Last active January 23, 2016 05:46
Error de un procedimiento / funcion invalido en Oracle
-- error de un objeto invalido
select * from sys.ERROR$ where obj#
in (select obj#
from sys.utl_recomp_invalid_all
where objname='&nombreprocedimiento'
);
@arbo-hacker
arbo-hacker / mfqueue-tables-retek.sql
Created January 23, 2016 05:48
Como monitorear las tablas MFQUEUE en Oracle Retail
select 'CODES_MFQUEUE' COLA, count(1) ENCOLADOS from CODES_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'RUA_MFQUEUE' COLA, count(1) ENCOLADOS from RUA_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'BANNER_MFQUEUE' COLA, count(1) ENCOLADOS from BANNER_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'ITEM_MFQUEUE' COLA, count(1) ENCOLADOS from ITEM_MFQUEUE I WHERE PUB_STATUS = 'U' AND I.APPROVE_IND = 'Y' union all
select 'SEEDOBJ_MFQUEUE' COLA, count(1) ENCOLADOS from SEEDOBJ_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'WH_MFQUEUE' COLA, count(1) ENCOLADOS from WH_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'STORE_MFQUEUE' COLA, count(1) ENCOLADOS from STORE_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'SUPPLIER_MFQUEUE' COLA, count(1) ENCOLADOS from SUPPLIER_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'TSF_MFQUEUE' COLA, count(1) ENCOLADOS from TSF_MFQUEUE WHERE PUB_STATUS = 'U' union all
select 'PARTNER_MFQUEUE' COLA, count(1) ENCOLADOS from PARTNER_MFQUEUE WHERE PUB_STATUS = 'U' union al
@arbo-hacker
arbo-hacker / test-jquery-serializearray.php
Created January 28, 2016 20:14
Demostracion de serializeArray() de JQuery
<?php
if (isset($_POST['first_name'])){
echo json_encode($_POST);
exit;
}
?>
<html>
<head>
<title>Test Serialize Array</title>
<script src="http://code.jquery.com/jquery-2.2.0.min.js"></script>
@arbo-hacker
arbo-hacker / nat-container.sh
Created February 1, 2016 20:23
Como dar salida/entrada a internet a tu Container (LXC) de Proxmox 4
#!/bin/sh
case "$1" in
start) echo "Starting iptables NAT"
#-----------------------------------------------------------------
#START NAT /////////////////////////////
#-----------------------------------------------------------------
/sbin/iptables -t nat -A POSTROUTING -s '10.0.0.0/24' -o vmbr0 -j MASQUERADE #BRIDGE
@arbo-hacker
arbo-hacker / status-tablespace-oracle.sql
Created February 4, 2016 02:24
Status de TABLESPACES en la base de datos ORACLE
-- Con el siguiente query podemos ver el status de los tablespaces o unidades lógicas de almacenamiento de la base de datos:
SELECT A.tablespace_name tablespace_name,
to_char(TRUNC(NVL(SUM(B.BYTES/1048576),0) / (A.BYTES/1048576),4)*100)||'%' pct_free,
100 - to_char(TRUNC(NVL(SUM(B.BYTES/1048576),0) / (A.BYTES/1048576),4)*100)||'%' pct_used,
NVL(TRUNC(SUM(B.BYTES/1048576),2),0)||'MB' FREE_SPACE,
TRUNC((A.BYTES/1048576)-NVL(SUM(B.BYTES/1048576),2),0)||'MB' USED_SPACE,
TRUNC(A.BYTES/1048576,2)||'MB' FILE_SIZE,
autoextensible, status
FROM DBA_DATA_FILES A, DBA_FREE_SPACE B
WHERE A.FILE_ID=B.FILE_ID (+)
@arbo-hacker
arbo-hacker / orders-in-rib.sql
Created February 4, 2016 02:28
Ordenes de compra que fueron publicadas en RIB
-- Query para determinar si las ordenes de compra fueron publicadas en RIB
select published, count(1)
from (
select distinct opi.*
from ordloc ol, ordhead oh, order_pub_info opi
where ol.location = 49
and oh.order_no = ol.order_no
and ol.order_no = opi.order_no
)
group by published;
@arbo-hacker
arbo-hacker / Querys-util-ORSIM.sql
Created February 4, 2016 02:41
Querys de tablas principales de SIM (Oracle Retail Store Inventory Management)
--Tabla de Maestro de Artículos
select * from AS_ITM where id_itm='&codigoitem';
--Tabla Item / Location
select * from RK_ITM_LCN where id_itm='&codigoitem';
--Solicitudes de Inventario
select * from rk_item_request where item_request_id=&itemrequesid;
select * from RK_ITEM_REQUEST_LINE_ITEM where item_request_id=&itemrequesid; --Detalle de Solicitud de Inventario
@arbo-hacker
arbo-hacker / validation-loadsales-rms.sql
Last active February 22, 2016 20:54
Verificar si una venta se cargo en RMS cuando el JOB POSUPLD queda en status ABORTED
-- To verify if a POSU file was successfully loaded even though the job "POSUPLD.PC" culminates in ABORTED, without errors or rejected items, verify the following query at the time it aborts:
select * from tran_data
where location=&idstore -- Store
and tran_date='&salesdate' -- Sales date
and pgm_name='posupld';
-- To verify the day after the batch
select * from if_tran_data
where location=&idstore -- Store
and tran_date='&salesdate' -- Sales date
@arbo-hacker
arbo-hacker / Start-uc4agent.sh
Created February 4, 2016 03:02
Procedimiento para levantar agentes con estatus “SRVC_DOWN” en UC4
# 1. Conectarse por línea de comandos al nodo con error con el usuario UC4.
# 2. Ir al directorio home de UC4
cd $AW_HOME
# 3. Ejecutar:
# Para levantar:
./uc4am.sh start
# Para detener:
./uc4am.sh stop
@arbo-hacker
arbo-hacker / comparacion-ventas-vs-inventario.sql
Created February 5, 2016 02:17
Como validar si se realizaron las rebajas de inventario de todos los artículos que se vendieron / devolvieron en el día en Oracle Retail (RESA vs RMS)
WITH
RESA AS
(
SELECT STD.BUSINESS_DATE FECHA,STD.STORE STORE,COUNT(DISTINCT STI.ITEM) ITEMS, SUM(STI.QTY) UNIDADES
FROM SA_TRAN_ITEM STI
JOIN SA_TRAN_HEAD STH
ON (STI.TRAN_SEQ_NO = STH.TRAN_SEQ_NO)
JOIN SA_STORE_DAY STD
ON (STD.STORE_DAY_SEQ_NO = STH.STORE_DAY_SEQ_NO)
WHERE STD.BUSINESS_DATE =&p_sales_date