Tuanlp.com
  • Oracle
    • Backup&Recovery
    • Rac
    • Dataguard
    • Performance Tuning
    • Troubleshoot
  • PostgreSQL
  • MySQL
  • SQL Server
  • Data Science
    • Tableau
    • Power BI
  • Linux
    • VMware
  • Other
  • Courses
  • Linux

    Hướng dẫn xóa toàn bộ phân vùng trên linux

    by tuanlp September 30, 2023
    by tuanlp September 30, 2023

     1. Câu lệnh: dd if=/dev/zero of=/dev/sda bs=512 count=1 conv=notrunc dd if=/dev/zero of=/dev/sda wipefs -a /dev/sda

  • Monitoring

    Hướng dẫn monitor oracle database with zabbix

    by tuanlp September 30, 2023
    by tuanlp September 30, 2023

      Cài trên server 1 – installing unixodbc on zabbix server yum -y install unixODBC unixODBC-devel 2- installing instant client packages <https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html> # rpm -ivh oracle-instantclient12.1-basic-12.2.0.1.0-1.x86_64.rpm # rpm -ivh oracle-instantclient12.1-odbc-12.2.0.1.0-1.x86_64.rpm …

  • Windows

    Hướng dẫn active windows server

    by tuanlp September 30, 2023
    by tuanlp September 30, 2023

      Gia hạn thêm 180 ngày To extend the evaluation license follow the below procedure. Open an elevated command prompt. Type following command **slmgr -dlv** or **cscript.exe %windir%\system32\slmgr.vbs /dlv** you …

  • Backup&RecoveryOracle

    Hướng dẫn backup database with sử dụng Oracle Datapump

    by tuanlp September 30, 2023
    by tuanlp September 30, 2023

      1) Kiểm tra trước trong Source database: Step 1 : Kiểm tra kích thước cơ sở dữ liệu trong SOURCE: select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ( select …

  • OracleTroubleshoot

    ORA-01045 CREATE SESSION privilege logon denied

    by tuanlp September 30, 2023
    by tuanlp September 30, 2023

      🚚 When trying to connect to an Oracle database, you might run into this error: ORA-01045: user xxx lacks CREATE SESSION privilege; logon denied The reason is that the …

  • Linux

    Hướng dẫn unmount a busy device trên linux

    by tuanlp September 30, 2023
    by tuanlp September 30, 2023

     1. Câu lệnh: umount -l /PATH/OF/BUSY-DEVICE umount -f /PATH/OF/BUSY-NFS (NETWORK-FILE-SYSTEM)

  • LinuxVMware

    Hướng dẫn sửa lỗi không đăng nhập được vmware ESXi trên web dù đăng nhập được ở máy chủ

    by tuanlp September 30, 2023
    by tuanlp September 30, 2023

     Login with F2 and go to the same place where you’d restart your management network…there’s a place there to reset your password,

  • OracleTroubleshoot

    RMAN-08137: WARNING: archived log not deleted

    by tuanlp September 30, 2023
    by tuanlp September 30, 2023

    💡 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process Cause: The archive logs seems that it is not yet applied in the standby database. Select …

  • 1
  • …
  • 17
  • 18
  • 19
  • 20
  • 21
  • …
  • 37

About Me

About Me

Freelance Sys Admins

My name is Tuanlp, freelance Sys Admins in HaNoi, VietNam. Welcome to my internet journal where I started my learning journey.

Popular Posts

  • SQL message: ORA-00600: internal error code, arguments: [kdsgrp1], [], [],

    October 2, 2023
  • Tìm kiếm file và thư mục theo dung lượng

    October 1, 2023
  • Oracle Client: INS-32025: The chosen installation conflicts with software already installed in the given Oracle home

    October 1, 2023
  • Buffer busy wait in Statspack report Oracle

    September 25, 2023
  • How to install Mattermost on RHEL 8

    November 3, 2023

Categories

MySQL (1) Ubuntu (2) Uncategorized (2) SQL Server (2) Other (4) Monitoring (5) Windows (5) VMware (9) Backup&Recovery (13) Rac (14) Web Application (16) AlmaLinux (21) PostgreSQL (21) Dataguard (27) Linux (33) Performance Tuning (39) Troubleshoot (77) Oracle (180)
  • Home
  • Downloads
  • Privacy Policy
  • Contact

@2023 - All Right Reserved. Designed and Developed by Tuanlp