8 Replies Latest reply: Apr 5, 2013 6:21 AM by EdStevens RSS

    Help

    Venkadesh Raja
      Hi All,

      I'm Getting Following Error Pls Help.
      C:\Documents and Settings\XPMUser>rman
      
      Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 5 09:13:57 2013
      
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      
      RMAN> connect target sys@raja
      
      target database Password:
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      ORA-12154: TNS:could not resolve the connect identifier specified
      
      RMAN>
      Database i created manually not using dbca
        • 1. Re: Help
          Aman....
          Venkadesh wrote:
          Hi All,

          I'm Getting Following Error Pls Help.
          C:\Documents and Settings\XPMUser>rman
          
          Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 5 09:13:57 2013
          
          Copyright (c) 1982, 2005, Oracle.  All rights reserved.
          
          RMAN> connect target sys@raja
          
          target database Password:
          RMAN-00571: ===========================================================
          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
          RMAN-00571: ===========================================================
          ORA-12154: TNS:could not resolve the connect identifier specified
          
          RMAN>
          http://lmgtfy.com/?q=ORA-12154

          Aman....
          • 2. Re: Help
            user639304
            Hi,

            Before invoking rman, you have to set oracle_sid, like this:

            set oracle_sid= your_oracle_sid
            • 3. Re: Help
              Venkadesh Raja
              Aman.... wrote:
              Venkadesh wrote:
              Hi All,

              I'm Getting Following Error Pls Help.
              C:\Documents and Settings\XPMUser>rman
              
              Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 5 09:13:57 2013
              
              Copyright (c) 1982, 2005, Oracle.  All rights reserved.
              
              RMAN> connect target sys@raja
              
              target database Password:
              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              ORA-12154: TNS:could not resolve the connect identifier specified
              
              RMAN>
              http://lmgtfy.com/?q=ORA-12154

              Aman....
              tried already no luck
              • 4. Re: Help
                Venkadesh Raja
                user639304 wrote:
                Hi,

                Before invoking rman, you have to set oracle_sid, like this:

                set oracle_sid= your_oracle_sid
                actually i created db not using DBCA .. created manually by running sql script..

                Setting oracle sid is working fine for connecting database not for RMAN
                • 5. Re: Help
                  Troll35
                  Hello,

                  You should check that the entry "raja" exists in your tnsnames.

                  Or, if you are on the same server your database is running, then you could use the solution provided by user639304 :
                  set ORACLE_SID variable and connect with
                  rman target /
                  Regards,
                  • 6. Re: Help
                    ragu.dba.in
                    What is your listener status and tnsping ? check it for your database name
                    \>lsntctl status
                    \>tnsping raja

                    Configure it,if not.
                    • 7. Re: Help
                      sushaant
                      http://ora-12154.ora-code.com/
                      • 8. Re: Help
                        EdStevens
                        Aman.... wrote:
                        Venkadesh wrote:
                        Hi All,

                        I'm Getting Following Error Pls Help.
                        C:\Documents and Settings\XPMUser>rman
                        
                        Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 5 09:13:57 2013
                        
                        Copyright (c) 1982, 2005, Oracle.  All rights reserved.
                        
                        RMAN> connect target sys@raja
                        
                        target database Password:
                        RMAN-00571: ===========================================================
                        RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                        RMAN-00571: ===========================================================
                        ORA-12154: TNS:could not resolve the connect identifier specified
                        
                        RMAN>
                        http://lmgtfy.com/?q=ORA-12154

                        Aman....
                        the connection process is the same regardless of the client - sqlplus, sqldeveloper, .. and rman.

                        see: [url http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] Help! I can’t connect to my database
                        see: [url http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/] Help! I can’t connect to my database (part duex)

                        And especially:
                        see: [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] ora-12154 TNS:could not resolve the connect identifier specified