This video shows how you can stop and start the Oracle Database using SQL*Plus as well as explore the different startup modes supported by the Oracle instance.
- [Instructor] We can control the Oracle listener…using the Oracle lsnrctl command.…This command allows us to perform various tasks…with our Oracle listener.…If the bin directory of the Oracle home environment variable…has been included in our Linux shell path,…which we can verify by typing echo dollar sign…and then in uppercase PATH, and as you can see,…we have our Oracle home bin directory…at the start of the path environment variable,…so if this has been configured,…we can run the Oracle lsnrctl command…by just typing lsnrctl in the terminal window…from the Oracle Linux OS user.…
We can also execute lsnrctl by specifying…the full path of the utility, which would be the Oracle home…with the bin directory inside it, slash lsnrctl.…Both methods work.…Pressing Enter will bring us into the lsnrctl utility,…allowing us to control our Oracle instance.…For example, we can see its status,…as you can see we have an Oracle listener running…using port 1521 and it is indeed listening…to our ORCL database instance.…
We can stop and start the Oracle listener.…
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
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 55s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.