Redian新闻
>
Oracle-Client connect to Server Database problem
avatar
Oracle-Client connect to Server Database problem# Database - 数据库
j*i
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
avatar
g*o
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 =

avatar
j*i
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
相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。