ASM Command-Line Utility (ASMCMD)

How to Resolve ORA-01258: unable to delete temporary file

by Ed Chen
November 8, 2022March 20, 2023

ORA-01258 We successfully dropped a temporary tablespace with its all files, but we saw some errors like ORA-01258 in the alert log. SQL> drop tablespace… Read More »

How to Resolve ASMCMD-9463: operation failed due to lack of write permissions

by Ed Chen
April 22, 2022May 18, 2022

ASMCMD-9463 Tried to copy a data file out of ASM, but it failed with ASMCMD-9463. [grid@primary01 grid]$ asmcmd cp +DATA/ORCLCDB/ORCLPDB/example_01.dbf /backup/example_01.dbf ASMCMD-9463: operation failed due… Read More »

How to Resolve RMAN-06023: no backup or copy of datafile found to restore

by Ed Chen
February 25, 2022May 4, 2023
2 Comments

RMAN-06026 and RMAN-06023 There're 2 error patterns of RMAN-06023 and RMAN-06026 in this post. Target Not Found in Backup Missing Directory in ASM Target Not… Read More »

How to Resolve ORA-65016: FILE_NAME_CONVERT

by Ed Chen
September 3, 2021November 12, 2021

ORA-65016 and ORA-65180 Tried to clone a remote PDB with the same name and path and got ORA-65016 like this. SQL> create pluggable database ORCLPDB… Read More »

How to Resolve ASMCMD-9453: failed to register password file as a CRS resource

by Ed Chen
December 6, 2020October 24, 2021

ASMCMD-9453 In the process of creating an empty RAC database, I tried to copy a password file into ASM by pwcopy command in ASMCMD, then… Read More »

How to Resolve OPW-00010: Could not create the password file. This resource has a Password File.

by Ed Chen
December 3, 2020April 6, 2022
2 Comments

OPW-00010 Tried to create a password file by orapwd, an Oracle utility for a RAC database and got OPW-00010: Could not create the password file.… Read More »

How Srvctl Modify Database SPFILE

by Ed Chen
December 2, 2020December 9, 2022

Srvctl Modify Database SPFILE We have changed the location of password file by srvctl modify database in the previous post, here we plan to change… Read More »

How Srvctl Modify Database Password File

by Ed Chen
December 2, 2020December 9, 2022

Srvctl Modify Database Password Even though I chose NOT to use Oracle Managed Files (OMF) during Oracle RAC database creation, I still got OMF password… Read More »

How to Resolve ORA-15173 Error Message

by Ed Chen
November 4, 2020December 9, 2022

ORA-15173: entry 'pdbseed' does not exist in directory There're two operations that you might see ORA-15173. Creating a Multitenant Database Creating a Pluggable Database ORA-15173… Read More »

How to Move Redo Log Location in Oracle

by Ed Chen
February 22, 2020July 10, 2022

Rename Redo Log File To improve overall performance, sometimes, we may consider to move redo logs to the location with faster disks, like Solid-State Drive… Read More »

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