XPost: comp.database.oracle   
   From: fbortel@nescape.net   
      
   Cherrish Vaidiyan wrote:   
   > Hello all,   
   >   
   > A warm Xmas greetings to all. I have a small problem with starting up   
   > the database. Here my strategy.   
   >   
   > I have installed Oracle 9i R 2 on Red Hat 9. i created two database on   
   > this system. And the two datasbe is working perfectly. Now i needed   
   > another RH9 system to work on Oracle 9i. So I was guided to copy the   
   > oracle home folder and that the oracle will be up for work. I even got   
   > such a response from Google Group. I copied the files and i was able   
   > to take netmgr,dbca etc. But i couldnt use the database..due to   
   > Listener problem. when ever i give..   
   >   
   > [oracle@node2 oracle]$ lsnrctl start Listener   
   > TNS-12560  TNS : Protocol adapter error   
   >     TNS-00530  TNS : Protocol adapter error   
   >      Linux - 113 - No route to host   
   >   
   > Sometime i get error 'Linux-111'  error. Can anyone experienced such a   
   > problem ? Can you help me how to overcome it ?   
   > i serached in the net and i got ideas to check the hostname in   
   > listener.ora and tnsnames.ora. I verfied and it is correct. Another   
   > suggestion from some oracle based website is that to check PATH and   
   > ORACLE_SID etc.I have even gone through it. All are correct. Any other   
   > ideas/suggection pls ...   
   >   
   > regards,   
   > Cherrish Vaidiyan   
      
   You _did_ alter the files before attempting this, did'nt you?   
   --   
   Merry Christmas and a Happy New Year,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)