Install and remove Help in Sqlplus

Help is not in sqlplus after the manual build, and the following records how to install and delete the help command in Sqlplus.

Note: The Sqlplus help command is available only when the database is open. Non-open state use help also error: Sp2-0171:help system not available.

The experiment is as follows: Note: The ORACLE 11.2.0.4 Environment Experiment SYSDBA and the ordinary DBA can, but also have the claim is to use System user.

1. Use Help to error: Sp2-0171:help system not available.

sys@ Bys3>help

Sp2-0171:help system not available.

sys@ bys3>?

Sp2-0171:help system not available.

##################################################

2. Run the appropriate script under $oracle_home/sqlplus/admin/help

[Oracle@bys3 help]$ ls

Helpbld.sql Helpdrop.sql Helpus.sql Hlpbld.sql

The order in which the Help scripts for installing Sqlplus are run:

Run the Helpbld.sql script first

The first prompt to enter the variable name: in Enter value for 1: Enter the absolute path where the/hlpbld.sql script is located, this is/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/ help/Carriage return

The second prompts for the variable name: Enter value for 2: Enter the absolute path of the Helpus.sql, this is/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/help/ Helpus.sql

Observe the Helpus.sql script content, you can find inside the statement is to System.help table inserted data. Therefore , it is speculated that a user who has created table permissions under the system user can successfully execute this script (it is presumed that SYSDBA and ordinary DBA users can, in 11.2.0.4 environments, experiment sysdba and ordinary DBAs).

As follows: @ Indicates the run script,? Represents the Oracel_home variable

sys@ Bys3>@?/sqlplus/admin/help/helpbld.sql

Enter value for 1:/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/help/

Enter value for 2:/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/help/helpus.sql

##################################################

3. When you enter Sqlplus, you can use Help:

sys@ Bys3>help

Help

----

Accesses this command line Help system. Enter help INDEX or? INDEX

For a list of topics.

You can view Sql*plus

http://www.oracle.com/technology/documentation/

Help|? [Topic]

##################################################

4. Delete Sqlplus Help-run $oracle_home/sqlplus/admin/help under Helpdrop.sql

sys@ Bys3>help

Help

----

Accesses this command line Help system. Enter help INDEX or? INDEX

For a list of topics.

You can view Sql*plus

http://www.oracle.com/technology/documentation/

Help|? [Topic]

To run the delete script:

sys@ Bys3>@?/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

sys@ Bys3>help

Sp2-0171:help system not available.

sys@ bys3>?

Sp2-0171:help system not available.

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/