# SPEC file for
# oracle-instantclient-basic
# oracle-instantclient-devel
# oracle-instantclient-sqlplus
# oracle-instantclient-jdbc
# oracle-instantclient-odbc
# oracle-instantclient-tools

%define __arch_install_post /bin/true

#%global mainver 11.2

Summary: 	Instant Client for Oracle Database 11g
Name: 		oracle-instantclient
Version: 	11.2.0.2.0
Release:	3%{?dist}
License:	Oracle
Group:		Productivity/Databases/Clients
Url:		http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

Source0:	instantclient-basic-linux32-%{version}.zip
Source1:	instantclient-jdbc-linux32-%{version}.zip
Source2:	instantclient-odbc-linux32-%{version}.zip
Source3:	instantclient-sdk-linux32-%{version}.zip
Source4:	instantclient-sqlplus-linux32-%{version}.zip
Source5:	instantclient-tools-linux32-%{version}.zip
Source6:	instantclient-precomp-linux32-%{version}.zip

NoSource:       0
NoSource:       1
NoSource:       2
NoSource:       3
NoSource:       4
NoSource:       5
NoSource:       6

Source10:	instantclient-basic-linux-x86-64-%{version}.zip
Source11:	instantclient-jdbc-linux-x86-64-%{version}.zip
Source12:	instantclient-odbc-linux-x86-64-%{version}.zip
Source13:	instantclient-sdk-linux-x86-64-%{version}.zip
Source14:	instantclient-sqlplus-linux-x86-64-%{version}.zip
Source15:	instantclient-tools-linux-x86-64-%{version}.zip
Source16:	instantclient-precomp-linux-x86-64-%{version}.zip

NoSource:       10
NoSource:       11
NoSource:       12
NoSource:       13
NoSource:       14
NoSource:       15
NoSource:       16

Source20:       %{name}-config 
Source21:	%{name}-rpmlintrc

Buildroot: 	%(mktemp -ud %{_tmppath}/%{name}-%{version}-%{release}-XXXXXX)
BuildArch:      i386 x86_64
BuildRequires:  unzip

%define topdir	instantclient_11_2
%define precomptopdir precomp/instantclient_11_2
%define oradir	%{_libdir}/oracle/%{version}/client
%define incdir	%{_includedir}/oracle/%{version}/client

%description
Base files for Instant Client.  Support for OCI, OCCI, 
and JDBC-OCI applications.

%package devel
Summary:	Development headers for Instant Client
Group:		Development/Libraries/Other
Requires: 	%{name} = %{version}

%description devel
Additional header files and an example Makefile for developing Oracle
applications with Instant Client.

%package jdbc
Summary: 	Supplemental JDBC features under Instant Client
Group:		Productivity/Databases/Tools
Requires: 	%{name} = %{version}

%description jdbc
Additional support for XA, Internationalization,
and RowSet operations under JDBC.

%package odbc
Summary: 	Oracle  ODBC Instant Client for Linux
Group:		Productivity/Databases/Tools
Requires: 	%{name} = %{version}

%description odbc
Oracle  ODBC Instant Client for Linux complies with 
ODBC 3.52 specifications. It is based on features of 
Oracle %{version}  ODBC driver for Windows, without 
the need for a traditional ORACLE_HOME installation.

%package sqlplus
Summary:	SQL*Plus for Instant Client
Group:		Productivity/Databases/Clients
Requires: 	%{name} = %{version}

%description sqlplus
Additional libraries and executable for running 
SQL*Plus with Instant Client.

%package tools
Summary:	Tools for Oracle Database 11g
Group:		Productivity/Databases/Tools
Requires: 	%{name} = %{version}

%description tools
This package provides tools to be used with the Oracle Database.
It currently includes
- wrc : a client to be used with the Database Replay feature

%package precomp
Summary:	Oracle Precompilers for Pro*C and Pro*COBOL
Group:		Development/Languages/Other
Requires:	%{name} = %{version}, %{name}-precomp-devel = %{version}
%if 0%?suse_version >= 1010
Recommends:	%{name}-devel = %{version}
%endif

%description precomp
PRECOMP Instant Client (IC) Package contains following
components:
  i) "proc" binary to precompile a Pro*C application
 ii) "procob" binary to precompile a Pro*COBOL application
iii) sample configuration files, demo programs and demo
     make files for building proc and procob demos and
     in general any Pro*C/Pro*COBOL application.

%package precomp-devel
Summary:        Libraries needed by precompilers for Pro*C and Pro*COBOL
Group:          Development/Libraries/Other
Requires:       %{name} = %{version}

%description precomp-devel
Required libraries to run Pro*C and Pro*COBOL precompiler

%prep
rm -rf %{topdir}

%{__sed} -i -e "s/@version@/%{version}/g" -e "s/@lib@/%{_lib}/g" %{SOURCE21}

%ifarch i386
unzip %{SOURCE0}
unzip %{SOURCE1}
unzip %{SOURCE2}
unzip %{SOURCE3}
unzip %{SOURCE4}
unzip %{SOURCE5}
unzip -d precomp %{SOURCE6}
%else
unzip %{SOURCE10}
unzip %{SOURCE11}
unzip %{SOURCE12}
unzip %{SOURCE13}
unzip %{SOURCE14}
unzip %{SOURCE15}
unzip -d precomp %{SOURCE16}
%endif

%build

%install
#rm -rf %{buildroot}

cd %{topdir}
chmod 0644 *.{htm,html} 

%{__install} -d -m0755 %{buildroot}%{_bindir}   
%{__install} -d -m0755 %{buildroot}%{oradir}/{bin,lib,precomp,precomp/admin,network,network/admin}   
%{__install} -d -m0755 %{buildroot}%{incdir}  
%{__install} -d -m0755 %{buildroot}%{_sysconfdir}/ld.so.conf.d
%{__install} -d -m0755 %{buildroot}%{_sysconfdir}/profile.d

# Basic
%{__install} -m0755 adrci		%{buildroot}%{oradir}/bin
%{__install} -m0755 genezi		%{buildroot}%{oradir}/bin
%{__install} -m0755 uidrvci		%{buildroot}%{oradir}/bin
%{__install} -m0755 libclntsh.so.11.1	%{buildroot}%{oradir}/lib
%{__install} -m0755 libnnz11.so		%{buildroot}%{oradir}/lib
%{__install} -m0755 libocci.so.11.1	%{buildroot}%{oradir}/lib
%{__install} -m0755 libociei.so		%{buildroot}%{oradir}/lib
%{__install} -m0755 libocijdbc11.so	%{buildroot}%{oradir}/lib
%{__install} -m0644 ojdbc5.jar		%{buildroot}%{oradir}/lib
%{__install} -m0644 ojdbc6.jar		%{buildroot}%{oradir}/lib
%{__install} -m0644 xstreams.jar	%{buildroot}%{oradir}/lib
%{__install} -m0755 %{SOURCE20}		%{buildroot}%{_bindir}

%{__sed} -i -e "s/@version@/%{version}/g" -e "s/@lib@/%{_lib}/g" %{buildroot}%{_bindir}/%{name}-config  
  
echo %{oradir}/lib >%{buildroot}%{_sysconfdir}/ld.so.conf.d/%{name}.conf

cat >%{buildroot}%{oradir}/network/admin/tnsnames.ora <<EOF
# Example configuration - RAC
#MYSID =
#  (DESCRIPTION =
#    (ADDRESS_LIST =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = racnode1-vip)(PORT = 1521))
#      (ADDRESS = (PROTOCOL = TCP)(HOST = racnode2-vip)(PORT = 1521))
#      (LOAD_BALANCE = no)
#    )
#    (SDU = 8192)
#    (CONNECT_DATA =
#      (SERVICE_NAME = SNAME)
#        (INSTANCE_NAME = instance1)
#    )
#  )
EOF

cat >%{buildroot}%{_sysconfdir}/profile.d/instantclient.sh <<EOF
#!/bin/bash
export ORACLE_HOME=%{oradir}
EOF

# ERROR: the files above contain java bytecode for something later than java 1.5,
# ERROR: please set the javac target to 1.5 or lower
# Disabling BYTECODE check on SLES. Being a bynary package we can't specify target
export NO_BRP_CHECK_BYTECODE_VERSION=true

# Devel
%{__install} -m0644 sdk/include/*.h 	%{buildroot}%{incdir}
%{__install} -m0644 sdk/ottclasses.zip		%{buildroot}%{oradir}/lib
%{__install} -m0755 sdk/ott		%{buildroot}%{oradir}/bin

ln -sf %{oradir}/bin/ott %{buildroot}%{_bindir}/ott

ln -s libocci.so.11.1   %{buildroot}%{oradir}/lib/libocci.so
ln -s libclntsh.so.11.1 %{buildroot}%{oradir}/lib/libclntsh.so

# SQL*Plus
%{__install} -m0755 sqlplus 		%{buildroot}%{oradir}/bin
%{__install} -m0644 glogin.sql 		%{buildroot}%{oradir}/lib
%{__install} -m0755 libsqlplus.so 	%{buildroot}%{oradir}/lib
%{__install} -m0755 libsqlplusic.so 	%{buildroot}%{oradir}/lib

ln -sf %{oradir}/bin/sqlplus %{buildroot}%{_bindir}/sqlplus

# Workaround for RPATH check as it can't be changed in a binary only package
# Taken from package at devel:languages:misc OBS repository
export NO_BRP_CHECK_RPATH="true" 

# JDBC
%{__install} -m0755 libheteroxa11.so	%{buildroot}%{oradir}/lib
%{__install} -m0644 orai18n-mapping.jar	%{buildroot}%{oradir}/lib
%{__install} -m0644 orai18n.jar		%{buildroot}%{oradir}/lib

# ODBC
%{__install} -m0755 libsqora.so.11.1	%{buildroot}%{oradir}/lib
%{__install} -m0755 odbc_update_ini.sh	%{buildroot}%{oradir}/bin

# Tools
%{__install} -m0755 wrc 		%{buildroot}%{oradir}/bin
ln -sf %{oradir}/bin/wrc %{buildroot}%{_bindir}/wrc

# Precomp
cd ../%{precomptopdir}
%{__install} -m0755 sdk/{proc,procob,rtsora}	%{buildroot}%{oradir}/bin
%{__install} -m0755 cobsqlintf.o	%{buildroot}%{oradir}/lib
%{__install} -m0644 precomp/admin/*	%{buildroot}%{oradir}/precomp/admin

ln -sf %{oradir}/bin/proc %{buildroot}%{_bindir}/proc
ln -sf %{oradir}/bin/procob %{buildroot}%{_bindir}/procob
ln -sf %{oradir}/bin/rtsora %{buildroot}%{_bindir}/rtsora

# Precomp-Devel
%{__install} -m0644 sdk/include/*.h     %{buildroot}%{incdir}

%clean
rm -rf %{buildroot}

%post 
/sbin/ldconfig 

%postun 
/sbin/ldconfig

%files 
%defattr(-,root,root)
%doc %{topdir}/BASIC_README
%config %{_sysconfdir}/ld.so.conf.d/%{name}.conf
%config %{_sysconfdir}/profile.d/instantclient.sh
%dir %{_libdir}/oracle  
%dir %{_libdir}/oracle/%{version} 
%dir %{oradir}
%dir %{oradir}/lib
%dir %{oradir}/bin
%dir %{oradir}/network
%dir %{oradir}/network/admin
%config %{oradir}/network/admin/tnsnames.ora
%{oradir}/lib/libclntsh.so.11.1
%{oradir}/lib/libnnz11.so
%{oradir}/lib/libocci.so.11.1
%{oradir}/lib/libociei.so
%{oradir}/lib/libocijdbc11.so
%{oradir}/lib/ojdbc5.jar
%{oradir}/lib/ojdbc6.jar
%{oradir}/lib/xstreams.jar
%{oradir}/bin/genezi
%{oradir}/bin/adrci
%{oradir}/bin/uidrvci
%{_bindir}/%{name}-config

%files devel
%defattr(-,root,root)
%doc %{topdir}/sdk/demo %{topdir}/sdk/SDK_README
%{oradir}/lib/libclntsh.so
%{oradir}/lib/libocci.so
%{oradir}/lib/ottclasses.zip
%dir %{_includedir}/oracle  
%dir %{_includedir}/oracle/%{version}
%{incdir}
%{_bindir}/ott
%{oradir}/bin/ott

%post sqlplus
/sbin/ldconfig 

%postun sqlplus
/sbin/ldconfig

%files sqlplus
%defattr(-,root,root)
%doc %{topdir}/SQLPLUS_README
%{_bindir}/sqlplus
%{oradir}/bin/sqlplus
%{oradir}/lib/glogin.sql
%{oradir}/lib/libsqlplus.so
%{oradir}/lib/libsqlplusic.so

%files jdbc
%defattr(-,root,root)
%doc %{topdir}/JDBC_README
%{oradir}/lib/libheteroxa11.so
%{oradir}/lib/orai18n-mapping.jar
%{oradir}/lib/orai18n.jar

%post odbc
/sbin/ldconfig

%postun odbc
/sbin/ldconfig

%files odbc
%defattr(-,root,root)
%doc %{topdir}/ODBC_IC_Readme_Unix.html %{topdir}/ODBCRelnotesJA.htm %{topdir}/ODBCRelnotesUS.htm
%{oradir}/bin/odbc_update_ini.sh
%{oradir}/lib/libsqora.so.11.1

%files tools
%defattr(-,root,root)
%doc %{topdir}/TOOLS_README
%{_bindir}/wrc
%{oradir}/bin/wrc

%post precomp
/sbin/ldconfig

%postun precomp
/sbin/ldconfig

%files precomp
%defattr(-,root,root)
%doc %{precomptopdir}/sdk/demo %{precomptopdir}/PRECOMP_README
%dir %{_includedir}/oracle
%dir %{_includedir}/oracle/%{version}
%dir %{oradir}/precomp
%dir %{oradir}/precomp/admin
%config  %{oradir}/precomp/admin/pcbcfg.cfg
%config  %{oradir}/precomp/admin/pcscfg.cfg
%{oradir}/lib/cobsqlintf.o
%{oradir}/bin/proc
%{oradir}/bin/procob
%{oradir}/bin/rtsora
%{_bindir}/proc
%{_bindir}/procob
%{_bindir}/rtsora

%files precomp-devel
%defattr(-,root,root)
%{incdir}

%changelog
* Sun Jan 2 2011 Ciro Iriarte <ciro.iriarte@gmail.com> 11.2.0.2.0
- Added ORACLE_HOME definition
- Added tnsnames.ora example and required directory structure

* Sat Jan 1 2011 Ciro Iriarte <ciro.iriarte@gmail.com> 11.2.0.2.0
- merge i386/x86_64 SPECs again
- fixed RPM Groups
- added Jean-Christophe Duberga's config script to help building Perl-DBD-Oracle
  (this wasn't documented on my first change in 2007, and was lost in OBS)
- skip RPATH and BYTECODE verifications in OBS builds
- renamed oracle-instantclient-basic to oracle-instantclient
- added unzip to BuildRequires
- general cleanup to make openSUSE 11.3 sanity checks happy
	o ToDo: Verify rpmlint filters
- add precomp and precomp-devel sub-packages

* Thu Nov 11 2010 Remi Collet <RPMS@famillecollet.com> 11.2.0.2.0-1
- update to 11.2.0.2.0

* Sat Dec 26 2009 Remi Collet <RPMS@famillecollet.com> 11.2.0.1-1.###.remi
- update to 11.2.0.1

* Sun Nov 30 2008 Remi Collet <RPMS@famillecollet.com> 11.1.0.7-1.###.remi
- update to 11.1.0.7
- add tools sub-package

* Sat Sep 13 2008 Remi Collet <RPMS@famillecollet.com> 11.1.0.6-1.###.remi
- improved split spec

* Tue Oct 30 2007 Remi Collet <RPMS@famillecollet.com> 11.1.0.6-1.###.remi
- split spec for i386, x86_64 and ppc
- update to 11.1.0.6.0

* Sun Aug 19 2007 Ciro Iriarte <ciriarte@personal.net.py> 10.2.0.3-3.###.remi
- added genezi to basic package

* Tue May 22 2007 Remi Collet <RPMS@famillecollet.com> 10.2.0.3-3.fc6.remi
- merge 32/64 spec file for mock

* Tue Nov 14 2006 Remi Collet <RPMS@famillecollet.com> 10.2.0.3-1.fc6.remi
- update to 10.2.0.3

* Tue Nov 14 2006 Remi Collet <RPMS@famillecollet.com> 10.2.0.2-3.fc6.remi
- FC6.x86_64 build (conditional targetname & datever)

* Thu Oct 26 2006 Remi Collet <RPMS@famillecollet.com> 10.2.0.2-2.fc6.remi
- FC6.i386 build 

* Fri Jun 23 2006 Remi Collet <RPMS@famillecollet.com> 10.2.0.2-2.fc5.remi
- Switch back to defaut oracle strategie.
- add /etc/ld.so.conf.d/oracle-instantclient.conf

* Fri Jun 23 2006 Remi Collet <RPMS@famillecollet.com> 10.2.0.2-1.fc5.remi
- initial RPM