Imp-00058 Oracle Error 12514 Encountered
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 Us Learn more imp-00058: oracle error 12154 encountered about Stack Overflow the company Business Learn more about hiring developers or posting ads imp-00058 imp-00000 import terminated unsuccessfully with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack oracle error 12154 encountered import Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle's imp.exe problems over tunneled connection up vote 0 down vote favorite
Imp-00058 Oracle Error 12560 Encountered
We have an Oracle server running in a remote server which only has an SSH connection and we need to run data import process against that. I tried different SSH tunnel combinations: 127.0.0.1:1521 127.0.0.1:1522 127.0.0.1:11111 127.0.0.107:1522 127.0.0.107:11111 But none of them work with imp.exe. Intresting thing that all those combinations works just fine with SQL Developer and Scriptella scripts that use JDBC. The following error is shown in standard imp-00058 oracle error 12154 encountered 11g error output: IMP-00058: ORACLE error 12514 encountered ORA-12514: TNS:listener does not currently know of service requested in connect descriptor IMP-00000: Import terminated unsuccessfully And the following appears in the sqlnet.log: *********************************************************************** Fatal NI connect error 12514, connecting to: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=tktdb1)(CID=(PROGRAM=C:\oraclexe\app\oracle\product\10.2.0\server\bin\imp.exe)(HOST=...)(USER=...)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=11111))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 07-MAR-2011 10:53:26 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Any ideas? sql oracle import ora-12514 share|improve this question edited Apr 9 '11 at 17:08 OMG Ponies 199k37356416 asked Mar 7 '11 at 10:04 Andrey Adamovich 12.2k1063107 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote accepted I asume that the connect strings are correct. If they are: does you database happen to be in restricted mode? In that case, the service it supports are not available for connections. If that is the case, try connecting with a tns alias using SID=xxx I fail to see what ssh has for impact here. The database connection is working. ssh only pl
off, listening and services are open with, but they can not successfully import the database. Error IMP-00058: ORACLE error 12514 encounteredORA-12514: TNS: listener does imp 00058 oracle error 1034 encountered not recognize the connection descriptor requested service IMP-00000: Import terminated unsuccessfully
Imp 00058 Ora 12154
With pl / sql login, also error: ORA-12514 TNS: listener does not recognize the connection descriptor requested
Imp 00058 Oracle Error 1950 Encountered
service Execute lsnrctl status after Tip: ........... listener does not support command is executed successfully If you need to see all the results lsnrctl status, I can Tieshanglai. http://stackoverflow.com/questions/5218270/oracles-imp-exe-problems-over-tunneled-connection Reply: Put your listener.ora Reply: oracle_home / product \ 11.2.0 \ dbhome_1 \ network \ admin Reply: Look there is no connection string 202.31.105.112/dataLms this configuration errors. tnsping 202.31.105.112/dataLms this look can ping. Reply: # Listener.ora Network Configuration File: E: \ app \ 11111 \ product \ 11.1.0 \ db_1 \ network \ admin \ listener.ora # http://oracle.veryoo.com/2013/09/orcale-import-database-imp-00058-oracle.html Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = 11111-PC) (PORT = 1521)) ) ) Reply: You can fight through tnsping 202.31.105.112/dataLms Reply: Preferably also labeled tnsnames.ora, "execute lsnrctl status after Tip: ........... listener does not support service, the command executed successfully" connect descriptor 202.31.105.112/dataLms described in Example the program is not registered with the listener. Reply: Instance is not registered with the listener program, it is up to how to do it Reply: Looked tnsnames.ora, none of which I want to turn on this database, is how ah Reply: You put your content inside tnsnames.ora stickers out first. . . Do not you want to import database information, which will be incorrect Posted by ou at 1:16 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search Loading... Popular Posts opatch: command not found oracle11g a
Mon, 22 August 2005 10:55 Philbzh Messages: 3Registered: August 2005 Junior Member When I try to import a file to a 10g database, I have this error message (see at http://www.orafaq.com/forum/t/50716/0/ the bottom). Anybody knows what it is ? I'm using Windows 2000 et a 10g Client. Thanks, Phil. D:\Oracle\product\10.2.0\client_1\BIN>imp Import: Release 10.2.0.1.0 - Production on Mon Aug 22 17:37:05 2005 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: euro@prod Password: IMP-00058: ORACLE error 6550 encountered ORA-06550: line 1, column 33: PLS-00302: component 'SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored IMP-00000: oracle error Import terminated unsuccessfully Report message to a moderator Re: Problem to import a file [message #134503 is a reply to message #133887] Thu, 25 August 2005 05:16 girish.rohini Messages: 744Registered: April 2005 Location: Delhi (India) Senior Member It appears that you have a permissions problem with the user that is running the imp. command. Please check for its permissions (roles/priveleges). Regds Girish 00058 oracle error Report message to a moderator Re: Problem to import a file [message #134588 is a reply to message #134503] Thu, 25 August 2005 12:30 Philbzh Messages: 3Registered: August 2005 Junior Member I don't think so because when I'm connect by "sys as sysdba", I have the same problem. Have you got another idea ? Thanks, B.R. Report message to a moderator Re: Problem to import a file [message #135830 is a reply to message #133887] Fri, 02 September 2005 14:42 felipedangelo Messages: 1Registered: September 2005 Junior Member I had problem the same. How he obtained to decide? please it helps me! Thanks. Report message to a moderator Re: Problem to import a file [message #136461 is a reply to message #135830] Thu, 08 September 2005 02:38 Wieldop Messages: 1Registered: September 2005 Junior Member I had the same problem. I was using the imp.exe from the 10.2.0 release (like you did) while the database in which I wanted to import the dump was in fact 10.1.0. So, stick to the imp.exe of 10.1.0 and everthing would be fine. Report message to a moderator R