环境:
    OS: Linux8.0          DB: Oracle8.1.7现状:
    初始安装时没有安装Java支持,现在想加上,有什么办法吗?查询v$option后的结果如下:SQL> set pagesize 100
SQL> Select * from v$option;PARAMETER                                                        VALUE
---------------------------------------------------------------- ---------
Partitioning                                                     TRUE
Objects                                                          TRUE
Parallel Server                                                  FALSE
Advanced replication                                             TRUE
Bit-mapped indexes                                               TRUE
Connection multiplexing                                          TRUE
Connection pooling                                               TRUE
Database queuing                                                 TRUE
Incremental backup and recovery                                  TRUE
Instead-of triggers                                              TRUE
Parallel backup and recovery                                     TRUE
Parallel execution                                               TRUE
Parallel load                                                    TRUE
Point-in-time tablespace recovery                                TRUE
Fine-grained access control                                      TRUE
N-Tier authentication/authorization                              TRUE
Function-based indexes                                           TRUE
Plan Stability                                                   TRUE
Online Index Build                                               TRUE
Coalesce Index                                                   TRUE
Managed Standby                                                  TRUE
Materialized view rewrite                                        TRUE
Materialized view warehouse refresh                              TRUE
Database resource manager                                        TRUE
Spatial                                                          TRUE
Visual Information Retrieval                                     TRUE
Export transportable tablespaces                                 TRUE
Transparent Application Failover                                 TRUE
Fast-Start Fault Recovery                                        TRUE
Sample Scan                                                      TRUE
Duplexed backups                                                 TRUE
Java                                                             FALSE
OLAP Window Functions                                            TRUE33 rows selected.

解决方案 »

  1.   

    以上结果中,Java选项的值为FALSE。
      

  2.   

    用ORACLE安装盘添加安装这些项目。
      

  3.   

    使用OUI(Oracle Universal Installer)时,看到先前已经安装上Java Products了,只是现在用不了。
    我的服务器因不慎误删一数据文件,导致按原来的SID不能启动了;后来重新创建数据库,得到一个新的SID,在新的库中使用不了dbms_java包。
    同样的Java Stored Procedure在基于Windows系统的Oracle8.1.7上安装完全成功,而在Linux上现在却用不了。
    如果没有办法,是不是只能重装了?向大师们求救呵。
      

  4.   

    我的发布环境是Linux环境呵!