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    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 

~