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

467014Nov 27 2009 — edited Nov 28 2009
Hi all

Im getting this error when i try to connect from my laptop to the databases on the server. (new RAC installation)

Enter user-name: sys/passwd@dware1 as sysdba
ERROR:
ORA-12533: TNS:illegal ADDRESS parameters

The listener is running.

I was connecting bofore then i edited the tnsnames file on the server and my laptop then it giving the error above this are the

listener.ora entry on the server
================

LISTENER_TSAVO-WEST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tsavo-west-vip.mydomain)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = public ip)(PORT = 1521)(IP = FIRST))
)
)

SID_LIST_LISTENER_TSAVO-WEST =
(SID_LIST =
(SID_DESC =
(SID_NAME = +ASM2)
(ORACLE_HOME = /oracle/ocr/oracleasm/product/asm)
)
)

==================================
then on the database home $ORACLE_HOME/network/admin
i have this entry on tnsnames.ora
NB# public ipnode1 and public ipnode1 i have changed this for me to post this

dware1 =
(DESCRIPTION =
(CONNECT_DATA =
(ADDRESS = (PROTOCOL = TCP)(HOST = public ipnode1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = public ipnode2)(PORT = 1521))
(LOAD_BALANCE = yes)
(SERVER = DEDICATED)
(SERVICE_NAME = dware)
(INSTANCE_NAME = dware1)
)
)

dware2 =
(DESCRIPTION =
(CONNECT_DATA =
(ADDRESS = (PROTOCOL = TCP)(HOST = public ipnode1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = public ipnode2)(PORT = 1521))
(LOAD_BALANCE = yes)
(SERVER = DEDICATED)
(SERVICE_NAME = dware)
(INSTANCE_NAME = dware2)
)
)

dware =
(DESCRIPTION =
(CONNECT_DATA =
(ADDRESS = (PROTOCOL = TCP)(HOST = public ipnode1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = public ipnode2)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = dware)
)
)

please assist
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2009
Added on Nov 27 2009
13 comments
17,255 views