Real World Oracle AI Cloud Database Solutions

Sunday, July 9, 2017

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]$

ANURAG PANDEY

I am Anurag Pandey, working as Cloud Database Architect | Cloud Migration and Modernization Expert .Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible, Audit, Email - anuragkumarjoy@gmail.com

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Wednesday, July 5, 2017

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>

ANURAG PANDEY

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Follow more articles at

Visit Blog

Thursday, March 2, 2017

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]$

ANURAG PANDEY

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Follow more articles at

Visit Blog

Sunday, February 26, 2017

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

ANURAG PANDEY

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Follow more articles at

Real World Oracle AI Cloud Database Solutions

Sunday, July 9, 2017

RELOCATE SCAN LISTENER BETWEEN RAC NODES

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Visit Blog

Wednesday, July 5, 2017

SET SQLPLUS PROMT VARIABLES

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Visit Blog

Thursday, March 2, 2017

Remove file using inode number in linux

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Visit Blog

Sunday, February 26, 2017

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

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Visit Blog

Create Resource Manager , Resource Group / Consumer groups in Oracle Database to limit CPU resources

Contact Form