How To Create [TNS Service] Using Oracle Net Configuration Assistant (netCA) BY Manish Sharma

[Music] what's up Internet welcome back once again i am manish from rebellionrider.com today in this video we will learn how to create TNS service using oracle net configuration assistant but before I start the tutorial I just want to ask you to subscribe to the channel for more searched database tutorials also press the bell icon to get notified every time I upload a video and if you are watching this video on Facebook then please like the Facebook page that being said let's start the tutorial firstly what is this DNS entry an Oracle database is represented to a client as a service let's say you have three pluggable databases created on your server each of those databases must have a corresponding service you can say that a service name is a logical representation of a database in order to connect with any of those pluggable databases your client program needs a connected descriptor a connector descriptor is comprised of information such as hostname and the port number where your pluggable database is installed and configure the network protocol listener is listening on and the name of the corresponding service of the database client wants to connect with this connector descriptor is called DNS entry all the DNS entries are restored into TNS names dot or a file you can read more about DNS names dot on a file in detail in the corresponding blog of this video link is in the description now let's move ahead and learn how to create a connector descriptor or DNS entry in DNS name start or a file using Oracle Net configuration assistant famously known as Oracle NAT CA to do that we need a use case and I guess I have a perfect one in my mind I just installed Oracle 19 C on my system during that installation I configured a default pluggable database with the name or CL PDB let's create a DNS entry for this pluggable tea hobbies to create a connector descriptor in DNS name stored or a file for this pluggable database or CLP DB we first need to find out its corresponding service name let's quickly do that let me quickly zoom in a little bit great now let's connect to the Oracle database using this user let's quickly check so the connection is finally established next we need the container ID of our pluggable database over CL PDB for that we will query the V dollar pdbs view let's run this select statement here we are the container ID of our pluggable database our CL PDB is 3 let's use this information and find out the corresponding service to get the name of the corresponding service of pluggable database over CL PDB we will query the V dollar active underscore services view let's do that by the way you can copy all these statements from the corresponding blog whose link is in the description now let's write the statement let's run it to see the service name so the service name of our pluggable database orcl PDB is also over CLP TV in most of the cases both the pluggable databases and their services share the same name but it's always the best practice to check it before making any changes in your database anyways this is the process of finding out the service name of any pluggable database now that we have got that next we will create a DNS entry into our DNS names dot or a file so let's do it step 1 launch the oracle net configuration assistant or net CA oracle net configuration assistant is a powerful tool which comes in bundle using this tool you can configure the network components of your Oracle database let's launch this tool and see what we can do with it launching Oracle net configuration assistant is very easy first launch your command prompt with administrative privileges or shell with sudo rights if you are working on Linux except the UAC warning and move ahead let me adjust my command prompt a little bit great so here is our command prompt next in this command prompt we have to write net CA which is a resort command for launching the oracle net configuration assistant and here we go now let's learn how to modify the pianist name stored or a file and add a DNS entry into it first let's minimize the command prompt mind here minimize it don't close it great also let's zoom in a little bit Dan screen one welcome on the first screen of the oracle net configuration assistant we need to select a configuration here we are presented with four options as we want to add an entry for our pluggable database into TNS name start or a file thus we will select the third or option which is localnet service name configuration selected and press next screen to on the second screen of this wizard we need to select the action which we want to perform here we are provided with five options all these options are self-explanatory as we want to add a new TNS entry does we will select the first option which is ad selected and press next screen three on the third screen of this wizard we need to specify the name of the service for which we want to add a DNS entry here we will specify the name of the service which we found out earlier so the service name for which we are adding this entry into our dns names dot or a file is over CL PDB write it down here in the text field and press next to move ahead in the next two steps we will be configuring the protocol address the address portion of the connect descriptor is called the protocol address a protocol address contains the host name and the port number along with the network protocol you can take help from the listener dot or a file to find out all this information almost all the time listener dot ora and TN s name start or our files share the same protocol address here is my listener dot or a file you can find out your listener dot or ax on the location which is flashing on your screen before I move ahead let me tell you be very careful with this file and do not make changes until it's necessary okay in this file come to the entry whose name is listener here you will find out your desired information according to this information the protocol is TCP in my case host name is localhost this could be different in your case anyways the port number is one five to one let's use this information to create a DNS entry for our pluggable database first let's close this listener dot ora and come back to our oracle net configuration assistant here it is now we are sure that on this step we need to select a TCP protocol select it and press next to move ahead screen five in this step of net configuration we need to specify the host name and the port number and we know that in my case the host name is localhost and the port number is one five to one which is the default port number for Oracle database does select the option which says use the standard port number of one five to one once you are done with the setting press Next and jump on to the next step screen six test the service though it is not necessary but it's recommended I mean we should not be overconfident right so it's better to test all our settings here rather than face errors during production let's test select the second option of yes perform a test and press next now press this change login button now in username write system and in password field specify the password which you have configured during the installation of your Oracle database in my case that password is Oracle now press ok oops we got an error we got this error because the pluggable database for which we are creating a TNS service is closed can solve this error simply by opening the pluggable database over CL PDB let's do that done now let's test the service once again here is the result test successful which means we have done correct settings so far now press next and move to the next step step 7 net service name here you have to specify a name for your TNS service you can give whatever name you want but specifying a meaningful name is always the best practice most of the time we name our DNS entry on the name of our pluggable database or its corresponding service this Oracle net configuration assistant has done the same thing for you it has specified the name of the TNS entry for you the name is ORCL PDB which is the same as the service name we specified earlier I'm good with it if you want you can change it but I don't want to thus I will press next and move ahead screen 8 now this configuration assistant is asking you whether you want to configure another net service or not here select no and move ahead here press next and then press finish that's it that's all you have to do so that's how we create TNS entry using oracle net configuration assistant i have tried to keep the tutorial as simple as possible but if you still have any doubt or want to read more about TNS then i suggest you check out the blog hope you enjoyed watching if so then please give this video a thumbs up and share it with your friends if you're watching this on Facebook then please like the Facebook page and if you're watching it on YouTube then please subscribe to the channel thanks for watching this is manish from rebellionrider.com

Channel: Manish Sharma

Views: 51,980

Keywords: Manish Sharma, Rebellion Rider, Oracle TNS, Oracle Database Networking, Networking Protocol, TNS Networking Protocol, Oracle 18c, Oracle 19c, Oracle Cloud, TNS, TNS Oracle, tnsnames.ora, listener.ora, tnsnames, netca, net configuration assistant, TNS Service, Oracle 12154, Transparent Network Substrate, Oracle DBA tutorial, oracle ace manish sharma, oracle database tutorial, data science, what is tns, what is NetCA, manish sharma vlogs, manish sharma videos, half engineer

Id: 1dvroWdSKWw

Length: 12min 9sec (729 seconds)

Published: Sun Aug 25 2019