Error From Recovery Catalog Database Ora-12514
Contents |
on Bitdefender Antivirus Free toEnglish → ORA-12514 TNS listener does not currently know of service requested in connectdescriptor Jun 8 Posted by sunilpadman Error from Recovery Catalog Database rman-00554: initialization of internal recovery manager package failed - ORA-12514 | Could not connect to RMAN Catalog Database Example : c:\>
Ora-12541: Tns:no Listener
rman target / catalog rcat/password@orcl Error: TNS: listener does not currently know of service requested in connect descriptor The typical solution when you encounter this error is to check the TNSNames.ora file in the $ORACLEHOME\NETWORK\ADMIN directory to correct any typo errors But what if your recovery catalog database was working perfectly earlier and no changes were done to the TNSNames.ora file. If yes, below steps should help you Connect to the Recovery Catalog Database c:\> set ORACLE_SID=catdb c:\> sqlplus target / You could end up getting an error message : Connected to an Idle Instance Startup the Instance You can start the Instance with below command c:\> oradim -STARTUP -SID
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM maxwellarnold I_am_the_dragon PCMag Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Dennis Stevenson Craig Borysowich DukeGanote Richard mircea_luca AbhaiTripathi https://tekrecipes.com/2014/06/08/error-from-recovery-catalog-database-ora-12514/ Nikki Klein knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES Hewlett Packard Hitachi America, LTD Compuware Fiberlink Communications View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/rman04005-error-from-target-database-4433903 including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. RMAN-04005: Error from Target Database, vendba asked Sep 22, 2011 | Replies (9) Hello Everyone, I am not able to connect to my target DB, every time I try to connect to target DB I got this errors: RMAN-04005: error from target database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 1. Target DB is up and running and its listener is started ( status is R
started . However when an attempt is made to connect to the Rcat database, as a user: rcatowner, using Rman http://kavanjitvirdioraclesolutions.blogspot.com/2012/03/rman-problem-and-solutions.html at the linux prompt then there are problems doing so and a user gets the following error: [ ~]$ rman target / catalog rcatowner@rcat connected to target database: ORCL (DBID=**********) recovery catalog database Password: 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 error from database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 2. Impact: High as the user cannot connect to the rcat database and hence cannot use the Rman (Recovery Manger) services. 3. Solution: Although the listener has been started and the target (orcl) database has been started and mounted the user cannot connect to rcat error from recovery because the rcat database instance has not yet been started by the user. You can know this by the following line in the above error: "connected to target database: ORCL (DBID=**********)". Here it clearly indicates that the user is connected to the orcl database instance and not the rcat instance. Rcat database instance needs to be started because Rcat is a database like the target database. Additional Info: Rcat is a database and comprises of Oracle tables and views which the RMAN (Recovery Manager) uses to store metadata and its (RMAN) repository information of one or more Oracle databases. RMAN utilises the metadata to manage the recovery, backup and restoring of the Oracle databases. Below are the steps that need to be followed: Step #1: [ ~]$ . oraenv ORACLE_SID = [orcl] ? rcat Step #2: [ ~]$ sqlplus / as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Database mounted. Database opened. Step #3: [ ~]$ rman target / catalog rcatowner@rcat connected to target database: RCAT (DBID=*********) rec