remote_listener 设置问题导致数据库不能打开

remote_listener 设置问题导致数据库不能打开alert 日志如下：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 = 604M
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= 4032M
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 = 200M
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
----起数据库是的报错：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:1521"
SQL>
关于remote_listener
tnsnams.ora配置：。。。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.137）（PORT = 1521））
（CONNECT_DATA =
（SERVER = DEDICATED）
（SID = +ASM1）
）
）。。。。。
hosts 配置：[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 vmrac210.0.0.1 vmrac1-priv
10.0.0.2 vmrac2-priv10.80.18.137 vmrac1-vip
10.80.18.138 vmrac2-vip~
这里已经问题已经很明了，解决方法如下：[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 vmrac210.0.0.1 vmrac1-priv
10.0.0.2 vmrac2-priv10.80.18.137 vmrac1-vip racdb-scan.rac.cn.oracle.com
10.80.18.138 vmrac2-vip racdb-scan.rac.cn.oracle.com ~ORA-600 [6947]/ORA-600 [kdsgrp1] 处理Oracle 建立序列以及触发器的建立相关资讯 remote_listener 本文评论查看全部评论（0）