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