General
cancel
Showing results for 
Search instead for 
Did you mean: 

Some questions about installing SQL HELP system manually

Wang,MinJie
Super Advisor

Some questions about installing SQL HELP system manually

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
1 REPLY
Indira Aramandla
Honored Contributor

Re: Some questions about installing SQL HELP system manually

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
Never give up, Keep Trying