how to connect to remote Oracle database, help me!!! - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

how to connect to remote Oracle database, help me!!!

how to connect to remote Oracle database, help me!!!# Database - 数据库

a*e2000-12-01 08:12

1 楼

In order to implement Oracle replication, I have to
connect to a remote Oracle8i server from my own Oracle8i
server. From Oracle's documentation, the systax in Sqlplus
is:
connect username/[email protected]
I only know the net-service-name of my own Oracle server.
I can log on to the other server by system account and I
know the JDBC connection string to that Oracle and the
instance I want.
How can I know net-service-name? Is there any other way to
do this?
Thank you very , v

g*y2000-12-01 08:12

2 楼

The name is not very important, You can name it by yourself
in your tnsnames.ora files,
but you should know the ip address and the tcp port where
the remote server is listenning on.

【在 a***e 的大作中提到】

: In order to implement Oracle replication, I have to
: connect to a remote Oracle8i server from my own Oracle8i
: server. From Oracle's documentation, the systax in Sqlplus
: is:
: connect username/[email protected]
: I only know the net-service-name of my own Oracle server.
: I can log on to the other server by system account and I
: know the JDBC connection string to that Oracle and the
: instance I want.
: How can I know net-service-name? Is there any other way to