Some questions about installing SQL HELP system manually

Wang,MinJie — Tue, 27 Jun 2006 01:47:28 GMT

Hey I have to install "Sql help system" manually and when I ran "helpins" it prompted me the following information:
"SYSTEM_PASS environment variable not set.
Installing HELP into the SYSTEM schema
Enter SYSTEM passwd"
and I first input root's passwd and then user oracle's passwd and my oracle sysdba "sys"'s passwd and all of them are no use
who can help me
thanks in advance

Re: Some questions about installing SQL HELP system manually

Indira Aramandla — Tue, 27 Jun 2006 20:10:22 GMT

Hi Wang,

To install HELP tables do the following:

1. Login as the oracle UNIX user

2. Set the environment variable SYSTEM_PASS to system/

% setenv SYSTEM_PASS system/

3. Run the script "helpins"

% cd /tmp (or any directory where you have "write" permissions)
% $ORACLE_HOME/bin/helpins

To install THE HELP TABLES USING THE INSTALLER

1. Set your ORACLE_SID to the database that is missing the SQL*Plus help facility

2. Invoke the Installer:

% cd $ORACLE_HOME/orainst
% ./orainst

3. Answer the installer prompts as follows:

Choose the 'Create new database objects' option for all products

Enter name of existing SID where you want to install the help facility.

Choose no products during the online documentation questions.

At the 'Available Products' screen, choose only:
sqlplus -> install

Indira A

topic Re: Some questions about installing SQL HELP system manually in Operating System - HP-UX

Some questions about installing SQL HELP system manually

Re: Some questions about installing SQL HELP system manually