Search the VMware Knowledge Base (KB)
View by Article ID

Extending the tablespace on an Oracle database (1003982)

  • 6 Ratings

Symptoms

  • The VMware VirtualCenter Server service may crash unexpectedly.
  • VirtualCenter vpxd.log may show an error similar to the following when connected to a Oracle database:

    ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-01653: unable to extend table <table> by <size> in tablespace  <tablespace>  is returned when executing SQL statement <SQL Statement
    >

  • VirtualCenter vpxd.log may show an error similar to the following when connected to a Oracle database:

    ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-02478: merge into base segment would overflow MAXEXTENTS limit .

Resolution

When utilizing an Oracle database the database administrator has to be aware of the amount of space assigned to each tablespace that is being utilized. In more recent versions of Oracle an administrator can set the database to automatically extend so that constant monitoring is not required.
 
To manually extend the tablespace of a database:
  1. Log in to to the Oracle server with an administrative account.
  2. Open a utility such as SQL Plus and log in to Oracle.
  3. Run the following query:

    ALTER DATABASE DATAFILE <filename> RESIZE <size>;

    where, <filename> is the path to the datafile and <size> is the size is the size you want to extend the database to in MB, for example 100M.
 
To configure the tablespace of a database to automatically extend:
  1. Log in to to the Oracle server with an administrative account.
  2. Open a utility such as SQL Plus and login to Oracle.
  3. Run the following query:

    ALTER DATABASE DATAFILE <filename> AUTOEXTEND ON NEXT <size> MAXSIZE <maxsize>;

    where, <filename> is the path to the datafile, <size> is the size is the increment size by which you want to extend the database every time it is extended for example 1024, and <maxsize> is the maximum you want the tablespace to extend to in MB, for example 100M.

    Note: If you want the tablespace to grow as required until the disk space is filled, <maxsize> can be set to UNLIMITED .

Update History

07/16/2013 - Removed Resolution Path out of Normalization status.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 6 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 6 Ratings
Actions
KB: