A simple Listener problem while installing Oracle by copying Ora Home

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Cherrish Vaidiyan
    #1

    A simple Listener problem while installing Oracle by copying Ora Home

    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
    Tags: None
    • Frank van Bortel
      #2
      Re: A simple Listener problem while installing Oracle by copyingOra Home

      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

        Comment

        • Cherrish Vaidiyan
          #3
          Re: A simple Listener problem while installing Oracle by copying Ora Home

          Frank van Bortel <fbortel@nescap e.netwrote in message news:<bscm3m$os 2$1@news3.tilbu 1.nb.home.nl>.. .
          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?
          SIR,
          I HAVE VERIFIED LISTENER.ORA AND TNSNAMES.ORA BEFORE I STARTED THE
          LISTENER..THE DETAILS IS CORRECT.I COULD ALSO SEE THE DETAILS WHEN I
          GIVE :
          lsnrctl start listener
          STILL I GET THE ERROR. CAN U HELP ME WAT ELSE I COULD DO...
          REGARDS,
          CHERRISH VAIDIYAN

            Comment

            Previous template Next
            Working...