469,271 Members | 1,743 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

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
Jul 19 '05 #1
2 8910
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

Jul 19 '05 #2
Frank van Bortel <fb*****@nescape.net> wrote in message news:<bs**********@news3.tilbu1.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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by UNIXNewBie | last post: by
6 posts views Thread by Ellen K. | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.