Oracle 9i installation on windows xp machine

in Oracle Database; Hi i have installed oracle 9i client on my windows xp machine.should I need to install the corresponding server on ...
+ Post Reply + Post New Topic
Results 1 to 7 of 7
  1. #1
    sabarmathi is offline Junior Member
    Points: 110, Level: 2
    Join Date
    23 Mar 2009
    Posts
    4
    Points
    110

    Oracle 9i installation on windows xp machine

    Hi i have installed oracle 9i client on my windows xp machine.should I need to install the corresponding server on my machine to start working? If yes, the server is freely availbale to download? I want to learn java/j2ee. For that i need oracle. can any one please help me?


  2. #2
    tyro's Avatar
    tyro is offline Forum Genius
    Points: 5,680, Level: 48
    Join Date
    20 Aug 2008
    Location
    India
    Posts
    368
    Points
    5,680

    Re: Oracle 9i installation on windows xp machine

    hi, you did not need to install the Oracle Client. If all you want to do is practice oracle queries on your pc, you need to download oracle database server and install it. Oracle database is available to download at the link below:

    http://www.oracle.com/technology/sof...01winsoft.html

    However it's a heavy download so u better have a fast internet connection. It's very easy to install on a xp machine so you shouldn't have a issue.

  3. #3
    sabarmathi is offline Junior Member
    Points: 110, Level: 2
    Join Date
    23 Mar 2009
    Posts
    4
    Points
    110

    Re: Oracle 9i installation on windows xp machine

    Hi thank u so much for the quick response. After installing this database server will i be able to access(insert/delete/update) the tables from the java page? Thanks in advance.

  4. #4
    sameer's Avatar
    sameer is offline Forum Advisor
    Points: 2,240, Level: 28
    Join Date
    21 Aug 2008
    Posts
    105
    Points
    2,240

    Re: Oracle 9i installation on windows xp machine

    yes it is very easy to connect to oracle with java , you have to use some code like, (not tested)
    Code :
    import java.sql.*;
     
    class demo
    {
    public static void main (String args [])
    throws SQLException
    	{
     
    	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
     
    	Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@db_server:1521:orcl","scott", "tiger");
     
    	Statement stmt = conn.createStatement ();
     
    	ResultSet rset = stmt.executeQuery ("select * from employee_table");
     
    	while (rset.next ())
    	System.out.println (rset.getString (1));
    	}
    }

    Hope it helps
    Learning is a path with no destination...

  5. #5
    sabarmathi is offline Junior Member
    Points: 110, Level: 2
    Join Date
    23 Mar 2009
    Posts
    4
    Points
    110

    Re: Oracle 9i installation on windows xp machine

    Thank you Sameer....

  6. #6
    sabarmathi is offline Junior Member
    Points: 110, Level: 2
    Join Date
    23 Mar 2009
    Posts
    4
    Points
    110

    Re: Oracle 9i installation on windows xp machine

    Hi Tyro & Sameer,

    I downloded the complete package (Download the Complete Files) from the url you specified and i installed it on my machine. Now I'm able to see 'SQL plus' from start-> programs-> Oracle oraHome92->application development->SQL Plus. When I try to open the SQL plus its asking for username,password and host string..

    What should i enter for the host string?

    Please advice..Thanks in advance..

  7. #7
    tyro's Avatar
    tyro is offline Forum Genius
    Points: 5,680, Level: 48
    Join Date
    20 Aug 2008
    Location
    India
    Posts
    368
    Points
    5,680

    Re: Oracle 9i installation on windows xp machine

    if your database is installed on your laptop you don't need a connection string, just enter scott for user and tiger for password.

Other Solutions
  1. oracle 9i and 11g installation on single machine problem in dbca
    By vks0982 in forum Installation - Windows
    Replies: 1
    Last Post: 11-22-2010, 04:10 PM
  2. ODAC 10.2.0.2.21 Installation failed on Windows Server 2008 (x64 bit)
    By bhaveshcjain in forum Installation - Windows
    Replies: 0
    Last Post: 02-16-2010, 08:22 AM
  3. R12 on a Vmwhare machine on windows 2003
    By Moonwalker in forum Oracle Financials
    Replies: 1
    Last Post: 02-12-2010, 08:56 AM
  4. how to find exp and imp version of machine and oracle
    By NAT in forum Security, Backup and Recovery
    Replies: 3
    Last Post: 12-24-2009, 07:40 AM
  5. 11i Apps Installation on Windows
    By RIAZ in forum Installation - Windows
    Replies: 3
    Last Post: 07-20-2009, 05:38 AM