Re: rename/clone an Oracle Database

Tong,

You need to copy $ORACLE_HOME/dbs/orapw<sid> file from your production to test enviroment.

hth,
Stan

Tong wrote:

> 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
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> 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:49:11 CST