connect to an oracle server on anoter machine - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

connect to an oracle server on anoter machine

connect to an oracle server on anoter machine# Database - 数据库

b*e2000-09-28 07:09

1 楼

i can ping the machine with no problem.. (same lan)
but if i do a
sqlplus system/[email protected]
i get an error ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
what does that mean? running the same command from the psotest machine
itself works fine.
what should i do?
thanks

s*j2000-09-28 07:09

2 楼

On your client machine, add one entry in your tnsnames.ora, the file is at
$ORACLE_HOME\network\admin.
You need to specify some info in the new entry like SID, IP address
for the server, etc. Have a look for the sample file comes with
Oracle installation. That's pretty straight forward.

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

: i can ping the machine with no problem.. (same lan)
: but if i do a
: sqlplus system/[email protected]
: i get an error ERROR:
: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
: descriptor
: what does that mean? running the same command from the psotest machine
: itself works fine.
: what should i do?
: thanks

n*h2000-09-28 07:09

3 楼

there is a graphic tool to do this, having u r using windows
as client, the name
is like 'net8 config' or 'easy config' something.

【在 s****j 的大作中提到】

: On your client machine, add one entry in your tnsnames.ora, the file is at
: $ORACLE_HOME\network\admin.
: You need to specify some info in the new entry like SID, IP address
: for the server, etc. Have a look for the sample file comes with
: Oracle installation. That's pretty straight forward.