-bash：小鬼：找不到命令神谕 [英] -bash: imp: command not found oracle

问题描述

我有一个的CentOS Linux的机和 Oracle服务器安装位于远程位置的服务器上

I have a centos Linux machine and a oracle server installed on a server which is located at a remote location.

我已经安装了 Oracle客户端使用链接我的Linux CentOS的机器上：

I have installed oracle client on my Linux centos machine using the link :

如何安装在Linux SQL * Plus客户端

How to install SQL * PLUS client in linux

可以注意到，虽然安装客户端没有 /网络/系统管理员目录中，因此没有的tnsnames.ora 文件。我现在已经手工创建的目录中，并创建了一个tnsnames.ora文件。我能够连接到远程服务器。

It may be noted that while installing client there was no /network/admin directory and hence no tnsnames.ora file. now I have manually created the directories and have have created a tnsnames.ora file. I am able to connect to remote server.

现在，当我看着bin文件夹中我得到的只有三个exe文件

Now when I look into the bin folder I get just three exe

 adrci  genezi  sqlplus.

我无法找到的小鬼。

I cant find the imp.

因此​​，当我尝试导入从CentOS的甲骨文转储文件，我得到的错误：

Hence when I try to import the dump file from centos to oracle , I get the error:

-bash: imp: command not found

我使用以下命令来导入Oracle服务器上转储：

I am using the following command to import dump on oracle server:

imp 'rdsuser@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=oracledbrds.cwuabchlhlu.us-east-2.rds.amazonaws.com)(Port=1521))(CONNECT_DAT                                                                                        A(SID=oracledb)))'

请帮助

推荐答案

即时客户端不包括许多从完整的客户端工具，包括小鬼 / EXP ，其较新的数据泵现金等价物，使用SQL * Loader等​​的查看即时客户常见问题解答，突出它在很大程度上是与自己的应用程序分配，但可以incude的SQL * Plus - 中提到的唯一工具。

The instant client does not include many of the tools from the full client, including imp/exp, their newer data pump equivalents, SQL*Loader etc. See the instant client FAQ, which highlights that it's largely for distribution with your own applications, but can incude SQL*Plus - the only tool mentioned.

如果你需要使用导出/导入或其他任何工具，则需要安装完整的客户端或服务器上运行它们;这可能是与AWS一个问题。 亚马逊对数据导入到Oracle 文章

If you need to use export/import or any other tools then you will need to install the full client, or run them on the server; which might be an issue with AWS. Amazon have an article on importing data into Oracle.

顺便说一句，你可以把你的的tnsnames.ora 文件中，只要任何地方，您设置 TNS_ADMIN 来指向的位置，但你是不是指它在你的小鬼命令反正 - 你指定的所有连接数据。如果您知道服务的名称，这可能是对SID不同（你可以在服务器上运行 LSNRCTL服务来找到合适的值），你可以使用易连接语法：

Incidentally, you can put your tnsnames.ora file anywhere as long as you set TNS_ADMIN to point to that location, but you aren't referring to it in your imp command anyway - you're specifying all the connection data. If you know the service name, which may be different to the SID (you can run lsnrctl services on the server to find the right value) you can use the 'easy connect' syntax:

sqlplus rdsuser@//oracledbrds.cwuabchlhlu.us-east-2.rds.amazonaws.com:1521/your_service_name

这篇关于-bash：小鬼：找不到命令神谕的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！