| Installation of Oracle 10g XE on Linux 10.2 suse!!! [message #247046] |
Sat, 23 June 2007 02:55  |
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 #247050 is a reply to message #247049] |
Sat, 23 June 2007 03:35  |
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 |
ThomasG
Messages: 3211
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
