Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error ora-01758 OSD-04002: no se ha podido abrir el archivo O/S-Error: (OS 5) Acceso denegado. Rename datafile PDB

myluismApr 12 2024

Hi. This happened on Windows with Oracle Database 19c Standard Edition 2.

This a development database so i used offline approach to move / rename datafiles.

  1. Startup mount DB
  2. Switch to container DB.
  3. Performed alter database move datafile operations “ALTER DATABASE RENAME FILE” command.
  4. When trying to open pluggable database got error ora-01758
  5. Checking logfiles found:

SDSDESA(3):Errors in file D:\APP\ORACLE\diag\rdbms\cdbdesa\cdbdesa\trace\cdbdesa_ora_11752.trc:
ORA-01110: archivo de datos 43: 'E:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\DEMO_TABLAS01.DBF'
ORA-01114: error de E/S al escribir el bloque en el archivo 43 (bloque número 1)
ORA-27041: no se ha podido abrir el archivo
OSD-04002: no se ha podido abrir el archivo
O/S-Error: (OS 5) Acceso denegado.
2024-04-12T11:08:34.126238-03:00
SDSDESA(3):Error 17528 during pluggable database SDSDESA opening in read write
2024-04-12T11:08:34.127237-03:00
SDSDESA(3):Errors in file D:\APP\ORACLE\diag\rdbms\cdbdesa\cdbdesa\trace\cdbdesa_ora_11752.trc:
ORA-17528: No se puede escribir en un archivo de solo lectura o abierto solo para lectura: E:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\DEMO_TABLAS01.DBF.
2024-04-12T11:08:34.127237-03:00
Errors in file D:\APP\ORACLE\diag\rdbms\cdbdesa\cdbdesa\trace\cdbdesa_ora_11752.trc:
ORA-17528: No se puede escribir en un archivo de solo lectura o abierto solo para lectura: E:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\DEMO_TABLAS01.DBF.

I have to rename datafiles back in order to open pluggable.

Now, I was connected as Administrator user in Windows and this user belong to ORA_DBA windows group:

c:\Dba\respaldos_BD\RDL1\Exp>net localgroup ora_dba
Nombre de alias ora_dba
Comentario ORA_DBA

Miembros

-------------------------------------------------------------------------------
Administrador
NT AUTHORITY\SYSTEM
Se ha completado el comando correctamente.

I will eventually need to move some datafiles, so which OS privileges Do I need if “Administrador” is part of ORA_DBA group? I find windows permission confusing.

I notice there are other Oracle related groups:

*ORA_ASMADMIN
*ORA_ASMDBA
*ORA_ASMOPER
*ORA_CLIENT_LISTENERS
*ORA_DBA
*ORA_DBSVCACCTS
*ORA_GRID_LISTENERS
*ORA_INSTALL
*ORA_OPER
*ORA_OraDB19Home1_DBA
*ORA_OraDB19Home1_OPER
*ORA_OraDB19Home1_SYSBACKUP
*ORA_OraDB19Home1_SYSDG
*ORA_OraDB19Home1_SYSKM

I'm familiar with unix based permissions not Windows, Can anyone suggest what to do here?

Thanks in advance !
Comments
Post Details
Added on Apr 12 2024
1 comment
353 views