Nethence Newdoc Olddoc Lab Your IP BBDock  


Warning: those guides are mostly obsolete, please have a look at the new documentation.

UnixWindowsOracleObsoleteHardwareDIYMechanicsScriptsConfigs

Oracle 10g client on Linux systems
 
 
Installation
Get the 10g client archive (http://www.oracle.com/technetwork/database/10201linuxsoft-097986.html).
 
Create the oracle user,
groupadd oinstall
useradd -m -g oinstall oracle
passwd oracle
 
Upload the client archive by FTP and connect as 'oracle' user, graphically or with X11 forwarding enabled,
unzip 10201_client_linux32.zip
rm -f 10201_client_linux32.zip
cd client/
./runInstaller -ignoreSysPrereqs
Note. assuming RHEL5, hence the -ignoreSysPrereqs
 
Oracle Universal Installer shows up. For developing applications choose e.g.,
install type: runtime (444MB)
name: client10g
path: /home/oracle/client10g
 
Oracle Net Configuration Assistant shows up. Click Next and Finish. Root scripts pop-up shows up, at last ; execute them as 'root'. Now add those variables to common user environment,
cd /etc/
cat >> bashrc <<EOF9
ORACLE_OWNER= oracle
ORACLE_HOME= /home/oracle/client10g
export ORACLE_OWNER ORACLE_HOME
EOF9
 
As root, fix the perms so all users can access Oracle client's libraries,
cd /home/
chmod 755 oracle/
chmod 755 oracle/client10g/
chmod 755 oracle/client10g/lib/
cd /home/oracle/client10g/lib/
chmod 644 libclntsh.so.10.1
chmod 644 libnnz10.so
 
Back to 'oracle' user,
cd ~/
cat >> .bashrc <<EOF9
ORACLE_OWNER=oracle
ORACLE_HOME=/home/oracle/client10g
LD_LIBRARY_PATH=/home/oracle/client10g/lib
export ORACLE_OWNER ORACLE_HOME LD_LIBRARY_PATH
 
PATH=\$PATH:\$ORACLE_HOME/bin
export PATH
EOF9
note. variables are escaped for convenience of `cat'
apply,
source .bashrc
 
 
Configuration
As 'oracle' user, configure a tns resolution against the database you need,
cd ~/
netca
like,
local net service name configuration
add
service name: dbname
tcp
hostname: oracle10g.example.local
check,
ls -l ./client10g/network/admin/tnsnames.ora
 
Note. you can also proceed manually,
cd ~/client10g/network/admin/
cat >> tnsnames.ora <<EOF9
DBNAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.example.local)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbname)
)
)
EOF9
Note. change `oracle.example.local' and `dbname' accordingly
 
 
Troubleshooting
If you need to restart from scratch,
userdel -r oracle
cd /etc/
rm -f oraInst.loc
 
 
References
http://download.oracle.com/docs/html/B14403_01/cli_qig.htm
http://download.oracle.com/docs/cd/B19306_01/install.102/b15662/toc.htm
 

(obsolete, see the new doc)