My Oracle Support Banner

Incorrect Path Variable Causes smsDbCleanup.sh to Fail (Doc ID 1328133.1)

Last updated on JULY 30, 2018

Applies to:

Oracle Communications Network Charging and Control - Version 4.3.0 and later
Oracle Solaris on SPARC (64-bit)
***Checked for relevance on 16-July-2013***

Symptoms


The smsMaster running on the Service Management System (SMS) raises the following error

May 30 02:50:05 oracle-tst-usms01 smsMaster: [ID 438867 user.warning] smsMaster(8198) WARNING OEXEC, OEXN=1654 oraUpdateLoader.c@517: ORA-01654: unable to extend index SMF.SMF_STA_PK by 6400 in tablespace SMF_STATS_

Changes

Installation of P98946SMS "Patch 98946 (1.2) for SMS (v3.1.2.6) on SMS".

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
 Some Terms
 Index
 Table
 Tablespace
 What table is SMF_STA_PK part of?
 Why do we have so many statistics?
 Check smsDBCleanupsmsDBCleanup.sh
 Check smsDbCleanup.sh-cron.sh.log
Solution
 Can I connect to the database
 What is your SMS Patch Level
 Is the path correct
 Change the .profile-sms file
 Check the output of smsDbCleanup.sh.log 
 Check how many statistics we have after smsDbCleanup.sh has run.
 Truncate the table to shrink it
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.