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

    AUTOMATICALLY KILL INACTIVE SESSIONS

    by tuanlp November 1, 2023
    by tuanlp November 1, 2023

    Hi, today we are going to create script which automatically kill inactive sessions in oracle database. Here i’m going to kill 15 minutes old inactive sessions. Related Keywords: oracle inactive sessions …

  • Backup&Recovery

    RMAN BACKUP SCRIPT

    by tuanlp November 1, 2023
    by tuanlp November 1, 2023

    How to automate Oracle RMAN Backup with shell script In a real environment, you obviously won’t manually trigger all of the Oracle database backups. An automated mechanism is required to …

  • Linux

    Change netplan renderer from networkd to NetworkManager

    by tuanlp October 31, 2023
    by tuanlp October 31, 2023

    How to change renderer from systemd-networkd NetworkManager First view the config file using the cat command: Sample outputs: The above config tells of bringing up the Ethernet interface named enp0s31f6 via …

  • Troubleshoot

    ORA-16086: Redo data cannot be written to the standby redo log

    by tuanlp October 30, 2023
    by tuanlp October 30, 2023

    The primary database is operating in MAXIMUM PROTECTIONor MAXIMUM AVAILABILITY mode, and the standby database doesnot contain any viable standby redo logfiles.ORA-16086: Redo data cannot be written to the standby …

  • Troubleshoot

    Recovering from the LOSS of REDO log files

    by tuanlp October 28, 2023
    by tuanlp October 28, 2023

    In the following post we’ll go through every possible scenario where we loose REDO, one by one. REDO is the most crucial part when we talk about recovery and contains …

  • Linux

    How to Configure Network Interfaces using NMCLI on Centos 7.6

    by tuanlp October 27, 2023
    by tuanlp October 27, 2023

    Preliminary Note The particularity of this command is you don’t need any requirements, however, it’s run as a root The basic format of nmcli: OBJECT could be one of these …

  • DataguardOracle

    How to Create a Physical Standby Database using Backup Pieces

    by tuanlp October 27, 2023
    by tuanlp October 27, 2023

    In this article we will learn How to create a new Physical Standby using Backup Set and also DUPLICATE in RMAN, this is a fast way to create Physical Standby …

  • Linux

    Linux Services (systemd, systemctl)

    by tuanlp October 19, 2023
    by tuanlp October 19, 2023

    Backwards Compatibility The transition to using systemd is made easier by the fact the service and chkconfig commands are still available. They have been reworked to call the equivalent systemctl commands. What’s more, they sometimes output the command …

  • 1
  • …
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • 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