| Asset ID: |
1-71-2066114.1 |
| Update Date: | 2017-02-07 |
| Keywords: | |
Solution Type
Technical Instruction Sure
Solution
2066114.1
:
Performance Intelligence Center (PIC) 10.1 NSP oracle SYSAUX Tablespace is Filling up to 100%
| Related Items |
- Oracle Communications Performance Intelligence Center (PIC) Software
|
| Related Categories |
- PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec PIC
|
In this Document
Created from <SR 3-11419115631>
Applies to:
Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.1.0 and later
Information in this document applies to any platform.
Goal
With PIC 10.1, NSP oracle database release changed to 11.2.0.4. This release is impacted by purge issues with AWR reports store that can fill up the SYSAUX tablespace up to 100%, this problem is described in KM 1292724.1.
To fix the issue the SYSAUX tablespace must be increased to provide enough space to switch and drop partitions.
Solution
To increase SYSAUX tablespace connect to the NSP Oracle box as oracle user and run the following commands:
- Log to sqplus prompt:
sqlplus <connection string>
- Run the following sql statements (ensure files do not already exist before running command):
ALTER TABLESPACE "SYSAUX" ADD DATAFILE '/opt/oracle/oradata/data3/NSP/sysaux03.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2048M;
ALTER TABLESPACE "SYSAUX" ADD DATAFILE '/opt/oracle/oradata/data3/NSP/sysaux04.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2048M;
ALTER TABLESPACE "SYSAUX" ADD DATAFILE '/opt/oracle/oradata/data3/NSP/sysaux05.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2048M;
ALTER TABLESPACE "SYSAUX" ADD DATAFILE '/opt/oracle/oradata/data3/NSP/sysaux06.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2048M;
ALTER TABLESPACE "SYSAUX" ADD DATAFILE '/opt/oracle/oradata/data3/NSP/sysaux07.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2048M;
ALTER TABLESPACE "SYSAUX" ADD DATAFILE '/opt/oracle/oradata/data3/NSP/sysaux08.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2048M;
- Log out of sqlplus.
References
<NOTE:1292724.1> - Suggestions if Your SYSAUX Tablespace Grows Rapidly or Too Large
Attachments
This solution has no attachment
