本机oracle的配置文件的路径:
/oracle/product/10.2.0/client_1/NETWORK/ADMIN/tnsnames.ora
查看oracle连接的方法:
oracle@ptl_portal02:~>
netstat -an |grep 1521|grep ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:57623 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:47643 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:42799 ESTABLISHED
tcp 0 0 10.168.48.155:53093 10.168.48.155:1521 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:55887 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.155:53093 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:44390 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:40302 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:59769 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:33414 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:33412 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:60568 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:38829 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:57024 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:52181 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:43475 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:46545 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:55277 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:57623 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:47643 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:42799 ESTABLISHED
tcp 0 0 10.168.48.155:53093 10.168.48.155:1521 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:55887 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.155:53093 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:44390 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:40302 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:59769 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:33414 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:33412 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:60568 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:38829 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:57024 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:52181 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:43475 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:46545 ESTABLISHED
tcp 0 0 10.168.48.155:1521 10.168.48.153:55277 ESTABLISHED