Migrating Oracle 10g to SQLServer 2016 by SSMA for Oracle
Migrating Oracle 10g to SQLServer 2016 by SSMA for Oracle ・ sql-server-2016.pdf?8618 Situation Oracle 10.2.0.3 32bit SQLServer 2016 Migrate database Download and install SSMA for Oracle. Create report. Validate data types. Convert schema. Synchronize with Database. Migrate Data. Errors SSMA 连接 Oracle 10.2.0.3 数据库时出现如下报错： ORA-01017 Invalid Username/Password; Logon Denied Workaround: 采用连接串方式，可正常连接。 Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.7)(PORT=1521))(CONNECT_...
Deploying SQLServer 2016 Failover Cluster on Windows Server 2016
Deploying SQLServer 2016 Failover Cluster on Windows Server 2016 数据库安装包： cn_sql_server_2016_enterprise_with_service_pack_1_x64_dvd_9538279.iso 数据库补丁： SQLServer2016SP2-KB4052908-x64-CHS.exe 数据库管理工具： SSMS-Setup-CHS-18.8.exe R Open / R Server 程序包： SRO_3.2.2.15000_1033.cab SRS_8.0.3.15000_1033.cab JRE 软件包（Polybase） jre-7u80-windows-x64.exe Installing failover cluster AD: 【添加角色和功能】-【Active Dirctory 域服务】 【添加角色和功能】-【DNS 服务器】 Node: 【添加角色和功能】-【故障转移群集】 【JRE 7u51 x64 or latest】 架构如下：...
How to reset root password in Solaris 11.2
How to reset root password in Solaris 11.2 Step 1: Boot from the Oracle Solaris media. Step 2: Import the root pool. Import the root pool, Mostly the pool name for root file system is rpool. zpool import -f rpool Step 3: Mount the boot environment. a. Create a mount point for the boot environment. mkdir /a b. Check for the boot environments available. beadm list c. Mount the boot environment(in our case solaris-1) on the mount point /a. beadm mount solaris-1 /a Step 3: Remove the root pass...
Upgrading from RHEL 6 to RHEL 7
Upgrading from RHEL 6 to RHEL 7
How to resize disk capacity while replacing disk in asm diskgroup
How to resize disk capacity while replacing disk in asm diskgroup SYMPTOMS The new disk and old disk do not have equal size. ORA-15410: Disks in disk group OCRDG do not have equal size. SOLUTION Determine the capacity of the new disk and the old disk. SQL> select name,os_mb,total_mb,free_mb,hot_used_mb,cold_used_mb,sector_size from v$asm_disk; new disk less than old disk. SQL> alter diskgroup ocrdg resize disk OCRDG_0000 size 5119M, OCRDG_0001 size 5119M, OCRDG_0002 size 5119M;SQL&...
How to Install Mesa Drivers on Ubuntu
How to Install Mesa Drivers on Ubuntu Qemu start with a Mesa error. sakura@sakurayumeno:~$ sudo qemu-system-x86_64 -m 4G -smp 4 -cpu host -usb -device usb-tablet -boot d -enable-kvm -drive file=/mnt/e/Downloads/Edgeless_Beta_4.1.0.iso,media=cdrom -device virtio-gpu-pci[sudo] password for sakura:error: XDG_RUNTIME_DIR is invalid or not set in the environment.MESA: error: ZINK: failed to choose pdevglx: failed to create drisw screen Install the latest stable version of Mesa driver. glxinfo | g...
How to do a Release Upgrade on Linux System
How to do a Release Upgrade on Linux System FedoraUbuntuSystem upgrade is only officially supported and tested over 2 releases at most (e.g. from 38 to 40). When upgrading across more than two releases, you may need to import the GPG key for the release you want to update to. You can do this with: sudo rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-N-primary # Performing system upgradesudo dnf -y install dnf-plugin-system-upgrade # require plugin for DNF4sudo dnf --refresh upgradesudo dnf...
How to Repair Corrupted XFS Filesystem with xfs_repair
How to Repair Corrupted XFS Filesystem with xfs_repair Our partition is now successfully mounted as an xfs partition. Next, we are going to simulate filesystem corruption by trashing random filesystem metadata blocks using the xfs_db command. ~]$ sudo mount | grep /dev/sdb1~]$ sudo umount /dev/sdb1~]$ sudo xfs_db -x -c blockget -c "blocktrash -s 512109 -n 1000" /dev/sdb1 Before we embark on repairing the filesystem, we can perform a dry run using the -n flag as shown. A dry run provides a pe...
Oracle Database Automatic Install Scripts
Oracle Database Automatic Install Scripts For 11g single instance ・ installDB11g_SI.sh
p31537677_112040_Linux-x86-64
p31537677_112040_Linux-x86-64 Patch 31537677 - Oracle Database Patch Set Update 11.2.0.4.201020 ・ p31537677_112040_Linux-x86-64_README Record Upgrade the OPatch utility version 11.2.0.3.23 or later to apply this patch. ~]# mv $ORACLE_HOME/OPatch{,.bak.`date +%Y%m%d`}~]# unzip -q -d $ORACLE_HOME /soft/p6880880_112000_Linux-x86-64_11.2.0.3.31.zip~]# chown -R oracle:oinstall $ORACLE_HOME/OPatch~]# su - oracle -c "$ORACLE_HOME/OPatch/opatch version"OPatch Version: 11.2.0.3.31OPatch succeeded....
