Skip to Main Content

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!

How to use sqlplus to connect to a remote oracle via SID?

Tony ZhangOct 29 2014 — edited Oct 29 2014

Help!!!

    Hello! I have a problem when I want to  connect a remote oracle database, by sqlPlus.exe with the SID. The SID and the service name of this oracle database is different. The SID is ORCL, and the service name is orcl.digit

   When I use sqlplus.exe, inputing the commond like this, 'system/password@192.168.0.49:1521/ORCL', it returns an error : ORA-12545. But when I input the commond 'system/password@192.168.0.49:1521/orcl.digit', I connected to the database successfully.

 

  On the other hand, I tryed to connect the same oracle database using Navicat For Oracle tool with SID, I can connect to the database successfully.

  And then I tryed another way that using OTL lib function to connect, the same error occur.

  Help! Thank you!@

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2014
Added on Oct 29 2014
2 comments
1,854 views