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

    Change network interface and subnet address by OIFCFG command in RAC Environment

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

     Oracle Clusterware requires that each node is connected through a private network. You can also called cluster interconnect. It used for established communication between all the nodes present in the …

  • OracleRac

    Restore the OCR on Linux or Unix in Oracle RAC

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

     Restoring the Oracle Cluster Registry on Linux or UNIX Systems If OCR is failed then first check with OCRCHECK command before start restoring the OCR disk Note: If OCR location …

  • OracleRac

    Restore the OCR on Windows system in Oracle RAC

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

      Backup and Restore the OCR on Windows system in Oracle RAC Restoring the Oracle Cluster Registry on Windows SystemsIf OCR is failed then first check with OCRCHECK command before …

  • OracleTroubleshoot

    ORA-01154: database busy. Open, close, mount, and dismount not allowed

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

     Normal database environment If database is giving following message then you can use shutdown abort and startup it again. If not fixed then you can use shutdown abort commandShutdown abort …

  • OracleTroubleshoot

    ORA-00257: archiver error. Connect internal only, until freed.

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

     Error: On checking the alert log we found the following error in alert log: ORA-00257: archiver error. Connect internal only, until freed.ORORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 904507904 …

  • OracleTroubleshoot

    ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n

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

     Error: When i tried to set the log_archive dest value then i got the following error:SQL> ALTER SYSTEM SET log_archive_dest=’D:oraclexe’;ALTER SYSTEM SET log_archive_dest=’D:oraclexe’*ERROR at line 1:ORA-02097: parameter cannot be modified …

  • OracleTroubleshoot

    ORA-27101: shared memory realm does not exist

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

     Issue When i tried to connect with the database then i got the following error.ORA-27101: shared memory realm does not exist ErrorSQL*Plus: Release 12.1.2 – Production on Mon May 07 …

  • Backup&RecoveryOracle

    Restore pluggable database from RMAN CDB backup in Oracle

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

      Restore Pluggable database with RMAN Advisory Recover the Pluggable database with RMAN advisory from CDB completed backup in Oracle. Error:SQL> alter pluggable database pdb3 open;alter pluggable database pdb3 open*ERROR …

  • 1
  • …
  • 31
  • 32
  • 33
  • 34
  • 35
  • …
  • 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