How Do I Do If eSight Upgrade or Secondary Installation Fails Because Automatic Growth of Data Space or Log Space Is Disabled
Question
eSight upgrade or secondary installation fails because automatic growth of data space or log space is disabled.
Answer
In the high availability system, perform the following operations only on the active server.
If the data space and log space of the database do not automatically increase, the space may become insufficient for proper database running; therefore, automatic growth of all eSight-related databases should be enabled.
Perform the following operations to enable automatic growth of the data or log space.
- SQL server database
- Choose Start > Microsoft SQL Server 2012 > SQL Server Management Studio. The database list is displayed.
- Right-click the database and select Properties. In the window displayed, select Files and click the Autogrowth button on the right panel.
- In the dialog box that is displayed, select Enable Autogrowth. In File Growth, select In Megabytes and enter 100. In Maximum File Size, select Unrestricted File Growth. Then, click OK.
- Oracle database
- Find the database disabled with automatic growth.
- Run the following command:
alter database datafile 'path tablespace' autoextend on