Oracle Listener Nl-00303 Syntax Error In Nv String
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have
Sid_list_listener
JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle http://dbaforums.org/oracle/index.php?showtopic=18568 VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace https://community.oracle.com/community/developer/search.jspa?q=ORA-01155 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
to friend TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #260710] Mon, 20 August 2007 14:44 niravana Messages: 6Registered: July 2007 Location: Bangladesh Junior Member i dont have any idea about http://www.orafaq.com/forum/t/87764/ this error... when i am trying to start the listener showing these http://samratkumar.blogspot.com/2015/09/tns-01155-incorrectly-specified.html errors.. "TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production System parameter file is C:\oracleproduct\network\admin\listener.ora Log messages written to C:\oracleproduct\network\log\listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=joynul)(PORT=1521))) TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA NL-00303: syntax error in NV string" i have checked the listener.ora file i have not got syntax error any error.. plzz help me out Report message to a moderator Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #260718 is a reply to message #260710] Mon, 20 August 2007 15:05 Michel Cadot Messages: 63912Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator But Oracle found one so double check. Maybe you have non printable syntax error in character. Regards Michel Report message to a moderator Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #260771 is a reply to message #260710] Mon, 20 August 2007 21:49 Arju Messages: 1554Registered: June 2007 Location: Dhaka,Bangladesh. Mobile:... Senior Member Quote:i have checked the listener.ora file i have not got any error.. I can bet that the problem is in your listener.ora file. Oracle can't be able to read that file. Fix that file. You can paste your listener.ora file and let us check where the error. Or you manually can also check and what is the status of the listener? Report message to a moderator Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261018 is a reply to message #260771] Tue, 21 August 2007 09:29 DreamzZ Messages: 1666Registered: May 2007 Location: Dreamzland Senior Member TNS-01155: Incorrectly specified SID_LIST_string parameter in LISTENER.ORA Cause: SID_LIST_
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-SEP-2015 03:43:02 Copyright (c) 1991, 2013, Oracle. All rights reserved. Starting /opt/oracle/product/11.2.0.4.RAC/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /opt/oracle/product/11.2.0.4.RAC/network/admin/listener.ora Log messages written to /opt/oracle/diag/tnslsnr/linux01/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA NL-00303: syntax error in NV string Listener failed to start. See the error message(s) above... Solution: In the listener.ora file there were blank lines under the section SID_LIST_LISTENER. We removed the blank line entries and brought up the listener. (please note that this may be one of the scenarios) Erroneous listener.ora file excerpts below: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL1) (ORACLE_HOME = /opt/oracle/product/11.2.0.4.RAC) (SID_NAME = ORCL1) ) <<<<< blank line (SID_DESC = (GLOBAL_DBNAME = ORCL2) (ORACLE_HOME = /opt/oracle/product/11.2.0.4.RAC) (SID_NAME = ORCL2) ) <<<<< blank line ) Posted by Samrat at 3:17 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Older Posts ► 2016 (3) ► October (1) ► May (2) ▼ 2015 (8) ▼ September (1) TNS-01155: Incorrectly specified SID_LIST_LISTENER... ► August (2) ► April (1) ► March (1) ► January (3) ► 2014 (17) ► November (4) ► September (2) ► July (1) ► May (2) ► April (1) ► March (1) ► February (2) ► January (4) ► 2013 (28) ► December (4) ► November (3) ► October (5) ► September (3) ► August (5) ► July (8) ► 2011 (2) ► January (2) About Me Samrat View my complete profile Followers Total Pageviews Live Traffic Feed Live Traffic Stats Disclaimer The views expressed on this blog are my own and do not necessarily reflect the views of either the companies I have worked for or Orac