1 2 Previous Next 24 Replies Latest reply: Mar 27, 2012 12:08 AM by 899401 RSS

    ORA-12560: TNS:protocol adapter error

    899401
      Hi,

      while connecting database i am getting below mentioned error

      Microsoft Windows [Version 6.0.6002]
      Copyright (c) 2006 Microsoft Corporation. All rights reserved.

      C:\Users\Administrator>sqlplus /NOLOG

      SQL*Plus: Release 10.1.0.5.0 - Production on Mon Mar 26 20:01:36 2012

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

      SQL> conn /as Sysdba
      ERROR:
      ORA-12560: TNS:protocol adapter error

      SQL>

      thanks
        • 1. Re: ORA-12560: TNS:protocol adapter error
          sb92075
          896398 wrote:
          Hi,

          while connecting database i am getting below mentioned error

          Microsoft Windows [Version 6.0.6002]
          Copyright (c) 2006 Microsoft Corporation. All rights reserved.

          C:\Users\Administrator>sqlplus /NOLOG

          SQL*Plus: Release 10.1.0.5.0 - Production on Mon Mar 26 20:01:36 2012

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

          SQL> conn /as Sysdba
          ERROR:
          ORA-12560: TNS:protocol adapter error

          SQL>

          thanks
          Handle:     896398
          Status Level:     Newbie
          Registered:     Nov 9, 2011
          Total Posts:     172
          Total Questions:     50 (39 unresolved)

          why so many unanswered questions?

          ORA-12560 indicates that something is wrong in external/OS environment.
          Oracle is victim; not the culprit.
          problem root cause & fix are external to Oracle
          • 2. Re: ORA-12560: TNS:protocol adapter error
            Shivananda Rao
            Check if the Oracle Database Service is started or not under Services.msc

            Start->run->services.msc->OracleService<SID> is started or not.
            • 3. Re: ORA-12560: TNS:protocol adapter error
              899401
              Hi,
              actually could not get time to check but i will certainly do that

              can u Please help me with this

              thanks
              • 4. Re: ORA-12560: TNS:protocol adapter error
                899401
                Hi,
                yes it showing started

                Oracleservicevisr29 status-started

                thanks
                • 5. Re: ORA-12560: TNS:protocol adapter error
                  Shivananda Rao
                  Set the Oracle Home and Oracle SID in the command prompt and then try to make the connection to the database

                  set ORACLE_HOME=<ORACLE_HOME PATH>
                  set ORACLE_SID=<SID NAME>
                  sqlplus / as sysdba
                  • 6. Re: ORA-12560: TNS:protocol adapter error
                    899401
                    Hi,

                    I am still getting an error message
                    C:\Users\Administrator>set ORACLE_HOME=C:\visr29\db\tech_st\11.1.0

                    C:\Users\Administrator>set ORACLE_HOME=C:\visr29\db\tech_st\11.1.0

                    C:\Users\Administrator>set ORACLE_SID=visr29

                    C:\Users\Administrator>sqlplus / as sysdba

                    SQL*Plus: Release 10.1.0.5.0 - Production on Mon Mar 26 13:20:42 2012

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

                    ERROR:
                    ORA-12557: TNS:protocol adapter not loadable
                    • 7. Re: ORA-12560: TNS:protocol adapter error
                      CKPT
                      What is the status of the service?
                      check start --> run --> services.msc , you can see servicename as "Oracleservice<sid>" , it should be started.
                      SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 26 23:18:38 2012
                      Copyright (c) 1982, 2010, Oracle.  All rights reserved.
                      ERROR:
                      "ORA-12560: TNS:protocol adapter error"
                      Enter user-name:
                      
                      
                      --- After starting service --
                      
                      C:\Users\bn2676>sqlplus / as sysdba
                      SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 26 23:20:37 2012
                      Copyright (c) 1982, 2010, Oracle.  All rights reserved.
                      Connected to:
                      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                      With the Partitioning, OLAP, Data Mining and Real Application Testing options
                      GLOBAL_NAME
                      ----------------------------------------------------------------------------------------------------
                      sys@ORCL
                      
                      sys@ORCL>
                      • 8. Re: ORA-12560: TNS:protocol adapter error
                        899401
                        Hi,
                        after restarting the services getting error mesage

                        Microsoft Windows [Version 6.0.6002]
                        Copyright (c) 2006 Microsoft Corporation. All rights reserved.

                        C:\Users\Administrator>sqlplus / as sysdba

                        SQL*Plus: Release 10.1.0.5.0 - Production on Mon Mar 26 23:46:00 2012

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

                        ERROR:
                        ORA-12560: TNS:protocol adapter error


                        Enter user-name:



                        thanks
                        • 9. Re: ORA-12560: TNS:protocol adapter error
                          899401
                          Hi,

                          error message got change please see

                          Microsoft Windows [Version 6.0.6002]
                          Copyright (c) 2006 Microsoft Corporation. All rights reserved.

                          C:\Users\295373>sqlplus / as sysdba

                          SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 26 23:49:43 2012

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

                          ERROR:
                          ORA-12638: Credential retrieval failed


                          Enter user-name:
                          • 10. Re: ORA-12560: TNS:protocol adapter error
                            sb92075
                            post content of sqlnet.ora file
                            • 11. Re: ORA-12560: TNS:protocol adapter error
                              912595
                              896398 wrote:
                              Hi,

                              error message got change please see

                              Microsoft Windows [Version 6.0.6002]
                              Copyright (c) 2006 Microsoft Corporation. All rights reserved.

                              C:\Users\295373>sqlplus / as sysdba

                              SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 26 23:49:43 2012

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

                              ERROR:
                              ORA-12638: Credential retrieval failed


                              Enter user-name:
                              Find the sqlnet.ora file in C:\visr29\db\tech_st\11.1.0\network\admin\sqlnet.ora
                              • 12. Re: ORA-12560: TNS:protocol adapter error
                                899401
                                Hi,

                                Please find the contains of sqlnet.ora file

                                # 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)


                                thanks
                                • 13. Re: ORA-12560: TNS:protocol adapter error
                                  912595
                                  896398 wrote:
                                  Hi,

                                  Please find the contains of sqlnet.ora file

                                  # 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)


                                  thanks
                                  Change
                                  SQLNET.AUTHENTICATION_SERVICES = (NTS)
                                  to
                                  SQLNET.AUTHENTICATION_SERVICES = (NONE)

                                  Then try
                                  • 14. Re: ORA-12560: TNS:protocol adapter error
                                    899401
                                    Hi,

                                    still the same message,

                                    Microsoft Windows [Version 6.0.6002]
                                    Copyright (c) 2006 Microsoft Corporation. All rights reserved.

                                    C:\Users\295373>sqlplus/ as sysdba

                                    SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 27 00:25:23 2012

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

                                    ERROR:
                                    ORA-12638: Credential retrieval failed


                                    Enter user-name:

                                    thanks
                                    1 2 Previous Next