Quoting edward pena <[EMAIL PROTECTED]>: > Actually, that does not work consistently.
The most common cause for it to not work is mentioned in the last paragraph of the document extract below. Many Oracle instances are set up to refuse remote connections as DBA or OPER. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 08, 2005 12:38 PM > To: [EMAIL PROTECTED]; dbi-users@perl.org > Subject: Re: (Fwd) FW: DBI connect as sysdba > > ora_session_mode ... > It has been reported that this only works if $dsn does not contain > a SID so that Oracle then uses the value of the ORACLE_SID (not > TWO_TASK) environment variable to connect to a local instance. Also > the username and password should be empty, and the user executing > the script needs to be part of the dba group or osdba group. -- Mac :})
