Hello,
In a university setting, we have about 20 Oracle 10g servers that are used in a classroom. All these are running i*SQLPlus service. The computers names are RM2-01, RM2-02, ..., RM2-20. Each of these servers has a SID called, "CSIS". We also have a UNIX 10g server that also runs Oracle HTTP service. There is a VAX 9i server as well. All these computers are networked together. I campus, I can get to any instance without any problem.

Here is my question: can the students get to each of the 20 individual instance using i*sqlplus from off campus?

Here is what I have done:
Using Internet Explorer we can connect to the HTTP server by http://qualified_instance_name:7778/isqlplus and then we can connect to 9i instance running on VAX and 10g instance running on the UNIX server without any problem.

The problem is when we try to connect to any Oracle 10g instance in each of the classroom computers it fails. For example, if I want to connect to the instance on computer number 7, I put in RM2-07/CSIS as the connection identifier I get the "SP2-0924: Supplied connect string has duplicate or incorrect keyword" error.

I am guessing that the connection identifier field does not take computer name as part of the string. And since there are twenty computers that have the same service name running, it causes the error.

Any ideas?

Regards,
----------------------
Saeed Rahimi
---------------------

Oracle LazyDBA home page