If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I tried but I am getting the same error as before.
[/B][/QUOTE]
Check metalink ( [url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=1018634.102&p_database_id=NOT[/url] )

[QUOTE][B]
Also, when you change the db_name why do I need to do resetlog?
[/B][/QUOTE]
Do you need to open resetlogs? No, probably not. I do it because I have just changed a major parameter of my database. Also, that's the way Oracle recommends to do it (http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=15390.1 )

I read the document and check config and init files as suggested. I could not find any ref. old database name.
When I tried "alter database rename....", did not work. I am getting the same error.
I am using oracle 8.0.5