Windows-7

SP2-0750:您可能需要設置 ORACLE_HOME

  • August 22, 2013

當我sqlplus在命令提示符下書寫時收到以下錯誤消息

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

以下是路徑詳情

在此處輸入圖像描述

在此處輸入圖像描述

在此處輸入圖像描述

網路配置幫助也不起作用。它沒有從 Program Files 啟動,直接訪問時會出現以下錯誤

C:\Oracle\product\11.1.0\db_1\BIN>netca.bat
java.lang.UnsatisfiedLinkError: Can't load library: C:/Oracle/product/11.1.0/db_
1;/oui/lib/win32/oraInstaller.dll
       at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1650)
       at java.lang.Runtime.load0(Runtime.java:769)
       at java.lang.System.load(System.java:968)
       at oracle.sysman.oii.oiip.osd.win32.OiipwWin32NativeCalls.loadNativeLib(
OiipwWin32NativeCalls.java:1491)
       at oracle.sysman.oii.oiip.osd.win32.OiipwWin32NativeCalls.<clinit>(Oiipw
Win32NativeCalls.java:47)
       at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.getEnv(OiipgEnvironment
.java:210)
       at oracle.sysman.oii.oiip.oiipg.OiipgPropertyLoader.initUnixPtrFileLoc(O
iipgPropertyLoader.java:213)
       at oracle.sysman.oii.oiip.oiipg.OiipgPropertyLoader.<clinit>(OiipgProper
tyLoader.java:126)
       at oracle.sysman.oii.oiic.OiicStandardInventorySession.updateProperties(
OiicStandardInventorySession.java:461)
       at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicS
tandardInventorySession.java:257)
       at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicS
tandardInventorySession.java:231)
       at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicS
tandardInventorySession.java:180)
       at oracle.net.ca.NetCA.getHomeInfo(Unknown Source)
       at oracle.net.ca.NetCA.main(Unknown Source)


java.lang.UnsatisfiedLinkError: no oraInstaller in java.library.path
       at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682)
       at java.lang.Runtime.loadLibrary0(Runtime.java:822)
       at java.lang.System.loadLibrary(System.java:993)
       at oracle.sysman.oii.oiip.osd.win32.OiipwWin32NativeCalls.loadNativeLib(
OiipwWin32NativeCalls.java:1514)
       at oracle.sysman.oii.oiip.osd.win32.OiipwWin32NativeCalls.<clinit>(Oiipw
Win32NativeCalls.java:47)
       at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.getEnv(OiipgEnvironment
.java:210)
       at oracle.sysman.oii.oiip.oiipg.OiipgPropertyLoader.initUnixPtrFileLoc(O
iipgPropertyLoader.java:213)
       at oracle.sysman.oii.oiip.oiipg.OiipgPropertyLoader.<clinit>(OiipgProper
tyLoader.java:126)
       at oracle.sysman.oii.oiic.OiicStandardInventorySession.updateProperties(
OiicStandardInventorySession.java:461)
       at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicS
tandardInventorySession.java:257)
       at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicS
tandardInventorySession.java:231)
       at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicS
tandardInventorySession.java:180)
       at oracle.net.ca.NetCA.getHomeInfo(Unknown Source)
       at oracle.net.ca.NetCA.main(Unknown Source)
Oracle Net Services configuration failed.  The exit code is -1

解決了,因為我嘗試了各種解決方案,所以我不記得了,但我認為通過以下兩件事解決了

1-ORACLE_HOME路徑後不應包含任何內容,即 no \, ;,,

2-我添加了一個LANG以值命名的環境變數American_America.we8iso8859p15

引用自:https://serverfault.com/questions/529261