UBUNTU16 installation completed, test the installation of the successful steps

1. View the Oracle environment variables, enter the command in the terminal

Echo $ORACLE _base

Echo $ORACLE _home

Echo $PATH

See if output is the path set when installing

2. Turn on the listener

Lsnrctl start

In addition, you can use LSNRCTL status to view listening information

3. Start Oracle

Sqlplus/nolog

4. Log in as system default user

Conn/as SYSDBA

5. Start the database

Startup

(Close database: Shutdown normal/transactional/immediate/abort Four parameters of different meanings)

6, the initial installation of the database, you need to create users

Create user fybing identified by 123456

7. Exit

Exit/quit; (two commands available)

8. Close the Listener

Lstrctl stop

Other common commands

echo $ORACLE _sid View ORACLE instance Name

or SYSDBA login, enter: select name from V$database

UBUNTU16 installation completed, test the installation of the successful steps