14 Replies Latest reply on Jul 6, 2011 12:37 PM by 873643

    ODBC error 81 in SQLConnect:

    709633
      I have a problem, when attempt to connect me by the ODBC

      odbcsql /u SADMIN /p SADMIN /s SBA_81_DSN

      Logging into "SBA_81_DSN" as "SADMIN" ...
      ODBC error 81 in SQLConnect:
      523 80
      (native error 0).
      Unable to login using specified ODBC parameters.

      P.D
      Already check and the Siebel Gateway Server is running.

      ps -fea|grep u01/SBA811/gtwysrvr

      sadmin 7132 1 0 10:10 pts/2 00:00:01 siebsvc -s gtwyns -a /f /u01/SBA811/gtwysrvr/sys/siebns.dat /t 2320 /c /u01/SBA811/gtwysrvr/bin/gateway.cfg
      sadmin 8240 6688 0 11:18 pts/2 00:00:00 grep u01/SBA811/gtwysrvr

      Already probe also the connection to the DATABASE

      $ sqlplus sadmin/sadmin@test

      SQL*Plus: Release 10.2.0.1.0 - Production on Mar Jun 30 11:49:52 2009

      Copyright (c) 1982, 2005, Oracle. All rights reserved.


      Conectado a:
      Oracle Database 10g Release 10.2.0.1.0 - Production

      SQL>

      Somebody can help me
        • 1. Re: ODBC error 81 in SQLConnect:
          Robert Ponder
          Hi,

          If you are on Oracle 11g you should know that passwords are now case sensitive by default. If you notice the times you can’t login your PW is in upper case and time you can login it is in lower.

          If you are on 11g I strongly suggest you review the what’s new section. There are 130 pages of new features.

          As both a DBA and developer I love 11g.

          HTH,

          R

          Robert Ponder
          Lead Architect and Director
          Ponder Pro Serve
          cell: 770.490.2767
          fax: 770.412.8259
          email: rponder@ponderproserve.com
          web: www.ponderproserve.com
          • 2. Re: ODBC error 81 in SQLConnect:
            709633
            The version of the DATABASE is "Oracle Database 10g Release 10.2.0.1.0".

            I prove with:

            odbcsql /u SADMIN /p SADMIN /s SBA_81_DSN
            odbcsql /u sadmin /p sadmin /s SBA_81_DSN
            odbcsql /u SADMIN /p sadmin /s SBA_81_DSN
            odbcsql /u sadmin /p SADMIN /s SBA_81_DSN

            It's the same error !!!

            Logging into "SBA_81_DSN" as "sadmin" ...
            ODBC error 81 in SQLConnect:
            523 80
            (native error 0).
            Unable to login using specified ODBC parameters.


            Some other idea, please.
            • 3. Re: ODBC error 81 in SQLConnect:
              TanteKaethe
              Is the ODBC port open?
              • 4. Re: ODBC error 81 in SQLConnect:
                709633
                Yes, I already did it and the problem continues being the same:

                Append rule in the file /etc/sysconfig/iptables as follows:
                -A INPUT -m state state NEW -m tcp -p tcp dport 2320 -j ACCEPT

                and restart iptables
                /etc/init.d/iptables restart
                service iptables restart

                and verify that port is open
                netstat -tulpn | less

                I make sure iptables is allowing port 2320 connections:
                iptables -L -n

                Chain INPUT (policy ACCEPT)
                target prot opt source destination
                ACCEPT all -- 0.0.0.0/0 0.0.0.0/0 state RELATED,ESTABLISHED
                ACCEPT icmp -- 0.0.0.0/0 0.0.0.0/0
                ACCEPT all -- 0.0.0.0/0 0.0.0.0/0
                ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:22
                ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:2320
                REJECT all -- 0.0.0.0/0 0.0.0.0/0 reject-with icmp-host-prohibited

                Chain FORWARD (policy ACCEPT)
                target prot opt source destination
                REJECT all -- 0.0.0.0/0 0.0.0.0/0 reject-with icmp-host-prohibited

                Chain OUTPUT (policy ACCEPT)
                target prot opt source destination

                I prove with:

                odbcsql /u SADMIN /p SADMIN /s SBA_81_DSN

                It's the same error:

                Logging into "SBA_81_DSN" as "sadmin" ...
                ODBC error 81 in SQLConnect:
                523 80
                (native error 0).
                Unable to login using specified ODBC parameters.

                Another idea, please.
                • 5. Re: ODBC error 81 in SQLConnect:
                  TanteKaethe
                  odbc/bin/ivtestlib can be used to further investigate driver problems.
                  http://www.datadirect.com/developer/odbc/docs/odbcdiagnostic.pdf

                  Maybe your driver is not loaded. Are the paths correct?
                  ODBCINI=/???/odbc.ini
                  LIBPATH=/???/odbc/lib (= for AIX or LD_LIBRARY_PATH or ?? whichever OS you are)
                  LANG=en_US

                  Double check paths in odbc.ini, too.

                  Edited by: TanteKaethe on Jul 2, 2009 9:13 PM

                  Edited by: TanteKaethe on Jul 2, 2009 9:17 PM
                  • 6. Re: ODBC error 81 in SQLConnect:
                    709633
                    I don't understand what I need to do.

                    I'm using Operation System Linux Fedora 11.1

                    And the value is:
                    ODBCINI=/u01/SBA811/siebsrvr/sys/.odbc.ini
                    LD_LIBRARY_PATH=/u01/SBA811/siebsrvr/lib
                    LANG=ENU

                    Please, I need more detail what you recommend to me that it does.

                    Thanks.
                    • 7. Re: ODBC error 81 in SQLConnect:
                      TanteKaethe
                      Add odbc-library path to LD_LIBRARY_PATH, too.

                      The file odbc.ini contains your connection settings. Check the file for wrong paths or wrong Oracle connection data.


                      http://www.odbcunix.org/content/blogcategory/8/32/37/ is for DB2 but the ODBC setup part is the same for Oracle. Verify if you have taken these steps.

                      Edited by: TanteKaethe on Jul 3, 2009 8:56 AM
                      • 8. Re: ODBC error 81 in SQLConnect:
                        709633
                        This document is for DB2, is the same for Oracle Database 10g?

                        The file ivtestlib not exist

                        $ ivtestlib
                        bash: ivtestlib: command not found
                        • 9. Re: ODBC error 81 in SQLConnect:
                          severla
                          i have the same problem I have set already enviroment .. im configuring siebel database but I need to test my ODBC connection

                          some advise

                          regards
                          • 10. Re: ODBC error 81 in SQLConnect:
                            709827
                            Somebody that can help us. Please.
                            • 11. Re: ODBC error 81 in SQLConnect:
                              713540
                              have u found any solution? If yes please post. I am facing exact same issue.
                              PK
                              • 12. Re: ODBC error 81 in SQLConnect:
                                668643
                                Could you please compare your environment varibales with the following ones, I copied them from .profile file. Please keep in mind, siebel should use 32 bit libraries of oracle.

                                export PATH=$PATH:/usr/sbin:/usr/local/bin:/usr/bin:/usr/ccs/bin:/usr/ucb:/usr/openwin/bin
                                export ORAENV_ASK=NO
                                export ORACLE_SID=CLIENT_1
                                export ORACLE_HOME=/oracle/product/11.1.0/client_1
                                export ORACLE_BASE=/oracle
                                export DBA=$ORACLE_BASE/admin
                                export TNS_ADMIN=$ORACLE_HOME/network/admin
                                . oraenv 2> /dev/null
                                export PATH=$PATH:$ORACLE_HOME/lib32
                                export LD_LIBRARY_PATH=$ORACLE_HOME/lib32
                                • 13. Re: ODBC error 81 in SQLConnect:
                                  766535
                                  I got odbcsql to work by setting these 2 environment variables :

                                  ODBCINI = /siebel/siebsrvr/sys/.odbc.ini
                                  SIEBEL_UNIXUNICODE_DB = ORACLE

                                  Other troubleshooting steps in this Bookshelf chapter :
                                  Siebel Installation Guide for Unix > Configuring Siebel Enterprise Server and Related Components > Troubleshooting Siebel Enterprise Server Installation and Configuration > Troubleshooting the ODBC Data Source Connection
                                  • 14. Re: ODBC error 81 in SQLConnect:
                                    873643
                                    I was facing same issue...
                                    host name entries were fine, even sqlplus connection was being established but was facing issues while creating ODBCSQL,
                                    what i did is took back up of current odbc.ini file (/siebel/siebsrvr/sys) , removed the original odbc.ini file,
                                    created and new .odbc.ini file and copy-paste same entries from bak up file, save changes
                                    execute chmod -R 777 .odbc.ini command and it worked fine.

                                    Good luck,
                                    Faisal