oracle help报错SP2-0171: HELP system not available. 安装help

本文主要是介绍oracle help报错SP2-0171: HELP system not available. 安装help，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

SQL>help

SP2-0171: HELP system not available.

手工建库的情况下SQL*Plus的help手册并没有被安装，需要手动安装。

首先确认有下面几个脚本

[oracle@orale help]$ cd $ORACLE_HOME/sqlplus/admin/help/

[oracle@orale help]$ pwd

/u01/app/oracle/product/11.2.0/sqlplus/admin/help
[oracle@orale help]$ ls
helpbld.sql helpdrop.sql helpus.sql hlpbld.sql

使用system用户登录不要使用as sysdba

[oracle@orale help]$sqlplus system/oracle
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 28 10:49:36 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

执行下面语句就OK啦

SQL>@?/sqlplus/admin/help/helpbld.sql
Enter value for 1: /u01/app/oracle/product/11.2.0/sqlplus/admin/help
Enter value for 2: /u01/app/oracle/product/11.2.0/sqlplus/admin/help/helpus.sql

PL/SQL procedure successfully completed.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

OK安装完成登录sqlplus 执行help

SQL> help
HELP
----
Accesses this command line help system. Enter HELP INDEX or ? INDEX
for a list of topics.
You can view SQL*Plus resources at
http://www.oracle.com/technology/tech/sql_plus/
and the Oracle Database Library at
http://www.oracle.com/technology/documentation/
HELP|? [topic]

到这就可以正常使用啦.

删除help:

SQL> @?/sqlplus/admin/help/helpdrop.sql
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@bys3 help]$ sqlplus / as sysdba
SYS@ bys3>select status from v$instance;
STATUS
------------
OPEN
SQL> help
SP2-0171: HELP system not available.
SYS@ bys3>?
SP2-0171: HELP system not available.