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

When I was working today, I suddenly reported an error when I was operating to delete all the tables under the oracle user, and then I couldn't link with plsql. Tried all kinds of methods, but to no avail. Finally decided to restart the oracle service. I logged into oracle's server through crt and planned to restart oracle. I found that I couldn't get in using sqlplus / as sysdba, so I was asked to enter my user name and password directly. Then I tried to use dba and any other user to link, and I was asked to re-enter it. Later, I decided to restart the server, and after restarting, I found that the oracle service still could not be started. The steps for the final solution are as follows:

1. Start oracle listening: under the command line window of cmd, type lsnrctl start, and enter enter to start listening.

two。 Configure sid:cmd instance name (orcl) in the set ORACLE_SID= command window

3. Connect to oracle: enter sqlplus / nolog, enter enter, and then enter conn / as sysdba;

4. Start: startup.

This could have solved the problem, but there is a new problem on my side. Report to No space on device at startup. The device does not have enough disk space.

So using df has checked and found that the installation of oracle has been close to 100% of the used directory.

So I deleted some useless things. And then rebooted successfully.

Then I logged in with the previous user and found an error ORA-01012: not logged on.

Then log in with the following name: sqlplus "/ as sysdba", shutdown abort.

Then it was found that the login report ora-01017 invalid username/password error.

Use the following:

Sqlplus / nolog, enter, and then enter connect old user name / old password as sysdba; enter

After that, all users will be able to log in.

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.