Here's my situation:
I have a laptop with OS XP Pro and having Oracle9i Ent edition installed (everything fine).
Then I need to install on the same laptop client application Oracle8 (SQLPlus and SQL Net 2.3). Installation fine (I finally have 2 oracle homes).
TNSNames.ora of Oracle8 has been configured correctly but when tried to connect using SQLPlus of O8 got an error msg: TNS names could not be resolved.
Checking the service found that there are 2 listeners: 1 belong to oracle9i (up and running) and another belongs to oracle8 (failed). Is having 2 listeners normal? My friend told me I just need 1 listener.
Question: Given that situation what should I do to get client application of Oracle8 connected to Oracle9i database?