136-9928-0061 189-1195-6537
当前位置:首页 > 新闻中心 > 服务器装上oracle 11G怎么修改SCAN IP讲解

服务器装上oracle 11G怎么修改SCAN IP讲解

更新时间:2016-12-01
服务器装上oracle 11G怎么修改SCAN IP讲解

root@node1 crsd]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
# public
 
192.168.110.71   node1
192.168.110.72   node2
 
# private
 
192.168.110.73   node1-vip
192.168.110.74   node2-vip
 
# virtual
 
10.10.0.21       node1-priv
10.10.0.22       node2-priv
 
# scan-ip
 
192.168.110.12   node-cluster   cluster-scan
[root@node1 crsd]# srvctl modify scan -h
 
Modifies the SCAN name.
 
Usage: srvctl modify scan -n <scan_name>
    -n <scan_name>           Domain name qualified SCAN name
    -h                       Print usage
[root@node1 crsd]# srvctl modify scan -n cluster-scan
[root@node1 crsd]# srvctl start scan
[root@node1 crsd]# srvctl modify scan_listener -u
[root@node1 crsd]# srvctl start scan_listener
[root@node1 crsd]# srvctl config scan
SCAN name: cluster-scan, Network: 1/192.168.110.0/255.255.255.0/em1
SCAN VIP name: scan1, IP: /cluster-scan/192.168.110.12
[root@node1 crsd]#
[root@node1 crsd]#
[root@node1 crsd]# srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
[root@node1 crsd]#
[root@node1 crsd]#
[root@node1 crsd]# su - oracle
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sqlplus system/123123@192.168.110.12/orcl
 
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 30 21:29:15 2016
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
ERROR:
ORA-01017: invalid username/password; logon denied
 
 
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
 
 
Enter user-name: oracle
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
 
 
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sqlplus system/123123@192.168.110.12/orcl
 
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 30 21:29:32 2016
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
ERROR:
ORA-01017: invalid username/password; logon denied
 
 
Enter user-name: ^C^[[A
[oracle@node1 ~]$
[oracle@node1 ~]$ sqlplus system/oracle@192.168.110.12/orcl
 
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 30 21:29:55 2016
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[root@node2 grid]# srvctl config scan
SCAN name: cluster-scan, Network: 1/192.168.110.0/255.255.255.0/em1
SCAN VIP name: scan1, IP: /cluster-scan/192.168.110.12
[root@node2 grid]# srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
上一篇:我问今天问下大家什么图形工作站?为什么要用工作站
下一篇:我们怎么样为ERP软件选择合适的服务器?
分享到: 微信 更多

本文责任编辑【DELL服务器销售中心


    关于我们

      • 联系方式:
      • 手机:18911956537
      • 官网:www.jxwtdell.com
      • 地址:北京市海淀区海淀路19-1号中成大厦
DELL服务器销售中心 戴尔服务器销售中心
展开