j**i
发帖数: 419 | 1 Hi,I got a problem with the connections.
I build a database on server(servername="ABC"),database name="ZZ"
At first I can't connect to the database on server itself.
Error:
ORA-12203: TNS:unable to connect to destination
after I changed the TNSNAMES.ORA,it is OK.
add
ZZ.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = ZZ)
)
(CONNECT_DATA = (SID = ZZ)
)
)
however,now I trying to connect from sql plus on the client machine,
I can't go through with it.
I | g***o
发帖数: 297 | 2 ORA-12203 means the client can not find the desired database
1) check the service name ADDRESS parameters in TNSNAmES.ORA is correct
2) Check TNS_ADMIN variable to see if you store your TNSNAMES>ORA in the right
directory.
3) Check the listener on the server has started and is running. If not, statrt
the listener.
【在 j**i 的大作中提到】
: Hi,I got a problem with the connections.
: I build a database on server(servername="ABC"),database name="ZZ"
: At first I can't connect to the database on server itself.
: Error:
: ORA-12203: TNS:unable to connect to destination
: after I changed the TNSNAMES.ORA,it is OK.
: add
: ZZ.world =
: (DESCRIPTION =
: (ADDRESS =
| j**i
发帖数: 419 | 3 I know there is something wrong with this"Connecction" part.
1.Looks like TNSNAMES.ora is not the problem
since I have tested diffrent kind of expression,like IPC,TCP,change server n
ame
to IP,add both port....and the same file works on server.
....
2.the default database ORACLE works well on client machine.
I don't know how/where to check the TNSadmin variable?
3.the listener starts OK and database ZZ can be operated well on server
but the client has some problem and both of them are in the fir |
|
