Home » RDBMS Server » Networking and Gateways » TNS-12533: TNS:illegal ADDRESS parameters
TNS-12533: TNS:illegal ADDRESS parameters [message #222824] Tue, 06 March 2007 09:33 Go to next message
bhanu11
Messages: 6
Registered: March 2007
Junior Member
Used parameter files:
/oraeng/app/oracle/product/10.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.201.08) (PORT=9848))
TNS-12533: TNS:illegal ADDRESS parameters



PLZZZZZZZZZZZZZZZZ HELP ME

[Updated on: Wed, 07 March 2007 00:45]

Report message to a moderator

Re: TNS-12533: TNS:illegal ADDRESS parameters [message #222848 is a reply to message #222824] Tue, 06 March 2007 12:55 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Looks like you're missing a close bracket - ).
Re: TNS-12533: TNS:illegal ADDRESS parameters [message #222955 is a reply to message #222848] Wed, 07 March 2007 01:11 Go to previous messageGo to next message
bhanu11
Messages: 6
Registered: March 2007
Junior Member
to_mydb=
(DESCRIPTION =
(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.201.08)(PORT=9848))
(CONNECT_DATA =
(SID=dba1)
)
)
this is my tnsnames.ora file

[Updated on: Wed, 07 March 2007 01:11]

Report message to a moderator

Re: TNS-12533: TNS:illegal ADDRESS parameters [message #222957 is a reply to message #222955] Wed, 07 March 2007 01:17 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

TO_MYDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.201.08)(PORT = 9848))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dba1)
    )
  )



regards
Taj
Previous Topic: listener running, but unable to listen client
Next Topic: Problem between listener.ora and tnsnames.ora
Goto Forum:
  


Current Time: Mon Nov 25 18:26:40 CST 2024