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

DELL服务器装上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

服务器技术支持   DELL服务器维修