1 临时连接
sqlplus 用户名/密码@IP地址[:端口]/service_name [as sysdba]
2 永久连接
vi $ORACLE_HOME/network/admin/tnsnames.ora
连接串名 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口号))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 服务名)
)
sqlplus 用户名/密码@连接串名 [as sysdba]
3 测试连通性
tnsping IP地址:端口号/数据库服务名
tnsping 网络服务名