8 Replies Latest reply on Aug 11, 2016 6:33 PM by mseberg

    Radius and version 4.1.3

    mseberg

      I have version 4.1.3.20 build main-20.78 with java 1.8.0_60 setup on Windows 10.

       

      My path env looks like this:

       

      C:\instantclient_12_1

      C:\app\client\se\product\12.1.0\client_1\bin

       

      Under database/Advanced

       

      Use Oracle client is set to:  Instant Client: file:/C:/instantclient_12_1/

      Use OCI/Thick driver is checked.

       

      All my external radius connections work without issue.

       

      However if I try the same setup on Windows 7 with the same Instant Client and SQL Dev zip files I get ORA-01017 Invalid Username/Password. I even moved the same tnsnames.ora and sqlnet.ora files to the Windows 7 workstation but the results are the same.

       

      Is there anything else I can try?

        • 1. Re: Radius and version 4.1.3
          thatJeffSmith-Oracle

          maybe compare the path on your 7 vs 10 box...it might be finding the wrong home/drivers

          • 2. Re: Radius and version 4.1.3
            mseberg

            Thanks, I wish it were that easy. However I did the setup on a third workstation, same issue.

            • 3. Re: Radius and version 4.1.3
              thatJeffSmith-Oracle

              what do you see when you the test button on the client setup dialog? it should write out some info to a new log panel showing the drivers being loaded, etc.

              • 4. Re: Radius and version 4.1.3
                mseberg

                I assume you are looking for this right?

                 

                Testing the Instant Client located at C:\instantclient\instantclient_12_1

                Testing client directory ... OK

                Testing loading Oracle JDBC driver ... OK

                Testing checking Oracle JDBC driver version ... OK

                  Driver version: 12.1.0.2.0

                Testing testing native OCI library load ... OK

                Success!

                 

                 

                 

                Exact error message on connect test:

                 

                Status : Failure - Test Failed: ORA-01017: invalid/password; logon denied.

                 

                 

                A user with a database password ( not external ) connects without issue.

                 

                 

                 

                sqlnet.ora has this setting:

                 

                SQLNET.AUTHENTICATION_SERVICES= (BEQ, RADIUS, NONE)

                 

                But it appears a client install resets this to:

                 

                SQLNET.AUTHENTICATION_SERVICES= (NTS)

                • 5. Re: Radius and version 4.1.3
                  thatJeffSmith-Oracle

                  sqlnet.ora has this setting:

                   

                  SQLNET.AUTHENTICATION_SERVICES= (BEQ, RADIUS, NONE)

                   

                  But it appears a client install resets this to:

                   

                  SQLNET.AUTHENTICATION_SERVICES= (NTS)

                   

                  so what's in your sqlnet.ora? on your win10 and win7 box?

                  1 person found this helpful
                  • 6. Re: Radius and version 4.1.3
                    mseberg

                    Just this:

                     

                    # 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.AUTHENTICATION_SERVICES= (NTS)

                     

                    #SQLNET.AUTHENTICATION_SERVICES= (NTS)

                     

                    SQLNET.AUTHENTICATION_SERVICES= (BEQ, RADIUS, NONE)

                     

                    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

                     

                     

                    Both boxes have matching sqlnet.ora files.

                    • 7. Re: Radius and version 4.1.3
                      thatJeffSmith-Oracle

                      is it working for sqlplus on the win7 box?

                       

                      if the answer is 'yes' then something Java-weird is happening.

                       

                      If the answer is 'no' then it's a sqlnet issue most likely

                       

                      in either scenario, you might want to open a SR with My Oracle Support.

                      1 person found this helpful
                      • 8. Re: Radius and version 4.1.3
                        mseberg

                        So SQL Plus does not work. And TNSPING offers the clue it's using the old sqlnet.ora file:

                         

                        \product\11.2.0\client_1\network\admin\sqlnet.ora

                         

                        This is the main difference from a working setup and ones that don't. Both Windows 7 workstations had an 11 client on them.

                         

                        TNS_ADMIN is set to the old Oracle home

                         

                        set TNS_ADMIN=<full_path_to_sqlnet_file>             Fixes SQL Plus.

                         

                        SQL Developer still fails.

                         

                        Work Around

                         

                        I created a batch file "startsqldev.bat" with these contents.

                         

                        set TNS_ADMIN=C:\app\client\se\product\12.1.0\client_1\network\admin

                        START C:\sql_dev413\sqldeveloper\sqldeveloper.exe

                         

                        This works!

                         

                        Thanks for your time.