| Creating Clone database manually [message #333719] |
Mon, 14 July 2008 04:27  |
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  |
 |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
