RELOCATE SCAN LISTENER BETWEEN RAC NODES

Relocate scan listener
==================================



[grid@rac1 etc]$
[grid@rac1 etc]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
SCAN Listener LISTENER_SCAN4 is enabled
SCAN listener LISTENER_SCAN4 is running on node rac2
[grid@rac1 etc]$
[grid@rac1 etc]$
[grid@rac1 etc]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1
SCAN VIP scan4 is enabled
SCAN VIP scan4 is running on node rac2
[grid@rac1 etc]$
[grid@rac1 etc]$
[grid@rac1 etc]$ srvctl relocate scan_listener -i 4 -n rac1
[grid@rac1 etc]$
[grid@rac1 etc]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1
SCAN VIP scan4 is enabled
SCAN VIP scan4 is running on node rac1
[grid@rac1 etc]$
[grid@rac1 etc]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
SCAN Listener LISTENER_SCAN4 is enabled
SCAN listener LISTENER_SCAN4 is running on node rac1
[grid@rac1 etc]$





[grid@rac1 etc]$
[grid@rac1 etc]$
[grid@rac1 etc]$ srvctl relocate scan_listener -i 2 -n rac2
[grid@rac1 etc]$
[grid@rac1 etc]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac2
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
SCAN Listener LISTENER_SCAN4 is enabled
SCAN listener LISTENER_SCAN4 is running on node rac1
[grid@rac1 etc]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac2
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1
SCAN VIP scan4 is enabled
SCAN VIP scan4 is running on node rac1
[grid@rac1 etc]$
[grid@rac1 etc]$
[grid@rac1 etc]$



[grid@rac1 etc]$
[grid@rac1 etc]$ srvctl relocate scan_listener -i 2 -n rac2
PRCR-1105 : Failed to relocate resource ora.LISTENER_SCAN2.lsnr to node rac2
PRCR-1089 : Failed to relocate resource ora.LISTENER_SCAN2.lsnr.
CRS-2731: Resource 'ora.LISTENER_SCAN2.lsnr' is already running on server 'rac2'
[grid@rac1 etc]$



[grid@rac1 etc]$ srvctl relocate scan_listener -i 4 -n rac1
[grid@rac1 etc]$
[grid@rac1 etc]$
[grid@rac1 etc]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
SCAN Listener LISTENER_SCAN4 is enabled
SCAN listener LISTENER_SCAN4 is running on node rac1
[grid@rac1 etc]$

SET SQLPLUS PROMT VARIABLES

SET  SQLPLUS  ENVIRONMENT
==========================================


set termout off
col user_name new_value user_name
col db_name new_value db_name
set pages 200 lines 200
rem select lower(user) user_name, ltrim(rtrim(lower(global_name))) db_name from global_name;
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
rem sqlprompt "&user_name@_CONNECT_IDENTIFIER> "
rem sqlprompt "_CONNECT_IDENTIFIER &user_name> "
SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER _DATE> "
set termout on
set trimspool on
set trimout on
set serveroutput on size 1000000
set timing on
set echo on feedback on time on timing on serveroutput on sqlblank on



====================

SQL> set termout off
col user_name new_value user_name
col db_name new_value db_name
set pages 200 lines 200
rem select lower(user) user_name, ltrim(rtrim(lower(global_name))) db_name from global_name;
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
rem sqlprompt "&user_name@_CONNECT_IDENTIFIER> "
rem sqlprompt "_CONNECT_IDENTIFIER &user_name> "
SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER _DATE> "
set termout on
set trimspool on
set trimout on
set serveroutput on size 1000000
set timing on
set echo on feedback on time on timing on serveroutput on sqlblank onSQL> SQL> SQL> SQL> SQL>
Session altered.

SQL> SQL> SQL> SYS@orcl1 05-JUL-2017 13:45:58> SYS@orcl1 05-JUL-2017 13:45:58> SYS@orcl1 05-JUL-2017 13:45:58> SYS@orcl1 05-JUL-2017 13:45:58> SYS@orcl1 05-JUL-2017 13:45:59> SYS@orcl1 05-JUL-2017 13:45:59>
13:46:00 SYS@orcl1 05-JUL-2017 13:46:00>
13:46:00 SYS@orcl1 05-JUL-2017 13:46:00>
13:46:00 SYS@orcl1 05-JUL-2017 13:46:00>
13:46:00 SYS@orcl1 05-JUL-2017 13:46:00>
13:46:01 SYS@orcl1 05-JUL-2017 13:46:01>

Remove file using inode number in linux

Remove  directory/file using inode number  in linux
-----------------------------------------------------------------

[oracle@stby oracle]$ ls -lrt
total 32
drwxrwxr-x.  3 oracle oinstall 4096 Feb 26 07:43 product
drwxrwxr-x. 11 oracle oinstall 4096 Feb 26 09:50 diag
drwxr-xr-x.  2 oracle oinstall 4096 Feb 26 09:53 checkpoints
drwxr-xr-x.  3 oracle oinstall 4096 Feb 26 10:31 cfgtoollogs
drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:01 admin
drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 fast_recovery_area
drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 oradata
drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:12 -p
[oracle@stby oracle]$

[oracle@stby oracle]$ ls -li
total 32
143126 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:01 admin
143086 drwxr-xr-x.  3 oracle oinstall 4096 Feb 26 10:31 cfgtoollogs
143085 drwxr-xr-x.  2 oracle oinstall 4096 Feb 26 09:53 checkpoints
143089 drwxrwxr-x. 11 oracle oinstall 4096 Feb 26 09:50 diag
131827 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 fast_recovery_area
140990 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 oradata
140979 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:31 -p
140980 drwxrwxr-x.  3 oracle oinstall 4096 Feb 26 07:43 product
[oracle@stby oracle]$
[oracle@stby oracle]$ find . -inum 140979 -exec rm -rf  {} \;
find: `./-p': No such file or directory
[oracle@stby oracle]$ ls -li
total 28
143126 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:01 admin
143086 drwxr-xr-x.  3 oracle oinstall 4096 Feb 26 10:31 cfgtoollogs
143085 drwxr-xr-x.  2 oracle oinstall 4096 Feb 26 09:53 checkpoints
143089 drwxrwxr-x. 11 oracle oinstall 4096 Feb 26 09:50 diag
131827 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 fast_recovery_area
140990 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 oradata
140980 drwxrwxr-x.  3 oracle oinstall 4096 Feb 26 07:43 product
[oracle@stby oracle]$


find . -inum 140979 -exec rm -rf  {} \;

Remove file using below command 

find . -inum 140979 -exec rm -i {} \;

[oracle@stby oracle]$ ls -li
total 28
143126 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:01 admin
140979 -rw-r--r--.  1 oracle oinstall    0 Mar  2 22:37 a.txt
143086 drwxr-xr-x.  3 oracle oinstall 4096 Feb 26 10:31 cfgtoollogs
143085 drwxr-xr-x.  2 oracle oinstall 4096 Feb 26 09:53 checkpoints
143089 drwxrwxr-x. 11 oracle oinstall 4096 Feb 26 09:50 diag
131827 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 fast_recovery_area
140990 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 oradata
140980 drwxrwxr-x.  3 oracle oinstall 4096 Feb 26 07:43 product
[oracle@stby oracle]$
[oracle@stby oracle]$ find . -inum 140979 -exec rm -i {} \;
rm: remove regular empty file `./a.txt'? y
[oracle@stby oracle]$
[oracle@stby oracle]$ ls -li
total 28
143126 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:01 admin
143086 drwxr-xr-x.  3 oracle oinstall 4096 Feb 26 10:31 cfgtoollogs
143085 drwxr-xr-x.  2 oracle oinstall 4096 Feb 26 09:53 checkpoints
143089 drwxrwxr-x. 11 oracle oinstall 4096 Feb 26 09:50 diag
131827 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 fast_recovery_area
140990 drwxr-xr-x.  2 oracle oinstall 4096 Mar  2 22:02 oradata
140980 drwxrwxr-x.  3 oracle oinstall 4096 Feb 26 07:43 product
[oracle@stby oracle]$

How to resolve PRVF-0002: could not retrieve local node name

 Error:  PRVF-0002: could not retrieve local node name


Solution:
-------------

first check hostname in server

[root@pri etc]# hostname
pri.localdomain
[root@pri etc]#

Old host file

[root@pri etc]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
[root@pri etc]#
[root@pri etc]#


Now make entry of server ip and hostname in host file


[root@pri etc]#
[root@pri etc]#
[root@pri etc]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.1.12 pri  pri.localdomain
[root@pri etc]#
[root@pri etc]#

after  restart oracle oui