Connect to SQL Server when you don’t know SA account or don’t have sysadmin access

Below are the steps you need to perform to grant SYSADMIN access to a user in SQL Server in case you are completely locked out. 1. Download PSexec to connect using SQL Server Management Studio using the NT Authority\System Download PsTools from https://download.sysinternals.com/files/PSTools.zip Unzip the content and copy PsExec.exe to

Determine what Linux Version

4 different commands that you can run to see information about your Linux distro. [oracle@server ~]$ cat /etc/issueOracle Linux Server release 6.8 [oracle@server ~]$ cat /etc/*releaseLSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarchOracle Linux Server release 6.8NAME=”Oracle Linux Server”VERSION=”6.8″ID=”ol”VERSION_ID=”6.8″PRETTY_NAME=”Oracle Linux Server 6.8″ANSI_COLOR=”0;31″CPE_NAME=”cpe:/o:oracle:linux:6:8:server”HOME_URL=”https://linux.oracle.com/”BUG_REPORT_URL=”https://bugzilla.oracle.com/”ORACLE_BUGZILLA_PRODUCT=”Oracle Linux 6″ORACLE_BUGZILLA_PRODUCT_VERSION=6.8ORACLE_SUPPORT_PRODUCT=”Oracle Linux”ORACLE_SUPPORT_PRODUCT_VERSION=6.8Red Hat Enterprise Linux Server release 6.8 (Santiago)Oracle Linux Server release 6.8 Kernel

Create Data Guard standby using RMAN

Production server – serverProdStandby server – serverStbyProduction database – whseprodStandby database – whsestby Step 1: Using RMAN, Backup the database that includes backup of datafiles, archivelogs and controlfile for standby [oracle@serverProd]$ rman target / connected to target database: whseprod (DBID=123322) RMAN> run { allocate channel disk1 type disk format ‘/backup/whseprod_restore/%d%U’