Pages

Sunday, February 10, 2013

Steps to Install Oracle SQL Database

In this post I will write the steps required to connect to an Oracle database using JDBC in Java Programming. There are 5 simple steps and we will the use the interfaces as discussed in the previous post here.



You will have to download OracleXE (FREE Edition) or OracleEE (Enterprise Edition) and install it along with inserting a password for the SQL Database main user.


  • Download OracleXE (based on your config) from Here - http://www.oracle.com/technetwork/products/express-edition/downloads/index.html
  • Set the classpath as C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar by using the command set CLASSPATH=C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar;.;
  • Run the SQL Command Line interface and connect to the default user using any of the following commands to check if the installation has gone perfect.
conn -> Press Enter -> system -> Press Enter -> Your Password
OR 
connect -> Press Enter -> system -> Press Enter -> Your Password
OR
          connect system/your passoword  -> Press Enter
  • That's it. We are done with the installing of Oracle Database we will be working on in the forthcoming programs and tutorials.


0 comments:

Post a Comment