EZCONNECT problem with Oracle11 (solved)
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 25 Mar 2008 09:40:54 GMT
Message-ID: <47e8c8a6$0$1347$834e42db@reader.greatnowhere.com>
Date: 25 Mar 2008 09:40:54 GMT
Message-ID: <47e8c8a6$0$1347$834e42db@reader.greatnowhere.com>
This is solved. As it turns out, it isn't a bug but a feature. On
Oracle10g and previous releases, the client was specifying the service
name. On oracle11 and later, one should specify default service for the
listener by using DEFAULT_SERVICE_<listener_name> directive in the
listener.ora. That means that the default service can now be configured
and that, if the target database is 11g or later, one doesn't need to
modify the service_names parameter to make certain database the default
one.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Tue Mar 25 2008 - 04:40:54 CDT