cancel
Showing results for 
Search instead for 
Did you mean: 

Connection to an Oracle database without CID, but with Servicename

abbas
Occasional Contributor

Connection to an Oracle database without CID, but with Servicename

Hi everybody, I cann't configure the connection to Oracle database, because there is no CID. I must configure it just with servicename! Thanks for your support. Abbas
14 REPLIES 14
NBorovykh
Moderator

Re: Connection to an Oracle database without CID, but with Servicename

Hello Abbas,

 

The connection string templates in R!API are customizable. You can edit them on the "JDBC drivers" tab in preferences.

 

In your case, I guess, you need to replace 

jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1521>:<SID>

with

jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1521>/SERVICE

where instead of "SERVICE" you need to provide your real service name (e.g. "orcl").

 

 

Natalie
Customer Care Team

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓
MFagerlind
Staff

Re: Connection to an Oracle database without CID, but with Servicename

You probably want to go with Nathalie's advice above, but if you want to change the Connection string for just one JDBC request, you could change the Configuration Connection to <None>. This will make the Connection string, Driver and password fields editable.

 

Regards,

Manne, Developer

abbas
Occasional Contributor

Re: Connection to an Oracle database without CID, but with Servicename

Thank you for this message, but I tried it and got the following error:

Failed to init connection for driver [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:/@:1521/SHOPTEST]

 

!!!

Cheers

Abbas

 

MFagerlind
Staff

Re: Connection to an Oracle database without CID, but with Servicename

The error message seems to indicate that the host name is missing in the connection string. Did you delete it by accident?

 

Did you use Nathalie's approach or the one I suggested?

 

Regards,

Manne

nmrao
Community Hero

Re: Connection to an Oracle database without CID, but with Servicename

Oracle Host name is missing in your case.


Regards,
Rao.
abbas
Occasional Contributor

Re: Connection to an Oracle database without CID, but with Servicename

I used the following configuration:

 Driver: OracleThin/oracle.jdbc.driver.OracleDriver

Connection String template: jdbc:oracle:thin:<catalog>/<catalog>@<HOST:10.7.1.50>:<PORT:1521>/SHOPTEST

and I have contact to the named database with SQL Developer, but I get the following error:

 

" Failed to init connection for driver [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:/@10.7.1.50:1521/SHOPTEST] "

 

What I did:

1-  in config Coection String template like above

2- Database Configuration -->New

      Driver: OracleThin/oracle.jdbc.driver.OracleDriver

      Host: 10.7.1.50

      Port: 1521

3: Click Test connection ---> Result: Erorr:

" Failed to init connection for driver [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:/@10.7.1.50:1521/SHOPTEST] "

 

 

 

abbas
Occasional Contributor

Re: Connection to an Oracle database without CID, but with Servicename

And the same problem with the following Connection String:

jdbc:oracle:thin:catalog/catalog@HOST:ractest-scan:PORT:1521/SHOPTEST

 

nmrao
Community Hero

Re: Connection to an Oracle database without CID, but with Servicename

dd1984
Occasional Contributor

Re: Connection to an Oracle database without CID, but with Servicename

Hi Rao,

 

I am also facing the same issue and when using the String suggested in stack overflow it's working fine but still when try to configure the Db connection it says SID is mandatory field.

 

What input should i give in SID field.

Tags (1)
New Here?
Join us and watch the welcome video:
Top Kudoed Authors