Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Installation and Configuration

443663May 19 2005 — edited May 20 2005
I have installed Oracle 8.1.7 on a HP machine which already had Oracle 8.0.4.

Currently I am able to use the database on Oracle 8.1.7. But I am not able to use the database on Oracle 8.0.4.

FYI, I have not modified the listener.ora of both the version. I have also not modified the tnsnames.ora of both the version.

My questions are (Please understand that I am doing all this for the first time)
1. Do I need two tnsnames.ora files. Can I merge them. If yes, where do I move the file. What should I do after moving the file?
2. I plan to keep listerner.ora separately for both the version, since they are under different homes.

FYI, if I start the database on version 8.0.4 using svrmgr, I get the following error..
SVRMGR> startup
ORACLE instance started.
Total System Global Area 113822444 bytes
Fixed Size 47852 bytes
Variable Size 93220864 bytes
Database Buffers 20480000 bytes
Redo Buffers 73728 bytes
ORA-03113: end-of-file on communication channel

Similarly if I try to see the status on lsnrctl I get the following error messages..
Connecting to (ADDRESS=(COMMUNITY=lsco_tcp.some.com)(PROTOCOL=TCP)(Host=tyoux
)(Port=1526))
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 239: Connection refused

Thanks a lot for your helps.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2005
Added on May 19 2005
5 comments
327 views