"Sql*plus help not available" resolution step

Sql*plus is the most commonly used CMD interface for Oracle management databases, where the Help system provides quick guidance and assistance in executing commands that are installed by default during Oracle installation. Sometimes this feature is lost due to some unexpected reasons, and the following error occurs when using the Help system:

sp2-0171: The Help system is not available.

So that it brings a lot of inconvenience and trouble. Here's how to fix this, and also the official recommended method step, which is available in the Oracle Help documentation, which is just for the relevant environment practice, to provide you with a convenient.

To practice Oracle version information:

Sql> select * from V$version;

BANNER

-------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-production

PL/SQL Release 11.1.0.6.0-production

CORE 11.1.0.6.0 Production

TNS for 32-bit windows:version 11.1.0.6.0-production

Nlsrtl Version 11.1.0.6.0–production

Log in to the system account for help situation:

Sql> Conn System

Enter Password:

is connected.

Sql> Help

sp2-0171: The Help system is not available.

Here are the steps to rebuild the Help system:

1. Execute the $oracle_home/sqlplus/admin/help/hlpbld.sql script to create a table pattern for help content.

Sql> @e:\app\administrator\product\11.1.0\db_1\sqlplus\admin\help\hlpbld.sql

2, execute $oracle_home/sqlplus/admin/help/helpus.sql script, autofill Help content

Sql> @e:\app\administrator\product\11.1.0\db_1\sqlplus\admin\help\helpus.sql

3, check Help, then sql*plus, the aid system is available

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]

The Help assistance system is actually querying a support table for System account maintenance, and if we open the Hlpbld.sql script for a closer look, we can find its samadhi, such as the following table help mode definition extract Hepbld.sql script:

CREATE TABLE Help

(

TOPIC VARCHAR2 () not NULL,

SEQ number is not NULL,

INFO VARCHAR2 (80)

) PCTFREE 0 STORAGE (INITIAL 48K pctincrease 0);

The Helpus.sql script is an insert for the content of the Help table, and the following is both its inserted content (intercept part):

INSERT into Help VALUES (' @ ', 1, NULL);

INSERT into Help VALUES (' @ ', 2, ' @ ' ("@ ') ');

INSERT into Help VALUES (' @ ', 3, '-------------');

INSERT into Help VALUES (' @ ', 4, ' Runs the sql*plus statements in the specified script. The script can be ');

INSERT into Help VALUES (' @ ', 5, ' called from the local file system or a Web server. ');

INSERT into Help VALUES (' @ ', 6, NULL);

INSERT into Help VALUES (' @ ', 7, ' @ {Url|file_name[.ext]} [arg ...] ');

INSERT into Help VALUES (' @ ', 8, NULL);

INSERT into Help VALUES (' @ ', 9, ' where URL supports HTTP and FTP protocols in the form: ');

INSERT into Help VALUES (' @ ', Max, NULL);

INSERT into Help VALUES (' @ ', one, ' http://host.domain/script.sql ');

INSERT into Help VALUES (' @ ', n, NULL);

INSERT into Help VALUES (' @@ ', 1, NULL);

......

Logging in with the System account can also query its Help table definition:

Sql> Conn System

Enter Password:

is connected.

Sql> desc Help

is the name empty? Type

----------------------------------------- -------- -------------------------

TOPIC not NULL VARCHAR2 (50)

SEQ not NULL number

INFO VARCHAR2 (80)

You can also verify the definition of the Help table, which is exactly what helps the system.

Ok,sql*plus's Help system is a solution to the problem, and detailed exploration of its Oracle documentation and scripts can be used to further explore Oracle's content.

"Sql*plus help not available" resolution step