db_file_name_convert & log_file_name_convert - Please help me

508936 Sep 11, 2006 10:47 PM

Currently Being Moderated

Sir,

I moved a database from one machine to another machine.
In the first machine all file resides at F:\oradata\BOASM

In my new machine F: drive is not available.
So in the new machine I kept all files in E:\oradata\BOASM

I changed controlfile locations, user_dump_dest,core_dump_dest,background_dump_dest in 'initBOASM.ora'

Also I added

db_file_name_convert=('F:\oradata\BOASM' 'E:\oradata\BOASM')
log_file_name_convert=('F:\oradata\BOASM' 'E:\oradata\BOASM')

to initBOASM.ora

But while starting up database it is showing this error..
=========================================
SQL> startup
ORACLE instance started.

Total System Global Area 260643680 bytes
Fixed Size 453472 bytes
Variable Size 150994944 bytes
Database Buffers 109051904 bytes
Redo Buffers 143360 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:\ORADATA\BOASM\SYSTEM01.DBF'
===================================================

Why this error is commig please help me.

1. Re: db_file_name_convert & log_file_name_convert - Please help me

MohammedTaj Sep 11, 2006 10:53 PM (in response to 508936)
Currently Being Moderated

ORA-01157: cannot identify/lock data file string - see DBWR trace file
Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.
Action: Have operating system make file available to database. Then either open the database or do
ALTER SYSTEM CHECK DATAFILES.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 134217728 bytes
Fixed Size                   787808 bytes
Variable Size              78379680 bytes
Database Buffers           54525952 bytes
Redo Buffers                 524288 bytes
Database mounted.
SQL> alter system check datafiles;

System altered.

SQL>
Report Abuse

Like (0)
2. Re: db_file_name_convert & log_file_name_convert - Please help me

508936 Sep 11, 2006 11:06 PM (in response to MohammedTaj)

Currently Being Moderated

Sir,

Still it is giving the same error.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 260643680 bytes
Fixed Size 453472 bytes
Variable Size 150994944 bytes
Database Buffers 109051904 bytes
Redo Buffers 143360 bytes
Database mounted.
SQL> alter system check datafiles;

System altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:\ORADATA\BOASM\SYSTEM01.DBF'

please help me
Report Abuse

Like (0)
3. Re: db_file_name_convert & log_file_name_convert - Please help me

MohammedTaj Sep 11, 2006 11:15 PM (in response to 508936)
Currently Being Moderated

I changed controlfile locations, user_dump_dest,core_dump_dest,background_dump_dest in 'initBOASM.ora'

You made change in pfile file
after that u create spfile from pfile.

sql> create spfile from pfile
bcoz u start ur database through spfile

Then Try
sql>shutdown immediate;
sql>create spfile from pfile
sql>startup
let me know ...
Report Abuse

Like (0)
4. Re: db_file_name_convert & log_file_name_convert - Please help me

508936 Sep 11, 2006 11:25 PM (in response to MohammedTaj)

Currently Being Moderated

Sir,

I am using init file. I am not using pfile.

regards
Mathew
Report Abuse

Like (0)
5. Re: db_file_name_convert & log_file_name_convert - Please help me

447708 Sep 11, 2006 11:29 PM (in response to 508936)

Currently Being Moderated

=========================================
SQL> startup
ORACLE instance started.

Total System Global Area 260643680 bytes
Fixed Size 453472 bytes
Variable Size 150994944 bytes
Database Buffers 109051904 bytes
Redo Buffers 143360 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:\ORADATA\BOASM\SYSTEM01.DBF'
===================================================

It is still looking into F:\. Looks like db_file_name_convert is not in effect.

Regards,
Satheesh Babu.S
Report Abuse

Like (0)
6. Re: db_file_name_convert & log_file_name_convert - Please help me

MohammedTaj Sep 11, 2006 11:42 PM (in response to 508936)

Currently Being Moderated

I am using init file. I am not using pfile

what command u execute

sql>startup pfile="path" ---------- if yes it ok

just
sql>startup -------- If yes This situation oracle use default init file and default init is spfilesid.ora.

let me know. plz.
Report Abuse

Like (0)
7. Re: db_file_name_convert & log_file_name_convert - Please help me

The Human Fly Sep 12, 2006 12:31 AM (in response to 508936)

Currently Being Moderated

db_file_name_convert=('F:\oradata\BOASM' 'E:\oradata\BOASM')
log_file_name_convert=('F:\oradata\BOASM' 'E:\oradata\BOASM')

Those parameters are useful when standby database is in place, when the directory structure/file sturce of primary and standby differ and you want oracle to conver the location at standby and create/add the file whenever a new datafile added (file management) done at primary level.

In your situation, you would have either re-created the controlfile with the new location or updated the controlfile with new location of those datafiles.

Jaffar
Report Abuse

Like (0)
8. Re: db_file_name_convert & log_file_name_convert - Please help me

447708 Sep 12, 2006 1:15 AM (in response to The Human Fly)

Currently Being Moderated

If you know what really you do, then "CREATE CONTROLFILE" is better option.

However filename_convert is not a standby specific parameters. Let us assume a db is having 1000 files and you want to move this db to another box using RMAN. In this new box the file system is different then that of source, then filename_convert is the way to go.Other options might give you more troubles.

Regards,
Satheesh Babu.S
Report Abuse

Like (0)
9. Re: db_file_name_convert & log_file_name_convert - Please help me

The Human Fly Sep 12, 2006 1:30 AM (in response to 508936)

Currently Being Moderated

db_file_name_convert=('F:\oradata\BOASM' 'E:\oradata\BOASM')
Could be , missing.

db_file_name_convert=('F:\oradata\BOASM','E:\oradata\BOASM')

Jaffar
Report Abuse

Like (0)
10. Re: db_file_name_convert & log_file_name_convert - Please help me

MohammedTaj Sep 12, 2006 1:34 AM (in response to 447708)

Currently Being Moderated

It is still looking into F:\. Looks like db_file_name_convert is not in effect.

right satheesh filename_convert not effect bcoz of compatiable parameter ( May Be)
plz. let me know what is right solution of this problem....

thanx.

Message was edited by:
user52
Report Abuse

Like (0)
11. Re: db_file_name_convert & log_file_name_convert - Please help me

508936 Sep 12, 2006 1:55 AM (in response to MohammedTaj)

Currently Being Moderated

Sir,

For this , we are mentioning

c:> set oracle_sid=BOASM
c:>startup

it will take <ORACLE_HOME>\database\initBOASM.ora

regards
Mathew
Report Abuse

Like (0)
12. Re: db_file_name_convert & log_file_name_convert - Please help me

447708 Sep 12, 2006 1:55 AM (in response to The Human Fly)

Currently Being Moderated

Well actually oracle puts the comma if you give space. So that's not the issue. The problem could be he is using the spfile and however edited pfile.

Regards,
Satheesh Babu.S
Report Abuse

Like (0)
13. Re: db_file_name_convert & log_file_name_convert - Please help me

508936 Sep 12, 2006 1:55 AM (in response to The Human Fly)

Currently Being Moderated

Sir,

I think it will work only for Dataguard, RMAN configuration.

regards
Mathew
Report Abuse

Like (0)
14. Re: db_file_name_convert & log_file_name_convert - Please help me

447708 Sep 12, 2006 1:57 AM (in response to 508936)

Currently Being Moderated

Can you please post the output of below command?

startup nomount
show parameter db_file_name_convert;
show parameter spfile.

Regards,
Satheesh Babu.S
Report Abuse

Like (0)

1 2 Previous Next

Go to original post