There are two ways to connect to an ArcSDE instance, application server connects (via the ArcSDE
network protocol) and Direct Connect (via a database client library). In the fomer the "instance"
parameter is the port number or "port:<number>", or the service name (from .../etc/services).
In the latter, the instance is "sde:<rdbms_key>[:parameters...]".
The nominal notation for an Oracle 11gR2 connect is "sde:oracle11g". Since no indication of which
Oracle instance is provided, the password parameter was modified to support the format password@instance .
This is the way ArcSDE was designed to function, so I'm having difficulty seeing how this syntax
would cause ArcGIS clients difficulty (the '@' symbol is forbidden from Oracle passwords, so this
is unlikely to conflict with actual passwords).
If you are having connection problems from ArcGIS clients, the cause is more likely to involve the
Oracle client configuration. Can you provide details on the exact errors you are seeing?
- V