Dream of Mirror Ruins

WSL2 Installation dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestartdism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestartwsl --set-default-version 2wsl --install -d kali-linux Setting hyper-v launch type bcdedit /set hypervisorlaunchtype autobcdedit /set hypervisorlaunchtype off Systemd support To enable systemd, open your wsl.conf file in a text editor using sudo for admin permissions and add ...

Configure MySQL to start on boot with systemd Add a systemd service unit configuration file with details about the MySQL service $> cd /usr/lib/systemd/system$> touch mysqld.service$> chmod 644 mysqld.service Add this configuration information to the mysqld.service file [Unit]Description=MySQL ServerDocumentation=man:mysqld(7)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=my...

How to reset root password MySQL 5.7.6 and later Modify /etc/my.cnf, append skip-grant-tables. sed -i '/[mysqld]/a skip-grant-tables' /etc/my.cnf Restart mysql server, update root password. select user,host,authentication_string from mysql.user;update mysql.user set authentication_string=password('Jove!123') where user='root';flush privileges; MySQL 5.7.5 and earlier Modify /etc/my.cnf, append skip-grant-tables. sed -i '/[mysqld]/a skip-grant-tables' /etc/my.cnf Restart mysql server, updat...

Installing MySQL on Linux Using YUM Repository 5.7 # Adding the MySQL YUM Repository.sudo yum localinstall mysql57-community-release-el7-{version-number}.noarch.rpmsudo yum-config-manager --enable mysql57-community# Disabling the Default MySQL Module.sudo yum module disable mysql# Installing MySQL.sudo yum install mysql-community-server# Starting the MySQL Server.sudo systemctl enable mysqld --now# Get root temporary password in the error log file.sudo grep 'temporary password' /var/log/my...

Configuring Storage Device Path Persistence Using Oracle ASMLIB If you configure disks using Oracle ASMLIB, then you must change the disk discovery string to ORCL:. If the diskstring is set to ORCL:, or is left empty (""), then the installer discovers these disks. Installing and Configuring Oracle ASMLIB Software ・ Oracle ASMLib Software Update and Support Policy (Doc ID 1089399.1) ・ Oracle ASMLib Install kmod-oracleasm,oracleasm-support,oracleasmlib rpm package. RHEL 7: curl -o /soft/km...

Configuring Storage Device Path Persistence Using UDEV For Oracle Automatic Storage Manager (ASM) to use disks, it needs to be able to identify the devices consistently and for them to have the correct ownership and permissions. In Linux you can use ASMLib to manage these tasks, but it is seen as an additional layer of complexity and has never really gained any popularity. Instead, many people use the Linux device manager "udev" to perform these tasks. This article presents a brief overview ...

Migrate DATA ASM Diskgroup To Another Storage If necessary, modify asm_diskstring. alter system set asm_diskstring = '/dev/emcpowerc*','/dev/emcpowerh*' scope=both;select name,path from v$asm_disk; Query the fail groups. col path for a20col state for a10col failgroup for a15col name for a15select dg.name,dg.state,dg.type,d.disk_number,d.path,d.mount_status,d.failgroup,d.name,d.state from v$asm_diskgroup dg, v$asm_disk dwhere dg.group_number=d.group_number and dg.name='DATA'order by ...

Changing the Oracle Database Archive Mode Enabling Archive Mode Oracle 10g and latest SI. SQL> alter system set log_archive_dest_1='location=/oradata/orcl/archivelog' scope=spfile;SQL> shutdown immediateSQL> startup mountSQL> alter database archivelog;SQL> alter database open;SQL> alter system switch logfile; Oracle 10g and latest RAC. SQL> alter system set log_archive_dest_1='location=+ARCH' scope=spfile sid='*';~]$ srvctl stop database -d orcl~]$ srvctl start inst...

Migrate OCR ASM Diskgroup To Another Storage Query css votedisk. ~]$ crsctl query css votedisk## STATE File Universal Id File Name Disk group-- ----- ----------------- --------- ---------1. ONLINE 73e1c48069d64fefbfc44cd8e65107d8 (ORCL:OCR_VOTE1) [OCR_VOTE]Located 1 voting disk(s). Query the fail groups. col path for a20col state for a10col failgroup for a15col name for a15select dg.name,dg.state,dg.type,d.disk_number,d.path,d.mount_status,d.failgr...

Migrate OCR ASM Diskgroup To New ASM Diskgroup OCR Perform ocr backup. ~]# /u01/app/11.2.0/grid/bin/ocrconfig -manualbackuprac2 2022/05/06 09:21:54 /u01/app/11.2.0/grid/cdata/rac-cluster/backup_20220506_092154.ocr~]# /u01/app/11.2.0/grid/bin/ocrconfig -showbackupPROT-24: Auto backups for the Oracle Cluster Registry are not availablerac2 2022/05/06 09:21:54 /u01/app/11.2.0/grid/cdata/rac-cluster/backup_20220506_092154.ocr Perform ocrcheck. ~]# /u01/app/11.2.0/grid/bin/ocr...