Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ubuntu linux - ORA-01031: insufficient privileges

ianbramMar 29 2011 — edited Mar 30 2011

hi all

I have oracle xe running on ubuntu linux without any apparent problems until I try to connect like this
sqlplus / as sysdba at which point I get the ORA-01031: insufficient privileges message.

I have tried as root, as oracle (su oracle) and as a user who has membership in the dba group.

I have even set all the privileges on the oracle directory (chmod -R 777 /usr/lib/oracle) but all without success.

Would really appreciate some help on this as I am trying to configure the RMAN backup utility and need to set
XE to operate in archivelog mode so I can do online backups.

This post has been answered by DBA_1976 on Mar 29 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2011

Added on Mar 29 2011

5 comments

5,587 views