Re: FreeTDS & Oracle11g

From: joel garry <joel-garry_at_home.com>
Date: Wed, 3 Jun 2009 09:33:47 -0700 (PDT)
Message-ID: <3416b32a-9b9b-4916-ad86-d82ae9de407b_at_k8g2000yqn.googlegroups.com>

On Jun 3, 5:51 am, Mladen Gogala <gogala.mla..._at_bogus.email.com> wrote:
> I have properly configured UnixODBC which used to work with Oracle10.2.0.4
> and hsodbc:
>
> mgogala_at_centos ~]$   isql -v mstest ccmview ccmview
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL> select table_name from information_schema.tables;
> +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> +
> |
> table_name                                                                                                                                                                                                                                                                                                  
> |
> +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> +
> |
> CallDetailRecord                                                                                                                                                                                                                                                                                            
> |
> |
> calldetailrecordbackup                                                                                                                                                                                                                                                                                      
> |
> |
> CallDetailRecordDiagnostic                                                                                                                                                                                                                                                                                  
> |
> |
> calldetailrecorddiagnosticbackup                                                                                                                                                                                                              
> .....
>
> Now, I am trying to do the same thing with Oracle 11.1.0.7 on CentOS 5.3
> (proof of concept):
>
> SQL> select * from systables_at_mstest;
> select * from systables_at_mstest
>                         *
> ERROR at line 1:
> ORA-28500: connection from ORACLE to a non-Oracle system returned this
> message:
> ORA-02063: preceding line from MSTEST
>
> Unfortunately, the trace file doesn't contain any useful information:
>
> Trace file /oracle/diag/clients/user_oracle/host_649917657_11/trace/
> ora_5040_308
> 5899456.trc
> OCI-21500: internal error code, arguments: [17183], [0x934454C], [], [],
> [], [],
>  [], []
> ********** Internal heap ERROR 17183 addr=0x934454c *********
>
> That's about it. This is a test machine, with an unsupported OS. It's not
> very important but I would still like to get this thing under control.
> Does anybody here know anything about that? Did anybody manage to get
> this working?
>
> --http://mgogala.fr

Which version of unixodbc? See https://bugs.launchpad.net/ubuntu/+source/unixodbc/+bug/164473 and http://www.unixodbc.org/ (2.2.12 has unicode fixes for Oracle). Also see the change log for Changes in DBD::ODBC 1.15_1 November 6, 2007 - that specifies winblows fixes, but seems to say it could be using 2.2.12.

Beyond that, see if it works on a supported OS, so you can ask support wtf 0x934454c means. Looks like the 17183 is a pretty generic pointer towads odbc code.

Sorry I don't have actual systems to try and see, but this is interesting.

jg

--
_at_home.com is bogus.
"you posted WHAT?"
http://www3.signonsandiego.com/stories/2009/jun/03/1n3nukes234543-data-maps-nuclear-sites-posted-onli/?uniontrib

Received on Wed Jun 03 2009 - 11:33:47 CDT