13 Replies Latest reply: Sep 11, 2013 4:08 PM by TSharma-Oracle RSS

    SQL*NET or Oracle Net Services

    OracleNewbie828

      Installed ODAC11.2.0.3 on my machine and able to connect to DB.

       

       

      Is Oracle Net Services (http://docs.oracle.com/cd/B28359_01/network.111/b28316/intro.htm) similar to SQL*Net?

      If so, how do you tell the version of Oracle Net Services being installed?

       

      This link Troubleshooting Oracle Net Services says to check SQLNET.LOG on the server, however, I do not have access to the server. Is there another way to tell which version?

       

      Thanks.

        • 1. Re: SQL*NET or Oracle Net Services
          TSharma-Oracle

          Check this below link. You  have your answer.

           

          https://forums.oracle.com/thread/2516111

          • 2. Re: SQL*NET or Oracle Net Services
            EdStevens

            OracleNewbie828 wrote:

             

            Installed ODAC11.2.0.3 on my machine and able to connect to DB.

             

             

            Is Oracle Net Services (http://docs.oracle.com/cd/B28359_01/network.111/b28316/intro.htm) similar to SQL*Net?

            Not "similar".  Same.



            If so, how do you tell the version of Oracle Net Services being installed?

             

            Here's one way:

             

            C:\Users\estevens\Documents\sql>sqlplus /nolog

            SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 11 10:36:37 2013

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

             

            SQL>




            This link Troubleshooting Oracle Net Services says to check SQLNET.LOG on the server, however, I do not have access to the server. Is there another way to tell which version?

             

            Network connections have two sides .. the client and the server.  The two sides do not have to be the same version.  If you don't have access to the server, then you are only concerned with the client.

            SQLNET.LOG only gets written/created in response to a problem.  And it gets written in the "current" directory of the process that had the problem.  So you could have several of them .. or none.


            Thanks.
            • 3. Re: SQL*NET or Oracle Net Services
              OracleNewbie828

              Here's one way:

               

              C:\Users\estevens\Documents\sql>sqlplus /nolog

              SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 11 10:36:37 2013

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

               

              SQL>

               

               

              Is this SQLPLUS version or Net Services?

              • 4. Re: SQL*NET or Oracle Net Services
                OracleNewbie828

                Unfortunately I do not have access to Oracle Support to check

                Note: 818454.1 How To Find Oracle Client Version And Check If It Is Instant Client Or Full Client

                 

                Thanks though.

                • 5. Re: SQL*NET or Oracle Net Services
                  EdStevens

                  OracleNewbie828 wrote:

                   

                  Here's one way:

                   

                  C:\Users\estevens\Documents\sql>sqlplus /nolog

                  SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 11 10:36:37 2013

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

                   

                  SQL>

                   

                   

                  Is this SQLPLUS version or Net Services?

                  Technically, it's the version for sqlplus, but sqlplus and "Net Services" got installed as part of the same "Oracle Client" installation.

                  If you don't think that's close enough for your purposes (what, exactly, are your purposes?) ...

                  You could also fire up the Oracle Universal Installer and see what is installed.

                  You could fire up regedit and take a look at HKLM/software/oracle

                  • 6. Re: SQL*NET or Oracle Net Services
                    TSharma-Oracle

                    Run the OUI (Oracle Universal Installer in your programs) to find the list of Products and Product versions from the list of Installed Products.

                     

                    Server side:

                    select distinct NETWORK_SERVICE_BANNER from v$session_connect_info

                    where NETWORK_SERVICE_BANNER like '%Version%' ;

                     

                    select * from v$verison;

                    • 7. Re: SQL*NET or Oracle Net Services
                      OracleNewbie828

                      My purpose - provide an inventory to our tech support department manager. And Oracle Instant Client 11.2.0.3.0 was not enough for him. He wants to know every piece and version installed.

                       

                      What will I be looking for on the registry route? I see KEY_OraClient11g_home1 but nothing in there for Net Services.

                      Also on Universal Installer, I see the client home information; but, where do I find the Net Services information?

                      • 8. Re: SQL*NET or Oracle Net Services
                        TSharma-Oracle

                        Did you try what I had said to use Oracle Universal Installer(OUI). You will se the version of each and every component  installed. Use OUI.

                         


                        • 9. Re: SQL*NET or Oracle Net Services
                          OracleNewbie828

                          I did ... I clicked on Installed Products on the OUI, then expand the '+' sign for the home, then the '+' sign for Oracle Data Access Components for Oracle Client 11.2.0.3.20.

                          In there I see:

                          Oracle Providers for .NET 11.2.0.3.0

                          Oracle Providers for ASP.NET 11.2.0.3.0

                          Oracle Developer Tools for Visual Studio 11.2.0.3.20

                          Oracle Providers for ASP.NET 11.2.0.3.0

                          Oracle Providers for OLE DB 11.2.0.3.0

                          Oracle Providers for OLE 11.2.0.3.0

                          Oracle Services for Microsoft Transaction Server 11.2.0.3.0

                          Oracle Data Access Components Samples 11.2.0.3.0

                          Oracle Universal Installer 11.2.0.3.0

                          Oracle Instant Client 11.2.0.3.0

                          • 10. Re: SQL*NET or Oracle Net Services
                            TSharma-Oracle

                            Go to oracle home/bin and check for the following or similar dlls which used by Sql*Net

                             

                            oran11.dll

                            oranbeq11.dll

                            orancds11.dll

                            ORANCRYPT11D.DLL

                            oranhost11.dll

                            oranipc11.dll

                            orannzmcs11.dll

                            and there are many more dlld starts with oran*.dll.

                             

                            If you right click on it and hit properties, then go to the details section, there you will see the file version and file description. You can take  the file version from there and send it to whatever you want.

                            ** This will be same as your sqlplus version as Ed said above**

                            • 11. Re: SQL*NET or Oracle Net Services
                              EdStevens

                              OracleNewbie828 wrote:

                               

                              I did ... I clicked on Installed Products on the OUI, then expand the '+' sign for the home, then the '+' sign for Oracle Data Access Components for Oracle Client 11.2.0.3.20.

                              In there I see:

                              Oracle Providers for .NET 11.2.0.3.0

                              Oracle Providers for ASP.NET 11.2.0.3.0

                              Oracle Developer Tools for Visual Studio 11.2.0.3.20

                              Oracle Providers for ASP.NET 11.2.0.3.0

                              Oracle Providers for OLE DB 11.2.0.3.0

                              Oracle Providers for OLE 11.2.0.3.0

                              Oracle Services for Microsoft Transaction Server 11.2.0.3.0

                              Oracle Data Access Components Samples 11.2.0.3.0

                              Oracle Universal Installer 11.2.0.3.0

                              Oracle Instant Client 11.2.0.3.0

                              Looks to me like that's what you need.  Surely the PHB isn't expecting a list down to the level of the individual DLLs ....  if so, I'd be tempted to make him choke on his own requirement.  Do as TSharma said, only get every blessed file in oracle_home\bin

                               

                              And if that's what he's expecting, I wonder what he thinks he's going to do with that information ...

                              • 12. Re: SQL*NET or Oracle Net Services
                                OracleNewbie828

                                First of all, thank you so much to both of you for your help.

                                I don't know what's on his mind or what is he going to do with that information. That's above my pay grade.

                                 

                                Frankly, I'm regretting installing the client myself. I should have just let him / his staff install it and they can inventory as much as they want. Of course, then they'll have more reasons like "we don't know what you need".

                                • 13. Re: SQL*NET or Oracle Net Services
                                  TSharma-Oracle

                                  Welcome to the corporate world! If you thing your question has been answered, you can close this question.