1 2 Previous Next 24 Replies Latest reply on Sep 30, 2019 7:46 PM by rjsosi Go to original post
      • 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 person found this helpful
                  • 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 person found this helpful
                    • 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!!!

                        1 2 Previous Next