rename/clone an Oracle Database

From: Tong <d052057_at_yahoo.com>
Date: 10 Mar 2002 22:20:40 -0800
Message-ID: <9718e99c.0203102220.304a7dcb@posting.google.com>

I am trying to clone a prod database to a test database. I am using cp command to copy datafiles to a different location and also use "alter database backup controlfile to trace" to generate sql script to rename the test database (see
http://www.idevelopment.info/data/DBA_tips/DBATIP_31.shtml ). After all, I 've gotten this error msg which I can't figure it out.

Oracle Server Manager Release 3.1.7.0.0 - Production

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SVRMGR> SVRMGR> Connected.
SVRMGR> SVRMGR> ORACLE instance started.

Total System Global Area                         72704160 bytes
Fixed Size                                          73888 bytes
Variable Size                                    55681024 bytes
Database Buffers                                 16777216 bytes
Redo Buffers                                       172032 bytes

ORA-01990: error opening password file
'/oracle/u01/app/oracle/product/8.1.7/dbs/orapw'

Any suggestions ?

Thank you
Please reply to d052057_at_yahoo.com Received on Mon Mar 11 2002 - 00:20:40 CST