DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 2: in the connect string

  1. #1
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    2: in the connect string

    Hi guys,
    I am migrating my oracle 7.3.2.1 database to Oracle 9i.I have three instances namely acc,hacc and tacc.
    Connect string used to connect to 7.3.2.1 db was 2:acc,2:hacc &2:tacc and this is working well with 7.3.2.1.
    ie. sqlplus acc/acc@2:acc is working.......
    if we use the same connect string in 9i it won't work.This is working if we remove 2:
    Could any one tell me what is the significance of 2: in the connect string in 7.3.2.1 and is it really not required in 9i?
    Immediate response is always appreciated.

    Regards,
    Sudheer

  2. #2
    Join Date
    Sep 2002
    Posts
    42
    There may not be any significance with 2.

    Check with 9i doc


    I suspect the character ':' in the connect string

    Please don't use special chars in the connect string for eg $ etc


    Cheers
    In GOD I find everything

  3. #3
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    I believe the '2:' is the old BEQ protocol used for local connections way back when. I think it had been a holdover from SQL*NET1. O7.3 was SQL*NET2.

    9i is SQL*NET3 (or SQLNET80 or maybe SQLNET90 now). The local connection is either through TNSNAMES, ONAMES,CMAN or LDAP. You are (I guess) using TNSNAMES, which elimanates the need for the protocol specifier.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

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