Shulou(Shulou.com)06/01 Report--

The command to save the screen output in sql:

Spool / tmp/a.txt

* perform any sql operation

Spool off

Ho cat / tmp/a.txt

Start the sqlplus tool:

Su-oracle

$lsnrctl status/start/stop to check the monitoring status and start and stop monitoring

Sqlplus / as sysdba

The sqlplus tool starts successfully, enter the SQL prompt!

SQL >

The first thing to do at the SQL prompt is to log in:

SQL > conn scott/tiger

To see which user is currently logged in

SQL > show user

At the command line, the scott user unlocks:

SQL > conn / as sysdba

SQL > alter user scott identified by tiger account unlock

SQL > conn scott/tiger

~

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux Error: 2: No such file or directory

~

View database-related system processes:

Ps-ef | grep ora_

Check to see if the shared memory of the database is allocated:

Ipcs-sm

How to start the database after the system reboot?

Su-oracle

Sqlplus / as sysdba

SQL > startup or shutdown immediate

SQL > select status from instance; check the status of the instance. Normal is open.

SQL > conn scott/tiger

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.