Sunday, 6 July 2025

PRKO-2012 : filesystem object is not supported in Oracle Restart

 

Subject:      ACFS not supported in Oracle Restart on 19c 

Error

 [oracle@asm-node01 ~]$ srvctl status filesystem -d /dev/asm/ggdisk-457

Usage: srvctl <command> <object> [<options>]

    commands: enable|disable|start|stop|status|add|remove|modify|update|getenv|setenv|unsetenv|config|upgrade|downgrade

    objects: database|service|asm|diskgroup|listener|home|ons|oraclehome

For detailed help on each command and object and its options use:

  srvctl <command> -help [-compatible] or

  srvctl <command> <object> -help [-compatible]

PRKO-2012 : filesystem object is not supported in Oracle Restart


Solution

[root@asm-node01 dev]# /bin/mount -t acfs /dev/asm/ggdisk-457 /u01/app/GG


Note: You can add this script to the root crontab after reboot. ACFS will mount the given directory 



acfsutil version: CLSU-00107: operating system function: open64; failed with error data: 2; at location: OOF_1

 

Error

[grid@asm-node01 ~]$ acfsutil version

acfsutil version: CLSU-00107: operating system function: open64; failed with error data: 2; at location: OOF_1

acfsutil version: CLSU-00101: operating system error message: No such file or directory

acfsutil version: CLSU-00104: additional error information: open64 (/dev/ofsctl)

acfsutil version: ACFS-00502: Failed to communicate with the ACFS driver.  Verify the ACFS driver has been loaded.

Solution

[root@asm-node01 init.d]# cd /u01/app/19.0.0/grid/bin

[root@asm-node01 bin]# ./acfsroot install
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9314: Removing previous ADVM/ACFS installation.
Use of uninitialized value $sub_command in string eq at /u01/app/19.0.0/grid/lib/osds_acfsroot.pm line 1749.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9294: updating file /etc/sysconfig/oracledrivers.conf
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9294: updating file /etc/sysconfig/oracledrivers.conf
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9298: Installing SELinux policy for ACFS.
ACFS-9297: Creating ACFS SELinux policy file /usr/share/oracleacfs/acfs.cil.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9154: Loading 'oracleoks.ko' driver.
ACFS-9154: Loading 'oracleadvm.ko' driver.
ACFS-9154: Loading 'oracleacfs.ko' driver.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.
ACFS-9156: Detecting control device '/dev/ofsctl'.
ACFS-9309: ADVM/ACFS installation correctness verified.

[root@asm-node01 bin]# ./acfsroot install -v

ACFS-9505: Using acfsutil executable from location: '/u01/app/19.0.0/grid/usm/install/cmds/bin/acfsutil'
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9314: Removing previous ADVM/ACFS installation.
Use of uninitialized value $sub_command in string eq at /u01/app/19.0.0/grid/lib/osds_acfsroot.pm line 1749.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9294: updating file /etc/sysconfig/oracledrivers.conf
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9503: ADVM and ACFS driver media location is '/u01/app/19.0.0/grid/usm/install/Oracle/EL8UEK/x86_64/5.4.17-2011.0.7/5.4.17-2011.0.7-x86_64/bin'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/Oracle/EL8UEK/x86_64/5.4.17-2011.0.7/5.4.17-2011.0.7-x86_64/bin/oracleadvm.ko' to the path '/lib/modules/5.4.17-2136.307.3.1.el8uek.x86_64/extra/usm/oracleadvm.ko'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/Oracle/EL8UEK/x86_64/5.4.17-2011.0.7/5.4.17-2011.0.7-x86_64/bin/oracleoks.ko' to the path '/lib/modules/5.4.17-2136.307.3.1.el8uek.x86_64/extra/usm/oracleoks.ko'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/Oracle/EL8UEK/x86_64/5.4.17-2011.0.7/5.4.17-2011.0.7-x86_64/bin/oracleacfs.ko' to the path '/lib/modules/5.4.17-2136.307.3.1.el8uek.x86_64/extra/usm/oracleacfs.ko'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/advmutil' to the path '/sbin/advmutil'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/advmutil.bin' to the path '/sbin/advmutil.bin'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/fsck.acfs' to the path '/sbin/fsck.acfs'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/fsck.acfs.bin' to the path '/sbin/fsck.acfs.bin'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/mkfs.acfs' to the path '/sbin/mkfs.acfs'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/mkfs.acfs.bin' to the path '/sbin/mkfs.acfs.bin'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/mount.acfs' to the path '/sbin/mount.acfs'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/mount.acfs.bin' to the path '/sbin/mount.acfs.bin'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/acfsdbg' to the path '/sbin/acfsdbg'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/acfsdbg.bin' to the path '/sbin/acfsdbg.bin'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/acfsutil' to the path '/sbin/acfsutil'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/acfsutil.bin' to the path '/sbin/acfsutil.bin'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/umount.acfs' to the path '/sbin/umount.acfs'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/umount.acfs.bin' to the path '/sbin/umount.acfs.bin'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/usm/install/cmds/bin/acfssihamount' to the path '/etc/init.d/acfssihamount'
ACFS-9504: Copying file '/u01/app/19.0.0/grid/lib/libacfs19.so' to the path '/opt/oracle/extapi/64/acfs/orcl/1/'
ACFS-9294: updating file /etc/sysconfig/oracledrivers.conf
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9298: Installing SELinux policy for ACFS.
ACFS-9297: Creating ACFS SELinux policy file /usr/share/oracleacfs/acfs.cil.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9154: Loading 'oracleoks.ko' driver.
ACFS-9154: Loading 'oracleadvm.ko' driver.
ACFS-9154: Loading 'oracleacfs.ko' driver.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.
ACFS-9156: Detecting control device '/dev/ofsctl'.
ACFS-9309: ADVM/ACFS installation correctness verified.
[root@asm-node01 bin]#

Friday, 27 June 2025

make: perl: Command not found make: *** [ins_rdbms.mk:573: javavm_refresh] Error 127 '

 Error: 

Patching component oracle.javavm.client, 19.0.0.0.0...

Make failed to invoke "/usr/bin/make -f ins_rdbms.mk javavm_refresh ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1 OPATCH_SESSION=napply"....'make: perl: Command not found

make: *** [ins_rdbms.mk:573: javavm_refresh] Error 127

Solution

check perl install on you system or not 

[root@asm-node01 ~]# dnf/yum/rpm  list installed | grep perl

[root@asm-node01 ~]#

[root@asm-node01 ~]# dnf/yum install perl

Note: as per the lmux version use yum or DNF to install Perl package 

[grid@asm-node01 37262208]$ export PATH=$ORACLE_HOME/perl/bin:$PATH

[grid@asm-node01 37262208]$ export PERL5LIB=$ORACLE_HOME/perl/lib


ORA-12547: TNS:lost contact CRS-2675: Stop of 'ora.***.db' on '01' failed

 Issue

[oracle@asm-node01 ~]$ srvctl stop database -db DB19c

PRCD-1334 : failed to stop database DB19c

PRCD-1124 : Failed to stop database DB19c and its services

PRCD-1131 : Failed to stop database DB19c and its services on nodes

PRCR-1133 : Failed to stop database DB19c and its running services

PRCR-1132 : Failed to stop resources using a filter

ORA-12547: TNS:lost contact

CRS-2675: Stop of 'ora.db19c.db' on 'asm-node01' failed


Solution

[oracle@asm-node01 ~]$ cd $ORACLE_HOME/bin
[oracle@asm-node01 bin]$ ls -ltr oracle
-rwxrwxr-x. 1 oracle asmadmin 441173504 Jun 25 16:55 oracle
[oracle@asm-node01 bin]$ chmod 6751 oracle
[oracle@asm-node01 bin]$ ls -ltr oracle
-rwsr-x--x. 1 oracle asmadmin 441173504 Jun 25 16:55 oracle

--> Stop the database service using SRVCTL 

[oracle@asm-node01 ~]$ srvctl stop database -db DB19c
[oracle@asm-node01 ~]$ srvctl statUS database -db DB19C

Sunday, 22 June 2025

The instance '****.**.**:3306' cannot be added to an InnoDB cluster because it has asynchronous (source-replica) replication channel(s) configured. MySQL InnoDB Cluster

  Error

  MySQL  JS > dba.checkInstanceConfiguration("root@192.*.*.*")

 NOTE: Found unexpected replication channel '' at ****.**.**:3306:3306

WARNING: The instance '****.**.**:3306' cannot be added to an InnoDB cluster because 

it has asynchronous (source-replica) replication channel(s) configured. MySQL InnoDB Cluster 

does not support manually configured channels as they are not managed using the AdminAPI (e.g. when PRIMARY moves to another member)

which may cause cause replication to break or even create split-brain scenarios (data loss).

Solution: 

         mysql> STOP REPLICA;

mysql> RESET REPLICA  ALL;

RE-execute : 

           MySQL  JS > dba.checkInstanceConfiguration("root@192.168.94.133")

A replica with the same server_uuid/server_id as this replica has connected to the source

 Error: 

 Last_IO_Error: Got fatal error 1236 from source when reading data from binary log: 

 'A replica with the same server_uuid/server_id as this replica has connected to the source;

 the first event 'ON.000014' at 277, the last event read from './ON.000014' at 479, the last byte read from 

 './ON.000014' at 479.'


 Solution: 

      - Stop mysql service 

 [root@node02 ~]# systemctl stop mysqld

      - Go to mysql server database directory and take the backup 

 [root@node02 mysql]# pwd

       /var/lib/mysql

  [root@node02 mysql]# mv auto.cnf auto.cnf_bkp

  [root@node02 mysql]#

  - Start mysqld service 

 [root@node02 ~]# systemctl start  mysqld

Thursday, 5 June 2025

Upgrade MySQL Commercial Edition from 8.4.5 to 9.3.0 on Oracle Linux 8.0

 

Topic: Upgrade MySQL Commercial Edition from 8.4.5 to 9.3.0 on Oracle Linux 8.0 

 

Upgrade in MySQL generally refers to updating the MySQL Cluster (Server) to a newer version, either a minor or major release, to benefit from bug fixes, new features, and performance enhancements. It also involves using the mysql_upgrade script to ensure your database schemas are compatible with the updated server.

In MySQL, the first two numbers of the version number represent the major version, while the last number indicates the minor version. A major version bump usually signifies incompatible changes or a new major feature set, while a minor version update typically introduces new features or bug fixes while maintaining backward compatibility.

 

Implementation Diagram:

 

 

Infrastructure Diagram:

OS Details

Host Name

Database Version

ORACLE_HOME

RHEL release 8.10 (Ootpa)

mysql-se.example.com

8.4.5

/var/lib/mysql

 

OS Details

Host Name

Database Version

ORACLE_HOME

RHEL release 8.10 (Ootpa)

mysql-se.exampl.com

9.3.0

/var/lib/mysql

 

In this QuickStart, we learn how to:

  • Check the current version of MySQL
  • Check the backup status
  • Check the MySQL edition upgrade matrix
  • Download and stage the new version of MySQL
  • Install MySQL shell from the new binaries
  • Perform the Pre-check using MySQL Shell
  • Set the DNF repo for the new MySQL version rpm
  • stop the MySQL service
  • Upgrade and install the new version mysql using DNF
  • start the MySQL service
  • Connect to the MySQL cluster and validate the version
  • Validation

 

Step 01: Check the current version of MySQL

[mysql@mysql-se ~]$ mysql --version

Step 02: Check the backup status

-          Check full backup status. If needed, then take a full backup of the MySQL cluster

 

Step 03: Check the MySQL commercial edition upgrade path

 

 

 

Step 04: Download and stage the new version of MySQL

 

[root@mysql-se tmp]# pwd

/tmp

[root@mysql-se tmp]# ls -ltr *.tar

-rw-r--r--. 1 root root 817848320 Jun  5 13:12 mysql-enterprise-9.3.0_el8_x86_64_bundle.tar

[root@mysql-se tmp]#

 

Step 05: Install MySQL shell from the new binaries

 

[root@mysql-se mysql-9.3.0]# pwd

/tmp/mysql-9.3.0

[root@mysql-se mysql-9.3.0]# ls -ltr *shell*

-rw-r--r--. 1 7155 31415 119818132 Mar 19 08:02 mysql-shell-commercial-9.3.0-1.1.el8.x86_64.rpm

[root@mysql-se mysql-9.3.0]#

[root@mysql-se mysql-9.3.0]# rpm -ivh mysql-shell-commercial-9.3.0-1.1.el8.x86_64.rpm

 

[root@mysql-se mysql-9.3.0]# mysqlsh --version

 

Step 06: Perform the Pre-check using MySQL Shell

 

 


INFORMATION: The Above output shows one warning seems it is deployment environment that’s why some parameter not set properly. Now we are good to proceed the upgrade

 

 


Step 07: Set the DNF repo for the new MySQL version rpm

 

-          Before setting up the Mysql repos read the readme.txt. in readme file you will get below command

-           

[root@mysql-se mysql-9.3.0]# sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023

 

[root@mysql-se mysql-9.3.0]# yum-config-manager --add file:///tmp/mysql-9.3.0

Adding repo from: file:///tmp/mysql-9.3.0

[root@mysql-se mysql-9.3.0]#

 

Step 08: stop the MySQL service

 

[root@mysql-se mysql-9.3.0]# systemctl stop mysqld

[root@mysql-se mysql-9.3.0]# systemctl status mysqld

 

Step 09: Upgrade and install the new version mysql using DNF

 

[root@mysql-se mysql-9.3.0]# dnf upgrade  mysql-commercial-server

 

 


INFORMATION: If you get error sudo: yum-config-manager: command not found means you need to install dnf install yum-utils.

 

 


Step 10: start the MySQL service

[root@mysql-se mysql-9.3.0]# systemctl daemon-reload

[root@mysql-se mysql-9.3.0]# systemctl start  mysqld

[root@mysql-se mysql-9.3.0]# systemctl status mysqld

 

 

Step 11: Connect to the MySQL cluster and validate the version

 

[root@mysql-se mysql-9.3.0]# mysql --version

mysql  Ver 9.3.0-commercial for Linux on x86_64 (MySQL Enterprise Server - Commercial)

[root@mysql-se mysql-9.3.0]#

 

Step 12: Validation

 

[root@mysql-se mysql-9.3.0]# mysql -u root -p

 

PRKO-2012 : filesystem object is not supported in Oracle Restart

  Subject :      ACFS  not supported in Oracle Restart on 19c  Error :   [oracle@asm-node01 ~]$ srvctl status filesystem -d /dev/asm/ggdisk-...