Learn operation commands frequently used to log on to the oracle database

1. su-Oracle is not required. It is suitable for use without a DBA password. You do not need a password to enter the sqlplus interface.

2. sqlplus/nolog, sqlplus system/manager, or./sqlplus system/manager @ ora9i;

3. SQL> connect/as sysdba; (as sysoper) or

Connect internal/oracle as sysdba; (scott/tiger)

Conn sys/change_on_install as sysdba;

4. SQL> startup; start the database instance

5. view all current databases: select * from v $ database;

Select name from v $ database;

Desc v $ databases; view database structure Fields

7. How to check which users have SYSDBA and SYSOPER permissions:

SQL> select * from V _ $ PWFILE_USERS;

Show user; view the current database connection user

8. Enter the test database: database test;

9. View All database instances: select * from v $ instance;

For example, ora9i

1 2 Next Page

[Content navigation]
Page 1st: Learn operation commands frequently used to log on to the oracle database	Page 2nd: Learn operation commands frequently used to log on to the oracle database