Summary of "linux&oracle" common commands

View database status (normal user login to ensure the database is open state)

Sql> select status from V$instance;

Create User ( new user needs to grant connection permissions to connect to database )

Sql> create user User1 identified by Redhat;

ERROR:
Ora-01045:user USER1 lacks CREATE SESSION privilege; Logon denied
Warning:you is no longer connected to ORACLE.

Sql> Show User
USER is ""
Sql> Conn/as SYSDBA
Connected.

Sql> Grant connect to User1;
Sql> Conn User1/redhat;
Connected.

See which users the system has

Sql> select * from All_users;

Execute the SQL file (path represents the file paths)

Sql> @PATH/filename.sql

Test SQL statement Execution time

Sql>set timing on;

View the current database name

Sql> select name from V$database;

Summary of "linux&oracle" common commands