Re: rename/clone an Oracle Database

Stan <stan0074_at_yahoo.com> wrote in message news:<3C8C53FB.3000304_at_yahoo.com>...
> 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
> >

You Can Also Run the ORAPWD Utility to Create the Oracle Password File.

HTH Regards,
Ganesh R Received on Mon Mar 11 2002 - 04:12:06 CST