Creating Clone database manually [message #333719] |
Mon, 14 July 2008 04:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 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?
|
|
|