In this video, we will show how you can use the Oracle NETCA utility to create and configure and Oracle LIstener thus allowing remote connections to your Oracle database
- [Instructor] After you have installed the Oracle software, using the Oracle Universal Installer, we can go ahead and create our listener, as well as our database. Remember that after finishing the software installation, you still don't have a database. You'll need to create one. First thing I recommend doing Is logging off and logging back in with the Oracle Linux OS user. In order to do that, you can click on the power button, in the upper right corner, selecting the oracle user, and selecting Log Out.
Confirm the Log Out. After the Log Out has finished, click on the oracle user and type the password to log back in again. Now that you have successfully logged in again, open a terminal window and type; 'cd' space '$' and then in uppercase, 'ORACLE' underscore 'HOME' Press enter. This will take you to the Oracle installation directory. You can verify it by typing 'pwd' which will display the current working directory.
Inside the oracle home directory, go to the bin folder, short for binary, and from that folder we are going to run the oracle netca, which is short for Network Configuration Assistant program, which will create the oracle listener for us. In order to do that just type 'netca' and press enter. This will open a wizard that will guide us through the listener creation process.
Let's keep the first option, Listener configuration, selected. And click next. We'll keep the only available option which is to add a new listener, selected. And click next. Here we can type the name for our listener. Keeping the default name, which is just LISTENER, in uppercase, should suffice. Click next. We can select the communication protocols we want this listener to support. Keeping the default options, which is TCPIP, should suffice, so please click next.
And here you can select the listener port. This is the port number, users and applications will use to connect to the listener, and thus gain access to the database. We can leave the default option, or select any other port that matches our network configuration. For this course we can leave the default option. And click next. The wizard will ask us if we would like to configure another listener. We can keep No, as one listener should suffice. Please click next. The Oracle Network Configuration Assistant completed the process and prompts us that Listener configuration is now complete.
We can select next, and finish. We now have an Oracle Listener up and running. We can verify that by typing; 'lsnrctl' which stands for Listener control. And enter. Inside the Listener control utility, we can type 'status' and enter. We will be shown that we have a listener created, listening on port 1521.
This listener is still not connected to any oracle instances. That's because we still haven't created an Oracle instance or an Oracle database. You can type 'quit' to exit the listener control utility. And we're done.
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management