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

    ORA-28000: the account is locked

    by tuanlp September 25, 2023
    by tuanlp September 25, 2023

      ORA-28000: the account is locked 1. Check the Status of User account in Oraclecol username for a22col account_status for a17col profile for a10Select username, account_status,profile from dba_users where username …

  • OraclePerformance Tuning

    Read of datafile ‘E:ORADATAORCLTEMP01.DBF’ (fno 201) header failed with ORA-01202

    by tuanlp September 25, 2023
    by tuanlp September 25, 2023

      Read of datafile ‘E:ORADATAORCLTEMP01.DBF’ (fno 201) header failed with ORA-01202 During the running the datapatch -verbose command for applying patch on DB, We got the following error:Queryable inventory could …

  • OraclePerformance Tuning

    SQL*Net more data to client event wait

    by tuanlp September 25, 2023
    by tuanlp September 25, 2023

      SQL*Net more data to client event wait In Oracle We generally got the wait “SQL*Net more data to client” in our performance reports. Wait event:SQL*Net data to clientSQL*Net more …

  • OracleTroubleshoot

    ORA-31641: unable to create dump file Expdp error

    by tuanlp September 25, 2023
    by tuanlp September 25, 2023

      ORA-31641: unable to create dump file Expdp error During the EXPDP backup we are getting the following error on executing the command ErrorC:Usersoracle>expdp full=y directory=dbdumpExport: Release 18.0.0.0.0 – Production …

  • OracleTroubleshoot

    ORA-04030: out of process memory when trying to allocate 4152 bytes

    by tuanlp September 25, 2023
    by tuanlp September 25, 2023

      ORA-04030: out of process memory when trying to allocate 4152 bytes (8475.kgghte,8475.kgghte) ErrorIn our case, we are getting the error in alert log during normal production timing:Mon Jan 07 …

  • DataguardOracle

    Check Dataguard found Log Switch gap status in Oracle

    by tuanlp September 25, 2023
    by tuanlp September 25, 2023

      Found Log Switch Gap status in archive dest status We are planning to switch-over the database from primary to secondary in Data guard environment. When we are checking the …

  • OraclePerformance Tuning

    Memory Paging cause Oracle database performance issue

    by tuanlp September 25, 2023
    by tuanlp September 25, 2023

      Memory Paging cause Oracle database performance issue ErrorOn checking the operating system, heavy paging is notice which degrade the performance of the Oracle Database. On unix base systemvmstat and …

  • OracleTroubleshoot

    RMAN-06429: TARGET database is not compatible with this version of RMAN

    by tuanlp September 25, 2023
    by tuanlp September 25, 2023

      RMAN-06429: TARGET database is not compatible with this version of RMAN ErrorWhile connecting with RMAN Command window getting the following errors: RMAN-06438: error executing package DBMS_RCVMAN in TARGET databaseRMAN-00571: …

  • 1
  • …
  • 34
  • 35
  • 36
  • 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