Oracle Database Commands and Practical Examples

Friday 16 April 2021

OCI- Cloud Sql developer connection

OCI- Web Sql developer connection

Visit oracle cloud website : https://www.oracle.com/in/cloud/sign-in.html

Enter Cloud Account Name credential.

Select dashboard menu

Select Autonomous database and choose mentioned database.

Select Tools options and new window open

Select mentioned icon below:

Execute command on web sql developer.

Thursday 8 April 2021

ASM - Online OCR and Voting Adding on ASM Diskgroup using Normal Redundancy

ASM - Online OCR and Voting disk SAN LUN Migration on ASM Diskgroup Normal Redundancy

Once 3 ASM disks are created at OS level using oracleasm utility. We will add to CRS ASM diskgroup online as OCR and voting disk is stored on it.

See also blog link for details in alert log: ASM - Online OCR and Voting disk SAN LUN Migration on ASM Diskgroup

Redundancy Level: Normal

Grid Version: 12.1.0.2.0

Create ASM disk of same size using oracleasm utility

[root@srv1 ~]# oracleasm createdisk CRSNEW1 /dev/sdc1

Writing disk header: done

Instantiating disk: done

[root@srv1 ~]# oracleasm createdisk CRSNEW2 /dev/sdd1

Writing disk header: done

Instantiating disk: done

[root@srv1 ~]# oracleasm createdisk CRSNEW3 /dev/sdk1

Writing disk header: done

Instantiating disk: done

[root@srv1 ~]# oracleasm listdisks

CRS1

CRS2

CRS3

CRSNEW

CRSNEW1

CRSNEW2

CRSNEW3

DATANEW

FRANEW

Login to the ASM instance using grid user and check the current diskgroup status.

[root@srv1 ~]# su grid

[grid@srv1 root]$ cd

[grid@srv1 ~]$ . oraenv

ORACLE_SID = [+ASM1] ?

The Oracle base remains unchanged with value /u01/app/grid

[grid@srv1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 2 17:45:51 2021

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL>

set lines 999;

col diskgroup for a10

col diskname for a12

col path for a30

select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

0 0 0 /dev/oracleasm/disks/CRSNEW FORMER

0 0 0 /dev/oracleasm/disks/CRSNEW1 PROVISIONED

0 0 0 /dev/oracleasm/disks/CRSNEW3 PROVISIONED

0 0 0 /dev/oracleasm/disks/CRSNEW2 PROVISIONED

CRS CRS1 12284 1519 10765 /dev/oracleasm/disks/CRS1 MEMBER

CRS CRS2 12284 1484 10800 /dev/oracleasm/disks/CRS2 MEMBER

CRS CRS3 12284 1485 10799 /dev/oracleasm/disks/CRS3 MEMBER

DATA DATA_0001 20473 2476 17997 /dev/oracleasm/disks/DATANEW MEMBER

FRA FRA_0001 20473 1075 19398 /dev/oracleasm/disks/FRANEW MEMBER

9 rows selected.

SQL> set pages 40000 lines 120

col PATH for a30

select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK;

DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE PATH

----------- ------- ------------ ------- -------- ------------------------------

0 CLOSED FORMER ONLINE NORMAL /dev/oracleasm/disks/CRSNEW

1 CLOSED PROVISIONED ONLINE NORMAL /dev/oracleasm/disks/CRSNEW1

2 CLOSED PROVISIONED ONLINE NORMAL /dev/oracleasm/disks/CRSNEW3

3 CLOSED PROVISIONED ONLINE NORMAL /dev/oracleasm/disks/CRSNEW2

1 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/FRANEW

3 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/CRS3

1 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/DATANEW

2 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/CRS2

0 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/CRS1

9 rows selected.

Add these provisioned disks in CRS diskgroup

SQL> ALTER DISKGROUP CRS ADD DISK '/dev/oracleasm/disks/CRSNEW1' NAME CRSNEW1,'/dev/oracleasm/disks/CRSNEW2' NAME CRSNEW2,'/dev/oracleasm/disks/CRSNEW3' NAME CRSNEW3;

Diskgroup altered.

Check Rebalance operation to complete using below query.

SQL> Select operation, state, est_work, est_minutes from v$asm_operation;

OPERA STAT EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN 2218 3

REBAL WAIT 0 0

SQL> /

OPERA STAT EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN 2218 1

REBAL WAIT 0 0

SQL> /

OPERA STAT EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL DONE 2218 0

REBAL RUN 0 0

SQL> Select operation, state, est_work, est_minutes from v$asm_operation;

OPERA STAT EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL DONE 2218 0

REBAL RUN 0 0

SQL> /

no rows selected

Check the status of Diskgroup

SQL>

set pages 40000 lines 120

col PATH for a30

select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK;

DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE PATH

----------- ------- ------------ ------- -------- ------------------------------

0 CLOSED FORMER ONLINE NORMAL /dev/oracleasm/disks/CRSNEW

1 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/FRANEW

3 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/CRS3

1 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/DATANEW

2 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/CRS2

5 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/CRSNEW3

0 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/CRS1

4 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/CRSNEW2

1 CACHED MEMBER ONLINE NORMAL /dev/oracleasm/disks/CRSNEW1

9 rows selected.

SQL>

set lines 999;

col diskgroup for a10

col diskname for a12

col path for a30

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

0 0 0 /dev/oracleasm/disks/CRSNEW FORMER

CRS CRS1 12284 778 11506 /dev/oracleasm/disks/CRS1 MEMBER

CRS CRS2 12284 746 11538 /dev/oracleasm/disks/CRS2 MEMBER

CRS CRS3 12284 746 11538 /dev/oracleasm/disks/CRS3 MEMBER

CRS CRSNEW1 12284 743 11541 /dev/oracleasm/disks/CRSNEW1 MEMBER

CRS CRSNEW2 12284 742 11542 /dev/oracleasm/disks/CRSNEW2 MEMBER

CRS CRSNEW3 12284 742 11542 /dev/oracleasm/disks/CRSNEW3 MEMBER

DATA DATA_0001 20473 2476 17997 /dev/oracleasm/disks/DATANEW MEMBER

FRA FRA_0001 20473 1075 19398 /dev/oracleasm/disks/FRANEW MEMBER

9 rows selected.

Drop old Diskgroup of CRS with disk CRS1,CRS2,CRS3

SQL> alter diskgroup CRS drop disk 'CRS1';

Diskgroup altered.

SQL> alter diskgroup CRS drop disk 'CRS2';

Diskgroup altered.

SQL> alter diskgroup CRS drop disk 'CRS3';

Diskgroup altered.

Check query to complete rebalance operations.

SQL> Select operation, state, est_work, est_minutes from v$asm_operation;

OPERA STAT EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN 2177 2

REBAL WAIT 0 0

SQL> Select operation, state, est_work, est_minutes from v$asm_operation;

OPERA STAT EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN 2177 2

REBAL WAIT 0 0

SQL> /

OPERA STAT EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN 2177 1

REBAL WAIT 0 0

SQL> /

no rows selected

Check the current status of disk CRS1, CRS2,CRS3

SQL>

set lines 999;

col diskgroup for a10

col diskname for a12

col path for a30

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

0 0 0 /dev/oracleasm/disks/CRSNEW FORMER

0 0 0 /dev/oracleasm/disks/CRS1 FORMER

0 0 0 /dev/oracleasm/disks/CRS3 FORMER

0 0 0 /dev/oracleasm/disks/CRS2 FORMER

CRS CRSNEW1 12284 1517 10767 /dev/oracleasm/disks/CRSNEW1 MEMBER

CRS CRSNEW2 12284 1485 10799 /dev/oracleasm/disks/CRSNEW2 MEMBER

CRS CRSNEW3 12284 1486 10798 /dev/oracleasm/disks/CRSNEW3 MEMBER

DATA DATA_0001 20473 2476 17997 /dev/oracleasm/disks/DATANEW MEMBER

FRA FRA_0001 20473 1075 19398 /dev/oracleasm/disks/FRANEW MEMBER

9 rows selected.

SQL> /

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

0 0 0 /dev/oracleasm/disks/CRSNEW FORMER

0 0 0 /dev/oracleasm/disks/CRS1 FORMER

0 0 0 /dev/oracleasm/disks/CRS3 FORMER

0 0 0 /dev/oracleasm/disks/CRS2 FORMER

CRS CRSNEW1 12284 1517 10767 /dev/oracleasm/disks/CRSNEW1 MEMBER

CRS CRSNEW2 12284 1485 10799 /dev/oracleasm/disks/CRSNEW2 MEMBER

CRS CRSNEW3 12284 1486 10798 /dev/oracleasm/disks/CRSNEW3 MEMBER

DATA DATA_0001 20473 2476 17997 /dev/oracleasm/disks/DATANEW MEMBER

FRA FRA_0001 20473 1075 19398 /dev/oracleasm/disks/FRANEW MEMBER

9 rows selected.

SQL> /

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

0 0 0 /dev/oracleasm/disks/CRSNEW FORMER

0 0 0 /dev/oracleasm/disks/CRS1 FORMER

0 0 0 /dev/oracleasm/disks/CRS3 FORMER

0 0 0 /dev/oracleasm/disks/CRS2 FORMER

CRS CRSNEW1 12284 1517 10767 /dev/oracleasm/disks/CRSNEW1 MEMBER

CRS CRSNEW2 12284 1485 10799 /dev/oracleasm/disks/CRSNEW2 MEMBER

CRS CRSNEW3 12284 1486 10798 /dev/oracleasm/disks/CRSNEW3 MEMBER

DATA DATA_0001 20473 2476 17997 /dev/oracleasm/disks/DATANEW MEMBER

FRA FRA_0001 20473 1075 19398 /dev/oracleasm/disks/FRANEW MEMBER

9 rows selected.

Delete Disk at OS level using oracleasm utility

srv1:/home/grid # oracleasm deletedisk CRS1

Disk "CRS1" defines an unmarked device

Dropping disk: done

srv1:/home/grid # oracleasm deletedisk CRS2

Clearing disk header: done

Dropping disk: done

srv1:/home/grid # oracleasm deletedisk CRS3

Clearing disk header: done

Dropping disk: done

SQL> /

Check query for current status of ASM Disk group

SQL>

set lines 999;

col diskgroup for a10

col diskname for a12

col path for a30

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

0 0 0 /dev/oracleasm/disks/CRSNEW FORMER

CRS CRSNEW1 12284 1517 10767 /dev/oracleasm/disks/CRSNEW1 MEMBER

CRS CRSNEW2 12284 1485 10799 /dev/oracleasm/disks/CRSNEW2 MEMBER

CRS CRSNEW3 12284 1486 10798 /dev/oracleasm/disks/CRSNEW3 MEMBER

DATA DATA_0001 20473 2476 17997 /dev/oracleasm/disks/DATANEW MEMBER

FRA FRA_0001 20473 1075 19398 /dev/oracleasm/disks/FRANEW MEMBER

6 rows selected.

############## Another Example of Online ASM disk group migration ###############

SQL> set lines 999;

SQL> col diskgroup for a10

SQL> col diskname for a12

SQL> col path for a30

SQL> select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

0 0 0 ORCL:CRSNEW1 PROVISIONED

0 0 0 ORCL:CRSNEW2 PROVISIONED

0 0 0 ORCL:CRSNEW3 PROVISIONED

BACKUP BACKUP 15359 96 15263 ORCL:BACKUP MEMBER

CRS CRS1 12287 3047 9240 ORCL:CRS1 MEMBER

CRS CRS2 12287 3046 9241 ORCL:CRS2 MEMBER

CRS CRS3 12287 3043 9244 ORCL:CRS3 MEMBER

DATA DATA 20479 4249 16230 ORCL:DATA MEMBER

FRA FRA 20479 937 19542 ORCL:FRA MEMBER

9 rows selected.

SQL> ALTER DISKGROUP CRS ADD DISK 'ORCL:CRSNEW1' NAME CRSNEW1,'ORCL:CRSNEW2' NAME CRSNEW2,'ORCL:CRSNEW3' NAME CRSNEW3;

Diskgroup altered.

SQL> set lines 999;

col diskgroup for a10

SQL> SQL> SQL> SQL> col diskname for a12

col path for a30

SQL> SQL> SQL> SQL> select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

BACKUP BACKUP 15359 96 15263 ORCL:BACKUP MEMBER

CRS CRS1 12287 3017 9270 ORCL:CRS1 MEMBER

CRS CRS2 12287 3014 9273 ORCL:CRS2 MEMBER

CRS CRS3 12287 3011 9276 ORCL:CRS3 MEMBER

CRS CRSNEW1 12287 34 12253 ORCL:CRSNEW1 MEMBER

CRS CRSNEW2 12287 34 12253 ORCL:CRSNEW2 MEMBER

CRS CRSNEW3 12287 35 12252 ORCL:CRSNEW3 MEMBER

DATA DATA 20479 4249 16230 ORCL:DATA MEMBER

FRA FRA 20479 937 19542 ORCL:FRA MEMBER

9 rows selected.

srv1:/home/grid # oracleasm deletedisk CRS1

Disk "CRS1" defines an unmarked device

Dropping disk: done

srv1:/home/grid # oracleasm deletedisk CRS2

Clearing disk header: done

Dropping disk: done

srv1:/home/grid # oracleasm deletedisk CRS3

Clearing disk header: done

Dropping disk: done

srv1:/home/grid # su grid

grid@srv1:~> sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 8 13:16:53 2021

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> set lines 999;

SQL> SQL> col diskgroup for a10

col diskname for a12

SQL> SQL> SQL> SQL> col path for a30

SQL> SQL>

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

BACKUP BACKUP 15359 96 15263 ORCL:BACKUP MEMBER

CRS CRSNEW1 12287 3045 9242 ORCL:CRSNEW1 MEMBER

CRS CRSNEW2 12287 3046 9241 ORCL:CRSNEW2 MEMBER

CRS CRSNEW3 12287 3045 9242 ORCL:CRSNEW3 MEMBER

DATA DATA 20479 4249 16230 ORCL:DATA MEMBER

FRA FRA 20479 937 19542 ORCL:FRA MEMBER

6 rows selected.

SQL>

srv2:~ # oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks...

Cleaning disk "CRS1"

Cleaning disk "CRS2"

Cleaning disk "CRS3"

Scanning system for ASM disks...

srv2:~ # oracleasm listdisks

BACKUP

CRSNEW1

CRSNEW2

CRSNEW3

DATA

FRA

srv2:~ #

Wednesday 7 April 2021

RAC - Rebuild node for surviving node 12.2.0.1.0

Rebuild node for surviving node 12.2.0.1.0

This is lab scenario , OS recreated after making passwordless oracle and grid connection. we proceed further for adding failed node. Here addenode.sh command are almost same but in 12.2.0.1.0 adding HUB or LEAF "CLUSTER_NEW_NODE_ROLES={HUB}" . In our case it is 2 node RAC grid so we use HUB depends upon option provided earlier.

Operating System : OEL 6.7 X 64 bit
Oracle Grid version : 12.1.0.2.0
Please follow these steps before executing commands Web blog link : Add failed node 12.1.0.2.0 grid
Below we add node from srv2 to srv1 server.

[grid@srv2 addnode]$ ./addnode.sh -ignoreSysPrereqs -ignorePrereq -silent "CLUSTER_NEW_NODES={srv1}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={srv1-vip}" "CLUSTER_NEW_NODE_ROLES={HUB}"

Prepare Configuration in progress.

Prepare Configuration successful.

.................................................. 7% Done.

Copy Files to Remote Nodes in progress.

.................................................. 12% Done.

.................................................. 17% Done.

..............................

Copy Files to Remote Nodes successful.

You can find the log of this install session at:

/u01/app/oraInventory/logs/addNodeActions2021-04-06_05-34-07-PM.log

Instantiate files in progress.

Instantiate files successful.

.................................................. 49% Done.

Saving cluster inventory in progress.

.................................................. 83% Done.

Saving cluster inventory successful.

The Cluster Node Addition of /u01/app/12.2.0/grid was successful.

Please check '/u01/app/12.2.0/grid/inventory/silentInstall2021-04-06_5-33-57-PM.log' for more details.

Setup Oracle Base in progress.

Setup Oracle Base successful.

.................................................. 90% Done.

Update Inventory in progress.

Update Inventory successful.

.................................................. 97% Done.

As a root user, execute the following script(s):

1. /u01/app/12.2.0/grid/root.sh

Execute /u01/app/12.2.0/grid/root.sh on the following nodes:

[srv1]

The scripts can be executed in parallel on all the nodes.

.................................................. 100% Done.

Successfully Setup Software.

[root@srv1 ~]# tail -1000f /u01/app/12.2.0/grid/install/root_srv1.example.com_2021-04-06_18-05-43-573011212.log

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= grid

ORACLE_HOME= /u01/app/12.2.0/grid

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/12.2.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

/u01/app/grid/crsdata/srv1/crsconfig/rootcrs_srv1_2021-04-06_06-08-10PM.log

2021/04/06 18:08:20 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2021/04/06 18:08:20 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.

2021/04/06 18:10:14 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2021/04/06 18:10:14 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2021/04/06 18:10:34 CLSRSC-363: User ignored prerequisites during installation

2021/04/06 18:10:34 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2021/04/06 18:10:41 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2021/04/06 18:10:44 CLSRSC-594: Executing installation step 5 of 19: 'SaveParamFile'.

2021/04/06 18:11:07 CLSRSC-594: Executing installation step 6 of 19: 'SetupOSD'.

2021/04/06 18:11:09 CLSRSC-594: Executing installation step 7 of 19: 'CheckCRSConfig'.

2021/04/06 18:11:13 CLSRSC-594: Executing installation step 8 of 19: 'SetupLocalGPNP'.

2021/04/06 18:11:27 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2021/04/06 18:11:52 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2021/04/06 18:11:52 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2021/04/06 18:12:06 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2021/04/06 18:12:24 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'

2021/04/06 18:13:24 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2021/04/06 18:13:38 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'srv1'

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'srv1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Oracle High Availability Services has been started.

2021/04/06 18:15:31 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2021/04/06 18:15:45 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'srv1'

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'srv1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Oracle High Availability Services has been started.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'srv1'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'srv1'

CRS-2677: Stop of 'ora.drivers.acfs' on 'srv1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'srv1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

2021/04/06 18:16:24 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

CRS-4123: Starting Oracle High Availability Services-managed resources

CRS-2672: Attempting to start 'ora.mdnsd' on 'srv1'

CRS-2672: Attempting to start 'ora.evmd' on 'srv1'

CRS-2676: Start of 'ora.mdnsd' on 'srv1' succeeded

CRS-2676: Start of 'ora.evmd' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'srv1'

CRS-2676: Start of 'ora.gpnpd' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.gipcd' on 'srv1'

CRS-2676: Start of 'ora.gipcd' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'srv1'

CRS-2676: Start of 'ora.cssdmonitor' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'srv1'

CRS-2672: Attempting to start 'ora.diskmon' on 'srv1'

CRS-2676: Start of 'ora.diskmon' on 'srv1' succeeded

CRS-2676: Start of 'ora.cssd' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'srv1'

CRS-2672: Attempting to start 'ora.ctssd' on 'srv1'

CRS-2676: Start of 'ora.ctssd' on 'srv1' succeeded

CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'srv1'

CRS-2676: Start of 'ora.asm' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.storage' on 'srv1'

CRS-2676: Start of 'ora.storage' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.crf' on 'srv1'

CRS-2676: Start of 'ora.crf' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'srv1'

CRS-2676: Start of 'ora.crsd' on 'srv1' succeeded

CRS-6017: Processing resource auto-start for servers: srv1

CRS-2672: Attempting to start 'ora.ASMIBNETLSNR_ASM.lsnr' on 'srv1'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'srv2'

CRS-2672: Attempting to start 'ora.net1.network' on 'srv1'

CRS-2676: Start of 'ora.net1.network' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.qosmserver' on 'srv1'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'srv2' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'srv2'

CRS-2672: Attempting to start 'ora.ons' on 'srv1'

CRS-2677: Stop of 'ora.scan1.vip' on 'srv2' succeeded

CRS-2672: Attempting to start 'ora.scan1.vip' on 'srv1'

CRS-2676: Start of 'ora.scan1.vip' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'srv1'

CRS-2676: Start of 'ora.ASMIBNETLSNR_ASM.lsnr' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'srv1'

CRS-2676: Start of 'ora.ons' on 'srv1' succeeded

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'srv1' succeeded

CRS-2676: Start of 'ora.asm' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.DATA.dg' on 'srv1'

CRS-2672: Attempting to start 'ora.FRA.dg' on 'srv1'

CRS-2676: Start of 'ora.DATA.dg' on 'srv1' succeeded

CRS-2676: Start of 'ora.FRA.dg' on 'srv1' succeeded

CRS-2676: Start of 'ora.qosmserver' on 'srv1' succeeded

CRS-6016: Resource auto-start has completed for server srv1

CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources

CRS-4123: Oracle High Availability Services has been started.

2021/04/06 18:18:25 CLSRSC-343: Successfully started Oracle Clusterware stack

2021/04/06 18:18:25 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

clscfg: EXISTING configuration version 5 detected.

clscfg: version 5 is 12c Release 2.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

2021/04/06 18:20:26 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

PRCR-1013 : Failed to start resource ora.LISTENER.lsnr

PRCR-1064 : Failed to start resource ora.LISTENER.lsnr on node srv1

CRS-5016: Process "/u01/app/12.2.0/grid/bin/lsnrctl" spawned by agent "ORAAGENT" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/grid/diag/crs/srv1/crs/trace/crsd_oraagent_grid.trc"

CRS-2674: Start of 'ora.LISTENER.lsnr' on 'srv1' failed

2021/04/06 18:20:44 CLSRSC-180: An error occurred while executing the command '/u01/app/12.2.0/grid/bin/srvctl start listener -n srv1'

2021/04/06 18:21:02 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@srv1 ~]#