Wednesday, 28 December 2022

ORA-01274: cannot add data file that was originally created as '+ADATA/CDBPR/EMOB/undotbs04.dbf

 Error In Standby Database:


22-12-28T12:33:32.063138+06:00
EMOB(7):File #581 added to control file as 'UNNAMED00581' because
EMOB(7):the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
EMOB(7):The file should be manually created to continue.
PR00 (PID:42551): MRP0: Background Media Recovery terminated with error 1274
2022-12-28T12:33:32.097676+06:00
Errors in file /d01/app/oracle/diag/rdbms/cdbdg/cdbdg/trace/cdbdg_pr00_42551.trc:
ORA-01274: cannot add data file that was originally created as '+ADATA/CDBPR/EMOB/undotbs04.dbf'
2022-12-28T12:33:32.098788+06:00
.... (PID:30028): Managed Standby Recovery not using Real Time Apply
2022-12-28T12:33:32.534498+06:00
Recovery interrupted!
2022-12-28T12:33:33.204594+06:00

Solution:

 

Perform the following steps in Standby Database

SQL> show parameter file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /d01/app/oracle/admin/cdbdg/ad
                                                 ump
control_file_record_keep_time        integer     7
control_files                        string      +ADATA/CDBDG/CONTROLFILE/curre
                                                 nt.261.1120417171, +FRA/CDBDG/
                                                 CONTROLFILE/current.260.112041
                                                 7171
db_create_file_dest                  string
db_file_multiblock_read_count        integer     128
db_file_name_convert                 string      cdbpr, cdbdg
db_files                             integer     4000

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_file                  string
db_performance_profile               string
db_recovery_file_dest                string      +FRA
db_recovery_file_dest_size           big integer 1800G
db_securefile                        string      PREFERRED
dg_broker_config_file1               string      /d01/app/oracle/product/19c/db
                                                 _1/dbs/dr1cdbdg.dat
dg_broker_config_file2               string      /d01/app/oracle/product/19c/db
                                                 _1/dbs/dr2cdbdg.dat
file_mapping                         boolean     FALSE
fileio_network_adapters              string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options                 string      asynch
ifile                                file
log_file_name_convert                string      cdbpr, cdbdg
max_dump_file_size                   string      unlimited
pdb_file_name_convert                string
remote_login_passwordfile            string      EXCLUSIVE
remote_recovery_file_dest            string
session_max_open_files               integer     10
spfile                               string      /d01/app/oracle/product/19c/db
                                                 _1/dbs/spfilecdbdg.ora
standby_file_management              string      MANUAL

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_pdb_source_file_dblink       string
standby_pdb_source_file_directory    string
tracefile_identifier                 string
SQL> alter system set standby_file_management=AUTO;

System altered.

SQL>

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            MOUNTED
         7 EMOB                           READ ONLY  NO
SQL> alter session set container=EMOB;

Session altered.

SQL> select name from v$datafile where file#=581;

NAME
--------------------------------------------------------------------------------
/d01/app/oracle/product/19c/db_1/dbs/UNNAMED00581

SQL>


SQL> alter database recover managed standby database cancel;
alter database recover managed standby database cancel
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active


-bash-5.1$ sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 28 12:46:33 2022
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> alter system set standby_file_management=MANUAL;

System altered.

SQL> alter session set container=EMOB;

Session altered.

SQL> alter database create datafile '/d01/app/oracle/product/19c/db_1/dbs/UNNAMED00581' as  '+ADATA/cdbdg/emob/undotbs04.dbf';

Database altered.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0
-bash-5.1$ sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 28 12:47:16 2022
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> alter system set standby_file_management=AUTO;

System altered.

SQL>


SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL>

Sunday, 6 November 2022

CRS-6706: After Grid Infrastructure upgrade from 19.3 to 19.14

Error:

root@absdg1:~# /d01/app/19c/grid/bin/crsctl start has
CRS-6706: Oracle Clusterware Release patch level ('2965637783') does not match Software patch level ('2676783881'). Oracle Clusterware cannot be started.
CRS-4000: Command Start failed, or completed with errors.
root@absdg1:~#

Solution:


root@absdg1:~# /d01/app/19c/grid/bin/clscfg -localpatch
clscfg: EXISTING configuration version 0 detected.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
root@absdg1:~#

root@absdg1:~# /d01/app/19c/grid/cr
crf/ crs/
root@absdg1:~# /d01/app/19c/grid/crs/install/rootcrs.sh -lock
Using configuration parameter file: /d01/app/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /d01/app/grid/crsdata/absdg1/crsconfig/crslock_absdg1_2022-11-06_03-56-05PM.log
2022/11/06 15:56:09 CLSRSC-329: Replacing Clusterware entries in file '/etc/inittab'
root@absdg1:~#


root@absdg1:~# /d01/app/19c/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.
You have new mail in /var/mail/root

root@absdg1:~# /d01/app/19c/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  OFFLINE      absdg1                   STABLE
ora.MGMT.GHCHKPT.advm
               OFFLINE OFFLINE      absdg1                   STABLE
ora.helper
               OFFLINE OFFLINE      absdg1                   IDLE,STABLE
ora.mgmt.ghchkpt.acfs
               OFFLINE OFFLINE      absdg1                   STABLE
ora.net1.network
               ONLINE  ONLINE       absdg1                   STABLE
ora.ons
               ONLINE  OFFLINE      absdg1                   STABLE
ora.proxy_advm
               OFFLINE OFFLINE      absdg1                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  OFFLINE                               STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  OFFLINE                               STABLE
ora.MGMT.dg(ora.asmgroup)
      1        ONLINE  OFFLINE                               STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.MGMTLSNR
      1        ONLINE  OFFLINE                               169.254.23.178 10.64
                                                             .171.50,STABLE
ora.OCRVOTE.dg(ora.asmgroup)
      1        ONLINE  OFFLINE                               STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.absdg1.vip
      1        ONLINE  OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  INTERMEDIATE absdg1                   Started,STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       absdg1                   STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  OFFLINE                               STABLE
ora.mgmtdb
      1        ONLINE  OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.qosmserver
      1        ONLINE  OFFLINE                               STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  OFFLINE                               STABLE
--------------------------------------------------------------------------------
root@absdg1:~#

Tuesday, 31 May 2022

openssl: error while loading shared libraries: libssl.so.1.1: cannot open shared object file: No such file or directory

 [root@ISTELAR-DR ~]# openssl -version
openssl: error while loading shared libraries: libssl.so.1.1: cannot open shared object file: No such file or directory
[root@ISTELAR-DR ~]# ll /usr/lib64/libssl*
-rwxr-xr-x 1 root root 339232 Oct  9  2018 /usr/lib64/libssl3.so
lrwxrwxrwx 1 root root     16 Sep 16  2019 /usr/lib64/libssl.so -> libssl.so.1.0.1e
-rwxr-xr-x 1 root root 324456 Mar  9  2016 /usr/lib64/libssl.so.0.9.8e
lrwxrwxrwx 1 root root     16 Sep 16  2019 /usr/lib64/libssl.so.10 -> libssl.so.1.0.1e
-rwxr-xr-x 1 root root 446344 Aug 13  2019 /usr/lib64/libssl.so.1.0.1e
lrwxrwxrwx 1 root root     16 Apr 23  2018 /usr/lib64/libssl.so.6 -> libssl.so.0.9.8e
[root@ISTELAR-DR ~]# echo $LD_LIBRARY_PATH

[root@ISTELAR-DR ~]# ll /usr/local/liblibssl*
lib/     lib64/   libexec/
[root@ISTELAR-DR ~]# ll /usr/local/lib64/libssl*
-rw-r--r-- 1 root root 1024502 May 31 19:01 /usr/local/lib64/libssl.a
lrwxrwxrwx 1 root root      13 May 31 19:01 /usr/local/lib64/libssl.so -> libssl.so.1.1
-rwxr-xr-x 1 root root  684412 May 31 19:01 /usr/local/lib64/libssl.so.1.1
-rwxr-xr-x 1 root root  766712 May 31 18:52 /usr/local/lib64/libssl.so.3
[root@ISTELAR-DR ~]# export LD_LIBRARY_PATH = /usr/local/lib64:$LD_LIBRARY_PATH
-bash: export: `=': not a valid identifier
-bash: export: `/usr/local/lib64:': not a valid identifier
[root@ISTELAR-DR ~]# export LD_LIBRARY_PATH=/usr/local/lib64:$LD_LIBRARY_PATH
[root@ISTELAR-DR ~]# ln -s /usr/local/lib64/libssl.so.1.1 /usr/lib64/libssl.so.1.1
[root@ISTELAR-DR ~]# ln -s /usr/local/lib64/libcrypto.so.1.1 /usr/lib64/libcrypto.so.1.1
[root@ISTELAR-DR ~]# openssl -version
Invalid command '-version'; type "help" for a list.
[root@ISTELAR-DR ~]# openssl version
OpenSSL 1.1.1o  3 May 2022
[root@ISTELAR-DR ~]#
[root@ISTELAR-DR ~]#
[root@ISTELAR-DR ~]#