Home > ora 12154 > error from recovery catalog database ora-12154

Error From Recovery Catalog Database Ora-12154

Contents

ORA-12154: database link ora 12154 TNS:could not resolve service name [message #338473]

Ora 12154 Error In Oracle 11g

Tue, 05 August 2008 03:54 in.lukfai Messages: 8Registered: July 2008

Rman Ora 12154

Location: India Junior Member ######################################################################################################### C:\>set oracle_sid=katie3 C:\>net start oracleServiceKatie3 The OracleServicekatie3 service is starting. The

Rman-04004: Error From Recovery Catalog Database

OracleServicekatie3 service was started successfully. C:\>rman target sys/katie3@katie3 Recovery Manager: Release 9.2.0.1.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: rman-00554 rman-04005 ora-12154 =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: ORA-12154: TNS:could not resolve service name ############################################################################################ Whenever I connect to DB and mention @database_name then I always get this error: ORA-12154: TNS:could not resolve service name If I do not mention, just simply add user name and password then I can connect to database. ############################################################################################ C:\>rman target sys/katie3 Recovery Manager: Release 9.2.0.1.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database (not started) RMAN> ############################################################################################ I have checked TNSNAMES.ORA file and service name is already there: #####################################################################################

inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any ora-12154: tns:could not resolve the connect identifier specified of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.*** Wednesday, 2 January 2013 ORA-12154: TNS: could not resolve service name When running Oracle RMAN backup, RMAN manages to connect to the target database but fails to connect to the Recovery Catalog by giving below errors: RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve service name Recently I receive and issue from one http://www.orafaq.com/forum/t/122899/ user, he has created a separate tablespace and user for recovery catalog and registered database in recovery catalog, but unable to connect to catalog using CONNECT CATALOG COMMAND. When he tries to connect catalog database with @database is giving error without @database he is able to connect successfully. Cause: TNS: could not resolve the connect identifier specified A connection to a database or other service was requested using the connect identifier, and the connect identifier specified http://shahiddba.blogspot.com/2013/01/ora-12154-tns-could-not-resolve-service.html could not be resolved into a connect descriptor using one of the naming method configured. For Example, if the type of connect identifier used was net service name then the net service name could not be found in a naming method repository or the repository cold not be located or reached. Solution: If you are using local naming method make sure the tnsname.ora file having the correct entry there is no syntax error. Simply try to connect your catalog database in SQL*plus SQL> sys/*****@orcl3 or try to ping your catalog database cmd> tnsping catalog_DB If it is not working, then check your tnsnames.ora for catalog database entry there must be any thing wrong entered, correct it try to tnsping again as long as it will start pinging then try to reload listener cmd>lsnrctl lsnrctl> reload listener when tns entry start pinging and listener is OK then cmd> set oracle_sid=catalog_db cmd> rman catalog rman/rman@catalog ORA-12154: TNS: Could not resolve service name. I need to create an ODBC connection to access oracle table data. I already installed oracle client on the system having ORACLE-BASE=C:\oracle9i through which allow a configuration of listener in a net configuration utility. When I try to connect getting the following error: ORA-12154: TNS: Could not resolve service name. 1. Find the tnsname.ora from the ORACLE-HOME\Network\Admin folder and try to change it accordingly:

Phone: Company: Customer Type: Select Customer TypeEnd CustomerTrial CustomerResellerDistributerMSP Arcserve Employee Language: EnglishFrenchGermanItalianJapanesePolishPortugueseSpanishTurkish Country: Region: North AmericaJapanAsia PacificEMEA (Europe MiddleEast Africa)Latin America Time https://arcserve.zendesk.com/hc/en-us/articles/202151629-RMAN-04004-error-from-recovery-catalog-database-ORA-12154-TNS-could-not-resolve-the-connect-identifier-specified zone: Select Time Zone GMT-11:00 :: American Samoa GMT-11:00 :: International http://www.dbasupport.com/forums/showthread.php?59421-TNS-issues Date Line West GMT-11:00 :: Midway Island GMT-10:00 :: Hawaii GMT-09:00 :: Alaska GMT-08:00 :: Pacific Time (US & Canada) GMT-08:00 :: Tijuana GMT-07:00 :: Arizona GMT-07:00 :: Chihuahua GMT-07:00 :: Mazatlan GMT-07:00 :: Mountain Time (US & Canada) GMT-06:00 :: Central America GMT-06:00 :: Central Time (US ora 12154 & Canada) GMT-06:00 :: Guadalajara GMT-06:00 :: Mexico City GMT-06:00 :: Monterrey GMT-06:00 :: Saskatchewan GMT-05:00 :: Bogota GMT-05:00 :: Eastern Time (US & Canada) GMT-05:00 :: Indiana (East) GMT-05:00 :: Lima GMT-05:00 :: Quito GMT-04:30 :: Caracas GMT-04:00 :: Atlantic Time (Canada) GMT-04:00 :: Georgetown GMT-04:00 :: La Paz GMT-04:00 :: Puerto Rico GMT-03:30 :: Newfoundland GMT-03:00 :: Buenos error from recovery Aires GMT-03:00 :: Greenland GMT-03:00 :: Santiago GMT-02:00 :: Brasilia GMT-02:00 :: Mid-Atlantic GMT-01:00 :: Azores GMT-01:00 :: Cape Verde Is. GMT+00:00 :: Casablanca GMT+00:00 :: Dublin GMT+00:00 :: Edinburgh GMT+00:00 :: Lisbon GMT+00:00 :: London GMT+00:00 :: Monrovia GMT+00:00 :: UTC GMT+01:00 :: Amsterdam GMT+01:00 :: Belgrade GMT+01:00 :: Berlin GMT+01:00 :: Bern GMT+01:00 :: Bratislava GMT+01:00 :: Brussels GMT+01:00 :: Budapest GMT+01:00 :: Copenhagen GMT+01:00 :: Ljubljana GMT+01:00 :: Madrid GMT+01:00 :: Oslo GMT+01:00 :: Paris GMT+01:00 :: Prague GMT+01:00 :: Rome GMT+01:00 :: Sarajevo GMT+01:00 :: Skopje GMT+01:00 :: Stockholm GMT+01:00 :: Vienna GMT+01:00 :: Warsaw GMT+01:00 :: West Central Africa GMT+01:00 :: Zagreb GMT+02:00 :: Athens GMT+02:00 :: Bucharest GMT+02:00 :: Cairo GMT+02:00 :: Harare GMT+02:00 :: Helsinki GMT+02:00 :: Istanbul GMT+02:00 :: Jerusalem GMT+02:00 :: Kyev GMT+02:00 :: Kyiv GMT+02:00 :: Pretoria GMT+02:00 :: Riga GMT+02:00 :: Sofia GMT+02:00 :: Tallinn GMT+02:00 :: Vilnius GMT+03:00 :: Baghdad GMT+03:00 :: Kuwait GMT+03:00 :: Minsk GMT+03:00 :: Moscow GMT+03:00 :: Nairobi GMT+03:00 :: Riyadh GMT+03:00 :: St. Petersburg GMT+03:00 :: Volgograd GMT+03:30 :: T

issues If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: TNS issues Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-26-2009,02:15 PM #1 Tuma View Profile View Forum Posts Member Join Date Apr 2007 Location USA Posts 110 TNS issues hi all, I just upgraded my database from 9.8 to 10.4. Now I have some TNS issues if sitting directing on my server and do a sqlplus user/passwd@InstanceName I get the TNS error ERROR: ORA-12154: TNS:could not resolve the connect identifier specified however my sqlplus connection is fine without the @InstanceName (if my SID is OK) However all my 3rd party/client tools are connecting fine. TOAD, DBVISUALIZER, client SQLPLUS and users are using the database OK. So I don't think anything has changed in TNS settings?. As a result I cannot initiate an RMAN backup from this server/instance Recovery Manager: Release 10.2.0.4.0 - Production on Thu Feb 26 13:26:40 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: XXXXXXX (DBID=368783836355) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified thanks Looking for the greatest evil in the world? Look in the mirror. Reply With Quote 02-26-2009,05:58 PM #2 ebrian View Profile View Forum Posts Senior Member Join Date Apr 2006 Posts 377 Did you keep the old 9.2.0.8 home on this node? Verify that you are resolving out to the correct tnsnames.ora file. What

 

Related content

12154 error in toad

Error In Toad table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby g a li li a href Error Connecting To a li ul td tr tbody table p Oracle SQL Server PRODUCTSDiscussion Resources Backup Reporter Benchmark Factory Code Tester for Oracle SQL relatedl Navigator SQL Optimizer for IBM DB SQL Optimizer ora toad for Oracle SQL Optimizer for SQL Server SQL Optimizer for SAP toad oracle ora ASE Spotlight on DB LUW Spotlight on Oracle Spotlight on SQL Server Spotlight on SAP ASE ora toad windows

asp net ora 12154 error

Asp Net Ora Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora Error Solution a li li a href Ora Error Informatica a li li a href Ora Error a li li a href Ora Error a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the relatedl workings and policies of this site About Us Learn more ora error in oracle g about Stack Overflow the company Business Learn more about hiring developers

business objects error ora-12154

Business Objects Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Error While Trying To Retrieve Text For Error Ora- a li li a href Ora Error Solution a li li a href Ora Tns Could Not Resolve Service Name a li li a href Ora Tns Could Not Resolve Service Name Oracle i a li ul td tr tbody table p SAP BusinessObjects Web IntelligenceWhere is this place located All Places SAP BusinessObjects Web Intelligence Replies Latest reply Jun relatedl AM by Mark Prosser p h id Error While Trying To

crystal reports error ora-12154

Crystal Reports Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Error a li li a href Ora Tns Could Not Resolve Service Name a li ul td tr tbody table p SAP Crystal Reports version for Visual StudioWhere is this place located All Places SAP Crystal Reports version for Visual Studio Replies Latest relatedl reply Jan PM by Andrew error while trying to retrieve text for error ora- Paes Tweet Crystal Reports Windows Server ORA- TNS could not resolve the ora error in oracle g connect identifier specified Andrew

database server error ora-12154

Database Server Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Error While Trying To Retrieve Text For Error Ora- a li li a href Ora Tns Could Not Resolve Service Name a li li a href Ora Tns No Listener a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on tracing and reexecute the operation If error persists relatedl contact Worldwide Customer Support ORA- TNS unable to send break message

database error code 12154 ora 12154

Database Error Code Ora table id toc tbody tr td div id toctitle Contents div ul li a href Ora Error In Oracle g a li li a href Ora Tns Could Not Resolve Service Name a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified Xe a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For relatedl further details turn on tracing and reexecute the operation database link ora If error persists contact Worldwide Customer Support ORA- TNS

dblink error ora-12154

Dblink Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Connection Description For Remote Database Not Found a li li a href Create Database Link Oracle a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site relatedl About Us Learn more about Stack Overflow the company Business Learn ora error in oracle g more about hiring developers or posting ads with us Stack Overflow Questions Jobs

error 12154 ora-12154

Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora Error a li li a href Ora Tns Could Not Resolve Service Name a li li a href Ora Error In Oracle a li li a href Error Ora a li ul td tr tbody table p SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support SPAN Development Implementation Consulting StaffConsulting PricesHelp Wanted Oracle PostersOracle Books Oracle Scripts Ion Excel-DB relatedl Don Burleson Blog P TD TR ora tns could not resolve the connect identifier

error attach server ora-12154

Error Attach Server Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Error While Trying To Retrieve Text For Error Ora- a li li a href Ora Error In Toad a li li a href Ora Tns Error a li li a href Ora Tns No Listener a li ul td tr tbody table p while creating a linked server to Oracle x x x x x x x x x x x x x x x SnehadeepJune This is one relatedl of the most common errors while creating linked p h id

error code ora 12154

Error Code Ora table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified Xe a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on tracing and reexecute relatedl the operation If error persists contact Worldwide Customer Support ora error in oracle g ORA- TNS unable to send break message Cause Unable

error from auxiliary database ora-12154

Error From Auxiliary Database Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Database Link Ora a li li a href Ora Error Solution a li li a href Ora Error a li li a href Ora Error a li ul td tr tbody table p NEWNAME FOR DATAFILE and SET NEWNAME FOR TEMPFILE SET NEWNAME FOR TABLESPACE relatedl SET NEWNAME FOR DATABASE The following variables are p h id Database Link Ora p introduced for SET NEWNAME from gR - b The file name remains ora error in oracle g same as

error ora 12154 could not resolve service name

Error Ora Could Not Resolve Service Name table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified Xe a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified At Oci Call Ociserverattach a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About

error ora 12154 in

Error Ora In table id toc tbody tr td div id toctitle Contents div ul li a href Sqlnet Ora a li li a href Ora Error Toad a li li a href Error While Trying To Retrieve Text For Error Ora a li li a href Ora Error In Oracle a li ul td tr tbody table p while creating a linked server to Oracle x x x x x x x x x x x x x x x SnehadeepJune This is one of the most common errors relatedl while creating linked server to Oracle database Today I

error ora 12154 tns could not resolve the service name

Error Ora Tns Could Not Resolve The Service Name table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve Connect Identifier Specified g a li li a href System Data Oracleclient Oracleexception Ora Tns Could Not Resolve The Connect Identifier Specified a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified N a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers

error ora-12154 toad

Error Ora- Toad table id toc tbody tr td div id toctitle Contents div ul li a href Ora Toad Windows a li li a href Ora Tns Error a li li a href Ora Toad a li ul td tr tbody table p NoSQL Oracle SQL Server PRODUCTSDiscussion Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer relatedl Spotlight Stat Toad Intelligence Central Toad Data Modeler toad oracle ora Toad Data Point Toad Extension for Eclipse Toad for Hadoop Toad for p h id Ora Toad Windows p IBM DB Toad for Oracle Toad for MySQL

error ora 12154 tns could not resolve service name

Error Ora Tns Could Not Resolve Service Name table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve Service Name Windows a li li a href Ora Tns Could Not Resolve Connect Identifier Specified g a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on relatedl tracing and reexecute the operation If error persists contact

error ora-12154 oracle

Error Ora- Oracle table id toc tbody tr td div id toctitle Contents div ul li a href Ora Oracle i a li li a href Oracle Ora Database Link a li li a href Ora Oracle a li li a href Ora Oracle a li ul td tr tbody table p server but either failed to contact the server or did not find a relatedl matching service name on that server TNS or oracle error ora 'Transparent Network Substrate' is a transport protocol that allows Oracle sessions to p h id Ora Oracle i p communicate across a network

error ora 12154 tns could

Error Ora Tns Could table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified Xe a li li a href Ora Tns Could Not Resolve Service Name Windows a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified N a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details

error oracle connection error ora-12154

Error Oracle Connection Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Oracle Ora Database Link a li li a href Oracle Odbc Ora a li li a href Oracle Ora a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on tracing and relatedl reexecute the operation If error persists contact Worldwide Customer ora error in oracle g Support ORA- TNS unable to send break message Cause Unable to send break

ora 12154 database driver error

Ora Database Driver Error table id toc tbody tr td div id toctitle Contents div ul li a href Sqlnet ora Location a li li a href Informatica Oracle Connection String a li ul td tr tbody table p WizardInformatica Cloud for Amazon AWSComplex Event ProcessingProactive Healthcare Decision ManagementProactive MonitoringReal-Time Alert ManagerRule PointData IntegrationB B Data ExchangeB B Data TransformationData Integration HubData relatedl ReplicationData ServicesData Validation OptionFast CloneInformatica PlatformMetadata ManagerPowerCenterPowerCenter ora- tns could not resolve the connect identifier specified in informatica ExpressPowerExchangePowerExchange AdaptersData QualityAddress DoctorAddress Doctor CloudData as a ServiceData informatica repository service ora- ExplorerData QualityData Quality Services Strike Iron

ora 12154 dblink error

Ora Dblink Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more relatedl about Stack Overflow the company Business Learn more about hiring developers ora tns could not resolve the connect identifier specified g or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x p h id Ora-

ora 12154 tns error in toad

Ora Tns Error In Toad table id toc tbody tr td div id toctitle Contents div ul li a href Ora Toad a li li a href Ora Tns Could Not Resolve Service Name a li ul td tr tbody table p NoSQL Oracle SQL Server PRODUCTSDiscussion Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer Spotlight Stat Toad Intelligence Central relatedl Toad Data Modeler Toad Data Point Toad Extension for p h id Ora Toad p Eclipse Toad for Hadoop Toad for IBM DB Toad for Oracle Toad for toad tns admin environment variable is not

ora 12154 error in oracle 11g

Ora Error In Oracle g table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns Listener Does Not Currently a li li a href Ora- Oracle c a li li a href Error While Trying To Retrieve Text For Error Ora- a li ul td tr tbody table p to send data Connection probably disconnected Action Reestablish connection If the error is persistent turn relatedl on tracing and reexecute the operation ORA- TNS received ora error in oracle c bad packet type from network layer Cause Internal error Action Not normally ora error

ora 12154 error in oracle forms

Ora Error In Oracle Forms p 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 relatedl reload this page Please enter a title You can not ora oracle g post a blank message Please type your message and try again More discussions ora tns could not resolve service name in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived Previous Next Replies Latest reply on Aug PM by rajeysh Go to original post

ora 12154 error toad

Ora Error Toad table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name a li li a href Tns admin Environment Variable Is Not Defined a li li a href Tnsnames ora Location a li ul td tr tbody table p NoSQL Oracle SQL Server PRODUCTSDiscussion Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer Spotlight Stat Toad Intelligence Central Toad Data Modeler Toad Data Point Toad relatedl Extension for Eclipse Toad for Hadoop Toad for IBM DB Toad ora toad for Oracle Toad for

ora 12154 toad error

Ora Toad Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora Toad a li li a href Tns admin Environment Variable Is Not Defined a li ul td tr tbody table p NoSQL Oracle SQL Server PRODUCTSDiscussion Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL relatedl Optimizer Spotlight Stat Toad Intelligence Central Toad Data p h id Ora Toad p Modeler Toad Data Point Toad Extension for Eclipse Toad for Hadoop ora tns could not resolve service name Toad for IBM DB Toad for Oracle Toad for MySQL Toad