Error while using dbspace_admin -addfile

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






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


Rate this page:

(0 users)Average rating

Add comments

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:

2013-04-19

Translate my page

Machine Translation

Content navigation