7 Replies Latest reply: Sep 10, 2013 6:15 AM by DK2010 RSS

    ORA-28547

    dba88

      Hi

       

      I have a database 11g in linux 86-64 server

      i have been facing an issue when i try to connect it with follwoing command, it gives error

       

      [oracle@abc admin]$ sqlplus sys@abcdb

       

      SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 10 11:29:34 2013

       

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

       

      Enter password:

      ERROR:

      ORA-28547: connection to server failed, probable Oracle Net admin error

       

      however it connect well if I do

       

      [oracle@abc admin]$ sqlplus / as sysdba

       

      SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 10 11:32:46 2013

       

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

       

       

      Connected to:

      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

       

      SQL>

       

       

      where can be the problem

        • 1. Re: ORA-28547
          DK2010

          Hi,

           

          check your sqlnet.ora file under $ORACLE_HOME/network/admin  and set /add the  Entry and try  SQLNET.AUTHENTICATION_SERVICES = (NONE)

           

          HTH

          • 2. Re: ORA-28547
            Fran

            dba88 escribió:

             

            Hi

             

            I have a database 11g in linux 86-64 server

            i have been facing an issue when i try to connect it with follwoing command, it gives error

             

            [oracle@abc admin]$ sqlplus sys@abcdb

             

            SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 10 11:29:34 2013

             

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

             

            Enter password:

            ERROR:

            ORA-28547: connection to server failed, probable Oracle Net admin error

             

            however it connect well if I do

             

            [oracle@abc admin]$ sqlplus / as sysdba

             

            SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 10 11:32:46 2013

             

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

             

             

            Connected to:

            Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

            With the Partitioning, OLAP, Data Mining and Real Application Testing options

             

            SQL>

             

             

            where can be the problem

            28547, 0000, "connection to server failed, probable Oracle Net admin error"

            // *Cause:   A failure occurred during initialization of a network connection

            //           from a client process to the Oracle server.  The connection

            //           was completed but a disconnect occurred while trying to

            //           perform protocol-specific initialization, usually due to

            //           use of different network protocols by opposite sides

            //           of the connection.  This usually is caused by incorrect

            //           Oracle Net administrative setup for database links or external

            //           procedure calls.   The most frequent specific causes are:

            //           --  The connection uses a connect string which refers

            //               to a Heterogeneous Services agent instead of

            //               an Oracle server.

            //           --  The connection uses a connect string which includes

            //               an (HS=) specification.

            //           --  Hitting Ctrl+C before connection initialization is

            //               complete.

            //           --  Using DRCP on Windows with SQLNET.AUTHENTICATION_SERVICES

            //               set to NTS.

            //           --  Connection timeout due to SQLNET.INBOUND_CONNECT_TIMEOUT

            //               parameter when all shared servers are busy in

            //               shared server configuration.

            // *Action:  Check Oracle Net administration in the following ways:

            //           --  When using TNSNAMES.ORA or an Oracle Names server, make sure

            //               that the client connection to the Oracle server uses

            //               the correct service name or SID.

            //           --  Check LISTENER.ORA on the connection end point's host machine

            //               to assure that this service name or SID refers

            //               to the correct server.

            //           --  Confirm in TNSNAMES.ORA or the equivalent service definition

            //               that the connect string does not contain (HS=).

            //           --  Set SQLNET.AUTHENTICATION_SERVICES to NONE when using DRCP

            //               on Windows.

             

            It's normal that you can connect "/ as sysdba"

            • 3. Re: ORA-28547
              sybrand_b

              sqlplus sys@<service> is incorrect syntax as you didn't use 'as sysdba'

              Oracle will only note this after connection!

              Then as to your question 'were is the problem?: Did you even look in sqlnet.log (which should have been created after the error). Did you even turn tracing on in sqlnet.ora.

              As we can not see what is in your sqlnet.log or in your trace files, how can anyone answer this question?

               

              -------------

              Sybrand Bakker

              Senior Oracle DBA

              • 4. Re: ORA-28547
                dba88

                i added the entry SQLNET.AUTHENTICATION_SERVICES = (NONE) to sqlnet.ora

                but the error is persisting,

                 

                moreover, i tried with a number of users, with each it gives the same error:

                 

                [oracle@abc admin]$ sqlplus scott/welcome@abcdb

                 

                SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 10 11:53:25 2013

                 

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

                 

                ERROR:

                ORA-28547: connection to server failed, probable Oracle Net admin error

                • 5. Re: ORA-28547
                  DK2010

                  Hi,

                   

                  Can you please show here your TNS/LISTENER and sqlnet.ora files... You can mask your IP/Host from  there

                  • 6. Re: ORA-28547
                    dba88

                    this is my listener.ora file

                    SID_LIST_LISTENER =

                      (SID_LIST =

                        (SID_DESC =

                          (SID_NAME = abcdb)

                          (ORACLE_HOME = /u01/db/tech_st/11.2.0.2)

                          (PROGRAM = extproc)

                        )

                       )

                    LISTENER =

                      (DESCRIPTION_LIST =

                        (DESCRIPTION =

                          (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1523))

                         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

                        )

                      )

                     

                    ADR_BASE_LISTENER = /u01/db/tech_st/11.2.0.2

                     

                    tnsnames.ora

                     

                    ABCDB =

                         (DESCRIPTION =

                           (ADDRESS_LIST =

                               (ADDRESS =

                                 (PROTOCOL = TCP)

                                 (Host = xxx)

                                 (Port = 1523)

                               )

                           )

                           (CONNECT_DATA = (SERVICE_NAME = abcdb)

                           )

                         )

                     

                     

                     

                    sqlnet.ora

                     

                    SQLNET.AUTHENTICATION_SERVICES = (NONE)

                    NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)

                    SQLNET.EXPIRE_TIME= 10

                    #SQLNET.INBOUND_CONNECT_TIMEOUT =60

                    DIAG_ADR_ENABLED=ON

                    ADR_BASE=/u01db/tech_st/11.2.0.2/network/admin

                     

                     

                    IFILE=/u01/db/tech_st/11.2.0.2/network/admin/sqlnet_ifile.ora

                    • 7. Re: ORA-28547
                      DK2010

                      Hi,

                      What is in the IFILE of sqlnet.ora, comment it and try

                      #IFILE=/u01/db/tech_st/11.2.0.2/network/admin/sqlnet_ifile.ora