您当前位置:设计在线网 >> Oracle >> 浏览文章

ORACLE_HOME环境变量设置应用讲解

分享到:
本文章讲述了ORACLE_HOME环境变量设置应用讲解.

今天有

时间对“ORACLE_HOME”环境变量进行了如下测试:

[[email protected] ~]$ export ORACLE_HOME=/u01/app/oracle//product/10.2/db_1

[[email protected] ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Jun 1 13:13:07 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> Disconnected

[[email protected] ~]$ export ORACLE_HOME=//u01/app/oracle/product/10.2/db_1

[[email protected] ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Jun 1 13:13:18 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> Disconnected

[[email protected] ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2/db_1/

[[email protected] ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Jun 1 13:13:31 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> Disconnected

[[email protected] ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2/db_1

[[email protected] ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Jun 1 13:13:42 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning and Data Mining options

SQL>

测试结果显示,ORACLE_HOME环境变量中对“/”符号要求严格,不能在该字符串变量的值中出现多余“/”符号(虽然这样写在linux下是合法的),否则可能引起连接数据库异常。对于初学者需要提高警惕。

相关编辑:

简单介绍ORACLE查询执行的历史记录

推荐阅读:
软硬结合为应用带来高性能引擎介绍
有关Oracle数据库优化方式解析
oracle数据库树形结构实行查询

相关文章:

推荐文章  
赞助商链接  
热门排行  
主题推广  
中国设计在线网 All Rights Reserved. 互联网违法和不良信息举报
信息产业部备案号:湘ICP备09001063号