Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.
- Owned all database oracle dba clients
- https://www.google.fr/?gfe_rd=cr&ei=c9m4WJOkNIHu8weIz7PAAQ&gws_rd=cr#q=oracledba.com.br&*
- oracledba.com.br
- suporte.oracledba.com.br/phpmyadmin - user: root pass: ripd40
- -- phpMyAdmin SQL Dump
- --
- -- Database: `2com`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `cliente`
- --
- CREATE TABLE IF NOT EXISTS `cliente` (
- `IDCliente` int(11) NOT NULL AUTO_INCREMENT,
- `NomeFantasia` varchar(100) NOT NULL,
- `RazaoSocial` varchar(100) DEFAULT NULL,
- `CNPJ` varchar(20) NOT NULL,
- `Tipo` char(1) NOT NULL,
- `InscricaoMunicipal` varchar(45) DEFAULT NULL,
- `InscricaoEstadual` varchar(45) DEFAULT NULL,
- `Ativo` int(11) NOT NULL,
- `Telefone1` varchar(20) NOT NULL,
- `Telefone2` varchar(20) DEFAULT NULL,
- `Site` varchar(100) DEFAULT NULL,
- `DataCadastro` datetime NOT NULL,
- `Status` int(11) NOT NULL,
- `IPHost` varchar(15) DEFAULT NULL,
- `IPHost2` varchar(15) NOT NULL,
- `QtdHoras` int(11) NOT NULL DEFAULT '0',
- `Url` varchar(255) NOT NULL,
- `FichaTecnica` mediumtext,
- `ExibirHelpDesk` int(1) DEFAULT '0',
- `Latitude` varchar(100) DEFAULT NULL,
- `Longitude` varchar(100) DEFAULT NULL,
- `Regiao` int(11) DEFAULT NULL,
- PRIMARY KEY (`IDCliente`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=923 ;
- --
- -- Dumping data for table `cliente`
- --
- INSERT INTO `cliente` (`IDCliente`, `NomeFantasia`, `RazaoSocial`, `CNPJ`, `Tipo`, `InscricaoMunicipal`, `InscricaoEstadual`, `Ativo`, `Telefone1`, `Telefone2`, `Site`, `DataCadastro`, `Status`, `IPHost`, `IPHost2`, `QtdHoras`, `Url`, `FichaTecnica`, `ExibirHelpDesk`, `Latitude`, `Longitude`, `Regiao`) VALUES
- (4, 'PRODAMA ORACLE', ' PRODAMA SERVICOS EM TECNOLOGIA DA INFORMACAO LTDA - ME ', '12904672000100', 'J', '', '', 1, '(44)3361-6452', '', '', '(873, 'NOVA ROVER DISTRIBUIDORA DE ALIMENTOS S.A', 'NOVA ROVER DISTRIBUIDORA DE ALIMENTOS S.A', '18.171.499/0001-65', 'J', '-', '-', 0, '(69)3222-2685', '', '', '2016-11-11 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 1),
- (874, 'PAPELEX ', 'COMERCIO DE PAPEIS PAPELEX LTDA', '07.650.459/0002-60', 'J', '-', '79.545.910', 1, '(21)2187-8688', '', 'www.papelex.com.br/', '2016-11-14 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 3),
- (875, 'DALMORO EQUIPAMENTOS DE PROTECAO', 'DALMORO EQUIPAMENTOS DE PROTECAO', '10.953.364/0001-40', 'J', '-', '90488051-56', 1, '(45)3264-0066', '', '', '2016-11-14 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 5),
- (876, 'PEMAZA ', 'PEMAZA AMAZONIA S/A ', '22.763.502/0001-07', 'J', '-', '04.186.996-6 ', 1, '(92)3616-4977', '', '', '2016-11-17 00:00:00', 2, '-', '-', 0, '-', '<p>Servidor Banco PROD:</p>\n\n<p>189.2.127.245 - Porta 10022 - usuário: root / senha: PemazaOracle2016##</p>\n\n<p><strong>Compartilhameto NFS:</strong></p>\n\n<p>192.168.150.11:/backup_oracle</p>\n\n<p> </p>\n\n<p> </p>\n\n<p>VPN 1 = 162.16.175.43</p>\n\n<p>IP INterno: 192.168.150.1</p>\n\n<p>NOme: servprod</p>\n\n<p>Senha root: PemazaOracle2016##</p>\n\n<p>Senha 2com: fall098*</p>\n\n<p>=============================================SERVIDOR ODA=============</p>\n\n<p><strong>ODA BASE</strong><br />\n127.0.0.1 localhost.localdomain localhost</p>\n\n<p># PUBLIC HOSTNAMES<br />\n192.168.151.1 pemaza0.grupopmz.com.br pemaza0<br />\n# PRIVATE HOSTNAMES<br />\n192.168.16.27 pemaza1-priv0.grupopmz.com.br pemaza1-priv0<br />\n192.168.16.28 pemaza2-priv0.grupopmz.com.br pemaza2-priv0</p>\n\n<p># NET(0-3) HOSTNAMES<br />\n192.168.151.1 pemaza0.grupopmz.com.br pemaza0<br />\n192.168.151.2 pemaza1.grupopmz.com.br pemaza1</p>\n\n<p># VIP HOSTNAMES<br />\n192.168.151.3 pemaza0-vip.grupopmz.com.br pemaza0-vip<br />\n192.168.151.4 pemaza1-vip.grupopmz.com.br pemaza1-vip</p>\n\n<p># Below are SCAN IP addresses for reference.<br />\n# SCAN_IPS=(192.168.151.5 192.168.151.6)<br />\n192.168.151.215 cloudcontrol.grupopmz.com.br cloudcontrol</p>\n\n<p><strong><span style="color:#008000">--------HYPERVISOR 0 ---------------</span></strong></p>\n\n<p><strong><span style="color:#B22222">Hostname</span></strong>:<strong> pmz-dom0node0</strong><br />\n <br />\n<strong>ibbond0 </strong>192.168.16.24 Bcast:192.168.16.255 Mask:255.255.255.0</p>\n\n<p><strong>net1 </strong>192.168.151.20 Bcast:192.168.151.255 Mask:255.255.254.0</p>\n\n<p><strong>vbr1 </strong>192.168.18.1 Bcast:192.168.18.255 Mask:255.255.255.0</p>\n\n<p><strong><span style="color:#006400">--------HYPERVISOR 1 ---------------</span></strong></p>\n\n<p><strong><span style="color:#B22222">Hostname</span></strong>: <strong>pmz-dom0node1</strong><br />\n<br />\n<strong>ibbond0 </strong>192.168.16.25 Bcast:192.168.16.255 Mask:255.255.255.0</p>\n\n<p><strong>net1 </strong>192.168.151.21 Bcast:192.168.151.255 Mask:255.255.254.0</p>\n\n<p><strong>vbr1 </strong>192.168.19.1 Bcast:192.168.19.255 Mask:255.255.255.0</p>\n\n<p> </p>\n\n<p>============= RAC1</p>\n\n<p>hostname: pemaza0.grupopmz.com.br</p>\n\n<p>IPs Locais: 192.168.151.1, 192.168.151.3 192.168.151.6</p>\n\n<p>VPN1 (tap1) - 162.16.175.55</p>\n\n<p>VLAN (veth1) -192.168.18.20</p>\n\n<p>usuário: root</p>\n\n<p>senha: welcome1 (provisoria)</p>\n\n<p>usuário: 2com</p>\n\n<p>senha: fall098*</p>\n\n<p>============= RAC2</p>\n\n<p>pemaza1.grupopmz.com.br </p>\n\n<p>IPs Locais: 192.168.151.2, 192.168.151.4 192.168.151.5</p>\n\n<p>VPN1 (tap1) - 172.16.175.62</p>\n\n<p>VLAN (veth1) -192.168.19.20</p>\n\n<p>usuário: root</p>\n\n<p>senha: welcome1 (provisoria)</p>\n\n<p>usuário: 2com</p>\n\n<p>senha: fall098*</p>\n\n<p>OBS.: Acesso com chave pelo servidor de banco em produção.</p>\n', 1, '', '', 1),
- (877, 'DIPAM GAUCHA DISTRIBUIDORA LTDA', 'DIPAM GAUCHA DISTRIBUIDORA', '91.222.133/0001-68', 'J', '-', '096/3316923', 1, '(51)3051-5655', '', 'www.dipamgaucha.com.br', '2016-11-18 00:00:00', 2, '172.16.175.156', '178.16.175.156', 4, '-', '<p><strong>Ficha Técnica :</strong></p>\n\n<p>Banco de dados : Oracle</p>\n\n<p>Versão : Oracle Database 11g Release 11.2.0.4.0 - 64bit Production </p>\n\n<p>Usuários -</p>\n\n<p><strong>Instância </strong>: WINT<br />\nSYS Manager86dip87<br />\nSYSTEM Manager11dip54<br />\nDBSNMP <br />\nSYSMAN <br />\nDIPAM D1P4M67 </p>\n\n<p><br />\nInformações Servidor.<br />\n <br />\nIP VPN 1 : 172.16.175.156<br />\nIP VPN 2 : <br />\nIP Interno : 90.0.0.125<br />\nHostname: DIPAN-001<br />\nSistema Operacional / Versão : Oracle Linux Server release 5.8<br />\nVersão SAMBA : 3.0.33-3.37<br />\nTipo de Redundância dos Backups: </p>\n', 1, '', '', 5),
- (878, 'DISTRIBUIDORA MASCOTE LTDA ', 'DISTRIBUIDORA MASCOTE LTDA ', '07.548.056/0001-24', 'J', '-', ' 082.342.53-9', 1, '(28)3553-2850', '', '', '2016-11-18 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 3),
- (879, 'Adriana Sementes', 'ODILIO BALBINOTTI FILHO E OUTRO', '596.770.159-15', 'J', '-', '132576929', 1, '(66)3411-9950', '', '', '2016-11-18 00:00:00', 2, '162.16.175.24', '-', 0, '-', '<p>=========| BANCO DE DADOS</p>\n\n<p>usuário: root<br />\nsenha: S@Oracl4Prd!</p>\n\n<p>usuário: 2com</p>\n\n<p>senha: fall098*<br />\nip local banco: 172.16.0.6</p>\n\n<p>VPN1: 172.16.175.85</p>\n\n<p>=========| STORAGE (WINDOWS SERVER)</p>\n\n<p>usuário: backup</p>\n\n<p>senha: backup098*</p>\n\n<p>compartilhamento: backup</p>\n\n<p>OBS.: IRÁ ADQUIRIR HD EXTERNO PARA BACKUP DEDICADO DO BANCO (22/02/2017)</p>\n', 1, '', '', 4),
- (887, 'VILA NOVA VARIEDADES', 'COMERCIAL VILA NOVA VARIEDADES LTDA - EPP', '19.054.153/0001-40', 'J', '-', '-', 1, '(99)2101-0300', '', '', '2016-12-01 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 2),
- (881, 'CASA DEZ', 'CASA DEZ COMERCIO LTDA', '05.898.706/0001-36', 'J', '-', '062.762.415 ', 1, '(71)3617-1100', '', '', '2016-11-23 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 2),
- (882, 'CENTERNORTE ', 'CENTERNORTE DISTRIBUIDORA DE ALIMENTOS LTDA', '04.899.081/0002-45', 'J', '-', '-', 1, '(38)3218-3400', '', '', '2016-11-24 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 3),
- (883, 'MONACO DIESEL ', 'MONACO DIESEL LTDA', '05.024.583/0001-04', 'J', '-', '-', 1, '(91)3075-5000', '', '', '2016-11-24 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 1),
- (884, 'TECHNICOLOR BRASIL', 'TECHNICOLOR BRASIL MIDIA E ENTRETENIMENTO LTDA', '02.773.531/0001-42', 'J', '-', '-', 1, '(92)3652-9005', '', '', '2016-11-28 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 1),
- (885, 'MUNDIAL ATACADISTA', 'MUNDIAL CENTER ATACADISTA LTDA ', '01.713.958/0001-92', 'J', '-', '10.466.406-1', 1, '(61)2108-3812', '(61)2108-3803', 'http://www.mundialatacadista.com.br/', '2016-11-29 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 4),
- (886, 'Cosme e Damiao', 'Cosme e Damiao Comercio e Distribuicao LTDA', '31.146.632/0001-91', 'J', '-', '78253410', 1, '(24)2103-3600', '(24)2103-3601', 'www.cosmedamiaocomercio.com.br', '2016-11-29 00:00:00', 2, '162.16.175.11', '-', 4, '-', '<p>##--Servidor produção--##</p>\n\n<p>Usuário: root<br />\nSenha: cosme098#@<br />\nExterno: 186.219.34.44 porta 2222 - Produção<br />\nVPN1: 162.16.175.11 (Testar)<br />\nVPN2:<br />\nLAN: 192.168.0.254</p>\n\n<p>Sys:Manager01cos<br />\n?System:Manager02cos</p>\n\n<p><br />\n##--Servidor Standby--##<br />\nUsuário: root<br />\nsenha: ro89#std<br />\nExterno: 186.219.34.44 porta 2223<br />\nVPN1: 162.16.175.211<br />\nVPN2:<br />\nLAN: 192.168.0.253</p>\n\n<p> </p>\n', 1, '', '', 3),
- (889, 'AVIPEC ', 'COMERCIAL DE RACOES PROD AGROPECUARIOS NORMANDIA LTDA', '72.537.137/0002-71', 'J', '-', '06.666147-1', 1, '(85)3535-5000', '(85)3453-7144', 'www.avipec.com.br', '2016-12-08 00:00:00', 1, '-', '-', 0, '-', '', 0, NULL, NULL, NULL),
- (890, 'CAMARA DE DIRIGENTES LOJISTAS DE BH', 'CDL/BH ', '17.179.359/0001-70', 'J', '-', '-', 1, '(31)3249-1666', '', '', '2016-12-13 00:00:00', 1, '-', '-', 0, '-', '', 0, '', '', 3),0000-00-00 00:00:00', 1, '-', '-', 0, '-', '<p>Ficha Tecnica :</p>\n\n<p>Banco de dados : Oracle</p>\n\n<p>Versão : </p>\n\n<p>Usuários -</p>\n\n<p>Intancia : <br />\nSYS <br />\nSYSTEM <br />\nDBSNMP <br />\nSYSMAN </p>\n\n<p><br />\nInformações Servidor.<br />\n <br />\nIP VPN 1 : <br />\nIP VPN 2 : <br />\nIP Interno : <br />\nHostname: <br />\nSistema Operacional / Versão : <br />\nVersão SAMBA : <br />\nTipo de Redundância dos Backups:</p>\n', 1, '', '', 5),
- (7, 'CAIRU TRANSPORTES', 'CAIRU TRANSPORTES', '84600378000116', 'J', '', '00000000519804', 1, '(69)3451-0500', '', '', '0000-00-00 00:00:00', 2, '-', '', 0, '', '<p>189.53.73.195:3396</p>\n\n<p>username=2com,password=spring098*,domain=cairucomb</p>\n\n<p>sa</p>\n\n<p>1qaz@WSX</p>\n', 1, NULL, NULL, 1),
- (37, 'AGUIA DISTRIBUIDORA DE ALIMENTOS LTDA ', 'AGUIA DISTRIBUIDORA DE ALIMENTOS LTDA ', '10512786000180', 'J', '', '06.373551-2', 1, '(85) 3459-0313', '', '', '2014-05-15 00:00:00', 2, '172.16.175.61', '', 0, '', '<p>Ficha Tecnica :</p>\r\n<p>Banco de dados : Oracle</p>\r\n<p>Versão : </p>\r\n<p>Usuários -</p>\r\n<p>Intancia : <br />\r\nSYS <br />\r\nSYSTEM <br />\r\nDBSNMP <br />
- http://suporte.oracledba.com.br/helpdesk/Login.php
- Teste ricsanber@gmail.com 827ccb0eea8a706c4c34a16891f84e7b d6aa3ea52e7fdb25cfab4602648b9e63
- Edit Delete Marcio marciochagasramos@gmail.com 202cb962ac59075b964b07152d234b70 b0929b9ebca736359de9189101917677
- Edit Delete Ulisses Baptista ulisses@oracledba.com.br a2849860c52c0c24c818112e6ddf17b3 605dae6157b9f7fb7559e6efcd85f356
- Edit Delete Fernando Martins fernando@oracledba.com.br d693c4871a99d7acf43c4b1112da0c6e 85e830ff183d64745469692351dcc78f
- Edit Delete Gustavo gustavo@oracledba.com.br e031372b1e1763572da5c3b4dc298ccf 61efb92177564aa558e8dcda7943715e
- Edit Delete Hercules Silva hercules@oracledba.com.br fe01eb049c2d47f90619cde5c00f7d6d 29f42e639666872bbc497649a23a2ad7
- Edit Delete Hirlane Garcia hirlane@oracledba.com.br 9f9d1df00a790873908c5e70b32f7ddb 5e42d0281d74300154783cfffda00f17
- Edit Delete Ricardo Pereira ricardo@oracledba.com.br 6e9552c9bd8e61c8f277c21220160234 5de88a114ce6365369618230cf9e39db
- Edit Delete Unilson unilson@oracledba.com.br 11124d80dd311754737989a6814f943f b90a5fe26b9a37e93adfc3535308ba80
- Edit Delete Jairo Carneiro jairo@oracledba.com.br 9e684ef74a86656f6a5cf5624d0e74ab dd57dc9f0aa459dd0810f27f7085a1d7
- Edit Delete Financeiro financeiro@oracledba.com.br 11124d80dd311754737989a6814f943f 109f418b3ab9045319e3dda25027719b
- Edit Delete Natanael natanael@oracledba.com.br 498787ad7b82b4db49f250b03f22381c 0ead691b9c4de9d7685741a37b9a4bcd
- Edit Delete Luciana luciana@oracledba.com.br 9fe2e71db4a25b119b2b28f6376ad893 ec7c1947e1aa754ffebf9eff980bea70
- Edit Delete Ronaldo ronaldo@oracledba.com.br 0ec8557228985e2f680c1cd681056157
- Edit Delete Abner abner@oracledba.com.br d318a8e441ec562795d5fd19f125550b
- Edit Delete Caroline Brum carol@oracledba.com.br 11124d80dd311754737989a6814f943f 64e892485d7af4ce95e9056792d5e525
- Edit Delete Flavia flavia@oracledba.com.br 11124d80dd311754737989a6814f943f e92fd1106e52e739df8132fccf1aa5e2
- Edit Delete Jorge jorge@oracledba.com.br 38b94bb063d943c5ef18f5c63944891b 4bd9fe5ca2c51aad5d59d6f857dfedf8
- Edit Delete Rudney Sabino rudney@oracledba.com.br 005a85452be22bbfa8a6728124fd4505 ba70c4c8aa728669a2913209531c71ec
- Edit Delete Thaylane Torres thaylane@oracledba.com.br 382ae4f5dee8aaf0b3db30810109a129 81acc771c0876fafc1a0802806a74f57
- Edit Delete Giselle giselle@oracledba.com.br 4f252401c25e3e495a9f96b3f510dc5b 440e68c059a2690bf34309b020914030
- Edit Delete Daniel Lima daniel@oracledba.com.br 1726af9765894cffc6b7588e7842c62f 7a654f5a6b849f004d6022b66061eddd
- Edit Delete Eduardo Ataide Ribeiro eduardo@oracledba.com.br b9c589df090d279ea6561be52d295045 7754791983a09d088094ad0e97ba3d1d
- Edit Delete Caroline Santos caroline.santos@oracledba.com.br 11124d80dd311754737989a6814f943f ef0d390e3fb798d6c459579b93e6311b
- Edit Delete Dayane Matos dayane@oracledba.com.br 4aa606997465fd6fc4e825ff8695fcdf fdd37026e9503518ed21f95c54611b63
- Edit Delete Renata Neiva renata@oracledba.com.br 62961d00ea27134f1421c56479e30e0b 71da25b4d277065731e7e99bfadaa34a
- Edit Delete Felipe Marques felipe@oracledba.com.br 18ed4649e7057787d889781ef7788657 a3699c48223b050d3b912c9699958bd2
- Edit Delete Ariel ariel@oracledba.com.br d2016189f39ba77cc8be78e45775bc40 2cfd0e536776c43e0177bf3482706ae2
- Edit Delete Denison Caldeira denison@oracledba.com.br c7dfcc55ec743c32c32893041b2b8d8e 18e6f9c6843ee78ec878ff5a1a9d33ec
- Edit Delete Renan Menezes renan@oracledba.com.br a2849860c52c0c24c818112e6ddf17b3 3a9042bea7ed644f1045f8a646d814e8
- http://186.202.136.92/cons_contato.aspx
- suporte.oracledba.com.br
- suporte.oracledba.com.br/helpdesk
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement