Error From Recovery Catalog Database Ora-12541
Contents |
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time rman-04004: error from recovery catalog database Help Create a Freelance Project Hire for a Full Time Job
Rman 00554 Rman 04005 Ora 12154
Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers ora-12541: tns:no listener Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > RMAN Catalog Want to Advertise Here? Solved RMAN Catalog Posted on 2010-11-22 Oracle Database MS Legacy OS Unix OS 1 Verified Solution 18 Comments 2,550 Views Last Modified: 2012-08-13 I have 2 databases on my laptop one is oracle11g database "oracle11" and oracle10g database "oracle10". I have done beow steps On Oracle11g: SQL> create tablespace rman_tbsp datafile 'C:\app\Khan\oradata\oracle11\rman_tbsp.DBF' size 500M extent management local segment space management auto; SQL>create user RMAN identified by abc temporary tablespace temp default tablespace rman_tbsp quota unlimited on rman_tbsp; SQL>grant connect,resource,recovery_catalog_owner to rman; C:\Documents and Settings\Administrator>rman catalog rman/rman@oracle11 Recovery Manager: Release 11.1.0.6.0 - Production on Mon Nov 22 07:04:46 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to recovery catalog database RMAN> connect target oracle10 target database Password: connected to target database: ORACLE11 (DBID=2428108270) My question here is when I mentioned connect target oracle10 database that is oracle 10g database its connecting to oracle11g database that is oracle11. Does I am making any mistake please let me know 0 Question by:hussainkhan22 Facebook Twitter LinkedIn Google LVL 5 Best Solution bymanzoor_dba Hi, RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: Instance "oracle10", status UNKNOWN, has 1 handler(s) for this service... As Go to Solution 18 Comments Message Author Comment by:hussainkhan222010-11-22 C:\Documents and Settings\Administrator>rman target system/system@oracle10 catal og rman/rman@oracle11 Recovery Manager: Release 11.1.0.6.0 - Production on Mon Nov 22 07:17:35 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. RMAN-00571: =========================================================== RMAN-00569
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 Nikki Klein knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 https://www.experts-exchange.com/questions/26630954/RMAN-Catalog.html 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, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/rman04005-error-from-target-database-4433903 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 READY). 2. I can able ping target from client side. Description in tnsnames.ora file is total match target listener details. *listener.ora file output*: Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=
View Blog For any company the most important asset is data and the most challenging job is to recovery the database with less downtime with out any data loss, in the http://www.oraclecommunity.net/profiles/blogs/understand-oracle-rman-reporting event of database failure. In many situations users end up with incomplete http://www.dba-oracle.com/t_ora_12541_tns_no_listener.htm recovery of the database with out knowing which data files backed and which data files need to backup. You should ensure that your database is backed up efficiently and should restore successfully when needed. The RMAN reporting provides effective and easy way to determine database backup for a successful error from recovery. Please view the article using below link.http://www.oracleracexpert.com/2011/06/understand-oracle-rman-repor... I hope you will like the article and it will be helpful to you.Please leave your valuable comments.Regards,Satishbabu Gunukula, Oracle ACEhttp://www.oracleracexpert.com Views: 928 Tags: Share Tweet Facebook < Previous Post Next Post > Comment by Mahrukh Khan on December 13, 2012 at 11:09am Can you help me please? I created recovery catalog error from recovery whenever i am trying to connect through rman target / catalog rman/rman@orcl. i get error RMAN-00554: initialization of internal recovery manager package failedRMAN-04004: error from recovery catalog database: ORA-12541: TNS:no listener. I tried lsnrctl start. listener started. I don't know where to find listener.ora. in network/admin folder i can see tnsnames.ora file only. when i do tnsping orcl it gives me Used HOSTNAME adapter to resolve the aliasAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.36.128)(PORT=1521))). I see service_name is missing. Where can i find this whole string and how can i edit service_name? I am looking forward to hearing from you. I know you can help me. Comment You need to be a member of Oracle Community to add comments! Join Oracle Community RSS Welcome toOracle Community Sign Upor Sign In Or sign in with: Oracle Community On Twitter Facebook LinkedIn Google+ Reddit I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain ser
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ORA-12541: TNS: no listener Oracle Tips by John Garmany You Asked: I get the ORA-12541 error message when I try to connect through Forms6i and Reports6i Builder. I've started the listener also. I have no problems accessing the database through SQL*Plus. I've checked the listener.ora and tnsnames.ora files and everything seems okay. We Said: From the docs: ORA-12541: TNS no listener Cause: Listener for the source repository has not been started. Action: Start the Listener on the machine where the source repository resides. Basically the Forms server could not find the listener. First check the tnsnames.ora file and ensure that it points to the correct server and port. If the Forms server is on another machine, test the TNS resolve with tnsping from the command prompt. Finally, check the listener. First, ensure that your listener service is running. C:\Documents and Settings\ME>lsnrctl stat This should show the status of the listener and the services it is listening for. Remember that when you run SQL*Plus on the database server, it does not need the listener to connect unless you specify the database tnsnames.ora entry.Try to start the listener service using lsnrctl from DOS prompt. set ORACLE_HOME= cd %ORACLE_HOME%/bin lsnrctl start LISTENER If the listener service is not running, re-start the listener service using the Windows task manager or use the DOS command line utility to re-start the Windows service with the "net start" command: C:\Documents and Settings\ME>net start OracleOraDb10g_home1TNSListener You can use the lsnrctl status command to verify that the listener is down, and lsnrctl start to start your listener. If you are on Windows, also verify that the listener service is running. Here are more notes on lsnrctl: Oracle listener lsnrctl command Oracle listener lsnrctl command Oracle listener security tips Blocking Oracle access by IP Addresses �� Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on ou