lmt_setup.sh fails with errors: "ORA-01031: insufficient privileges" and "SP2-0157: unable to CON (4330116)

When running lmt_setup.sh as root, it may fail with the errors "ORA-01031: insufficient privileges" and "SP2-0157: unable to CONNECT to ORACLE after 3 attempts" as the following session shows:

irvsupu16 # id
uid=0(root) gid=1(other)
irvsupu16 # pwd
/u01/sha52/prod/bin
irvsupu16 # ./lmt_setup.sh
This script creates a view exposing SYS.X$KTFBUE and grants select
privilege on this view to the SharePlex Oracle user. An Oracle logon
with SYSDBA role is required to perform these steps.

Enter database ORACLE_SID:[quest10g]

Enter ORACLE_HOME:[/u00/oracle/product/10g]

Enter username for an Oracle logon with SYSDBA privilege:
system
Enter password for system:
Enter username for SharePlex Oracle logon:
sha52

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Aug 22 09:50:40 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter user-name: ERROR:
ORA-01031: insufficient privileges


Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Script needs to be run by user who is a part of spadmin group.

The script should be run as a user who is a part of spadmin group for the run to be successful, as the following session shows (here we su to oracle which is a part of spadmin group):

irvsupu16 # su oracle
irvsupu16 # ./lmt_setup.sh
This script creates a view exposing SYS.X$KTFBUE and grants select
privilege on this view to the SharePlex Oracle user. An Oracle logon
with SYSDBA role is required to perform these steps.

Enter database ORACLE_SID:[quest10g]

Enter ORACLE_HOME:[/u00/oracle/product/10g]

Enter username for an Oracle logon with SYSDBA privilege:
sha52
Enter password for sha52:
Enter username for SharePlex Oracle logon:
sha52

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Aug 22 09:54:47 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter user-name:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> CREATE OR REPLACE VIEW SYS.SHAREPLEX_KTFBUE AS SELECT * FROM SYS.X$KTFBUE;

View created.

SQL> GRANT SELECT ON SYS.SHAREPLEX_KTFBUE TO sha52;

Grant succeeded.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64
bit Production
With the Partitioning, OLAP and Data Mining options