TNS-01550 Error 1

[kodaksmile]

I just created a new database called wiretst (in small letters) I added the following entry in my listener.ora file:

# Listener to the wiretst
USE_PLUG_AND_PLAY_WIRETST = OFF
USE_CKPFILE_WIRETST = OFF
wiretst =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=itdevb3.rexallsundown.com)(PORT=1532))
(ADDRESS=(PROTOCOL=tcp)(HOST=itdevb3.rexallsundown.com)(PORT=1537))
(ADDRESS=(PROTOCOL=ipc)(KEY=wiretst)))

SID_LIST_WIRETST=
(SID_LIST=
(SID_DESC=
(SDU = 8192)
(GLOBAL_DBNAME=wiretst.REXALLSUNDOWN.COM)
(SID_NAME=wiretst)
(ORACLE_HOME=/u01/app/oracle/product/8.1.7)
)
)

STARTUP_WAIT_TIME_WIRETST = 0
CONNECT_TIMEOUT_WIRETST = 0
LOG_DIRECTORY_WIRETST = /u01/app/oracle/product/8.1.7/network/log
TRACE_LEVEL_WIRETST = OFF

I also added the following entry in my tnsnames.ora file:

wiretst.REXALLSUNDOWN.COM =
(DESCRIPTION =
(SDU = 8192)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = itdevb3.rexallsundown.com
)(PORT = 1532)
(COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = itdevb3.rexallsundown.com
)(PORT = 1537)
)
)
(CONNECT_DATA = (SID = wiretst))
)

It looks the same as other entries in both files (there are multiple databases on my unix server) but, I get the following error when I try to start the listener :

TNS-01550 Address of specified listener name is incorrect
NL-00303 syntax error in NV string

It also looks like it is trying to use port 1521 instead of the ports I assigned. I also tried doing lsnrctl reload in case it didn't pick up the changes but, same result. Any help would be appreciated. thanks

 

[ThomVF]

From technet:

By default, the PMON process registers with the local listener on the default local address of TCP/IP on a port 1521. If you want to register information with another listener, you must configure the LOCAL_LISTENER parameter in the initialization parameter file in order for PMON to register information with it. The value for LOCAL_LISTENER must then be resolved with a net service name entry in the tnsnames.ora file or an Oracle Names server.

The LOCAL_LISTENER parameter should be configured as follows in the initialization parameter file:

local_listener=listener_name_alias



=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[kodaksmile]

But neither of the other 2 databases I have running on that server use that parameter in the init file...I will try it though and see if it fixes my problem. Thanks.

 

[ThomVF]

That is strange.

Does the fact that you named the listener in lower case have any impact? I cannot remember if that matters.

Do you other listeners have plug and play enabled?
What about dbname, domain name init parameters - are they set in the same manner (not value) in all of you databases? =================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[kodaksmile]

I tried your suggestion but when I tried to start the listener I received the same error message.

 

[ThomVF]

In your TNSNAMES.ORA file, are you misssing an ADDRESS= qualifier??

wiretst.REXALLSUNDOWN.COM =
(DESCRIPTION =
(SDU = 8192)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(HOST = itdevb3.rexallsundown.com)
(PORT = 1532)
)
(ADDRESS=
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(HOST = itdevb3.rexallsundown.com)
(PORT = 1537)
)
)
(CONNECT_DATA =
(SID = wiretst)
)
)
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[kodaksmile]

There is only one (ADDRESS on the other 2 entries in the tnsnames file. None of the other listeners have plug and play enabled - I basically copied and pasted from one that is working and just modified the places where the dbname or sid references appeared - I also deleted the blank spaces to make sure there weren't any funky characters included. I have some dbnames in caps and some in small letters - domains also in mixed cases but, they are working fine. :-(

 

[ThomVF]

I'm at a loss now.

Try using some unique ports not being used by the other databases...sorry =================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[kodaksmile]

I am using unique ports

 

[ThomVF]

A few other comments (sorry, don't think I am insulting your intelligence when I mention these basics - sometimes they help shake loose a problem)

By the way, is the error# actually TNS-01150, versus 01550??

I've been asumming that the tnsnames.ora file shown above is on the server - is that correct ?

You have multiple listeners and multiple databases on one machine. You are defining all listeners in single listener.ora file, right ?

The TNS-01150 implies that there is a syntax error in the listener definition. Cut the other listeners out of the listener.ora (disabling them) and try it.

Disable the other listeners and try using one of their port#s instead of 1532 and 1537 - any chance you have port contention?

Did you generate the listener.ora by hand? If so, try using Net8 Assistant to regenerate it. Perhaps it will format it differently and (hopefully) eliminate the error. If you used Net8 Assistant....then

Tom




=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[kodaksmile]

No offense taken - I thought I did something stupid at first like a typo or the infamous invisible unix character so I did it again - yes it really is error TNS-01150. I did create it manually since we are on unix by copying and pasting an entry from a working listener - changed ports and all occurances of dbname or sid as shown above - not sure how to use net8 assistant on unix. The tnsnames file is in the same directory oracle_home/network/admin as the listener.ora. Yes there is only one listener.ora file. I cannot take the others down right now but, will try around lunch time - users get upset when they cannot connect - even developers.

 

[kodaksmile]

Well I did a quick shuffle and removed all entries except the one for wiretst and recieved the same error message so it really doesn't like something in the syntax even though I cannot see anything wrong with the file - I will try to recreate it one more time and see if there is something funny in there.

 

[ThomVF]

You can use Net8 Assistant on a client PC to generate a listener.ora file (and a tnsnames.ora), then move the file (s) to the server. I suggest trying this to be 100% sure of your syntax/spacing.

A couple other basic considerations:

Check dbname and domain name parameters in init.ora - ideally, they should match the GLOBAL_DBNAME and be set to dbname=wiretst domain=REXALLSUNDOWN.COM

This database isn't running MTS, is it?


=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[kodaksmile]

I tried in between comments to create the entry on my local desktop using net8 but the syntax is the same as only part of the actual entry required - It looks as follows:
WIRETST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = itdevb3.rexallsundown.com)(PORT = 1532))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = itdevb3.rexallsundown.com)(PORT = 1537))
)
)

And the error seems to refer to what comes after this which is the sid list part.




Also here is the result of init file and global_dbname

This is the entry in the initwiretst.ora file:

db_name = "wiretst"
db_domain = REXALLSUNDOWN.COM
instance_name = wiretst
service_names = wiretst.REXALLSUNDOWN.COM


Result of global name query:

SVRMGR> select * from global_name;
GLOBAL_NAME
--------------------------
WIRETST.REXALLSUNDOWN.COM

 

[ThomVF]

I sensed that the error regarded the ADDRESS specification:

TNS-01150 The address of the specified listener name is incorrect

Cause: The address on which the listener attempted to listen contains a syntax error.

Action: For the listener name or service name specified to LSNRCTL, check that the address or connect descriptor is well-formed. You can find the listener name in LISTENER.ORA, or you can access the listener through the service name is TNSNAMES.ORA.

=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[kodaksmile]

I looked up the error and saw the same thing but, I still don't see where it is wrong unfortunately making it difficult to fix. :-(

 

[kodaksmile]

I tried to delete and recreate the entry and this is still the error:

TNS-01155: Incorrectly specified SID_LIST_WIRETST parameter in LISTENER.ORA
NL-00303: syntax error in NV string

Here is the contents of the file:

# Listener to the edms
USE_PLUG_AND_PLAY_EDMSDEV = OFF
USE_CKPFILE_EDMSDEV = OFF
EDMSDEV =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=itdevb3.rexallsundown.com)(PORT=1535))
(ADDRESS=(PROTOCOL=tcp)(HOST=itdevb3.rexallsundown.com)(PORT=1538))
(ADDRESS=(PROTOCOL=ipc)(KEY=EDMSDEV)))

SID_LIST_EDMSDEV=
(SID_LIST=
(SID_DESC=
(SDU = 8192)
(GLOBAL_DBNAME=EDMSDEV.REXALLSUNDOWN.COM)
(SID_NAME=EDMSDEV)
(ORACLE_HOME=/u01/app/oracle/product/8.1.7)
)
)

STARTUP_WAIT_TIME_EDMSDEV = 0
CONNECT_TIMEOUT_EDMSDEV = 0
LOG_DIRECTORY_EDMSDEV = /u01/app/oracle/product/8.1.7/network/log
TRACE_LEVEL_EDMSDEV = OFF

# Listener to the edms
USE_PLUG_AND_PLAY_PIPDEV = OFF
USE_CKPFILE_PIPDEV = OFF
PIPDEV =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=itdevb3.rexallsundown.com)(PORT=1531))
(ADDRESS=(PROTOCOL=tcp)(HOST=itdevb3.rexallsundown.com)(PORT=1536))
(ADDRESS=(PROTOCOL=ipc)(KEY=PIPDEV)))

SID_LIST_PIPDEV=
(SID_LIST=
(SID_DESC=
(SDU = 8192)
(GLOBAL_DBNAME=PIPDEV.REXALLSUNDOWN.COM)
(SID_NAME=PIPDEV)
(ORACLE_HOME=/u01/app/oracle/product/8.1.7)
)
)

STARTUP_WAIT_TIME_PIPDEV = 0
CONNECT_TIMEOUT_PIPDEV = 0
LOG_DIRECTORY_PIPDEV = /u01/app/oracle/product/8.1.7/network/log
TRACE_LEVEL_PIPDEV = OFF

# listener to the edms
USE_PLUG_AND_PLAY_WIRETST = OFF
USE_CKPFILE_WIRETST = OFF
WIRETST =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=itdevb3.rexallsundown.com)(PORT=1532))
(ADDRESS=(PROTOCOL=tcp)(HOST=itdevb3.rexallsundown.com)(PORT=1537))
(ADDRESS=(PROTOCOL=ipc)(KEY=WIRETST)))

SID_LIST_WIRETST=
(SID_LIST=
(SID_DESC=
(SDU = 8192)
(GLOBAL_DBNAME=WIRETST.REXALLSUNDOWN.COM)
(SID_NAME=wiretst)
(ORACLE_HOME=/u01/app/oracle/product/8.1.7)
)
)

STARTUP_WAIT_TIME_WIRETST = 0
CONNECT_TIMEOUT_WIRETST = 0
LOG_DIRECTORY_WIRETST = /u01/app/oracle/product/8.1.7/network/log
TRACE_LEVEL_WIRETST = OFF

 

[ThomVF]

The only thing that stands out is the SID name is lower case, while your other listener sid names are upper-case:

(SID_NAME=wiretst)
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[kodaksmile]

I have that scenario on another oracle server (3 separate instances) without any problems though the one that works is on 8.1.6.2 and this is 8.1.7 - this is not fun

 

[kodaksmile]

This is not going to make any sense but, I got it to work - deleted any reference to the sid_list in the listener.ora file, modified the key to be wiretest.REXALLSUNDOWN.COM and reconfigured the tnsnames file to handle service_names instead of sid, listener came up but with no services - I could tnsping wiretst from my workstation - then went back and cut and pasted the entry from above for just the sid_list and modified leaving spacing completely messed up -ran the script we use that takes the db and listener down and then brought them back up - works. wierd ... unless there was still an invisible character in that section the whole time....Thank you so much for your help and Patience........:-D