Skip to content
Advertisements

ORA-01157 ORA-01110 ORA-27041 OSD-04002 O/S-Error

I am trying to change the one of the database running on Window server with my domain user But this existing oracle service running on NT Services.

I renamed the database and created a new sid and service started by NT Services and then I tried to start the database, Its throwing the below error

 

SQL> startup pfile=’E:\oracle\INITSIEBUAT.ORA’;
ORACLE instance started.

Total System Global Area 7734296576 bytes
Fixed Size 8764936 bytes
Variable Size 1543504376 bytes
Database Buffers 6174015488 bytes
Redo Buffers 8011776 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 8 – see DBWR trace file
ORA-01110: data file 8: ‘E:\ORACLE\PRODUCT\12.2.0\DBHOME_1\DATABASE\S_DATA01’

 

I checked the alter log file

Errors in file E:\ORACLE\diag\rdbms\siebelbi\siebelbi\trace\siebelbi_dbw0_8316.trc:
ORA-01157: cannot identify/lock data file 9 – see DBWR trace file
ORA-01110: data file 9: ‘E:\ORACLE\PRODUCT\12.2.0\DBHOME_1\DATABASE\S_DATA02’
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

 

But I have full rights of the directory but still I am facing the above issue

Solution:

 

I stopped the services and started the services Log on as Local Account, the database is opened.

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: