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
~
- 01-11全球最受赞誉公司揭晓:苹果连续九年第一
- 12-09罗伯特·莫里斯:让黑客真正变黑
- 12-09谁闯入了中国网络?揭秘美国绝密黑客小组TA
- 12-09警示:iOS6 惊现“闪退”BUG
- 12-05亚马逊推出新一代基础模型 任意模态生成大模
- 12-05OpenAI拓展欧洲业务 将在苏黎世设立办公室
- 12-05微软质疑美国联邦贸易委员会泄露信息 督促其
- 12-05联交所取消宝宝树上市地位 宝宝树:不会对公
- 12-04企业微信致歉:文档打开异常已完成修复