• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
Unable to add file to a Tablespace:

When trying to add a file to a Tablespace in the Production region using util/o/13/3 we get the following error:
ORA 0130: insufficient privileges
Idle> SP2 - 0640 – not connected.

Resolution:
I believe this is like the case with "Oracle Auditing" today:... user ALEPH_DBA is not granted with the sysdba privilege.

In order to fix this, you should log on as sys:

> su - root
Password:
root@xxx~ # sudo su - oracle
Execute oracle cshrc
...
oracle@xxx ~$ sqlplus '/as sysdba'

and do:

SQL>grant sysdba to aleph_dba

• Article last edited: 3/4/2014