Oracle database connection

From MWCSWiki

Jump to: navigation, search
  1. login by sqlplus (username)/(password) at the command line
  2. create a database. (just like mysql for the most part)
  3. exit sqlplus
  4. make sure lsnrctl is running. (located in $ORACLE_HOME/bin)
  5. include the classes12.jar file in classpath (located in $ORACLE_HOME/jdbc/lib)
  6. in jdbc, connect to oracle.jdbc.OracleDriver.
  7. the url for a oracle database is: dbc:oracle:thin:@(url):(oracle listening port, usally 1521):(oracle SID)","(username)","(password)"
Retrieved from "http://rosemary.umw.edu/mediawiki/index.php/Oracle_database_connection"
Personal tools