This video shows how you can stop and start the Oracle listener using the LSNR utility as well review the status of an existing listener.
- [Instructor] We can start up and shut down…the Oracle database instance…directly using sequel plus.…We can do that by opening a sequel plus prompt…using the sysdba oracle user.…You write sqlplus space, quotation mark,…back slash, as, space, sysdba.…This will open a database connection as…the sys or sysdba user which is…the most powerful Oracle user.…
We need to connect to that user in order…to be able to successfully start up and shut down…the Oracle instance.…We can shut down the instance…by simply typing shut rephrase.…We can shut down the instance…by typing shutdown immediate.…Shutdown immediate is the…most common instance shutdown method.…It will disconnect existing users…and will roll back any running transaction.…It will also make sure the database is…shut down cleanly so no automatic recovery…will be needed at start up.…
Let's press enter to initiate the instance shutdown.…Note that Oracle will display us…the various stages in the sequence…of instance shutdown as the instance is going down.…It will mention that it's closing the instance,…
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.