Monday, July 29, 2013

Use Database 12c Net Manager to Configure TNS for Multitenant Environment

In this demo I will show how to use the well known Net Manager utility to configure the local TNS file on the Multitenant environment. The Net Manager tool has been around since 8i and is a useful tool to configure multiple TNS entries in one tool.


1. Set your environment to your Oracle 12c database home.


2. Currently no tnsnames files exist in the <oracle_home>/network/admin directory

















3. Execute netmgr

  • $<oracle_home>/bin/netmgr

4. The net manager will open. Click on Service Naming then click the plus.


4. Entry the net service name you want and click next.

5. Select the communication protocol and click next.

6. Enter the host name and port and click next.

7. Enter the service name for the Pluggable database and click next.

8. Click the test button

9. The test button defaults to testing with scott/tiger we can see how long this utility has been around. Click the change login button to change the credentials.

10. Set the username and password credentials for the Pluggable database click OK.

11. Now click test and this time the connection will be successful. Click close.

12. Click finish to close the net service name wizard.

13. Under service naming you will see your service configured. If you need to add more service names just repeat the same steps above if not continue to step 14.

14. Click file>save network configuration

15. Then click file>exit to close net manager.

16.  We can now see under $ORACLE_HOME/network/admin the tnsnames.ora has been created.

17. When we more the tnsnames.ora file we can see the three service names I created have been written to the tnsnames.ora file.































18. Now we can connect to the pluggable database using net service name.





Follow me on Twitter


6 comments:

  1. nice tutorial thanks

    ReplyDelete
  2. It's a nice post I was really impressed by reading this .NET Online Course Hyderabad

    ReplyDelete
  3. .Net technology. This post gives me detailed information about the .net technology. I am working as trainer in leading IT training academy offering Dot Net Training in Chennai and i use your guide to educate my students.




    Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery


    ReplyDelete
  4. Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Fusion Procurement. Actually, I was looking for the same information on internet for Oracle Fusion HCM and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject.

    ReplyDelete
  5. Simply wish to say your article is as astonishing. The clarity in your post is simply great, and I could assume you are an expert on this subject. Same as your blog i found another one Oracle Fusion Procurement .Actually I was looking for the same information on internet for Oracle Fusion Procurement and came across your blog. I am impressed by the information that you have on this blog. Thanks a million and please keep up the gratifying work.

    ReplyDelete