Re: SQL*Net V2 connect string

From: Henry Yick <92908250_at_cpccux1>
Date: Sun, 12 Feb 1995 00:08:27 +0800
Message-ID: <Pine.SOL.3.91.950212000056.3437B-100000_at_cpccux1>

On 9 Feb 1995, Roger Bjarevall wrote:

> Using SQL*Net V1 did it easy to supply the full connect string
> after the '_at_' sign.
>
> My question is how to the same using V2?
>
> I have tried something like this but it does not work:
>
> sqlplus scott/smith_at_(ADDRESS = \
> (COMMUNITY = SEA) \
> (PROTOCOL = TCP) \
> (HOST = sea25) \
> (PORT = 2767))
>
You can create a alias file in your client and server side, the name is $ORACLE_HOME/network/admin/tnsnames.ora in unix and C:\ORAWIN\NETWORK\ADMIN\TNSNAMES.ORA in DOS. The content is : ---- Cut Here ----
testdb=(ADDRESS=

	    (COMMUNITY = SEA )
	    (PROTOCOL = TCP)
	    (HOST = sea25)
	    (PORT = 2767))

otherdb= ......
---- Cut Here ----
then you can connect the database by :

sqlplus scott/smith_at_testdb

If you still have problem, do check the file listener.ora in $ORACLE_HOME/netowrk/admin to see if tcp listerner is included and config propery. -

---

      __       _        | Yick Ka Yuen, Henry | City Univserity of Hong Kong
 |_| |_  |\ | |_| \ /   | Email : 92908250_at_cpccux1.cityu.edu.hk
 | | |__ | \| | \  | .  | Computer Studies, Year 3/4 
-------------------------------------------------------------------------------

- Learn from yesterday, live for tomorrow. Received on Sat Feb 11 1995 - 17:08:27 CET