Home » Infrastructure » Linux » Installation of Oracle 10g XE on Linux 10.2 suse!!!
Installation of Oracle 10g XE on Linux 10.2 suse!!! [message #247046] Sat, 23 June 2007 02:55 Go to next message
SenthilGugan
Messages: 9
Registered: June 2007
Junior Member
Hi all,
I have successfully installed the Oracle 10 XE in my Linux 10.2 suse OS.

Here my Questions:
To run java JDBC source code(which will connect the Oracle database), is it necessary to install exclusively the ODBC Driver Manager in my linux OS machine?

Looking forward to your reply,
Thanks in advance,
Senthil.

[Updated on: Sat, 23 June 2007 02:57]

Report message to a moderator

Re: Installation of Oracle 10g XE on Linux 10.2 suse!!! [message #247049 is a reply to message #247046] Sat, 23 June 2007 03:27 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Depends on which JDBC driver you use.

If you use the driver supplied by oracle there is no need for an ODBC layer.

If you use the thin driver, there is even no need for an oracle client on the client machine.
Re: Installation of Oracle 10g XE on Linux 10.2 suse!!! [message #247050 is a reply to message #247049] Sat, 23 June 2007 03:35 Go to previous messageGo to next message
SenthilGugan
Messages: 9
Registered: June 2007
Junior Member
Hi,
Thanks for your reply.
Actually I don't have any idea about the drivers.
My Oracle installation is 10g XE server and my jdk is j2se1.4.2.

and I have this problem,
I am unable to connect the oracle database through Jdbc.
when I run the Jdbc java program, it gives me,

manickam:~/workspace # java MainClass
error: failed to create a connection object.
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:database

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at MainClass.getConnection(MainClass.java:18)
at MainClass.main(MainClass.java:26)

Thanks,
Senthil.
Re: Installation of Oracle 10g XE on Linux 10.2 suse!!! [message #247056 is a reply to message #247050] Sat, 23 June 2007 05:04 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, when you read the message :

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:database


The driver connected to the listener on port 1521 on localhost fine, but the listener doesn't know a database called "database"

You must change the database name in the java app to the real database name that you have.
Re: Installation of Oracle 10g XE on Linux 10.2 suse!!! [message #247268 is a reply to message #247056] Mon, 25 June 2007 05:41 Go to previous message
SenthilGugan
Messages: 9
Registered: June 2007
Junior Member
Hi ThomasG,
Thanks again,
I changed the database name as xe, now its working.
And you people in this particular forum doing a great job. I am very much impressed with your work.
Thanks,
Senthil.
Previous Topic: Redhat linux
Next Topic: How to check the Correct Xserver Environment
Goto Forum:
  


Current Time: Sun Dec 11 00:17:57 CST 2016

Total time taken to generate the page: 0.09827 seconds