EMS :: NBPRD Database Freespace Fully Utilized

Asset ID:	1-71-2001494.1
Update Date:	2017-02-15
Keywords:

Solution Type Technical Instruction Sure

Solution 2001494.1 : EMS :: NBPRD Database Freespace Fully Utilized

Applies to:

Oracle Communications EAGLE (Software) - Version EMS 43.x and later
Oracle Communications EAGLE (Hardware) - Version EMS 43.x to EMS 43.x [Release EMS 43.0]
Tekelec

Goal

Database of EMS server have warning: Database Freespace Summary NBPRD 96%
Check DB Space:

  Database Freespace Summary

  Free Largest Total Available Pct
  Tablespace Frags Frag (KB) (KB) (KB) Used
---------------- -------- ------------ ------------ ------------ ----
RBS 21 983,040 2,097,152 2,001,400 5
INDX 208 956,152 419,840 1,300,848 -210
INDX 208 956,152 1,048,576 1,300,848 -24
TEMP 17,743 64 1,332,992 1,135,544 15
NBPRD 1 187,384 4,194,304 187,384 96
TOOLS 1 8,600 15,360 8,600 44
USERS 1 10,232 10,240 10,232 0
SYSTEM 34 129,744 409,600 141,088 66

Solution

Add further tablespace to the NBPRD.

NOTE: Below mentioned steps should be carried out by EMS Technical Support Engineer. If you are a customer, please raise an SR so that the support engineer can carry out this procedure.

1. Run following command to check DB status:

NBInfo.sh

2. Check for below mentioned output. In the example; you can see NBPRD is 96% utilized.

                   Free     Largest       Total      Available   Pct
   Tablespace     Frags    Frag (KB)       (KB)         (KB)     Used
---------------- -------- ------------ ------------ ------------ ----
RBS                    21      983,040    2,097,152    2,001,400    5
INDX                  208      956,152      419,840    1,300,848 -210
INDX                  208      956,152    1,048,576    1,300,848 -24
TEMP               17,743           64    1,332,992    1,135,544   15
NBPRD                   1      187,384    4,194,304      187,384   96
TOOLS                   1        8,600       15,360        8,600   44
USERS                   1       10,232       10,240       10,232    0
SYSTEM                 34      129,744      409,600      141,088   66

3.Check status of Netboss processes

sudo /etc/init.d/netboss checkall

4. Stop netboss application

sudo /etc/init.d/netboss stopall

5. Print DB status to a textfile

sqlplus netboss/netboss @/u01/app/netboss/misc/oracleinfo.sql; cat /u01/app/netboss/tmp/tmpfile1.txt

6. Login to database

sqlplus netboss/netboss

7. Check tablespace names of NBPRD

select * from dba_data_files where tablespace_name='NBPRD';

8. Add Tablespace to NBPRD. In example below; second file named nbprd02.dbf has been created with 4000MB space.

alter tablespace NBPRD add datafile '/u05/oradata/NBPRD/nbprd02.dbf' size 4000M;

9. Check if the new tablespace is now being shown.

select * from dba_data_files where tablespace_name='NBPRD';

10. Exit database

exit

11. Restart Netboss application

sudo /etc/init.d/netboss start

Attachments

This solution has no attachment