关闭

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

1116人阅读 评论(2) 收藏 举报
分类:


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  

~





1
0

猜你在找
【直播】机器学习&数据挖掘7周实训--韦玮
【套餐】系统集成项目管理工程师顺利通关--徐朋
【直播】3小时掌握Docker最佳实战-徐西宁
【套餐】机器学习系列套餐(算法+实战)--唐宇迪
【直播】计算机视觉原理及实战--屈教授
【套餐】微信订阅号+服务号Java版 v2.0--翟东平
【直播】机器学习之矩阵--黄博士
【套餐】微信订阅号+服务号Java版 v2.0--翟东平
【直播】机器学习之凸优化--马博士
【套餐】Javascript 设计模式实战--曾亮
查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:772612次
    • 积分:14629
    • 等级:
    • 排名:第789名
    • 原创:671篇
    • 转载:95篇
    • 译文:11篇
    • 评论:85条
    博客专栏
    oracle blog
    最新评论