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