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