OCNCC/OC3C Configuration

Oracle Communications NCC/CCC Configuration

Database Updates

The N2FE application requires a slight increase to database access on Oracle Communications Network Charging and Control (NCC) or Convergent Charging Controller (CCC) platforms.

Security Trigger Update

The existing SMF security trigger SMF_USER_ALD is intended to prevent NCC/OC3C screens users from directly accessing the database, but has an exclusion to allow these users access via the NCC/OC3C GUI. This trigger must be extended to allow N2FE the same level of access.

To update this trigger, access the OCNCC/OC3C SMF node, and locate the directory:

/IN/service_packages/SMS/db/install/create/

In this directory, edit the file smf_logon_security.sql and change:

  IF ((v_screens_user = 'Y') AND (v_program not like 'NCC Screens')) OR

Update the text to read:

  IF ((v_screens_user = 'Y') AND (v_program not like 'NCC Screens') AND (v_program not like 'httpd%') AND (v_program not like 'perl%')) OR

Note that the exact content of this IF statement in the SQL trigger may differ depending on your version of OCNCC/OC3C. The critical change is to allow v_program to be either httpd%, or perl%.

Finally, replace the trigger with the updated body. Copy the file smf_logon_security.sql to the OCNCC/OC3C SMF database instance node, and execute it:

su - oracle
sqlplus '/ as sysdba'
@/path/to/smf_logon_security.sql

Additional Permissions

In order to monitor the compilation of flows on the NCC/OC3C platform, N2FE requires the ability to view the status of ongoing compilations in the database. This is a simple addition of a permission.

To add this permission, access database administration from the database host machine as the oracle user:

su - oracle
sqlplus '/ as sysdba'

Then add the permission to the role used by N2FE:

GRANT SELECT ON acs_compile_errors TO acs_user_role;