正如你所提到的,它的特权问题.
引自这个site
ORA-01031: insufficient privileges
Cause: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if attempting to
install a database without the necessary operating system privileges.
When Trusted Oracle is configure in DBMS MAC,this error may occur if
the user was granted the necessary privilege at a higher label than the
current login.
Action: Ask the database administrator to perform the operation or grant
the required privileges. For Trusted Oracle users getting this error
although granted the appropriate privilege at a higher label,ask the
database administrator to re-grant the privilege at the appropriate label.
如果您正在进行调试,它应该工作
grant DEBUG CONNECT SESSION to