The problem analysis and solution of Oracle database SYS user Login error ora-00119,ora-00132

In the Oracle server with SYS user login times wrong ora-00119,ora-00132, such as

Reading the newspaper wrong is the need to modify the configuration information of the parameter file network registration module

The first step: View the init.ora.418201831545 file, find the error message mentioned in the ' LISTENER_ORCL ', such as

Step Two: No configuration information found in Listener.ora, Tnsnames.ora files

Recall the operation found the error operation to delete the configuration information in the Tnsnames.ora file

There are two solutions to these problems:

First: Add a configuration to the Tnsnames.ora file

Restart the database server.

The second type: Modify the database initialization parameter file configuration information

First of all:

And then:

Use the command to close the database-"shutdown immediate;

Again:

Start the database with the command-"startup pfile= ' xxxx\init.ora.4182018231545 ';

Create binary parameter file with command-"create SPFile from pfile= ' xxxx\init.ora.4182018231545";

Finally, you can restart the database with a binary file:

Use the command to close the database-"shutdown immediate;

Start the database with a binary file-"startup;

Problem solving.

The problem analysis and solution of Oracle database SYS user Login error ora-00119,ora-00132