Sqlplus connecting to a remote database

1, the first to configure the network service name.

In the: E:\oracle9201\ora92\network\admin\tnsnames.ora file

MyOracle =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.20) (PORT = 1521))
)
(Connect_data =
(SERVER = dedicated)
(service_name = myoracle)
)
)

Where the first line of MyOracle is just an alias

Specific configuration can refer to E:\oracle9201\ora92\network\admin\SAMPLE\TNSNAMES. ORA

2, open the cmd window, enter sqlplus username/[email protected] can (@ followed by the first line of the alias, not the service name)

or in order to not see the password, you can enter sqlplus [email protected] Enter, will prompt for a password