My Oracle Support Banner

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

Last updated on FEBRUARY 09, 2024

Applies to:

Oracle Communications Network Charging and Control - Version 4.3.0 and later
Oracle Solaris on SPARC (64-bit)

Symptoms


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

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.