熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

“ORACLE

2022-06-13   來源: Oracle 

  今天有時間對ORACLE_HOME環境變量進行了如下測試

  [oracle@linux ~]$ export ORACLE_HOME=/u/app/oracle//product//db_

  [oracle@linux ~]$ sqlplus / as sysdba

  SQL*Plus: Release Production on Mon Jun ::

  Copyright (c) Oracle  All Rights Reserved

  Connected to an idle instance

  SQL> Disconnected

  [oracle@linux ~]$ export ORACLE_HOME=//u/app/oracle/product//db_

  [oracle@linux ~]$ sqlplus / as sysdba

  SQL*Plus: Release Production on Mon Jun ::

  Copyright (c) Oracle  All Rights Reserved

  Connected to an idle instance

  SQL> Disconnected

  [oracle@linux ~]$ export ORACLE_HOME=/u/app/oracle/product//db_/

  [oracle@linux ~]$ sqlplus / as sysdba

  SQL*Plus: Release Production on Mon Jun ::

  Copyright (c) Oracle  All Rights Reserved

  Connected to an idle instance

  SQL> Disconnected

  [oracle@linux ~]$ export ORACLE_HOME=/u/app/oracle/product//db_

  [oracle@linux ~]$ sqlplus / as sysdba

  SQL*Plus: Release Production on Mon Jun ::

  Copyright (c) Oracle  All Rights Reserved

  Connected to:

  Oracle Database g Enterprise Edition Release Production

  With the Partitioning and Data Mining options

  SQL>

  測試結果顯示ORACLE_HOME環境變量中對/符號要求嚴格不能在該字符串變量的值中出現多余/符號(雖然這樣寫在linux下是合法的)否則可能引起連接數據庫異常對於初學者需要提高警惕


From:http://tw.wingwit.com/Article/program/Oracle/201311/16813.html
    推薦文章
    Copyright © 2005-2022 電腦知識網 Computer Knowledge   All rights reserved.