DB Design & Dev

Database Design & Development

How to set up ORACLE_SID and ORACLE_HOME on ubuntu

1. step Open the .profile hidden file which is located in /yourname/home/.profile

2. step add the following lines to end of the .profile file

export ORACLE_HOME=Oracle/app/<strong>yourname</strong>/product/11.1.0/db_1/bin export ORACLE_SID=lnr

3. step save the changes , restart your computer

4. step you can check your environment variable

$ echo $ORACLE_SID $ echo $ORACLE_HOME

Path : Oracle/app/yourname/product/11.1.0/db_1/bin

UnsatisfiedLinkError exception loading native library: njni11

Installing Oracle 11g on Linux
[Oracle Net Services configuration failed.] $./netca Error message:
UnsatisfiedLinkError exception loading native library: njni11

java.lang.UnsatisfiedLinkError: jniGetOracleHome
at oracle.net.common.NetGetEnv.jniGetOracleHome(Native Method)
at oracle.net.common.NetGetEnv.getOracleHome(Unknown Source)
at oracle.net.ca.NetCA.main(Unknown Source)
Oracle Net Services configuration failed. The exit code is -1

sudo apt-get install build-essential libaio1 gawk ksh