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