Common Oracle commands, common Oracle database commands

1. Su Oracle is not required, it is suitable for use when there is no DBA password, and you can enter the SQLPLUS interface without a password.

2. sqlplus nolog or 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 DB instance.

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

6、startup force

Forced start mode.

If the database cannot be shut down, you can use the startup force to complete the database shutdown.

Shut down the database and then run the normal start database command.

Not accurate enough. It can also be used to recover your data if it shuts down ungracefully.

1. Su Oracle is not required, it is suitable for use when there is no DBA password, and you can enter the SQLPLUS interface without a password.

2. sqlplus nolog or 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 DB instance.

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

See if it's what you need?

It was also the one I used to learn Oracle in the first place, from front to back.

Suitable for beginners.

I have a PPT of our company training oracle. Leave an email address and I'll send it to you.