Ed Chen Logic

PDB_PLUG_IN_VIOLATIONS, How and Why

by Ed Chen
August 3, 2023November 12, 2023

PDB_PLUG_IN_VIOLATIONS PDB_PLUG_IN_VIOLATIONS is a dictionary view for displaying incompatible information or violations about the PDB to the CDB which it plugs in. Usually, we use… Read More »

How to Resolve ORA-31619: invalid dump file

by Ed Chen
July 31, 2023August 1, 2023

ORA-31619 Saw error ORA-31619, when we tried to import data from a dump file. [oracle@test ~]$ impdp system/password@orcl full=yes directory=BACKUP2 dumpfile=full.dmp logfile=full.log ... ORA-39001: invalid… Read More »

How to Resolve ORA-31640: unable to open dump file

by Ed Chen
July 25, 2023July 26, 2023

ORA-31640 Tried to import data into the database from a dump file, but it failed with ORA-31640. Linux [oracle@test ~]$ impdp system/password@orcl full=yes directory=BACKUP2 dumpfile=full.dmp… Read More »

How to Resolve ORA-19693: backup piece already included

by Ed Chen
July 24, 2023June 26, 2023

ORA-19693 We saw error ORA-19693 when we tried to restore some archived logs from backup sets in a newly duplicated database. RMAN> catalog start with… Read More »

How to Resolve ORA-48140: the specified ADR Base directory does not exist

by Ed Chen
July 21, 2023August 14, 2023

ORA-48108 ORA-48140 ORA-48187 OSD-00002 Tried to startup a database on Windows, but it failed with several errors like ORA-48140. SQL> startup nomount; ORA-48108: invalid value… Read More »

ORADIM Create Services and Registries

by Ed Chen
July 20, 2023June 28, 2023

ORADIM In an active/passive cluster, we usually install Oracle software and configure listener in the redundant server, then stop. This is because we don't need… Read More »

How to Resolve OSD-04002: unable to open file

by Ed Chen
July 19, 2023June 19, 2023

OSD-04002 In this case, we tried to backup database to a specific location by formatting its path, but it failed with OSD-04002. RMAN> backup database… Read More »

NLS_SESSION_PARAMETERS, How and Why

by Ed Chen
July 18, 2023November 12, 2023

What is NLS_SESSION_PARAMETERS ? NLS_SESSION_PARAMETERS is a dictionary view which shows all current NLS parameters of an user's session. Let's see their values. SQL> set… Read More »

NLS_INSTANCE_PARAMETERS, How and Why

by Ed Chen
July 17, 2023November 12, 2023

What is NLS_INSTANCE_PARAMETERS ? NLS_INSTANCE_PARAMETERS is a dictionary view which shows default NLS parameters of an instance. Let's see their values. SQL> set pagesize 1000;… Read More »

NLS_DATABASE_PARAMETERS, How and Why

by Ed Chen
July 14, 2023November 12, 2023

What is NLS_DATABASE_PARAMETERS ? NLS_DATABASE_PARAMETERS is a dictionary view which shows default NLS parameters of a database. Let's see their values. SQL> set pagesize 1000;… Read More »

JavaScript is not enabled. Please enable it and reload the page.