Sqlplus login to remote ORACLE host

D: \ oraclexe \ app \ oracle \ product \ 10.2.0 \ Server \ Network \ admin

Tnsnames. ora

 
Xe = (description = (address = (Protocol = TCP) (host = spark) (Port = 1521) (CONNECT_DATA = (Server = dedicated) (SERVICE_NAME = Xe ))) ora254 = (description = (address_list = (address = (Protocol = TCP) (host = server-name) (Port = 1521) (CONNECT_DATA = (SID = test ))) extproc_connection_data = (description = (address_list = (address = (Protocol = IPC) (Key = extproc_for_xe) (CONNECT_DATA = (SID = plsextproc) (Presentation = Ro ))) export lr_connection_data = (description = (address_list = (address = (Protocol = IPC) (Key = extproc_for_xe) (CONNECT_DATA = (SID = clrextproc) (Presentation = Ro )))
 

Ora254: configure the new host:

Open sqlplus input:

Connect sys @ ora254 as sysdba

Password :***

Connection successful.

Diagnosis: Use the tnsping command. CMD->

$ Tnsping ora254

Output:

TNS Ping utility for 32-bit windows: Version 10.2.0.1.0-production on 22-9-

14:03:43 2011

Copyright (c) 1997,200 5, Oracle. All rights reserved.

Used parameter files:

D: \ oraclexe \ app \ oracle \ product \ 10.2.0 \ Server \ Network \ admin \ sqlnet. ora

Alias resolved using tnsnames Adapter

Attempting to contact (description = (address_list = (address = (Protocol = TCP)

(Host = server-PC) (Port = 1521) (CONNECT_DATA = (SID = test )))

OK (20 ms)