-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|