1. View, close, and start the listener
1) Use the Lsnrctl command with the status parameter to see if the listener is starting to work
$lsnrctl status
2) using the LSNRCTL command with the stop parameter, you can shut down the database listener and stop providing remote database services to the external
$lsnrcrl stop
3) using the LSNRCTL command with the stop parameter, you can open the database listener and provide remote database service externally.
$lsnrctl start
2. Starting and shutting down a DB instance
1) After logging in to the Linux system as Oracle, user SYS connects to the database as Sysdba
$sqlplus Sys/manager as Sysdba
2) Start the routine
Sql>startup
3) Close the DB instance
Sql>shutdown Immediate
3. View, stop, and start the Oracle Database console service
1) View Oracle Database Console Service
$emctl Status Dbconsole
If the status is running, start browser Firefox, enter address: https://localhost:1158/em, add to Security exception, enter SYS and its password to log in to the system SYSDBA identity
2) Stop Oracle Database Console service
$emctl Stop Dbconsole
3) Start the Oracle Database console service
$emctl Start Dbconsole
4. Start and Exit Sql*plus
1) Display the startup syntax format:
Sqlplus User name/password
or sqlplus username/password @ Service Name example: $sqlplus scott/[email protected]
$sqlplus Sys/manager as SYSDBA
2) Implicit startup syntax format:
$sqlplus
Enter User-name:scott
Enter Password:tiger
3) Exit Sql*plus
Exit or quit
4) Get Help information
Sql>help
Accompanying notes for Oracle database (i)