• 15. Re: Need Debugging help Oracle to MYSQL local single instance install
      EdStevens

      Google the error code - ORA-28545

      • 16. Re: Need Debugging help Oracle to MYSQL local single instance install
        mxallen-Oracle

        Change the name of the file initmysql80w.ora to initMYSQL80w.ora

        Try it after making this change.

         

        Matt

        • 17. Re: Need Debugging help Oracle to MYSQL local single instance install
          rjsosi

          Hi Mxallen,

           

          I'm going to report my SQLNET files as you had suggested last week. I  fixed some things but still getting an ORA-28545: error so Here are the lates version of all files.

           

          Please let me know what you find.

           

           

          MYSQL DB info

          Listener.ora

           

          # listener.ora Network Configuration File: c:\LOCAL\network\admin\listener.ora
          # Generated by Oracle configuration tools.
          
          
          
          
          SID_LIST_LISTENER =
            (SID_LIST =
              (SID_DESC =
                (SID_NAME = CLRExtProc)
                (ORACLE_HOME = C:\app\rlogin\virtual\product\12.2.0\dbhome_1)
                (PROGRAM = extproc)
                (ENVS = "EXTPROC_DLLS=ONLY:C:\app\rlogin\virtual\product\12.2.0\dbhome_1\bin\oraclr12.dll")
              )
              (SID_DESC =
                (GLOBAL_DBNAME = Oracle8)
                (SID_NAME = ORCL)
              )
              (SID_DESC =
                (SID_NAME = MYSQL80w)
                (ORACLE_HOME = C:\app\rlogin\virtual\product\12.2.0\dbhome_1)
                (PROGRAM = dg4odbc)
              )
          #    (SID_DESC =
          #      (SID_NAME = MYSQL80w32)
          #      (ORACLE_HOME = C:\app\rlogin\virtual\product\12.2.0\dbhome_1)
          #      (PROGRAM = hsodbc)
          #    )
            )
          
          
          LISTENER =
            (DESCRIPTION_LIST =
              (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
              )
              (DESCRIPTION =
                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
              )
            )
          
          
          ADR_BASE_LISTENER = C:\app\rlogin\virtual\product\12.2.0
          

           

          TNSNAMES.ora

           

          # tnsnames.ora Network Configuration File: c:\LOCAL\network\admin\tnsnames.ora
          # Generated by Oracle configuration tools.
          
          
          EXTPROC_CONNECTION_DATA =
            (DESCRIPTION =
              (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
              )
              (CONNECT_DATA =
                (SERVICE_NAME = PLSExtProc)
              )
            )
          
          XE = 
            (DESCRIPTION = 
              (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 
              (CONNECT_DATA = 
                (SERVER = DEDICATED) 
                (SERVICE_NAME = XE) 
              ) 
            ) 
          
          ORCL_DEV =
            (DESCRIPTION =
              (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
              )
                  (CONNECT_DATA =
                (SID = ORCL)
              )
            )
          
          # Hosts column equals DB name  ORCL is the name in the
          
          MYSQL80W =
            (DESCRIPTION=
                (ADDRESS= (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))   
          
                (CONNECT_DATA=
                  (SID=MYSQL80w))
                (HS=OK)
          )
          
          
          #MYSQL80W32 =
          #  (DESCRIPTION=
          #    (ADDRESS= (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))   
          # 
          #      (CONNECT_DATA=
          #        (SID=MYSQL80w32))
          #      (HS=OK)
          #)
          

           

          initmysql80w.ora

           

          # This is a sample agent init file that contains the HS parameters that are
          # needed for the Database Gateway for ODBC
          
          #
          # HS init parameters
          #
          HS_FDS_CONNECT_INFO = MYSQL80w
          
          
          HS_FDS_TRACE_LEVEL = 4
          
          
          #
          # Environment variables required for the non-Oracle system
          #
          #set <envvar>=<value>
          
          
          

           

          SQLNET.ora

           

          # sqlnet.ora Network Configuration File: c:\LOCAL\network\admin\sqlnet.ora
          # Generated by Oracle configuration tools.
          
          # This file is actually generated by netca. But if customers choose to 
          # install "Software Only", this file wont exist and without the native 
          # authentication, they will not be able to connect to the database on NT.
          
          SQLNET.KERBEROS5_CC_NAME = C:\oracle\Kerbos_credcach.txt
          
          SQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS, NTS)
          
          NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, LDAP)
          
          SQLNET.KERBEROS5_CLOCKSKEW = 6000
          
          SQLNET.KERBEROS5_CONF = C:\oracle\ora10g\NETWORK\ADMIN\krb5.conf
          
          SQLNET.KERBEROS5_CONF_MIT = TRUE
          
          SQLNET.AUTHENTICATION_KERBEROS5_SERVICE = oracle
          
          ADR_BASE = C:\app\rlogin\virtual\product\12.2.0\dbhome_1\log
          
          

           

          C:\>lsnrctl status

           

          LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 30-SEP-2019 10:06:35
          
          Copyright (c) 1991, 2016, Oracle.  All rights reserved.
          
          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
          STATUS of the LISTENER
          ------------------------
          Alias                     LISTENER
          Version                   TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
          Start Date                27-SEP-2019 15:59:56
          Uptime                    2 days 18 hr. 6 min. 38 sec
          Trace Level               off
          Security                  ON: Local OS Authentication
          SNMP                      OFF
          Listener Parameter File   c:\LOCAL\network\admin\listener.ora
          Listener Log File         C:\app\rlogin\virtual\product\12.2.0\diag\tnslsnr\OCLT70545153\listener\alert\log.xml
          Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=OCLT70545153.office.adroot.bmogc.net)(PORT=5500))(Security=(my_wallet_directory=C:\APP\Rlogin\VIRTUAL\admin\orcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
          Services Summary...
          Service "CLRExtProc" has 1 instance(s).
            Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
          Service "MYSQL80w" has 1 instance(s).
            Instance "MYSQL80w", status UNKNOWN, has 1 handler(s) for this service...
          Service "Oracle8" has 1 instance(s).
            Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
          Service "d767cda564dd4065aeb98259d87281ee.office.adroot.bmogc.net" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
          Service "orcl.office.adroot.bmogc.net" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
          Service "orclXDB.office.adroot.bmogc.net" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
          Service "orclpdb.office.adroot.bmogc.net" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
          The command completed successfully
          

           

          C:\>lsnrctl services

           

          LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 30-SEP-2019 10:07:57
          
          
          Copyright (c) 1991, 2016, Oracle.  All rights reserved.
          
          
          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
          Services Summary...
          Service "CLRExtProc" has 1 instance(s).
            Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
              Handler(s):
                "DEDICATED" established:0 refused:0
                   LOCAL SERVER
          Service "MYSQL80w" has 1 instance(s).
            Instance "MYSQL80w", status UNKNOWN, has 1 handler(s) for this service...
              Handler(s):
                "DEDICATED" established:5 refused:0
                   LOCAL SERVER
          Service "Oracle8" has 1 instance(s).
            Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
              Handler(s):
                "DEDICATED" established:0 refused:0
                   LOCAL SERVER
          Service "d767cda564dd4065aeb98259d87281ee.office.adroot.bmogc.net" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
              Handler(s):
                "DEDICATED" established:1 refused:0 state:ready
                   LOCAL SERVER
          Service "orcl.office.adroot.bmogc.net" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
              Handler(s):
                "DEDICATED" established:1 refused:0 state:ready
                   LOCAL SERVER
          Service "orclXDB.office.adroot.bmogc.net" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
              Handler(s):
                "D000" established:0 refused:0 current:0 max:1022 state:ready
                   DISPATCHER <machine: OCLT70545153, pid: 3884>
                   (ADDRESS=(PROTOCOL=tcp)(HOST=OCLT70545153.office.adroot.bmogc.net)(PORT=63225))
          Service "orclpdb.office.adroot.bmogc.net" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
              Handler(s):
                "DEDICATED" established:1 refused:0 state:ready
                   LOCAL SERVER
          The command completed successfully
          

           

          C:\>tnsping MYSQL80w

           

          TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 30-SEP-2019 10:08:45
          
          Copyright (c) 1997, 2016, Oracle.  All rights reserved.
          
          Used parameter files:
          c:\LOCAL\network\admin\sqlnet.ora
          
          Used TNSNAMES adapter to resolve the alias
          Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA= (SID=MYSQL80w)) (HS=OK))
          OK (30 msec)
          

           

          C:\>tnsping ORCL_DEV

           

          TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 30-SEP-2019 10:18:03
          
          Copyright (c) 1997, 2016, Oracle.  All rights reserved.
          
          Used parameter files:
          c:\LOCAL\network\admin\sqlnet.ora
          
          Used TNSNAMES adapter to resolve the alias
          Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SID = ORCL)))
          OK (40 msec)
          
          C:\>
          

           

          create public database link MYSQL80w connect to "root" identified by "password1" using 'MYSQL80w';

           

           

          Please let me know what you find

          • 18. Re: Need Debugging help Oracle to MYSQL local single instance install
            rjsosi

            Also I was able to successfully connect to MYSQL using my 64 bit ODBC MYSQL80w driver via Advanced Query Tool. So I've verified the 64 bit ODBC driver works!

            • 19. Re: Need Debugging help Oracle to MYSQL local single instance install
              rjsosi

              I took a look at my ORACLE homes and found this.

               

              Here are the products installed on my main Oracle Home

               

               

              But on a previous ORacle Home I have these products installed and one of them in Oracle Net Services.

               

               

              At this point I'd like to remove this second Oracle Home and reinstall the products from it top the first on at the top.

               

              But do you think this is what's causing my ORA-28545: issue?

              • 20. Re: Need Debugging help Oracle to MYSQL local single instance install
                L. Fernigrini

                Usually, you do not need a client to be installed on a server where the DB is installed, the DB home includes all the client functionality. You can remove it and no probably won't need to reinstall it.

                 

                Can you post the entire error message again?

                 

                You may also want to check the listener log for more details regarding the error:

                 

                Listener Log File         C:\app\rlogin\virtual\product\12.2.0\diag\tnslsnr\OCLT70545153\listener\alert\log.xml 

                1 位用户发现它有用
                • 21. Re: Need Debugging help Oracle to MYSQL local single instance install
                  mxallen-Oracle

                  Like I said earlier,  change the name of the initmysql80w.ora file to initMYSQL80w.ora.

                  I have seen different cases for the gateway SID between tnsnames, listener, and the gateway init file

                  happen because of case issues.

                   

                  Matt

                  1 位用户发现它有用
                  • 22. Re: Need Debugging help Oracle to MYSQL local single instance install
                    L. Fernigrini

                    That's 100% sure on Unix/Linux environment, should not be a problem on Windows, but it is worth trying!!!!

                    • 23. Re: Need Debugging help Oracle to MYSQL local single instance install
                      rjsosi

                      I changed the name to init MYSQL80w.ora

                       

                      I also tried to remove the Oracle Home install I wasn't using (ORAClient12Home1).

                       

                      We have major Security limitations surrounding our Admin rights So I had to use Windows 10 to removed that Oracle CLient and not the Oracle de-installer.

                       

                      The point is when I started the machine back up and tested the Query it WORKED!!!

                       

                      I don't exactly know what I did , if it was renaming the initmysql80w.ora to initMYQL80w.ora or if It was related t me deinstalling what I could from the other Oracle home.

                       

                      Maybe it was a combination of the two.

                       

                      But the end result is from the SQL Developer Session:

                       

                      select * from first_one@MYSQL80w;

                       

                       

                      onetwothree
                      123
                      456

                       

                      From the table I created in MYSQL. From the MYSQL Session.

                       

                      create table mysql.first_one 
                      select 1 one, 2 two, 3 three
                      union
                      select 4 one, 5 two, 6 three;
                      

                       

                      There you have it!

                       

                      It's irritating though that this was not an obvious issue. I'm going to say it was fixed by me capitalizing MYSQL in initMYSQL80w.ora.

                       

                      This however didn't take effect until I rebooted my machine.  When I had just restarted my listener it didn't work still so the reboot factored in. So I'm going to say it was the capitalisation.

                       

                      However knowing Oracle's quirks and proclivity for it's persistence of "Mystery Errors" I'm also going to stress having one and Only One Oracle home to the folks I'm going to be setting this up for, because who knows what that could have caused.

                       

                      So now that 'proof of concept' is done I'll move on to 'Phase II' which is going to be connecting to the Sybase DB I alluded to in my other post.

                       

                      I'll move back to that post that most of you have responded to and pick it up from there.

                       

                      Thanks Again to ALL OF YOU!!!

                      • 24. Re: Need Debugging help Oracle to MYSQL local single instance install
                        rjsosi

                        No Need.

                         

                        It's now working.

                        1 2 上一个 下一个