Home » RDBMS Server » Backup & Recovery » Creating Clone database manually
Creating Clone database manually [message #333719] Mon, 14 July 2008 04:27 Go to next message
Messages: 29
Registered: May 2008
Junior Member
Hi all,

i am creating a clone database manually using Oracle 9i.

Original Database name: PRODB
Clone Database name : TDB

i have done all the activity(copy all datafile,relogfile,parameterfile with necessary modifications).

i have also set the environment variable,listener,tnsnames plus set oracle_sid=TDB.

Now,the problem is when i connect the database as

sqlplus /nolog
connect / as sysdba

It connect to PROD(Not TDB).

what is problem behind it.
Please help me.

Re: Creating Clone database manually [message #333776 is a reply to message #333719] Mon, 14 July 2008 07:28 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> what is problem behind it.
Unless you post exactly what you did (session snapshots, instead of explaining what you did), there is nothing much for us to start with.
Is the OS *nix?
variables are case sensitive
Did you export ORACLE_SID=TDB?
Previous Topic: RMAN backup failing.
Next Topic: Logfile & Database !
Goto Forum:

Current Time: Tue Jul 25 08:01:40 CDT 2017

Total time taken to generate the page: 0.14402 seconds