Operation Generated Oracle Error 12541
Contents |
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 ora-12541 but listener is running Us Learn more about Stack Overflow the company Business Learn more about hiring ora-12541 tns no listener 11g developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join ora 12541 tns no listener toad the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error while restoring oracle 10g ora-12541: tns:no listener linux .dmp file in oracle database 12c up vote 0 down vote favorite I've got a .dmp file created with Oracle 10g containing the database of one of my clients. I can't for the life of me get it set up with my 12c installation. I can connect to my db using https://localhost:5500/em I've created a user 'BOB' in my desired PDB and granted import, read and
Ora 12541 Tns No Listener Oracle 11g Client
write permissions. Next I try to import using the following command: impdp BOB/password@//localhost:1521/pdbname full=y directory=dpdump_dir dumpfile=BOB.dmp However this gives me the following errors: UDI-12541: operation generated ORACLE error 12541 ORA-12541: TNS:listener does not currently know of service requested in connect descriptor In the listener.ora and tnsnames.ora i have EZCONNECTOR and ports 1521. Does anyone know how to get this to work? Many thanks in advance, Bob oracle import restore dump oracle12c share|improve this question edited Apr 28 '14 at 15:32 asked Apr 28 '14 at 12:15 user3292873 63 get a dba involved in this to help with your job. –ik_zelf Apr 28 '14 at 12:35 @ik_zelf I've managed to get a bit further, is this something I can fix myself or should I still contact a dba? –user3292873 Apr 28 '14 at 15:33 I don't think you need to add the server and port to the impdb command, only the SID. Try impdp BOB/password@pdbname full=y directory=dpdump_dir dumpfile=BOB.dmp –tilley31 Apr 28 '14 at 17:48 Given the questions you ask I would say, get a dba involved. dba's are used to setup infrastructures and perform backup recoveries. It woul
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
Tns No Listener Error In Oracle 11g
ORA-12541: TNS: no listener Oracle Tips ora-12541 tns no listener windows by John Garmany You Asked: I get the ORA-12541 error message when I try to connect through Forms6i and Reports6i Builder. tns-12560: tns:protocol adapter error 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 http://stackoverflow.com/questions/23340890/error-while-restoring-oracle-10g-dmp-file-in-oracle-database-12c 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. http://www.dba-oracle.com/t_ora_12541_tns_no_listener.htm 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 cr
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 https://community.oracle.com/thread/2188674 enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message https://www.experts-exchange.com/questions/27559605/export-error.html and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 14 Replies Latest reply on Mar 7, no listener 2011 6:41 PM by 839770 ORA-12541- TNS:No Listener Error 839770 Mar 7, 2011 7:59 AM Dear All, I am new to oracle and this forum. I installed Oracle 11g and Oracle forms in my system. When i Try to connect to database thru SQL* Plus, am getting error as "ORA-12541- tns no listener TNS:No Listener". Same issue when i try to connect thru Forms Builder. This is how my tnsnames.ora looks # tnsnames.ora Network Configuration File: C:\DevSuiteHome_2\network\admin\tnsnames.ora # Generated by Oracle configuration tools. EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Pradeep-PC)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = PLSExtProc) ) ) ORACLE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle) ) ) LISTENER_ORACLE = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) Kindly guide me I have the same question Show 0 Likes(0) 20437Views Tags: none (add) ora-12541Content tagged with ora-12541 This content has been marked as final. Show 14 replies 1. Re: ORA-12541- TNS:No Listener Erro
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 Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > export error Want to Advertise Here? Solved export error Posted on 2012-01-28 Oracle Database 2 Verified Solutions 11 Comments 1,187 Views Last Modified: 2012-05-12 I tried to export tables from the schema created directories datapump1 inside oracle as well as in the os.. still shows error Could you please clarifiy.. Thank you, SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 28 13:14:08 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn sunu/sunu Connected. SQL> insert into t1 values('one'); 1 row created. SQL> / 1 row created. SQL> / 1 row created. SQL> / 1 row created. SQL> select * from t1; NAME ---------- Sunu one one one one SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options [oracle@bms dbs]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 28 13:14:52 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> commit 2 ; SP2-0640: Not connected SQL> conn / as sysdba Connected. SQL> conn sunu/sunu Connected. SQL> select * from t1; NAME ---------- Sunu one one one one SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options [oracle@bms dbs]$ expdp sunu/sunu@db10 tables=t1,t2 directory=datapump Export: Release 10.2.0.1.0 - Production on Saturday, 28 January, 2012 13:16:00 Copyright (c) 2003, 2005, Oracle. All rights reserved. UDE-00008: operation generated ORACLE error 12541 ORA-12541: TNS:no listener [oracle@bms dbs]$ > dumpfile=t1_t2.dmp logfile=expdpt1_t2.log [oracle@bms dbs]$ expdp sunu/sunu@db10 tables=t1,t2 directory=datapump dumpfile=t1_t2.dmp logfile=expdpt1_t2.log Export: Release 10.2.0.1.0 - Production on Saturday, 28 January, 2012 13:19:28 Copyright (c) 2003, 2005, Oracle. All rights reserved. UDE-00008: operation generated ORACLE error 12541 ORA-12541: TNS:no listener [oracle@bms dbs]$ lsnrctl start LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-JAN-2012 13:19:42 Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting /u01/app