David Le Borgne dleborgne
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /******************************************************** | |
| COPYRIGHTS http://www.ranjithk.com | |
| *********************************************************/ | |
| CREATE PROCEDURE CleanUpSchema | |
| ( | |
| @SchemaName varchar(100) | |
| ,@DropSchema char(1) = 'n' -- use 'y' to drop schema after cleanup | |
| ) | |
| AS | |
| /*----------------------------------------------------------------------------------------- |
dleborgne
/ userDefineLang_Dockerfile.xml
Last active
March 5, 2019 13:28
— forked from centic9/userDefineLang_Dockerfile.xml
notepad++ syntax highlighting for Dockerfiles
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <NotepadPlus> | |
| <UserLang name="Dockerfile" ext="Dockerfile" udlVersion="2.1"> | |
| <Settings> | |
| <Global caseIgnored="no" allowFoldOfComments="no" foldCompact="no" forcePureLC="0" decimalSeparator="0" /> | |
| <Prefix Keywords1="no" Keywords2="no" Keywords3="no" Keywords4="no" Keywords5="no" Keywords6="no" Keywords7="no" Keywords8="no" /> | |
| </Settings> | |
| <KeywordLists> | |
| <Keywords name="Comments">03 04 00# 01 02</Keywords> | |
| <Keywords name="Numbers, prefix1"></Keywords> | |
| <Keywords name="Numbers, prefix2"></Keywords> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Trace file C:\oracle\diag\clients\user_Administrateur\host_332782822_82\trace\ora_1764_4440.trc | |
| 2018-02-19 17:46:44.002840 : nlstddt_do_alter_trace:--- TRACE CONFIGURATION INFORMATION FOLLOWS --- | |
| 2018-02-19 17:46:44.063511 : nlstddt_do_alter_trace:New trace stream is C:\oracle\diag\clients\user_Administrateur\host_332782822_82\trace\ora_1764_4440.trc | |
| 2018-02-19 17:46:44.063554 : nlstddt_do_alter_trace:New trace level is 10 | |
| 2018-02-19 17:46:44.063577 : nlstddt_do_alter_trace:--- TRACE CONFIGURATION INFORMATION ENDS --- | |
| 2018-02-19 17:46:44.063605 : nlstdtp_trace_pfile:--- PARAMETER SOURCE INFORMATION FOLLOWS --- | |
| 2018-02-19 17:46:44.063671 : nlstdts_trace_source:Attempted load of system pfile source C:\oracle\product\12.1.0\client_1\network\admin\sqlnet.ora | |
| 2018-02-19 17:46:44.063713 : nlstdts_trace_source:Parameter source loaded successfully | |
| 2018-02-19 17:46:44.063732 : nlstdts_trace_source: | |
| 2018-02-19 17:46:44.063749 : nlstdts_trace_source:Attempted load of local pfile source C:\Users\Administrateur\sqlnet.ora |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ENCRYPTION_WALLET_LOCATION = | |
| (SOURCE = | |
| (METHOD = FILE) | |
| (METHOD_DATA = | |
| (DIRECTORY = /opt/oracle/product/12.1.0/dbhome_1/owm/wallets/oracle) | |
| ) | |
| ) | |
| SQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SSL_CLIENT_AUTHENTICATION = FALSE | |
| WALLET_LOCATION = | |
| (SOURCE = | |
| (METHOD = FILE) | |
| (METHOD_DATA = | |
| (DIRECTORY = /opt/oracle/product/12.1.0/dbhome_1/owm/wallets/oracle) | |
| ) | |
| ) |
dleborgne
/ gist:a02e3567eab2c1f3b33180a4c5c67aff
Created
February 16, 2018 09:55
yum update log (oracle101)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Feb 15 14:07:08 Updated: ca-certificates-2017.2.14-65.0.1.el6_9.noarch | |
| Feb 15 14:07:11 Updated: rhn-client-tools-1.0.0.1-43.0.3.el6.noarch | |
| Feb 15 14:07:28 Updated: linux-firmware-20171128-56.git17e62881.0.2.el6.noarch | |
| Feb 15 14:07:32 Updated: selinux-policy-3.7.19-307.0.1.el6_9.3.noarch | |
| Feb 15 14:07:35 Updated: tzdata-java-2018c-1.el6.noarch | |
| Feb 15 14:07:35 Updated: 12:dhcp-common-4.1.1-53.P1.0.1.el6_9.1.x86_64 | |
| Feb 15 14:07:37 Installed: kernel-uek-firmware-4.1.12-112.14.15.el6uek.noarch | |
| Feb 15 14:07:38 Updated: python-sssdconfig-1.13.3-57.el6_9.noarch | |
| Feb 15 14:07:42 Updated: tzdata-2018c-1.el6.noarch | |
| Feb 15 14:07:43 Updated: nss-softokn-freebl-3.14.3-23.3.0.1.el6_8.x86_64 |
dleborgne
/ gist:b3b16e0075e4a381403c2465b6befa23
Created
February 16, 2018 09:49
Oracle JDBC TLS 1.2 handshake failure verbose log
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| adding as trusted cert: | |
| Subject: CN=Oracle Certificate Authority, O=COMPANY, L=SURESNES, ST=ILE-DE-FRANCE, C=FR | |
| Issuer: CN=Oracle Certificate Authority, O=COMPANY, L=SURESNES, ST=ILE-DE-FRANCE, C=FR | |
| Algorithm: RSA; Serial number: 0x5a267b7d | |
| Valid from Tue Dec 05 11:57:01 CET 2017 until Wed Dec 05 11:57:01 CET 2018 | |
| trigger seeding of SecureRandom | |
| done seeding SecureRandom | |
| Using SSLEngineImpl. | |
| Allow unsafe renegotiation: false |
dleborgne
/ system.out.log
Created
January 23, 2018 14:06
JBoss AS 7.1.1 startup error with Java 7 update 171
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Calling "C:\PRODUCT\jboss-as-7.1.1\bin\standalone.conf.bat" | |
| "JAVA_OPTS already set in environment; overriding default settings with values: -server -Xrs -Xms256m -Xmx512m -XX:MaxPermSize=128m -Dproduct.home=C:\PRODUCT -Djboss.server.base.dir=C:\PRODUCT\jboss-as-7.1.1\standalone -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djboss.server.default.config=standalone.xml " | |
| =============================================================================== | |
| JBoss Bootstrap Environment | |
| JBOSS_HOME: C:\PRODUCT\jboss-as-7.1.1 | |
| JAVA: C:\Java\jdk1.7.0\bin\java |
dleborgne
/ wildfly-10-install.sh
Last active
April 12, 2018 08:08
— forked from sukharevd/wildfly-install.sh
Script to install JBoss Wildfly 10.x as service in Linux
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| #title :wildfly-install.sh | |
| #description :The script to install Wildfly 10.x | |
| #more :http://sukharevd.net/wildfly-8-installation.html | |
| #author :Dmitriy Sukharev | |
| #date :2016-06-18T02:45-0700 | |
| #usage :/bin/bash wildfly-install.sh | |
| #tested-version1 :10.1.0.Final | |
| #tested-distros1 :CentOS 7; Fedora 22 |
dleborgne
/ teradata-northwind.sql
Last active
December 3, 2017 23:25
This SQL script creates the Northwind database on Teradata
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- This SQL script creates the Northwind database on Teradata | |
| -- It has been created from https://developer.teradata.com/sites/all/files/TeradataNorthwind.zip | |
| -- DROP TABLE OrderDetails; | |
| -- DROP TABLE InternationalOrders; | |
| -- DROP TABLE EmployeesTerritories; | |
| -- DROP TABLE Orders; | |
| -- DROP TABLE Products; | |
| -- DROP TABLE Territories; | |
| -- DROP TABLE Customers; |
NewerOlder