OraFAQ Forum: Networking and Gateways » TNS-12533: TNS:illegal ADDRESS parameters

Home » RDBMS Server » Networking and Gateways » TNS-12533: TNS:illegal ADDRESS parameters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS-12533: TNS:illegal ADDRESS parameters [message #222824]

Tue, 06 March 2007 09:33

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

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Looks like you're missing a close bracket - ).

Report message to a moderator

Re: TNS-12533: TNS:illegal ADDRESS parameters [message #222955 is a reply to message #222848]

Wed, 07 March 2007 01:11

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 10 17:58:42 CDT 2025