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;