ORA-00119: invalidspecificationforsystemparameterREMOTE

Three database instances run normally on a RAC (ORACLE11.2.0.3) with two nodes. Recently, if you want to switch the archive mode of the database, you will have to stop a database that has not been officially invested.

Three database instances run normally on a RAC (ORACLE 11.2.0.3) with two nodes. Recently, if you want to switch the archive mode of the database, you will have to stop a database that has not been officially invested.

Three database instances run normally on a RAC (Oracle 11.2.0.3) with two nodes. Recently, I want to switch the database archive mode ,, A database instance that has not been officially put into production is stopped. When you want to restart one of the instances, the error 00119 is displayed, as shown below:

# Srvctl start instance-d test-I test2-o mount

PRCR-1013: Failed to start resource ora. test. db

PRCR-1064: Failed to start resource ora. test. db on node p740b

The CRS-5017: the resource action "ora. test. db start" encountered The following error:

ORA-00119: invalid specification for system parameter REMOTE_LISTENER

ORA-00132: syntax error or unresolved network name 'p740db-scan: 8080'

. For details refer to "(: CLSN00107 :)" in "/oraclu/app/grid_home/log/p740b/agent/crsd/oraagent_oracle/oraagent_oracle.log ".

CRS-2674: Start of 'ora. test. db' on 'p740b' failed

#

Check hosts, tnsnames. ora should be normal, and the sqlnet. ora under grid_home is also normal. I forgot to carefully check the sqlnet. ora under oracle.

At last, I found that sqlnet. ora under oracle was automatically removed, and there was an automatic backup in the same directory. I have never moved it manually. I still don't know why.

You only need

NAMES. DIRECTORY_PATH = (TNSNAMES)

Change

NAMES. DIRECTORY_PATH = (EZCONNECT)

The database can be started normally.

Related reading:

Knowledge points of Oracle instances and services