Oracle 11g RAC database creation times ORA-00119 and ORA-00132 errors
When the Grid is installed on Oracle 11g RAC and the library software is also created, the following error is reported when the database is created:
ORA-00119: Invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'ora-scan: 100'
When an error is reported, the REMOTE_LISTENER of the parameter file is faulty.
There are two solutions:
1. Add the corresponding resolution name
Enter oracle and enter netca
[Oracle @ rac01 ~] $ Netca
Select Cluster configuration
ORA-00119: Invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'ora-scan: 100'
The following figure has no good columns. Step by step and finish
After the database is installed, no error will be reported.
2. Modify the REMOTE_LISTENER parameter in init. ora.
Check that no init-related parameter file is found under the oracle user (the database has not been created yet)
Enter the $ ORACLE_HOME/dbs of the grid user
When init. ora is enabled, the REMOTE_LISTENER parameter is not explicitly specified.
Append a REMOTE_LISTENER = (ADDRESS_LIST = (Address = (Protocol = tcp) (Host = your_hostname) (Port = 1521 )))
Just execute the same command. The second method is in theory. I have never tested it. If anyone has ever tested it, please leave a message and reply to me to solve my problem .. Thank you ~~
ORA-00119: Invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'ora-scan: 100'