Oracle 客户端安装错误 - 路径太长
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/12089655/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle client installation error - path too long
提问by kamal
I'm trying to install Oracle 11g Release 2 (client). But it gives an error like that :
我正在尝试安装 Oracle 11g 第 2 版(客户端)。但它给出了这样的错误:
Environment variable: "PATH" - This test checks whether the length of the
environment variable "PATH" does not exceed the recommended length.
Expected Value:?1023
Actual Value?:?1028
List of errors: -?PRVF-3929 : Adding the Oracle binary location to the PATH
environment variable will exceed the OS length limit of [ "1023" ] for the
variable on the node "KamalNuriyev-PC" ?-
Cause:? The installer needs to update the PATH environment variable to
include the value "%ORACLE_HOME%/bin;". However, doing so will
cause PATH to exceed the maximum allowable length that this
operating system allows. ?- Action:? Ensure that the sum of the
lengths of your current PATH environment variable and that of
"%ORACLE_HOME%/bin;" does not exceed the operating system limit.
Restart the installer after correcting the setting for
environment variable.
采纳答案by Dimitri Dewaele
This limitation is based on older Windows restrictions,where length of environmental variables was important. This limitation is still there in the Oracle installation.
此限制基于较旧的 Windows 限制,其中环境变量的长度很重要。此限制在 Oracle 安装中仍然存在。
Work around this:
解决这个问题:
- Step 1: Copy the value of your 'path' variable to a text-editor (Ex.: notepad) and save this value as backup.
- Step 2: Reduce the size of this pathto less that 1023 characters. Remove path variables at the end. You will mostly not need any of them during the oracle installation. Keep those removed values in a separate text-file, because you need to add them again later!
- Step 3: Start the oracle installationagain.
- Step 4: After Oracle installation: Add those removed path values againat the end of the path.
- 步骤 1:将“路径”变量的值复制到文本编辑器(例如:记事本)并将此值保存为备份。
- 步骤 2:将此路径的大小减少到 1023 个字符以下。最后删除路径变量。在 oracle 安装过程中,您通常不需要它们中的任何一个。将这些删除的值保存在单独的文本文件中,因为您稍后需要再次添加它们!
- 第三步:再次启动oracle安装。
- 步骤 4:Oracle 安装后:在路径末尾再次添加那些删除的路径值。
Good luck!
祝你好运!
回答by 4u.Ans
For those who are facing this issue, solution would be to look into your Environment Variable "PATH" and bring it to shorter in length by removing unnecessary paths / repeating paths as suggested by Bob Javis in his comment. Thanks to him.
对于那些面临此问题的人,解决方案是查看您的环境变量“PATH”,并按照 Bob Javis 在评论中的建议,通过删除不必要的路径/重复路径来缩短它的长度。感谢他。
I had the similar issues and got it resolved by doing so.
我遇到了类似的问题,并通过这样做得到了解决。
To Edit ENV Variable on Windows 7:Start -> Computer -> Properties -> Advanced System Settings -> On "System properties" window, select "Advanced" tab - > Click on "Environment Variable" -> Scroll down to see the PATH variable and click on "Edit" to edit accordingly and Click "OK" to save
要在 Windows 7 上编辑 ENV 变量:开始 -> 计算机 -> 属性 -> 高级系统设置 -> 在“系统属性”窗口中,选择“高级”选项卡 -> 单击“环境变量”-> 向下滚动以查看 PATH变量并单击“编辑”进行相应编辑,然后单击“确定”保存
Hope someone might get helped :)
希望有人能得到帮助:)
回答by Abhijeet
You could check on the ignore all check box on top right and that should enable the next button to continue further.
您可以选中右上角的忽略所有复选框,这将使下一步按钮继续。
回答by ahasbini
One way of fixing this is to go to stage\cvu
in the installer directory and edit cvu_prereq.xml
, replace all values(there are multiple ones) containing 1023 with a larger number and then try to install it again.
解决此问题的一种方法是转到stage\cvu
安装程序目录并编辑cvu_prereq.xml
,将包含 1023 的所有值(有多个)替换为更大的数字,然后再次尝试安装。
Might need to do this after running the installer but before the installer does the check on the different requirements like the PATH length.
可能需要在运行安装程序之后执行此操作,但在安装程序检查不同要求(如 PATH 长度)之前执行此操作。
回答by pamalac
After trying with all I found this in the Oracle wiki:
在尝试了所有之后,我在 Oracle wiki 中找到了这个:
What it says is that you should reduced your string's path changing the "C:\Program Files (x86)" to "C:\PROGRA~2"
它说的是您应该减少字符串的路径,将“C:\Program Files (x86)”更改为“C:\PROGRA~2”
Be sure to make a backup of the original path.
请务必备份原始路径。
回答by akashfugtu
Simple,
简单的,
Check path size, if unnecessary things are there removing that, if not, save it as it is. And restart oracle installation process.
检查路径大小,如果有不必要的东西,请删除它,如果没有,请按原样保存。并重启oracle安装过程。
http://hashtutorial.com/plsql-tutorial/plsql-environment-setup/
http://hashtutorial.com/plsql-tutorial/plsql-environment-setup/
回答by Sergey
Simple solution:
简单的解决方案:
- Rename your current PATH variable to PATH2
- Then add a new PATH = %PATH2%
- Continue with the installation
- 将当前的 PATH 变量重命名为 PATH2
- 然后添加一个新的 PATH = %PATH2%
- 继续安装
回答by Saptarshi
But, if you don't have unnecessary paths / repeating paths and you can't shorten it(beware! if you delete some necessary paths it can affect corresponding services!), go by removing some paths before oracle installation and return them after the installation.
但是,如果你没有不必要的路径/重复路径并且你不能缩短它(注意!如果你删除一些必要的路径会影响相应的服务!),在oracle安装之前删除一些路径并在之后返回它们安装。
Or, you can manually ADD the oracle path string in the system PATH variable(add it at the start of the string, not at the end) for your oracle installation. As example, if you're installing Oracle 11g R2 in the path "c:\ora" then typically the path string for this will be, C:\ora\product\11.2.0\dbhome\BIN -for server and C:\ora\product\11.2.0\client_1\BIN -for client. :)
或者,您可以在系统 PATH 变量中手动添加 oracle 路径字符串(将其添加到字符串的开头,而不是末尾)以用于您的 oracle 安装。例如,如果您在路径“c:\ora”中安装 Oracle 11g R2,那么通常的路径字符串将为 C:\ora\product\11.2.0\dbhome\BIN - 用于服务器和 C: \ora\product\11.2.0\client_1\BIN - 用于客户端。:)
回答by David G
I used two approaches to shorten my PATH environmental variable:
我使用了两种方法来缩短我的 PATH 环境变量:
1) Use other environment variables, e.g.: %CommonProgramFiles(x86)% for "C:\Program Files (x86)\Common Files" %ProgramFiles(x86)% for "C:\Program Files (x86)"
1) 使用其他环境变量,例如: %CommonProgramFiles(x86)% for "C:\Program Files (x86)\Common Files" %ProgramFiles(x86)% for "C:\Program Files (x86)"
2) Use 8 character DOS path names, e.g.: MICROS~4 for "Microsoft SQL Server" * Your system may have a different number, in a CMD window, browse to the parent folder and type "dir /ad /x"
2) 使用 8 个字符的 DOS 路径名,例如:MICROS~4 代表“Microsoft SQL Server” * 您的系统可能有不同的编号,在 CMD 窗口中,浏览到父文件夹并键入“dir /ad /x”
"%ProgramFiles(x86)%\Micros~4\140\DTS\Binn" is 15 characters shorter than "C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn"
"%ProgramFiles(x86)%\Micros~4\140\DTS\Binn" 比 "C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn" 短 15 个字符
I shrank the total length of the PATH from 1120 to 890. Then I could install the Oracle client without a problem.
我将 PATH 的总长度从 1120 缩小到 890。然后我可以毫无问题地安装 Oracle 客户端。
回答by Brandon Hawbaker
In my case, I couldn't install an 11.2.0.4 32 bit client or the 12.2.0.1 64 bit client also, due to this error. After much investigation, I discovered there appears to be a bug when installing it on Windows 10 Enterprise 1703 as hinted at by this issue:
就我而言,由于此错误,我也无法安装 11.2.0.4 32 位客户端或 12.2.0.1 64 位客户端。经过大量调查,我发现在 Windows 10 Enterprise 1703 上安装它时似乎存在一个错误,正如此问题所暗示的那样:
In my case, as I was using automation to install this, I ended up recreating my virtual machine as Windows 10 Enterprise LTSC and no longer have this error. In my case, it had nothing to do with the actual path as I had shortened to the point where barely anything was left and it was not enough to resolve the issue.
就我而言,当我使用自动化来安装它时,我最终将我的虚拟机重新创建为 Windows 10 Enterprise LTSC,并且不再出现此错误。就我而言,它与实际路径无关,因为我已经缩短到几乎没有任何东西剩下并且不足以解决问题的地步。