Configuring paths for Java1.6.0_0 and Oracle 11g on fedora 11Prerequisites:1. Oracle 11g installed(You can refer my earlier posts)
2. Jdk installed(You can refer my earlier posts)
Adding PathsAdd 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 ConfigurationsAdd 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)
VirtualBox
