On Oct 29, 2009, at 2:15 AM, jeff wrote:
Oracle.pm built against 8 works great with Oracle 8 when doing an
'external connection' (i.e., No user or password supplied in
DBI-connect ) but will not connect to 10 without a username/password.
Each version of Oracle uses a different mechanism to do
:-)
Can't, privileges do vary from SID to SID so need user's real access.
DBI::Proxyserver for one or the other is a winner I think.
On Mon, 2009-11-02 at 09:10 -0700, Bruce Johnson wrote:
On Oct 29, 2009, at 2:15 AM, jeff wrote:
Oracle.pm built against 8 works great with Oracle 8 when doing
Asked a question yesterday but I don't think I worded it very well so
heres another try.
I want to do an 'external connection' (i.e., No user or password
supplied in DBI-connect ) from a single script to multiple versions of
Oracle ( Oracle 8 10 ).
What I have found so far is that Oracle.pm
More info on the oracle 8 external setup:
SQL show parameter os_authent_prefix;
NAME TYPEVALUE
--- ---
os_authent_prefixstring
Notice no value just to complicate it more :-)
SQL select
On 29/10/09 09:15, jeff wrote:
Asked a question yesterday but I don't think I worded it very well so
heres another try.
I want to do an 'external connection' (i.e., No user or password
supplied in DBI-connect ) from a single script to multiple versions of
Oracle ( Oracle 8 10 ).
What I have
This may indeed be impossible and I'm probably going to go with
DBD::ProxyServer, but I want to add some interesting observations:
External connections Orcale 8:
If the remoter server has a username that matches the username of the
remote client it will still authenticate. This work in our setup.
On 29/10/09 15:51, jeff wrote:
External connections Orcale 8:
If the remoter server has a username that matches the username of the
remote client it will still authenticate. This work in our setup. You
don't necessarily have to be local.
This is so only if some idiot has set the parameter
On 29/10/09 17:00, jeff wrote:
Please post you replies to the list, not just to me.
Its a closed system. No outside access.
In that case, set remote_os_authent = true on all the servers,
use the Oracle 10 client, an make all the connections using
a network connections, i.e. not setting