The easy connect method is one of the naming method to get all the data needed to identified the location of the database.
The easy connect naming method eliminates the need for service name lookup in the tnsnames.ora files for TCP/IP environments; in fact, no naming or directory system is required if you use this method.
This naming method provides out-of-the-box TCP/IP connectivity to databases.
This method allow you to give :
instead of the net service name to be able to connect to a database.
Check your parameters : Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID)
CONNECT username/password@[//]host[:port][/service_name]
where :
Then you can perform a easy connection with sqlplus or with the connect command.
C:\Documents and Settings\Nicolas>sqlplus gerardnico/password@ngerard:1521/orcl
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 10 14:16:13 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
gerardnico@ngerard:1521/orcl>connect gerardnico/password@ngerard:1521/orcl
Connected.