[SOLVED] ORA-01031: insufficient priviledges while running @create_glog_users.sql

Hey,

As a green horn trying to set up the whole OTM 5.5.1 environment by
myself. I need your help!! Thanks Alan for pointing out to me that I
need to configure the OTM database first before starting the OTM
application server, the Admin guide made it look like you only need to
do that if you are going to install OTM on the 10g database server. So
that's why I skip the whole process naively thinking the OTM install
would create the database first.

Anyway I tried to connect to the Oracle 10.2.0.2.0 database server from
my client installed on the OTM 5.5.1 server using *SYS user* (as SYSDBA)
after updating the init.ora file on the server by adding

/O7_DICTIONARY_ACCESSIBILITY = true
Open_cursors = 200 (or greater)

/and restart the database server.

Then I ran the create_gc3_tablespaces script, create_glog_roles script,
and finally at create_glog_users script, I got the infamous ORA-01031:
insufficient priviledges error while trying to:

*" grant execute on dbms_aqin to glogdba".*

It also failed at

*"grant execute on dbms_rls to glogowner"
"grant execute on dbms_aqin to glogowner"
"grant execute on dbms_pipe to glogowner"*

The other GRANT all succeeded.

Why the above four "Grant Execute" would fail since I am already using
the *SYSTEM* user requested by the script itself??
Please help me!! Thanks in advance!! Happy holidays!!

Zara

You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!