Serba-serbi Operating System

Windows Subsystem for Linux can use (mount): SD card USB drives CD drives (CDFS) Network drives UNC paths Local storage / drives Drives formatted as FAT, ExFAT or NTFS can be mounted in WSL. For this example, we assume the drive shows in Windows as F:\ If Windows changes the USB drive letter on a subsequent session, you need to repeat this process. The commands are typed into the Windows Subsystem for Linux Terminal. Create a mount location in WSL: $ sudo mkdir /mnt/f Mount the drive in WSL: $ sudo mount -t drvfs f: /mnt/f After this one-time setup, one can create and manipulate files from both Windows and WSL on the same drive. network storage Here we assume: networked storage is already showing in Windows under \\server\share we want to access this network storage from WSL as /mnt/share Create a mount location in WSL: $ sudo mkdir /mnt/share Mount the network share in WSL: $ sudo mount -t drvfs '\\server\share' /mnt/share

Backup / Cloning USB to Image: $ sudo dd if=/dev/sdb1 of=/home/ivanhoe/murrotal-advance.img bs=4M status=progress Restore Image to USB: $ sudo dd if=/home/ivanhoe/murrotal-advance.img of=/dev/sdb1 bs=4M status=progress

Let us see some examples and commands to change a user and group ID in Linux: To assign a new UID to user called foo, enter: # usermod -u 2005 foo To assign a new GID to group called foo, enter: # groupmod -g 3000 foo Verify that you changed UID and GID for given users with the help of ls command: # ls -l

How To Change SYS user password for oracle database instance If you have ever tried to change the SYS of a normal or ASM database instance Password, you would get errors as below : SQL> password Changing password for SYS Old password: New password: Retype new password: ERROR: ORA-00600: internal error code, arguments: [15051], [], [], [], [], [], [], [] SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME ---------------- +ASM SQL> ALTER USER sys IDENTIFIED BY [new_password] REPLACE [old_password]; ALTER USER sys IDENTIFIED BY [new_password] REPLACE [old_password] * ERROR at line 1: ORA-01109: database not open The following error also might occur: SQL> alter user sys identified by ; alter user sys identified by * ERROR at line 1: ORA-01031: insufficient privileges The reason behind these failures are – The password should be the one provided when the password file was created, also REMOTE_LOGIN_PASSWORDFILE should be se...

OPW-00005: File with same name exists - please delete or rename: Solving oracle@unknown:/u01/oracle/products/12/dbhome_1/dbs$ mv orapworcl orapworcl.bak oracle@unknown:/u01/oracle/products/12/dbhome_1/dbs$ orapwd file=$ORACLE_HOME/dbs/orapworcl password=passwordDB

ORA-12154: TNS:could not resolve the connect identifier specified: Solution Verify a TNSNames.ora file exists on the QuickConnect server By default, the TNSNames.ora file resides in <OracleInstallDirectory>\network\admin If the TNSNames.ora file does not exist, reference the following guide on how to create one: https://oracle-base.com/articles/misc/oracle-network-configuration Set the TNS_Admin environment variable if it is not set:     Navigate to Control Panel > System     Select Advanced System Settings     In the Advanced tab, select Environment Variables     Under System Variables, click New     In the Variable name text box, type TNS_ADMIN     In the Variable value text box, type the location of the TNSNames.ora file     Click OK to add the variable     Restart the server

ERROR ORACLE DB: The version 12.2.0.1.0 of the database that you are using is not a supported version or The specified user may not have sufficient privileges to perform this operation. User should have sysdba or dba privileges. Solution SQL> alter system set db_32k_cache_size = 512M scope=both;