Connect without an entry in tnsname.ora - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Connect without an entry in tnsname.ora

  1. #11
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Originally posted by richyip
    So is there any problem with the connect string?
    Exactly.
    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.
    Try:
    sqlplus system/admin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=172.20.21.15)(Port=1521))(CONNECT_DATA=(SID=test)))
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  2. #12
    Join Date
    Sep 2002
    Posts
    411
    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????

    thanks

  3. #13
    Join Date
    May 2002
    Posts
    2,645
    variable: TNS_ADMIN
    value: $ORACLE_HOME\network\admin
    What you actually type in, assuming your $ORACLE_HOME resolves to d:\ora81:
    value: d:\ora81\network\admin

    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.

  4. #14
    Join Date
    May 2002
    Posts
    2,645
    Well?

  5. #15
    Join Date
    Sep 2002
    Posts
    411
    Thanks Stecal

  6. #16
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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...)
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width