您好,欢迎访问一九零五行业门户网

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

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 
~

其它类似信息

推荐信息