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

浏览:
字体:
发布时间:2013-12-09 23:23:20
来源:


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

~

>更多相关文章
24小时热门资讯
24小时回复排行
资讯 | QQ | 安全 | 编程 | 数据库 | 系统 | 网络 | 考试 | 站长 | 关于东联 | 安全雇佣 | 搞笑视频大全 | 微信学院 | 视频课程 |
关于我们 | 联系我们 | 广告服务 | 免责申明 | 作品发布 | 网站地图 | 官方微博 | 技术培训
Copyright © 2007 - 2024 Vm888.Com. All Rights Reserved
粤公网安备 44060402001498号 粤ICP备19097316号 请遵循相关法律法规
');})();