Bright DBA

ORACLE DBA – Tips and Techniques

Skip to content
  • Home
  • DBA Monitor
    • OS
    • DATABASE
    • NETWORK
    • STORAGE
  • DB-Generic
    • DB-Install
      • Install 10g
      • Install Oracle Software in silent mode 11gR2
      • Deinstall Oracle 11gR2 Database binaries
      • Uninstall Oracle Client on Windows
      • Create database -DBCA silent mode
      • Delete database -DBCA silent mode
      • Drop Database
      • Patch Terminology
    • DB-Admin
      • How to change SQL  prompt to show connected user and database name
      • Change Archive Dest
      • Enable Archivelog
      • How to Recover Loss of DATA – (Without a Backup!)
      • Configure OEM DBConsole manually
      • Proxy User
      • Database Link
      • DBMS_SCHEDULER
      • Enable/Disable JOBS during Maintenance
      • ORA-00054
      • Blocking Sessions
      • Create Service using DBMS_SERVICE
      • Error TNS-12543
      • Store DB credentials in Oracle Wallet
      • Under Edit
  • BACKUP
    • BACKUP ORACLE HOME AND INVENTORY
    • EXP/IMP
    • Datapump
      • SCHEMA REFRESH FROM 11G TO 12C PDB
    • RMAN
      • CATALOG
      • RMAN Database Restore RAC – RAC
      • RMAN Database Restore ASM – ASM
      • RMAN Database Restore from ASM to File System
      • RMAN ACTIVE DUPLICATION ASM TO ASM
      • Backup Based RMAN Duplicate Database
  • PT
    • Tuning Stage 1
      • Statistics
      • Oracle Histograms
      • Export/Import schema statistics
      • CONTROL MANAGEMENT PACK ACCESS
      • Generate Explain Plan
      • SQL Query is really hanged or not
    • Tuning Stage 2
      • STATSPACK
      • ASH
      • AWR
      • Colored SQL_ID
      • SYSAUX Tablespace
    • Tuning Stage 3
      • Troubleshooting Long Running Queries
      • SQL Tuning Advisor
      • SQLT
        • How to Install SQLT
        • How to Run SQLT
        • How to Create Custom SQL Profile
        • Uninstall SQLT
      • Tracing
      • TRCA – Trace Analyzer
  • HA
    • DG 11g
      • CONFIGURATION
        • Active Dataguard on Non-ASM
        • Active Dataguard on ASM
        • Convert Physical Standby Database to Snapshot Standby Database
        • Convert Snapshot Standby database to Physical Standby database
        • Configure Cascading Standby Database
        • DG Broker Configuration
        • DG Broker Error – ORA-16714
        • Disable DG Broker
      • SWITCHOVER
        • Switchover Manual No-Broker
        • Switchover with Broker
      • FAILOVER
        • Failover with Broker(No Flashback)
        • Failover with No Broker (No Flashback)
        • Failover with Broker using Flashback
        • Failover with No Broker using Flashback
      • Enable Real-Time Apply
      • Apply DB PSU on Standby
      • Refresh Standby Database using RMAN Incremental SCN Backup
      • Resetlogs on Primary where Standby in place
      • Drop SRL
    • DG 12c
      • 12.2 Active Dataguard in CDB on Non-ASM
      • Create Physical Standby using RMAN Backup Without Duplicate Command
      • Create Physical Standby using RMAN Backup with Duplicate Command
      • 12c DG Broker Configuration
      • Upgrade Database to 12.2 with Physical Standby
    • ASM
      • Move ASM Spfile to diff. DiskGroup
      • ASM Commands
      • Instantiating disk: failed
      • CSSD won’t start automatically
  • RAC
    • RAC Install
      • RAC Install 11.2.0.3
      • Upgrade GI to 11.2.0.4
      • Downgrade GI to 11.2.0.3
      • root.sh failed with ORA-29783 on RAC
      • Delete Node
      • Add Node
      • Delete Node without remove software
      • Add Node Back which was DELETED without remove software
    • RAC Admin
      • How to take OCR backup on 11.2.0.4
      • Cluster Name
      • Move/Relocate OCR
      • Restore loss of all VOTE disk
      • Cluster Startup issues
      • Add SCAN
    • RAC Tools
      • CLUVFY
      • OSWatcher
    • RAC Standby 12.2
    • Create ACFS File System on RAC
  • GG
    • GG 11g
      • GoldenGate Installation
      • Unidirectional DML Replication
      • Zero Downtime Migration
      • DDL Replication
    • GG 12C
      • GoldenGate 12C Installation
      • Integrated Capture
      • Oracle GoldenGate Heterogeneous Replication
      • Credential Store
      • ADD NEW TABLE TO AN EXISTING GOLDENGATE CONFIGURATION
    • GG 19C
      • Install Oracle GoldenGate 19C for Database 12C
      • Install Oracle GoldenGate 19C for Database 19C
  • 12c/18c/19c
    • Install 12.2 Database Binaries in silent mode
    • Upgrade DB Manually 11.2.0.4 to 12.2.0.1
    • Upgrade DB using DBUA from 11.2.0.4 to 12.2.0.1
    • CREATE PDB USING SEED
    • CREATE NEW PDB BY CLONING AN EXISTING PDB
    • CREATE PDB USING DBCA
    • DROP PDB MANUALLY
    • Configure OEM Express 12c
    • CREATE NON-CDB ON ORACLE 12C IN SILENT MODE
    • Create Non-CDB on Oracle 12c using DBCA (GUI)
    • Convert Non-CDB to PDB with DBMS_PDB
    • SCHEMA REFRESH FROM 11G TO 12C PDB
    • STARTUP/SHUTDOWN CDB AND PDB
    • Apply RU on DATABASE 12.2
    • ROLLBACK RU from DATABASE 12.2
    • How to Change MAX_STRING_SIZE on Physical Standby Environment
    • 18C
      • Install 18c
      • Deinstall Oracle 18c Database Binaries
      • 18c DB Patching
    • Install 19c GUI
    • Install 19c in silent mode
    • Oracle 19c Deinstall
    • Create DB 19C – DBCA-GUI
    • Create DB 19C – DBCA-SILENT
    • Apply Patch RU on Database 19c
    • Upgrade Oracle Database from 12.2.0.1 to 19c using DBUA
    • Upgrade Oracle Database Manually from 12.2.0.1 to 19c
    • Rolling Upgrade With an Existing Physical Standby Database
    • Upgrade TIMEZONE Version
  • Scripts
    • DBA Sheet v6.1
    • DBA Sheet v7.0
    • DBA Daily Report
  • EM
    • Install OEM 13.2
    • Install OEM 13.3
    • Add Targets Manually on EM Cloud Control 13c
    • Upgrade OMSPatcher
    • Apply Patch on OMS 13.1
    • Apply Patch on Agent 13.1
  • MS SQL
  • MySQL/MariaDB
  • PostgreSQL
    • Install PostgreSQL 13 using yum Repository on Linux
    • Install PostgreSQL Using Source Code
    • How to START/STOP PostgreSQL 13 on Linux
    • Create Database in PostgreSQL
  • DB2
    • Install DB2 V10.5 using GUI
  • YouTube

Create Windows Authentication Login

How to create Windows Authentication Login in SQL Server

Table of Contents
___________________________________________________________________________________________________

1. Prerequisites
2. Using SSMS (GUI)
3. Using T-SQL
___________________________________________________________________________________________________


1. Prerequisites

The user must be exist in Active Directory




2. Using SSMS (GUI)

























3. Using T-SQL

USE [master]
GO
CREATE LOGIN [SQL\david] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO



Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

New Notes – Rajasekhar Amudala

  • DBA Sheet v6.1
  • DATABASE
  • NETWORK
  • How To Configure MySQL Master-Slave Replication?
  • Install DB2 V10.5 using GUI

Categories – Rajasekhar Amudala

  • Install
  • RMAN
  • Dataguard
  • ASM
  • RAC
  • DB Generic
  • GoldenGate
  • Tuning
  • 12C
  • Linux
  • SQL Server
  • EM
  • 19C
  • MySQL
  • PostgreSQL
About me - Rajasekhar Amudala