Skip to content
Ed Chen Logo

Ed Chen Logic

To Make My Logic More Logical
  • Privacy Policy
Ed Chen Logo

Ed Chen Logic

To Make My Logic More Logical
  • Privacy Policy

How to Change DB_UNIQUE_NAME of a RAC Database

  • by Ed Chen
  • February 3, 2021January 24, 2021
In previous post, we have talked about how to change DB_NAME of a RAC database. In this post, we will talk about how to change… Read More »How to Change DB_UNIQUE_NAME of a RAC Database

How to Change DB_NAME of a RAC Database

  • by Ed Chen
  • January 30, 2021February 1, 2021
In previous post, we have talked about how to change DBID of a RAC database. In this post, we will talk about how to change… Read More »How to Change DB_NAME of a RAC Database

How to Change DBID of a RAC Database

  • by Ed Chen
  • January 27, 2021February 4, 2021
In previous post, we have talked about how to change both DB_NAME and DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about… Read More »How to Change DBID of a RAC Database

How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database

  • by Ed Chen
  • January 23, 2021January 24, 2021
In previous post, we have talked about how to change DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about how to change… Read More »How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database

How to Change DB_UNIQUE_NAME of a Single-Instance Database

  • by Ed Chen
  • January 20, 2021January 24, 2021
In previous post, we have talked about how to change DB_NAME of a single-instance database. In this post, we will talk about how to change… Read More »How to Change DB_UNIQUE_NAME of a Single-Instance Database

How to Change DB_NAME of a Single-Instance Database

  • by Ed Chen
  • January 16, 2021January 24, 2021
In previous post, we have talked about how to change DBID of a single-instance database. In this post, we will talk about how to change… Read More »How to Change DB_NAME of a Single-Instance Database

How to Change DBID of a Single-Instance Database

  • by Ed Chen
  • January 13, 2021January 23, 2021
For a duplicate database, you may want to change its Database Identifier (DBID) only in order to distinguish this one from another. For a RAC… Read More »How to Change DBID of a Single-Instance Database

How to Resolve ORA-01565: error in identifying file '?=/dbs/spfile@.ora'

  • by Ed Chen
  • January 9, 2021January 14, 2021
ORA-01565 To create a plain-text parameter file, I usually don't specify both locations of the parameter file (PFILE) or the server parameter file (SPFILE). SQL>… Read More »How to Resolve ORA-01565: error in identifying file '?=/dbs/spfile@.ora'

How to Resolve NID-00120: Database should be mounted exclusively

  • by Ed Chen
  • January 6, 2021January 22, 2021
NID-00120 NID-00120 means that the current instance does not get the exclusivity of the cluster database, so DBNEWID utility (nid) cannot change the database name… Read More »How to Resolve NID-00120: Database should be mounted exclusively

How to Resolve ORA-01730: invalid number of column names specified

  • by Ed Chen
  • January 2, 2021December 17, 2020
ORA-01730 ORA-01730 means that the number of listed columns between the target (the view) and the source (the base table) in the CREATE VIEW statement… Read More »How to Resolve ORA-01730: invalid number of column names specified
  • « Previous
  • 1
  • 2
  • 3
  • 4
  • …
  • 85
  • Next »

Search This Website

Bookmark This Page

★By Pressing Ctrl + D

Recent Posts

  • How to Resolve RMAN-03009: failure of allocate command on channel
  • How to Resolve ORA-01624: log needed for crash recovery of instance
  • How to Modify VARCHAR2 into CLOB of a Column
  • How RMAN Duplex Backup Copies
  • How RMAN Set Backup Location

Categories

Recent Comments

  • Ed Chen on 3 Steps to Make Filezilla Preserve Timestamp
  • Ed Chen on How to Resolve ORA-01861: literal does not match format string
  • Barry Marshall on 3 Steps to Make Filezilla Preserve Timestamp
  • Ummati on How to Resolve ORA-01861: literal does not match format string
  • Ed Chen on How to Resolve ORA-12560 on Windows Server

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Neve | Powered by WordPress