3 Replies Latest reply on Sep 9, 2013 10:48 AM by sohan.sonu

    ORA-12162: TNS:net service name is incorrectly specified

    sohan.sonu

      Dear All

      Good Morning

       

      I am facing problem when starting recovery manager from linux 4 64 bit version of oracle 11g

      Database is working fine and when i trying to start rman it giving

      i have set all parameter well and able to start database but facing problem when trying to start rman target /

       

      [oracle@std ~]$ rman target /

       

      Recovery Manager: Release 11.2.0.1.0 - Production on Mon Sep 9 00:12:46 2013

       

      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-00554: initialization of internal recovery manager package failed

      RMAN-04005: error from target database:

      ORA-12162: TNS:net service name is incorrectly specified

       

      Thanks & regards

      Sohan lal

        • 1. Re: ORA-12162: TNS:net service name is incorrectly specified
          sb92075

          sohan.sonu wrote:

           

          Dear All

          Good Morning

           

          I am facing problem when starting recovery manager from linux 4 64 bit version of oracle 11g

          Database is working fine and when i trying to start rman it giving

          i have set all parameter well and able to start database but facing problem when trying to start rman target /

           

          [oracle@std ~]$ rman target /

           

          Recovery Manager: Release 11.2.0.1.0 - Production on Mon Sep 9 00:12:46 2013

           

          Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

           

          RMAN-00571: ===========================================================

          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

          RMAN-00571: ===========================================================

          RMAN-00554: initialization of internal recovery manager package failed

          RMAN-04005: error from target database:

          ORA-12162: TNS:net service name is incorrectly specified

           

          Thanks & regards

          Sohan lal

           

           

          OS/Networking mis-configuration since should not see TNS related error without specifying @REMOTE.

           

          post results from following OS command

           

          env | sort

           

          post tail end of listener log file. which contains the 12162 status code

          • 2. Re: ORA-12162: TNS:net service name is incorrectly specified
            Pradeepcmst

            Hi Sohan lal,

            Do you have the database entry in tnsnames.ora file? If not you need to set it.

            And then you need to export the sid before calling rman target /

             

             

            Kindly check and let us know the status

             

             

            Regards,

            Pradeep. V

            • 3. Re: ORA-12162: TNS:net service name is incorrectly specified
              sohan.sonu

              Dear Pradeep

              Thanks for your reply

              Problem now solved , i set the tns parameter.

              Thanks