Problem Symptoms

• Items can be renewed, but not discharged
• Fines and fees cannot be added manually or via Circulation batch jobs
• Circjob.log and/or alert_VGER.log contain error: ORA-01536: space quota exceeded for tablespace 'XXXDB'
• Attempting to discharge item results in error: An error occurred while attempting to process discharge request

Cause

XXXDB may be out of tablespace, or tablespace may not be set to autoextend.

Resolution

Open a Case with Voyager Support for assistance

OR

1. Use UTIL menu to add tablespace:
2. SSH or telnet to server as voyager user.
3. dlib xxxdb
4. util
5. Type O (Oracle Management)
6. Type C (Check Oracle tablespace)
7. Enter oracle administrative user
8. Enter oracle password for system user

UTIL menu will check tablespace. If indicates that additional tablespace is needed:

9. Type Enter to return to Oracle Management menu
10. Type A (Add an Oracle datafile for xxxdb)
11. Enter oracle administrative user
12. Enter oracle password for system user
13. UTIL menu gives message:

14. Type YES to continue.

UTIL menu adds datafile

• Article last edited: 2016-Mar-15