Oracle cannot be started

Shulou Source: shulou.com Published: 2022-06-01 05:22:51 11月12日 Update

1. A test library in the company suddenly lost its connection.

Sqlplus / as sysdba can not enter, error can not create aduit file

Resolve:

1. Check to see if there is this folder and whether there are files under the directory

It was found that there was. There's no problem with permissions or anything.

2df-TH to view disk space

Found that the space has been used up (there is no alarm in the test environment), delete the large backup files, free up 50g.

Sqlplus / as sysdba is ready to log on.

3. Log in and continue to report an error

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

It was stuck there when the monitor was turned off.

Found in the log

TNS-12531: TNS:cannot allocate memory

There are two situations: there is not enough memory, or the hostname of the / etc/hosts file is inconsistent with what hostname sees

Later, it was determined who temporarily changed the host name, so that the login could not be made.

Modify the host name in the / etc/hosts file.

Startup can start normally.