I have a problem running a 8.1.5 database on 9.2 Listener.
I have two Oracle homes installed in the same machine. 188.8.131.52.0 and 8.1.5 and I want both homes be accessible through the TNSListener. So I have 9.2 Listener and 9.2 database is opening ok. But there's no way I can connect to 8.1.5 database. I get this error when trying to connect:
ORA-12500: TNS:listener failed to start a dedicated server process
Is it possible at all to work with such conf?
Or is it possible to run two listeners (8 and 9) at the same time? Looks like not, cause only one would start..
just in case, content of my listener.ora and tnsnames.ora:
hey, thanks for your help!
but actually it is possible to serve both databases with one (earliest) listener! my problem was that I had an environment variable of ORACLE_HOME set! and it's not allowed when having more than one oracle homes in the system. cause then you end up trying to connect to 8i database using 9i home and of course it fails!