IBM Support

Error while using dbspace_admin -addfile or modifyfile command

Technote (troubleshooting)


Problem(Abstract)

How to use the part_admin -addfile command to increase tablespace using the correct privileage user account?

Symptom

Tried to add datafile to the TRAFFIC_LARGE_OVFW using dbspace_admin results in the following error using sys user.

BUILD FAILED

/appl/virtuo/conf/dbspace_admin/dbspace_admin.xml:41: Unable to get a connection:ORA-28009: connection as SYS should be as SYSDBA or SYSOPER


virtuo@test: dbspace_admin -addfile -tbsname TRAFFIC_LARGE_OVFW -dirpath /oradata03/vtdb/ -extsize 5120 -totalsize 5120


Licensed Materials - Property of IBM

5724W86

(C) Copyright IBM Corp. 2004, 2009 All Rights Reserved.



Please enter database name [vtdb] : vtdb

Please enter database user name [system] : sys

Please enter database user password [Sysdb01] : Sysdb01

Buildfile: /appl/virtuo/conf/dbspace_admin/dbspace_admin.xml



init:
BUILD FAILED

/appl/virtuo/conf/dbspace_admin/dbspace_admin.xml:41: Unable to get a connection:ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

Total time: 9 seconds


Or else if user is facing below error :

dbspace_admin -modifyfile -filepath /devsda1/appl/oradata04/vtdb/traffic_large01.dbf -totalsize 40000

SQL Error: ORA-06598: insufficient INHERIT PRIVILEGES privilege


Resolving the problem

Please ensure to enter the database user name that has system administrator privileges to resolve this error and to proceed with adding the datafile .

virtuo@test: dbspace_admin -addfile -tbsname TRAFFIC_LARGE_OVFW -dirpath /oradata03/vtdb/ -extsize 5120 -totalsize 5120

Licensed Materials - Property of IBM

5724W86

(C) Copyright IBM Corp. 2004, 2009 All Rights Reserved.

Please enter database name [vtdb] : vtdb
Please enter database user name [system] : system
Please enter database user password [Sysdb01] : Sysdb01
Buildfile: /appl/virtuo/conf/dbspace_admin/dbspace_admin.xml

init:

run:

Successfully Added Datafile(s) to Tablespace TRAFFIC_LARGE_OVFW

Associated Datafile(s) has extent size of 5120M and total max size of 5120M

List of Associated Datafiles:
TABLESPACE NAME FILE NAME ACTUAL SIZE(MB) MAX SIZE(MB)
===================================================================

TRAFFIC_LARGE_OVFW /oradata03/vtdb/traffic_large02.dbf 1000 5120
TRAFFIC_LARGE_OVFW /oradata04/vtdb/traffic_large01.dbf 11048 20480

If you are entering correct login credentials, then you need to check if the user has DBA privileges or not.

Else login to SQlplus and run the alter database command consulting your DBA.

Document information

More support for: Tivoli Netcool Performance Manager for Wireless

Software version: 1.2.1, 1.3

Operating system(s): AIX, Linux, Solaris

Software edition: All Editions

Reference #: 1595094

Modified date: 07 September 2016


Translate this page: