Three ways to not use the TNS Direct database

1. Create a new Tnsnames.ora file in the current directory

In the Windows environment, create a new Tnsnames.ora file under the C:\Users\Administrator directory with the following content:
Test = (description= (address= (protocol=tcp) (host=192.168.0.1) (port=1521)) (Connect_data= (server=dedicated) ( SERVICE_NAME=ORCL)))
c:\users\administrator>sqlplus sys/[email protected] as SYSDBA;

Sql*plus:release 11.2.0.1.0 Production on Friday February 13 00:03:51 2015

Copyright (c) 1982, Oracle. All rights reserved.

Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options

2. Add desctiption content while Sqlplus connection
c:\users\administrator>sqlplus sys/[email protected] (description= (address= (protocol=tcp) (HOST=RUSKY-PC) ( port=1521)) (Connect_data= (SID=ORCL) )) as SYSDBA;

Sql*plus:release 11.2.0.1.0 Production on Thu February 12 23:56:33 2015

Copyright (c) 1982, Oracle. All rights reserved.

Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options

3. Connect directly with IP, port number, instance name
c:\users\administrator>sqlplus sys/[email protected]:1521/orcl as SYSDBA;

Sql*plus:release 11.2.0.1.0 Production on Thu February 12 23:58:24 2015

Copyright (c) 1982, Oracle. All rights reserved.

Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options

"from:http://blog.csdn.net/hhuck/article/details/5337764"

Three ways to not use the TNS Direct database