SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting to Remote Database using Debian w/Oracle XE

606595Jun 10 2012 — edited Jun 10 2012

Hello.

I have managed to install Oracle XE on a Debian box.
I am trying to connect to a remote server located on my network.

I am using the following connection string:

# sqlplus <User>/<Password>@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP>)(PORT=1521)))(CONNECT_DATA=(SID=<SID>)))'

However, I was given both a SID and a Service_name.

I tried connecting with both.

Is it possible to parametrize both? I checked and the remote server is up, and that is the existing port.

Thanks a lot!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2012

Added on Jun 10 2012

3 comments

307 views