Configuring paths for Java and Oracle on fedora

Configuring paths for Java1.6.0_0 and Oracle 11g on fedora 11


Prerequisites:
1. Oracle 11g installed(You can refer my earlier posts)
2. Jdk installed(You can refer my earlier posts)

Adding Paths

Add these paths to the .bash_profile file in your oracle home directory
-----------------------------------------------------------------------
TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=acerfedora; export ORACLE_HOSTNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME

ORACLE_SID=orcl; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

JAVA_HOME=/usr/lib/jvm/java-1.6.0 export JAVA_HOME

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$PATH; export PATH

PATH=$JAVA_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/jdbc/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:.:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/jlib/orai18n.jar:$ORACLE_HOME/jdbc/lib/ojdbc6.jar:/usr/share/java:/usr/share/java/servlet-api-2.5.jar:/usr/share/java/mysql-connector-java-5.1.6.jar:/usr/share/java/commons-dbcp-1.2.1.jar;
export CLASSPATH
------------------------------------------------------------------------------------------

Checking Java

[oracle@acerfedora ~]$ java -version
java version "1.6.0_0"
OpenJDK Runtime Environment (IcedTea6 1.5) (fedora-25.b16.fc11-i386)
OpenJDK Server VM (build 14.0-b15, mixed mode)

Starting Oracle

[oracle@acerfedora ~]$ lnsrctl start
bash: lnsrctl: command not found
[oracle@acerfedora ~]$ clear

[oracle@acerfedora ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 03-AUG-2009 04:48:09

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/acerfedora/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=acerfedora)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 03-AUG-2009 04:48:09
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/acerfedora/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=acerfedora)(PORT=1521)))
The listener supports no services
The command completed successfully

Note:To stop use [oracle@acerfedora ~]$ lsnrctl stop

[oracle@acerfedora ~]$ dbstart
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbstart ORACLE_HOME
Processing Database instance "orcl": log file /u01/app/oracle/product/11.1.0/db_1/startup.log

Note: To stop use [oracle@acerfedora ~]$ dbshut


Example program:atm.java

To verify the connection compile and run this example
class atm {
public static void main (String args []) throws SQLException
{
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "scott", "oracle");
// @machineName:port:SID, userid, password

Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
while (rset.next())
System.out.println (rset.getString(1)); // Print col 1
stmt.close();
}
}

Compile: javac atm.java
Run: java atm
Output:
[oracle@acerfedora jsp]$ java atm
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

You can use Oracle Enterprise Manager 11g for further work

[oracle@acerfedora jsp]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://acerfedora:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control .......... started.

Logs are generated in directory /u01/app/oracle/product/11.1.0/db_1/acerfedora_orcl/sysman/log

Note: To stop [oracle@acerfedora jsp]$ emctl stop dbconsole


http://www.oracle.com/technology/software/products/database/index.html

Tomcat Server Configurations

Add these 2 files to /usr/share/tomcat5/common/lib

ojdbc6_g.2.jar and tools.jar

You wil get ojdbc6_g.2.jar from /u01/app/oracle/product/11.1.0/db_1/jdbc/lib

(or ur $ORACLE_HOME/jdbc/lib)

You wil get tools.jar from /usr/lib/jvm/java-1.6.0/lib

(or $JAVA_HOME/lib)