Re: ORA-01157

The database your friend gave you must have been in some other directories. What you need to do is mount the database, and then rename the datafiles.

rename all of the files.
svrmgrl
>connect internal
> alter database rename file 'oldfilepath' to 'newfilepath';
> exit;

You then should be able to open the database.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
<sundarkumar_at_india.com> wrote in message news:8gpag4$ehr$1_at_nnrp1.deja.com...


> Hi All

>

> I have a problem on opening a database stating that oracle error no

> 01157.

>

> Actually I got oracle directory from my friend and he wants me to bring

> up in my server(Some database is already running in the system). So I

> have copied all the stuff(database,datafiles) into my system and started

> changing the init.ora file to the specific directory in my system, then

> I went to svrgrml and connected and I said "startup pfile=<directoryname

> and init.ora>then it says instance created and so and so and finally

> said that ora-01157 error no. I went all the documentation of error and

> I am unable to fix it. So kindly anyone pls help me to bring up this

> database in my system, so that I can give the dump of the database to my

> friend. Kindly help me out, I'll be very greatefull to u all.

>

> Thanx in advance. Consider this's very urgent.

>

> Sundar

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.