Oracle Login Procedure

Connecting to Oracle 11g Database in 346 RC using Windows 7 OS

1. After login (in 346 RC, userid = "student", with no password)

2. To run SQLPlus from command line, Run command prompt, and type at command prompt:

sqlplus myusername/mypassword@cseora/cseora11

where cseora is server and cseora11 is a database name.

Example: C:\Users\student>sqlplus s1/tiger9@cseora/cseora11

(when username is S1 and initial password is tiger9)

3. To change the password, use the "PASSWORD" command at the SQL prompt.

Connect String Configuration for SQL Developer

Oracle Reference

• Rajshekhar Sunderraman, ORACLE Programming: A Primer, Addison-Wesley.

JDBC

The java source must contain the DB host string name, such as cseora11, to work properly:

 
import java.sql.*; 
import java.io.*; 
 
class simple{ 
 public static void main (String[] args) 
 throws SQLException, IOException{ 
 
 try{ 
 Class.forName ("oracle.jdbc.driver.OracleDriver"); 
 } catch (ClassNotFoundException e) { 
 System.out.println("Could not load the drive"); 
 } 
 
 String user, pass; 
 //user=readEntry("userid : "); 
 //pass=readEntry("password: "); 
 Connection conn=DriverManager.getConnection( 
  "jdbc:oracle:thin:@//cseora.cs.wright.edu:1521/cseora11", "userid", "password");