Originally posted by Running Bear
I'm new to Oracle and mostly use TOAD when working with oracle
That's your first mistake! Toad is the spawn of the devil! You need to learn how to type stuff out via the command line which is either sql or dos prompt. 
Then once you know that stuff you can use toad. Bahhh!
to find out if you have connectivity from the live database to the backup database you would do this. From the dos prompt issue
$> sqlplus userid/used_for_db_link@backup_datbase
if you connect then you're good to go
if you don't, that means you don't have the backup database listed in your tnsnames.ora file.
it's nice that you have connectivity from your backup to your live but that's not what we're trying to accomplish here, we want the reverse which means you need to tell Oracle that it exsits. Which means you need to go open up netmanger and fix it 
Last edited by OracleDoc; 04-13-2004 at 10:01 AM.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
Reply With Quote