My Oracle Support Banner

Incorrect Path Variable Causes 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***


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_


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


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
 Some Terms
 What table is SMF_STA_PK part of?
 Why do we have so many statistics?
 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 
 Check how many statistics we have after has run.
 Truncate the table to shrink it

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