oracle10g中可以不需要配置tnsnames.ora或者sqlnet.ora就可以通过10g的客户端连接到数据库。
前提:需要知道目标主机的host_name或host_ip,port,sid
限制:只能用于TCP/TP网络
使用1521标准端口的话可以不指定段口号
语法:connect username/password@//host:port/oracle_sid
举例:
D:>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 18 15:07:08 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect system/oracle@//xxx.xxx.xxx.xxx/ppe
已连接。
SQL> show parameter service_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
service_names string sppe
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
instance_name string ppe
SQL> select name from v$datafile where rownum<=2;
NAME
------------------------------------------------------------------------------------------------
/home/etuser/oracle/oradata/ppe/system01.dbf
/home/etuser/oracle/oradata/ppe/undotbs01.dbf
D:>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 18 15:08:52 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect sys/oracle@//xxx.xxx.xxx.xxx/ppe as sysdba
已连接。
SQL> show user
USER 为 "SYS"
SQL> show parameter service_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
service_names string ppe
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
instance_name string ppe
SQL> select name from v$datafile where rownum<=2;
NAME
----------------------------------------------------------------------------------------------------------
/home/etuser/oracle/oradata/ppe/system01.dbf
/home/etuser/oracle/oradata/ppe/undotbs01.dbf
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7794469/viewspace-884632/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7794469/viewspace-884632/