| Database copy from one m/c to another m/c [message #133908] |
Mon, 22 August 2005 13:48  |
poratips
Messages: 345
Registered: April 2005
Location: IL
|
Senior Member |
|
|
Hi,
I got my new laptop and I installed new oracle s/w on my local m/c. On my old laptop I have two oracle home as one home(8i) was pointing to my server db(prod)
and another home was 901 which I have craeted my local DB for testing purpose. I was able to access both db whithin
my respective home, Now I have installed new oracle s/w on my local m/c 902 oracle home and I am thinking to access
both DB local and my production (production db located on another location and local db is on my local m/c)
How can I user the one Oracle home to access both DB? means should I need to copy the files over to new laptop or
I have to create new DB again to access my local db which was on old laptop?
I copied my TNSNAMES.ORA file into my network directory which has both DB entry but I am able to access my prod db but bot not
local db? Which steps I need to finish?
Thanks,
|
|
|
|
| Re: Database copy from one m/c to another m/c [message #133911 is a reply to message #133908] |
Mon, 22 August 2005 14:08  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
did you create your local datatbase?
if so, do you have proper listner entries , tnsnames.ora entries ( Acutally you dont need tnsentries to talk to local database. But it will be nice).
Did you start the localdb and listener?
sqlplus scott/tiger # will be defualt connect to local db
sqlplus scott/tiger@localdb #uses tnsservicename localdb to talk to local db.
sqlplus scott/tiger@remotedb #uses tnsservicename remotedb to talk to remote db
[Updated on: Mon, 22 August 2005 14:09] Report message to a moderator |
|
|
|
| Re: Database copy from one m/c to another m/c [message #133917 is a reply to message #133911] |
Mon, 22 August 2005 14:40 |
poratips
Messages: 345
Registered: April 2005
Location: IL
|
Senior Member |
|
|
Thanks. My Question is regarding copy v/s createting db from scratch. I have created local DB on my laptop but now I got new laptop so I am confused that I need to create the db again or I just copy the necessry files from old laptop to new laptop and yes then which files?
I have copied tnsnames.ora file from old laptop to new laptop from C:\oracle\ora901\network\ADMIN (old m/c) to C:\oracle\ora901\network\ADMIN (new m/c) with both entries one for prod db and another for local db. Now I can talk with my prod db but not local db. So I need to copy the files or create the db to access my original local db?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
