Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12533 TNS illegal ADDRESS parameters

gorddanmilojevic-JavaNetFeb 11 2011 — edited Feb 14 2011
I m using Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
, os linux open suse 11.3 and I was making dbling with
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

This link working good until now, theres error

ORA-12533 TNS illegal ADDRESS parameters?

tnsnames.ora
DBASE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP)(HOST=10.0.0.8)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=DBASA2)
))



dblink:
CREATE DATABASE LINK "DATABASE_LINK2"
CONNECT TO "DATABASE2" IDENTIFIED BY 'PASSWORD'
USING '(DESCIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.7)(PORT = 1521))
(CONNECT_DATA = (SID = DBASA2)))'
/

is there any solution for this?
regards
Gordan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2011
Added on Feb 11 2011
9 comments
2,282 views