Nokia OSS

What is Object Class In NetAct Database?

In OSS NetAct Database Oracle Server there is Objects Tables which is listed all Objects within the Network Element, for example BSC, BCF, BTS, HOC, POC, ADCE, ADJW, RNC, WBTS, WCEL, FMCG, FMCS, FMCI, ADJS, ADJG, ADJI,etc.

So what is Object Class?, simply defined object class is group which is having similar level. So for every Object Class its having same Object Class ID, example BSC is having Object Class = 3, RNC is 811, WBTS is 812 and WCEL is 813.

In simple oracle script, this is how to get the BSC List using Object Class Query:
SELECT * FROM OBJECTS WHERE OBJECT_CLASS=3;

Sample Oracle SQL script to get the RNC List from NetAct Database:
SELECT * FROM OBJECTS WHERE OBJECT_CLASS=811;

Sample Oracle SQL script to get the WBTS List from NetAct Database:
SELECT * FROM OBJECTS WHERE OBJECT_CLASS=812;

Sample Oracle SQL script to get the WCEL List from NetAct Database:
SELECT * FROM OBJECTS WHERE OBJECT_CLASS=813;

So its clear that using Object_Class ID we can filter some Objects within Network Element directly from NetAct Database Oracle Server.

Free Nokia BSC RNC MML Macro Converter Online
http://www.oss-tools.com

As we know that NetAct OSS using Oracle as its main database. If we can connect to the Oracle database, we can run some SQL query from specific table or  view. On this article i want to share about tutorial "How To Setup Oracle SID Connection In Netact OSS".

After installing Oracle Client (you can use Oracle 8.X, 9.X or Oracle 10.X version), now we can setup SID/Service connection to NetAct OSS database. Just please follow step by step instruction below. This tutorial is assuming if your operating system is Windows XP.

1. Open Application Oracle Net Configuration Assistant:
Start->Programs->Oracle - OraHome90->Configuration and Migration Tools->Net Configuration Assistant
Select -> Local Net Service Name Configuration
Click -> Next

2. Selecting Database Version

4. Protocol Setting
Choose the protocol used : TCP
Click -> Next

5. TCP/IP Protocol Setting

Please fill the Host Name with the IP Address, please ask the OSS Admin about this IP information.
Please choose the port number 1521 as standard port.
Click -> Next

6. Connection Testing
When you finishing the TCP IP Setting, you can try to test the connection or you can skip it.

Its better for you to test the connection just to make sure that the its OK.
Click -> Next.

7. Net Service Name
Pleas fill the Net Service Name with any name,example : OSS
Click -> Next

8. Another Net Service

On this step, you have successfully setup for one NetAct OSS connection, you can select : No if you want to finished, or you can select Yes if you want to setup for other OSS connection.
Click -> Next

Finished.

Free Nokia BSC RNC MML Macro Converter Online
http://www.oss-tools.com
 

On this article i just want to share about Nokia NetAct OSS Database Introduction.

As we know that Nokia OSS is using Oracle database for its database platform. Measurement data is transferred from BSC, RNC, or NE to Oracle database. The raw data from BSC having binary format, while the raw data from RNC having XML format.

There are some process within NetAct OSS handling the measurement process,for example mecmanmx. If the process stopped, it will caused the raw data not available in NetAct OSS. Basically raw data is aggregated on hourly basis, but for some measurement it also available within 15 minutes basis.

Normally the latency between data in real network and in the NetAct OSS is having different one hour,so if we want to collect data at 5PM then the latest  update of our data is up to 4PM.

If we want to collect the report,we can use Reporting Suite which is available in the NetAct on Reporting Page section,if we understand about oracle, we also can get the data directly for OSS Raw data tables, example for 2G/BSC raw data tables : P_NBSC_TRAFFIC, P_NBSC_SERVICE,etc.

Free Nokia BSC RNC MML Macro Converter Online
http://www.oss-tools.com
 

On this article i just want to share about simple Nokia NetAct OSS Introduction.

Nokia Siemens Networks use NetAct as their OSS Platform. This environment giving access to statistic, performance monitoring, configuration management, user management, fault management and all OSS aspect for the overall subsystem. All tools which is available in NetAct mostly developed by Java platform.

Some tools are available in Configuration Management Page:
-CM Editor
CM Editor is application which is used to modify,add,delete soma parameter directly using gui interface.

-CM Operation Manager
CM Operation Manager is application which is using XML as its interface to provisioning the radio parameters for the mass operation, for example site creation, frequency retuning, rehoming, rehosting, lac splitting.

-Application Launcher
Application Launcher is application to connect to NE, example RNC.

-WBTS Manager
-WBTS Manager is application to do the remote access to the end site. We only need IP Address, user and password to connect to the sites.

Some tools are available in Reporting Page:
-Reporting Suite
Reporting suite is reporting tools, we use this tool to get the report,example RSRAN report, ND Report or Counter Level report. Some options are available to breakdown the counter: Daily, Hourly and Object Level aggregation are also avilable: RNC Level, WBTS Level, or WCEL Level.

-Reporting Suite Scheduler
Reporting Suite Scheduler is application to automate the report generation. You can setup custom report to make it create everyday.

-Report Builder
Report Builder is application to create custom formula from counter. So if you want to create your own formula, you can cutomize using this tool, just drag and drop the counter from specific tables.

Free Nokia BSC RNC MML Macro Converter Online
http://www.oss-tools.com