Wednesday, 16 April 2014

Local Naming Method (or) Net Service Name



1. Open Net Manager (Start -> All Programs -> Oracle -> Database Configuration Assistant -> Net Manager)

2. Expand 'Local'

3. Single Click on Select Service Naming (do not expand)

4. Click the menu 'Edit' on the top

5. Click option 'Create'

6. At Net Service Name box type SHOP

7. Click Next

8. Click Next again 

9. At Host Name box you need to type the computer name ... this you will  get by following the below steps;

                                      (a). Go to Start ->  Right Click on Computer -> select properties -> on the top select Computer Name - > Copy                                                the computer name (exclude the dot at the last)

10. Paste your computer name in the Host Name box

11. In the same page change the port number to 5210

12. Click Next

13. Enter the service name as CHOPPIES(database name).

14. Click Next

15. Click Test

16. Click Change Login

17. For the user scott change the password (enter your normal user password).

18. Click ok and click test again .... you must see the success message there ... that's all.

No comments:

Post a Comment