TriniDBA

Problem:

When logging on to HRMS Production instance as SYSADMIN, the following message is displayed:

You have insufficient privileges for the current operation

Solution:

Log on to the HRMS Production server. Check the alert log for any ORA errors by issuing the following commands:

[applmgr@ebusiness /]$
[applmgr@ebusiness bdump]$ cd /u0/oracle/proddb/9.2.0/admin/PROD_ebusiness/bdump/
[applmgr@ebusiness bdump]$ tail alert_PROD.log
Current log# 2 seq# 33933 mem# 1: /u0/oracle/proddata/log02b.dbf
Tue Dec  2 09:46:30 2008
Completed checkpoint up to RBA [0x848d.2.10], SCN: 0x056d.102174e9
Tue Dec  2 10:00:40 2008
Beginning log switch checkpoint up to RBA [0x848e.2.10], SCN: 0x056d.1021d85e
Thread 1 advanced to log sequence 33934
Current log# 1 seq# 33934 mem# 0: /u0/oracle/proddata/log01a.dbf
Current log# 1 seq# 33934 mem# 1: /u0/oracle/proddata/log01b.dbf
Tue Dec  2 10:15:50 2008
ORA-1654: unable to extend index ICX.ICX_SESSIONS_N1 by 35 in tablespace              ICXX
[applmgr@ebusiness bdump]$
[applmgr@ebusiness 9.2.0]$ sqlplus apps/********
SQL*Plus: Release 9.2.0.3.0 - Production on Tue Dec 2 10:25:25 2008
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
SQL> desc dba_data_files
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
FILE_NAME                                          VARCHAR2(513)
FILE_ID                                            NUMBER
TABLESPACE_NAME                                    VARCHAR2(30)
BYTES                                              NUMBER
BLOCKS                                             NUMBER
STATUS                                             VARCHAR2(9)
RELATIVE_FNO                                       NUMBER
AUTOEXTENSIBLE                                     VARCHAR2(3)
MAXBYTES                                           NUMBER
MAXBLOCKS                                          NUMBER
INCREMENT_BY                                       NUMBER
USER_BYTES                                         NUMBER
USER_BLOCKS                                        NUMBER
SQL> select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'ICXX';
TABLESPACE_NAME FILE_NAME                      BYTES/1024/1024
--------------- ------------------------------ ---------------
ICXX            /u0/oracle/proddata/icxx01.dbf              20
SQL> alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M;
alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> connect system/********
Connected.
SQL> alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M;
Tablespace altered.
SQL>  select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'ICXX';
TABLESPACE_NAME FILE_NAME                      BYTES/1024/1024
--------------- ------------------------------ ---------------
ICXX            /u0/oracle/proddata/icxx01.dbf              20
ICXX            /u0/oracle/proddata/icxx02.dbf              20

Log on to SYSADMIN and confirm that the issue no longer exists.