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
raj_roshan_009
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.

Regards
Roshan.
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: 10672
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.
>>oracle_sid=TDB
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: Thu Dec 08 20:03:04 CST 2016

Total time taken to generate the page: 0.10731 seconds