Ora-00132 Syntax Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss
Ora-00132 Syntax Error Or Unresolved Network Name Remote_listener
the workings and policies of this site About Us Learn more ora-00119 ora-00130 about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow
Ora-00119 Ora-00132
Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping ora-00132: syntax error or unresolved network name 'listener_+asm' each other. Join them; it only takes a minute: Sign up ORA-00119: invalid specification ORA-00132: syntax error up vote 0 down vote favorite Below are outputs from my SQLPLUS startup , LSNRCTRL SERVICES, LSNRCTRL STATUS and TNSPING. Also included are my LISTENER.ORA file, TNSNAMES.ORA and my PFILE. As you can see from the SQLPLUS startup output the database syntax error or unresolved network name 'listener_orcl' will not startup because init.ora file local_listener is setup as LISTENER and it says its unable to resolve that name. However the LSNCTRL status shows the name of the LISTENER to be LISTENER, so I'm not sure how LSNCTRL utility is seeing the LISTENER and SQLPLUS can't. My guess, is I'm missing something and I'm sure its OBVIOUS and SIMPLE. Any help would be appreciated! ORACLE_HOME=C:\app\product\12.1.0\dbhome_1 SQLPLUS STARTUP ================================================================================ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Feb 27 06:37:51 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER' SQL> ================================================================================ LSNRCTL SERVICES ================================================================================ LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 27-FEB-2015 06:36:45 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Service "EDMP1" has 1 instance(s). Instance "EDMP1", status UNKNOW
and SafetyAsset NetworkAsset Operations and ora-00119 invalid specification for system parameter local_listener 12c MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for
Oracle 12c Ora 00119 Invalid Specification For System Parameter Local_listener
CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial http://stackoverflow.com/questions/28765999/ora-00119-invalid-specification-ora-00132-syntax-error Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative http://scn.sap.com/thread/538653 Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverv
linux using srvctrl start database/instance command gave https://aprakash.wordpress.com/2011/08/02/ora-00132-syntax-error-or-unresolved-network-name-listener_test2at/ the below error - $ srvctl start instance https://community.oracle.com/community/developer/search.jspa?q=ORA-00132 -d testat -i test1at PRCR-1079 : Failed to start resource ora.testat.db CRS-5017: The resource action "ora.testat.db start" encountered the following error: ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network syntax error name 'LISTENER_TEST2AT' . For details refer to "(:CLSN00107:)" in "/u01/app/oracle_crs/11.2.0.2/log/anand-lab/agent/crsd/oraagent_oracle/oraagent_oracle.log". The error lead to check tnsnames.ora and tnsping for LISTENER_TEST2AT. All was fine.Did some more debugging and found TNS_ADMIN set. $echo $TNS_ADMIN /var/opt/oracle/ The tnsnames.ora, listener.ora and sqlnet.ora were present in /var/opt/oracle location. syntax error or The issue was sqlnet.ora file was not present in $ORACLE_HOME/network/admin folder.Created symbolic link for sqlnet.ora in $ORACLE_HOME/network/admin $ cd $ORACLE_HOME/network/admin/ $ ln -s /var/opt/oracle/sqlnet.ora Also, missing was symbolic link for tnsnames.ora. Once done, the srvctl start instance/database command succeeded. For ORA-00132, you can also refer http://askdba.org/weblog/2011/05/ora-00132-while-starting-11gr2-database/ Like this:Like Loading... Related Posted in 11gR2, CRS, Oracle, RACLeave a comment Post navigation Previous PostEXPDP - ORA-39166: Object XXX was notfound.Next PostKEEP_MASTER and METRICS inEXPDP/IMDP Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have 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 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 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