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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 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.
|
|