From 5c87fb97220c99809021269663ac976c0b2643b0 Mon Sep 17 00:00:00 2001
From: Frank Brehm <frank@brehm-online.com>
Date: Tue, 7 Feb 2017 11:20:38 +0100
Subject: [PATCH] committing changes in /etc after emerge run

Package changes:
+dev-db/oracle-instantclient-12.1.0.2
---
 .etckeeper                   |  4 ++
 env.d/50oracle-instantclient |  6 +++
 env.d/99oracle-instantclient |  6 +++
 oracle/tnsnames.ora.sample   | 93 ++++++++++++++++++++++++++++++++++++
 4 files changed, 109 insertions(+)
 create mode 100644 env.d/50oracle-instantclient
 create mode 100644 env.d/99oracle-instantclient
 create mode 100644 oracle/tnsnames.ora.sample

diff --git a/.etckeeper b/.etckeeper
index dd51225..98e000e 100755
--- a/.etckeeper
+++ b/.etckeeper
@@ -262,12 +262,14 @@ maybe chmod 0644 'env.d/30gnupg'
 maybe chmod 0644 'env.d/37fontconfig'
 maybe chmod 0644 'env.d/50guile'
 maybe chmod 0644 'env.d/50ncurses'
+maybe chmod 0644 'env.d/50oracle-instantclient'
 maybe chmod 0644 'env.d/50postgresql'
 maybe chmod 0644 'env.d/70less'
 maybe chmod 0644 'env.d/80subversion-extras'
 maybe chmod 0644 'env.d/98ca-certificates'
 maybe chmod 0644 'env.d/99editor'
 maybe chmod 0644 'env.d/99gentoolkit-env'
+maybe chmod 0644 'env.d/99oracle-instantclient'
 maybe chmod 0755 'env.d/binutils'
 maybe chmod 0644 'env.d/binutils/config-x86_64-pc-linux-gnu'
 maybe chmod 0644 'env.d/binutils/x86_64-pc-linux-gnu-2.25.1'
@@ -630,6 +632,8 @@ maybe chmod 0400 'openldap/ssl/ldap.key'
 maybe chown 'ldap' 'openldap/ssl/ldap.pem'
 maybe chgrp 'ldap' 'openldap/ssl/ldap.pem'
 maybe chmod 0400 'openldap/ssl/ldap.pem'
+maybe chmod 0755 'oracle'
+maybe chmod 0644 'oracle/tnsnames.ora.sample'
 maybe chmod 0644 'os-release'
 maybe chmod 0755 'pam.d'
 maybe chmod 0644 'pam.d/chage'
diff --git a/env.d/50oracle-instantclient b/env.d/50oracle-instantclient
new file mode 100644
index 0000000..194ec1c
--- /dev/null
+++ b/env.d/50oracle-instantclient
@@ -0,0 +1,6 @@
+# /etc/env.d/50oracle-instantclient
+# Do not edit this file, but 99oracle-instantclient instead
+
+ORACLE_HOME=/usr/lib64/oracle/12.1/client
+LDPATH=/usr/lib64/oracle/12.1/client/lib64
+TNS_ADMIN=/etc/oracle/
diff --git a/env.d/99oracle-instantclient b/env.d/99oracle-instantclient
new file mode 100644
index 0000000..c6e97fc
--- /dev/null
+++ b/env.d/99oracle-instantclient
@@ -0,0 +1,6 @@
+# /etc/env.d/99oracle-instantclient
+# Configure system-wide defaults for your Oracle Instant Client here
+
+#ORACLE_HOME=/usr/lib64/oracle/12.1/client
+#TNS_ADMIN=/etc/oracle/
+#NLS_LANG=
diff --git a/oracle/tnsnames.ora.sample b/oracle/tnsnames.ora.sample
new file mode 100644
index 0000000..f0524f5
--- /dev/null
+++ b/oracle/tnsnames.ora.sample
@@ -0,0 +1,93 @@
+# This file contains the syntax information for 
+# the entries to be put in any tnsnames.ora file
+# The entries in this file are need based. 
+# There are no defaults for entries in this file
+# that Sqlnet/Net3 use that need to be overridden 
+#
+# Typically you could have two tnsnames.ora files
+# in the system, one that is set for the entire system
+# and is called the system tnsnames.ora file, and a
+# second file that is used by each user locally so that
+# he can override the definitions dictated by the system
+# tnsnames.ora file.
+
+# The entries in tnsnames.ora are an alternative to using
+# the names server with the onames adapter.
+# They are a collection of aliases for the addresses that 
+# the listener(s) is(are) listening for a database or 
+# several databases.
+
+# The following is the general syntax for any entry in 
+# a tnsnames.ora file. There could be several such entries 
+# tailored to the user's needs.
+
+<alias>= [ (DESCRIPTION_LIST =  # Optional depending on whether u have 
+				# one or more descriptions
+				# If there is just one description, unnecessary ]
+	  (DESCRIPTION=
+	    [ (SDU=2048) ]	# Optional, defaults to 2048
+				# Can take values between 512 and 32K
+	    [ (ADDRESS_LIST=    # Optional depending on whether u have
+				# one or more addresses
+				# If there is just one address, unnecessary ]
+	      (ADDRESS=
+		[ (COMMUNITY=<community_name>) ] 
+		(PROTOCOL=tcp)
+		(HOST=<hostname>)
+		(PORT=<portnumber (1521 is a standard port used)>)
+	      )
+	      [ (ADDRESS=
+		  (PROTOCOL=ipc)
+		  (KEY=<ipckey (PNPKEY is a standard key used)>)	
+		)
+	      ]
+	      [ (ADDRESS=
+		  [ (COMMUNITY=<community_name>) ]
+		  (PROTOCOL=decnet)
+		  (NODE=<nodename>)
+		  (OBJECT=<objectname>)
+		)
+	      ]
+              ... # More addresses
+	    [ ) ] # Optional depending on whether ADDRESS_LIST is used or not 
+	    [ (CONNECT_DATA=
+		(SID=<oracle_sid>)
+		[ (GLOBAL_NAME=<global_database_name>) ]
+	      )
+	    ]
+	    [ (SOURCE_ROUTE=yes) ]  
+	  )
+	  (DESCRIPTION=     
+	    [ (SDU=2048) ]	# Optional, defaults to 2048
+				# Can take values between 512 and 32K
+	    [ (ADDRESS_LIST= ]	# Optional depending on whether u have more
+				# than one address or not
+				# If there is just one address, unnecessary
+	      (ADDRESS
+		[ (COMMUNITY=<community_name>) ]
+		(PROTOCOL=tcp)
+		(HOST=<hostname>)
+		(PORT=<portnumber (1521 is a standard port used)>)
+	      )
+	      [ (ADDRESS=
+		  (PROTOCOL=ipc)
+		  (KEY=<ipckey (PNPKEY is a standard key used)>)
+	         )
+	      ]
+	      ... 		# More addresses
+	    [ ) ] 		# Optional depending on whether ADDRESS_LIST  
+				# is being used
+	    [ (CONNECT_DATA=
+		(SID=<oracle_sid>)
+		[ (GLOBAL_NAME=<global_database_name>) ]
+	      )
+	    ]
+	    [ (SOURCE_ROUTE=yes) ]
+	  )
+	  [ (CONNECT_DATA=
+	      (SID=<oracle_sid>)
+	      [ (GLOBAL_NAME=<global_database_name>) ]
+	    )
+	  ]
+	  ...   # More descriptions 
+	[ ) ]	# Optional depending on whether DESCRIPTION_LIST is used or not
-- 
2.39.5