Save Initialized Name with airSlate SignNow

Bulk argue signature block

hello again everyone in this video we're going to take a look at two files that are essential for Oracle to function properly whether you're talking about file set live on the host with Oracle database lives or if they live on the client which is where you're going to access the Oracle database from those two files are called Tina's names aura and listener not aura now listener aura is a file that only exists on the server and that's going to configure the listener and tell the listener how to listen for requests for people coming in from the client and the client could be running anything client could be running a web browser application can be run in a forms application any type of application that needs to communicate to the Oracle database is going to go through the listener so the listener aura is going to Lee is going to live just on the server but TNS name said aura is going to exist both on the server and on any client machine that needs access to the Oracle database so let's start with the TNS name so to our file in your Oracle home wherever that is on your machine if you're running a client machine with let's say Oracle forms on it you'll have an Oracle home directory if you're talking about the server with a running the Oracle database software they'll obviously be an Oracle home for the Oracle server software in this example I'm going to go to my Oracle home which in in this case is C Oracle DB product 11200 DB home 1 that's my Oracle home for my Oracle database that's running on my server in your Oracle home you will always have a directory called network and underneath that network directory you will have a directory called admin and in that admin directory you'll have a couple of different files out there you can see that I have one called listener Ora another one called TNS names or this video is going to focus on those two a different video we're going to talk about sequel net or but if we take a look at the TNS names Dora to edit this guy looks like it's a little hard to read but what this really does is it encapsulates all the different ways that you can talk to an Oracle database and it puts all of that different information in a specific entry so if we ignore this Oracle connection data one that's up here you can see there's three entries in this file is Oracle connection data sandbox and V is so sandbox is going to be the name of my entry and I can call this anything I want just because my database happens to be called sandbox doesn't mean the entry in the TNS names has to be called sandbox it could be called prod or dev or XYZ or anything I want normally you create an entry with the same name as the actual database name itself so one of the things that are encapsulated inside this sandbox entry well we have things like the protocol how we're going to communicate to the database 99% of shops out there today use tcp/ip as your network protocol there's backwards compatibility for older Network protocol methods but 99.9 percent of the time you're going to be used tcp/ip as your network protocol what else so I have to specify well I have to specify the host of where this database lives so my sandbox database is running locally on my machine Oskie one dot fourth month comm you can say have another entry for the VIS database that's on a completely different host and because I'm not running a DNS server inside my local home network here I have to specify the IP address the port that the listener for that database is listening on 1521 is the standard port and the actual service name are the instance thing that I'm going to connect to right in this case it's called sandbox like I said the instance name does not have to correspond to the name of the entry that you put in this file you can call it X Y Z or anything you want but obviously it makes sense to do those types of things so when it comes time for you to add a new entry to the TNS name set or a file you can certainly go in there and modify it yourself I mean a real common thing to do would be just to copy an existing entry copy that guy paste it in here and then make the necessary changes for the new information that you want to add to the file but Oracle provide you with a graphical tool also so if you're running on Windows if you go into your Oracle home and under configuration and migration tools there's two call an ED configuration assistant I'm going to bring that up right now and it's a wizard it's a wizard that will go through and I'll ask you a whole bunch of questions about the new things that you want to configure or if you want to maybe remove entries from your TNS names file and it will update that information for you automatically and it's a real nice tool because as you can see that what the TNS names file looks like you have all of these open parentheses close parentheses you know all it takes is one mistyped character somewhere and can screw up your whole networking environment so I'm going to minimize him and as you can see the net configuration this is the last-minute configure a whole bunch of different tools I can configure the listener named methods configuration my local net service name that's the one we're going to do for this and if we were using Oracle directories we can configure that through this tool also but I'm going to do my local net service name configuration I click on next and I can obviously add a new entry reconfigure an existing entry delete an entry rename an entry do a test so if I do something like test I'll get a drop-down box and you can see that the three entries here correspond with three entries in my TNS names at our Oracle connection data which is a specific type of entry for inter-process communication you don't have to worry about that one or I can modify sandbox or my vis entry those are the three entries that I have there as part of the net service name so let's just go back and say you know what I want to add one I'm just going to add this bogus entry that doesn't really mean anything the service name is going to correspond to the actual instance name but what you want to connect to so in this case it's either you know something like sandbox or vis this is where the service name entry is going to go so I'm just going to create a bogus one call XYZ what protocol do I want to use that obviously corresponds with this part right here what protocol I'm going to use to connect to this particular database and again most of the time you're going to use tcp/ip what's the host name again I'm going to give just a silly name like ABC that's going to correspond obviously that this guy right here the host what port do I want to use from my listener use the standard of 1521 or some other port that's obviously going to correspond to this guy right here now I'm not going to perform a test and then the net service name is what I'm going to have the entry as here so even though it's an XYZ database this might be my dev database so I'm going to call it dev do I want to configure another service name nope server's name complete se finish and then if I reload this file I'll close this guy out and then just reload him back again you can see now I have my dev entry that points to the XYZ service 1521 the ABC host using the tcp/ip protocol it made all the entries in there for me automatically so what I'm going to do is I'm going to run that guy again and I'm going to say you know what I want to get rid of that entry because that's going to screw up my DNS names file but you can see how easy it is to use the wizard to go through and create new entries like I said you don't have to use the wizard if you don't want to you can certainly modify those fields from scratch modify that file from scratch but again you miss one parenthesis one missed head character somewhere and the whole thing can go haywire so let's go back into local I'm going to delete which entry am I going to delete there's the dev entry delete that guy sure you want to delete that yep boom he's gone boom he's gone I'm back to the main page now let me close out my TNS name's Dora let me re-edit him again and you can see that the dev entry pointing to that bogus XYZ database is gone the listener only exists on the server that's running the Oracle database you don't have to have a listener file running on a client that's going to connect to the Oracle database let's take a look at that guy kind of similar as to you know the way the entries are is a lot of descriptions and addresses and you know different parentheses all over the place but here's an example of the listener and we can give the listener a different name that the full name for the snare is listener so if I were to go to the command line and I would say LS and our CTL which is the listener control program and I just type start it would automatically default to look for a listener called listener and try to start that listener up if I had different listener names like X Y Z or ABC I would have to say start ABC or start XYZ or something like that but if we take the default name it will just go to listener so here's all the information about the listener process where the Oracle home is any type of environment variables that it needs and then here's the actual listener name so this listener description here corresponds to this guy right here it goes along with the listener and this is just going to display some information about okay how am I going to communicate how am I going to start up my information I'm using the tcp/ip protocol here's my host information here's the port information what I'm going to start up on so if I go into my program here to configure the listener I'm going to present be presented with the same types of questions right so let's go into the wizard here so what do I want to do do I want to add a new listener do I want to reconfigure an existing listener so let's reconfigure an existing listener and I'll say to me well which one do you want to do well the only one that's in there is the default one the one called listener so that's the only one I have the ability to do listener is currently running a sure you want to stop modify the listener with the named listener yeah let's go ahead and do that so what protocols am I going to use I can obviously support multiple protocols here so I can do that if I want to don't want to use a different port number now stick with 1521 what tcp/ip ssl port number because i use tcp/ip s as one of the protocols that I'm going to support so it's going to say okay which one do you want to use for that 2484 sounds good want to reconfigure another listening there so this is what my listener entry looked like before I close out of that guy listen your configuration complete I'm going to edit listener again you can see now it's made another entry for me for TCP s SSL secure tcp/ip with a different port number so again you don't have to use the wizard to configure these different files if you don't want to but it sure makes things a heck of a lot easier just to make sure that all the syntax is correct and everything else is set up properly inside your files the listener again only exists on the actual host that's going to configure the program to listen for requests to the Oracle Database TNS names exist both on the host where the Oracle database is running and on your different client machines now if you access Oracle via a web browser and a program on a web browser the TNS names file where is that going to exist well it's going to exist where the web browser is the that's serving up the application server because that's where the actual program lives it's just serving up information to you on a web browser so in that case you may not have a TNS name set or file running locally on your client machine if you're accessing it through a true web based application the web based application wherever that server is that's serving up the web pages that's the thing that is actually going to connect to your Oracle database so there has to be a TNS names that or a file somewhere there on that server unless it's using a protocol like JDBC Java database Java database connectivity which doesn't use a TNS names out of our file it's programmatic inside the actual Java program to say this is how I'm going to connect to an Oracle database but if you're using a tool like Oracle forms or some other tool that runs locally on your machine that talks to an Oracle database you're going to have to have that TNS names file locally on your machine also