Originally posted by richyip
So is there any problem with the connect string?
jovery has posted the form of the connect descriptor you have to use.
The form you used is jdbc-like connect string and does not work in sqlplus.
The whole difference between a little boy and an adult man is the price of toys
STECAL and other peer,
per your advises, I am trying to do the same thing as you show and I just want to double check if I did it right.
set TNS_ADMIN environment variable: like this?? TNS_ADMIN=$ORACLE_HOME\NETWORK\ADMIN and this oracle home is somewhere on the network.
that's all you have to do without modifying or adding anything to the regedit????
What you actually type in, assuming your $ORACLE_HOME resolves to d:\ora81:
TNS_ADMIN could point to c:\my documents, \\some_server\directory, k:\some_other_path_on_a_mapped_network_drive and so on - it does NOT have to point to ANY ORACLE_HOME; it is simply a directory location, one that you must be able to read from.
I'm into centrally managed connections. Consider this option.
Put your connection entries in Oracle Internet Directory and simply point clients there, like this:
client $ORACLE_HOME/network/admin/sqlnet.ora file:
NAMES.DIRECTORY_PATH = (LDAP)
client $ORACLE_HOME/network/admin/ldap.ora file:
DIRECTORY_SERVER_TYPE = OID
DIRECTORY_SERVERS = (YourOidServerIP:Port:SslPort, YourBackupOidServerIP:Port:SslPort, etc...)
Click Here to Expand Forum to Full Width