b****e
发帖数: 1275 | 1 i can ping the machine with no problem.. (same lan)
but if i do a
sqlplus system/manager@psotest
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****j
发帖数: 14 | 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/manager@psotest
: 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*****h
发帖数: 212 | 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.
| j****s
发帖数: 271 | 4 Net8 Configuration Assistant
【在 n*****h 的大作中提到】
: 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.
|
|
