ORA 12533 TNS illegal ADDRESS parameters
467014Nov 27 2009 — edited Nov 28 2009Hi 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