The remote_listener cannot be enabled due to a problem in the settings.

The remote_listener setting problem causes the database to fail to open the alert Log as follows: Startingup: OracleDatabase11gEnterpriseEditionRelease1

The remote_listener setting problem causes the Database to fail to open the alert Log as follows: Starting up: Oracle Database 11g Enterprise Edition Release 1

The remote_listener cannot be enabled due to a problem in the settings.

The alert Log is as follows:

Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options.
Using parameter settings in server-side pfile/u01/app/oracle/product/11.2.0/db_home/dbs/inittest1.ora
System parameters with non-default values:
Processes = 150
Spfile = "+ CRS/test/spfiletest. ora"
Sga_target = 604 M
Control_files = "+ CRS/test/controlfile/current.266.823515685"
Control_files = "+ ARCH/test/controlfile/current.257.823515685"
DB _ block_size = 8192
Compatible = "11.2.0.0.0"
Cluster_database = TRUE
Db_create_file_dest = "+ CRS"
Db_recovery_file_dest = "+ ARCH"
Db_recovery_file_dest_size = 4032 M
Thread = 1
Undo_tablespace = "UNDOTBS2"
Instance_number = 1
Remote_login_passwordfile = "EXCLUSIVE"
Db_domain = ""
Dispatchers = "(PROTOCOL = TCP) (SERVICE = testXDB )"
Remote_listener = "racdb-scan.rac.cn.oracle.com: 1521"
Job_queue_processes = 0
Audit_file_dest = "/u01/app/oracle/admin/test/adump"
Audit_trail = "DB"
Db_name = "test"
Open_cursors = 300
Pga_aggregate_target = 200 M
Diagnostic_dest = "/u01/app/oracle"
Cluster communication is configured to use the following interface (s) for this instance
169.254.40.103
Cluster interconnect IPC version: Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Thu Dec 05 14:47:24 2013
USER (ospid: 10931): terminating the instance due to error 119
Instance terminated by USER, pid = 10931

---- Database startup error:

SQL> startup force
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'racdb -scan.rac.cn.oracle.com: 8080'
SQL>

Remote_listener

Tnsnams. ora Configuration:

...

Racscan =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = racdb-scan.rac.cn.oracle.com) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oradb)
)
)

ASM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.80.18.htm) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = + ASM1)
)
)

.....

Hosts Configuration:

[Root @ vmrac1 ~] # Vi/etc/hosts
# Do not remove the following line, or various programs
# That require network functionality will fail.
127.0.0.1 vmrac1 localhost. localdomain localhost
: 1 localhost6.localdomain6 localhost6
10.80.18.135 vmrac1
10.80.18.136 vmrac2

10.0.0.1 vmrac1-priv
Vmrac2-priv 10.0.0.2

10.80.18.w.vmrac1-vip
10.80.18.138 vmrac2-vip

~

The problem has been clarified here. The solution is as follows:

[Root @ vmrac1 ~] # Vi/etc/hosts
# Do not remove the following line, or various programs
# That require network functionality will fail.
127.0.0.1 vmrac1 localhost. localdomain localhost
: 1 localhost6.localdomain6 localhost6
10.80.18.135 vmrac1
10.80.18.136 vmrac2

10.0.0.1 vmrac1-priv
Vmrac2-priv 10.0.0.2

10.80.18.20.vmrac1-vip racdb-scan.rac.cn.oracle.com
10.80.18.138 vmrac2-vip racdb-scan.rac.cn.oracle.com

~

,