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.
nice tutorial thanks
ReplyDeleteGreat!
ReplyDeleteIt's a nice post I was really impressed by reading this .NET Online Course Hyderabad
ReplyDelete.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.
ReplyDeleteDot 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
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.
ReplyDeleteSimply 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