on 10-26-2009 5:06 AM
Hello All,
I am trying to create new connection to Oracle DB 10.1,
I could not see any drivers in my xMII(12.0) - System Management - JDBC Drivers . connection status is stopped.
Please let me know if I need to install drivers or are they available with xMII. & guide me to establish connection
Many Thanks,
polaku.
Hi,
You have to upload the corresponding drivers through SystemManagement -> JDBC Drivers -> Upload button.
Once you upload the driver you can check the connection status through DataServices -> ConnectionStatus.
Thanks
Rajesh Sivaprakasam.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As I am tryingto ocnnect orcale 10.1 db , I deployed jar ojdbc14.jar and In Dataservers -> new -> IDBC and then i gave fallowing parametrs :
JDBC driver :oracle.jdbc.driver.OracleDriver
ServerPackage: com.sap.xmii.Illuminator.connectors.IDBC
ServerURL : jdbc:oracle:thin:@<machine>:1521:<Instance>
Username & password.
But the status of connection is "error"
sql7=true for Oracle???
Polaku,
The instance is the SID and I believe that you will run into problems if you fully qualify it instead of just the short version.
short version: XYZ14
fully qualified version: XYZ14.something.mycompany.com
I recently ran into this same type of problem and fixed it by changing to the XYZ14 in the URL. Not sure why the change worked. Perhaps a more DBA savvy person can inform us both. My experience has always been to use the short version with the data server configuration.
Good luck,
Mike
Edited by: Michael Appleby on Oct 26, 2009 1:09 PM
Try jdbc driver = oracle.jdbc.OracleDriver
And check out port name. 1521 looks like default port for the installation . try to connect with that DB using toad or some thing to confirm port. ( i m asking since i have diffent port number for the same version on oracle ) . If you already did that.., change the driver name to above and see.
Thanks
Hari
Network issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Polaku,
Delete the JDBC Driver and download once again ojdbc14.jar and reload it and deploy.
Actually I faced the same problem and I did the above steps and it worked fine for me.
Also try with server name instead of server IP in ServerURL Field.
jdbc:oracle:thin:@<hostname>:<port>:<instance>
Regards
Khaleel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.