remote_listener 设置问题导致数据库不能打开 alert 日志如下: starting up:oracle database 11g enterprise edition release 1
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 vmrac2
10.0.0.1 vmrac1-priv
10.0.0.2 vmrac2-priv
10.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 vmrac2
10.0.0.1 vmrac1-priv
10.0.0.2 vmrac2-priv
10.80.18.137 vmrac1-vip racdb-scan.rac.cn.oracle.com
10.80.18.138 vmrac2-vip racdb-scan.rac.cn.oracle.com
~
,