12 Replies Latest reply: Mar 7, 2013 10:44 AM by EdStevens RSS

    RMAN Connection Error

    user9080275
      Hi,

      Im getting the following error when trying to connect to Standby database as Rman, i have started the standby Database in nomount state, i want to restore controlfile from backup so when try to connect to Rman, the following error comes,


      *[imsoracle@dregpodb ~]$ rman target sys/egimsprd_R10Sys@egimsprdstby*

      Recovery Manager: Release 10.2.0.4.0 - Production on Wed Mar 6 18:22:11 2013

      Copyright (c) 1982, 2007, Oracle.  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-12528: TNS:listener: all appropriate instances are blocking new connections
      *[imsoracle@dregpodb ~]$*



      My listener.ora looks like the following,

      LISTENER =
      *(DESCRIPTION =*
      *(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))*
      *(ADDRESS = (PROTOCOL = TCP)(HOST = dregpodb.qia.local)(PORT = 1521))*
      *)*
      SECURE_REGISTER_LISTENER = (IPC)


      I have gone the Note ID ORA-12528: TNS:listener: all appropriate instances are blocking new connections *[ID 301099.1]*


      kindly anyone help me in resolving the error.

      waiting for your replies.


      Thanks in advance
        • 1. Re: RMAN Connection Error
          sb92075
          from the standby system issue the following OS commands

          lsnrctl status
          lsnrctl service

          you'll see that the listener reports that the SERVICE_NAME is in a blocked stated; since the DB is in NOMOUNT.

          listener.ora must be modified so the listener know about this DB/service even when it is down.
          • 2. Re: RMAN Connection Error
            user9080275
            Hi,

            How should i modify my listener.ora, What all parameters do i need to add in the below listener.ora file, which is the current file,

            LISTENER =
            *(DESCRIPTION =*
            *(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))*
            *(ADDRESS = (PROTOCOL = TCP)(HOST = dregpodb.qia.local)(PORT = 1521))*
            *)*
            SECURE_REGISTER_LISTENER = (IPC)


            And what about the tnsnames.ora, how should i modify that also.???


            Kindly assist, waiting for your update.

            Thanks
            • 3. Re: RMAN Connection Error
              sb92075
              user9080275 wrote:
              Hi,

              How should i modify my listener.ora, What all parameters do i need to add in the below listener.ora file, which is the current file,

              LISTENER =
              *(DESCRIPTION =*
              *(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))*
              *(ADDRESS = (PROTOCOL = TCP)(HOST = dregpodb.qia.local)(PORT = 1521))*
              *)*
              SECURE_REGISTER_LISTENER = (IPC)


              And what about the tnsnames.ora, how should i modify that also.???


              Kindly assist, waiting for your update.

              Thanks
              http://docs.oracle.com/cd/B28359_01/network.111/b28317/listener.htm#CCHCIJFE
              • 4. Re: RMAN Connection Error
                user9080275
                Hi

                Do i need the following parameters in listener.ora file.?

                LISTENER=
                *(DESCRIPTION=*
                *(ADDRESS_LIST=*
                *(ADDRESS=(PROTOCOL=tcp)(HOST=sale-server)(PORT=1521))*
                *(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))*
                SID_LIST_LISTENER=
                *(SID_LIST=*
                *(SID_DESC=*
                *(GLOBAL_DBNAME=sales.us.example.com)*
                *(ORACLE_HOME=/oracle11g)*
                *(SID_NAME=sales))*
                *(SID_DESC=*
                *(SID_NAME=plsextproc)*
                *(ORACLE_HOME=/oracle11g)*
                *(PROGRAM=extproc)))*


                What about the tnsnames.ora .??

                Do we need to make any changes.?

                Please advice.


                Thanks
                • 5. Re: RMAN Connection Error
                  vlethakula
                  If that doesn't work add
                  modify tnsnames.ora like below (UR=A) add


                  **** =
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521))
                  (CONNECT_DATA =
                  (UR=A)
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = ****)
                  )
                  )
                  • 6. Re: RMAN Connection Error
                    user9080275
                    Hi,


                    I will try both and update you.

                    Thanks for your support.


                    Regards,
                    Saneel
                    • 7. Re: RMAN Connection Error
                      EdStevens
                      user9080275 wrote:
                      Hi

                      Do i need the following parameters in listener.ora file.?

                      LISTENER=
                      *(DESCRIPTION=*
                      *(ADDRESS_LIST=*
                      *(ADDRESS=(PROTOCOL=tcp)(HOST=sale-server)(PORT=1521))*
                      *(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))*
                      SID_LIST_LISTENER=
                      *(SID_LIST=*
                      *(SID_DESC=*
                      *(GLOBAL_DBNAME=sales.us.example.com)*
                      *(ORACLE_HOME=/oracle11g)*
                      *(SID_NAME=sales))*
                      *(SID_DESC=*
                      *(SID_NAME=plsextproc)*
                      *(ORACLE_HOME=/oracle11g)*
                      *(PROGRAM=extproc)))*


                      What about the tnsnames.ora .??
                      Shouldn't need to, the key was adding the SID_LIST section to listener.ora, so that the listener would know about databases even when they are down. That's the difference between dynamic registration and static registration. tnsnames is a client configuration, and the client really doesn't care how the listener came to know of a database.
                      >
                      Do we need to make any changes.?

                      Please advice.


                      Thanks
                      • 8. Re: RMAN Connection Error
                        user9080275
                        Hi,

                        then if i edit my listener.ora like below, will it work, is there anything more to be modified.

                        LISTENER=
                        *(DESCRIPTION=*
                        *(ADDRESS_LIST=*
                        *(ADDRESS=(PROTOCOL=tcp)(HOST=dregpodb.qia.qa)(PORT=1521))*
                        *(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))))*
                        SID_LIST_LISTENER=
                        *(SID_LIST=*
                        *(SID_DESC=*
                        *(GLOBAL_DBNAME=egimsprdstby.qia.qa)*
                        *(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)*
                        *(SID_NAME=egimsprdstby))*
                        *(SID_DESC=*
                        *(SID_NAME=plsextproc)*
                        *(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)*
                        *(PROGRAM=extproc)))*


                        please advice.


                        thanks
                        • 9. Re: RMAN Connection Error
                          sb92075
                          user9080275 wrote:
                          Hi,

                          then if i edit my listener.ora like below, will it work, is there anything more to be modified.

                          LISTENER=
                          *(DESCRIPTION=*
                          *(ADDRESS_LIST=*
                          *(ADDRESS=(PROTOCOL=tcp)(HOST=dregpodb.qia.qa)(PORT=1521))*
                          *(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))))*
                          SID_LIST_LISTENER=
                          *(SID_LIST=*
                          *(SID_DESC=*
                          *(GLOBAL_DBNAME=egimsprdstby.qia.qa)*
                          *(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)*
                          *(SID_NAME=egimsprdstby))*
                          *(SID_DESC=*
                          *(SID_NAME=plsextproc)*
                          *(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)*
                          *(PROGRAM=extproc)))*


                          please advice.


                          thanks
                          yes, it will work; unless of course some error is thrown.

                          let us know what happens when you actually try it.
                          • 10. Re: RMAN Connection Error
                            user9080275
                            Hi,

                            I have modified the listener.ora and tnsnames.ora as follows, but when i trying to connect as Rman it is giving me error like,

                            *[imsoracle@dregpodb admin]$ rman target sys/egimsprd_R10Sys@EGIMSPRDSTBY*

                            Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 7 08:33:58 2013

                            Copyright (c) 1982, 2007, Oracle.  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-01031: insufficient privileges

                            *[imsoracle@dregpodb admin]$ ps -ef |grep tns*
                            mbaig    32075     1  0 08:31 ?        00:00:00 /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
                            *500 32392 31086 0 08:40 pts/2 00:00:00 grep tns*


                            listener.ora

                            LISTENER =
                            *(DESCRIPTION =*
                            *(ADDRESS_LIST =*
                            *(ADDRESS =(PROTOCOL=tcp)(HOST=dregpodb.qia.local)(PORT=1521))*
                            *)*
                            *)*
                            SID_LIST_LISTENER =
                            *(SID_LIST =*
                            *(SID_DESC =*
                            *(SID_NAME= EGIMSPRDSTBY)*
                            *(ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1)*
                            *)*
                            *)*

                            tnsnames.ora

                            EGIMSPRDSTBY =
                            *(DESCRIPTION =*
                            *(ADDRESS = (PROTOCOL = TCP)(HOST = dregpodb.qia.local)(PORT = 1521))*
                            *(CONNECT_DATA =*
                            *(UR= A)*
                            *(SERVER = DEDICATED)*
                            *(SID = EGIMSPRDSTBY)*
                            *)*
                            *)*
                            What could be the reason for this.

                            Kindly assist me.


                            Thanks
                            • 11. Re: RMAN Connection Error
                              user9080275
                              [imsoracle@dregpodb ~]$ lsnrctl start

                              LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 07-MAR-2013 09:20:08

                              Copyright (c) 1991, 2007, Oracle. All rights reserved.

                              Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

                              TNSLSNR for Linux: Version 10.2.0.4.0 - Production
                              System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
                              Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
                              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dregpodb.qia.local)(PORT=1521)))

                              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dregpodb.qia.local)(PORT=1521)))
                              STATUS of the LISTENER
                              ------------------------
                              Alias LISTENER
                              Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
                              Start Date 07-MAR-2013 09:20:08
                              Uptime 0 days 0 hr. 0 min. 0 sec
                              Trace Level off
                              Security ON: Local OS Authentication
                              SNMP OFF
                              Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
                              Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
                              Listening Endpoints Summary...
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dregpodb.qia.local)(PORT=1521)))
                              Services Summary...
                              Service "EGIMSPRDSTBY" has 1 instance(s).
                              Instance "EGIMSPRDSTBY", status UNKNOWN, has 1 handler(s) for this service...
                              The command completed successfully
                              • 12. Re: RMAN Connection Error
                                EdStevens
                                user9080275 wrote:
                                Hi,

                                I have modified the listener.ora and tnsnames.ora as follows, but when i trying to connect as Rman it is giving me error like,

                                *[imsoracle@dregpodb admin]$ rman target sys/egimsprd_R10Sys@EGIMSPRDSTBY*

                                Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 7 08:33:58 2013

                                Copyright (c) 1982, 2007, Oracle.  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-01031: insufficient privileges

                                *[imsoracle@dregpodb admin]$ ps -ef |grep tns*
                                mbaig    32075     1  0 08:31 ?        00:00:00 /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
                                *500 32392 31086 0 08:40 pts/2 00:00:00 grep tns*


                                listener.ora

                                LISTENER =
                                *(DESCRIPTION =*
                                *(ADDRESS_LIST =*
                                *(ADDRESS =(PROTOCOL=tcp)(HOST=dregpodb.qia.local)(PORT=1521))*
                                *)*
                                *)*
                                SID_LIST_LISTENER =
                                *(SID_LIST =*
                                *(SID_DESC =*
                                *(SID_NAME= EGIMSPRDSTBY)*
                                *(ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1)*
                                *)*
                                *)*

                                tnsnames.ora

                                EGIMSPRDSTBY =
                                *(DESCRIPTION =*
                                *(ADDRESS = (PROTOCOL = TCP)(HOST = dregpodb.qia.local)(PORT = 1521))*
                                *(CONNECT_DATA =*
                                *(UR= A)*
                                *(SERVER = DEDICATED)*
                                *(SID = EGIMSPRDSTBY)*
                                *)*
                                *)*
                                What could be the reason for this.

                                Kindly assist me.


                                Thanks
                                What does the error message say?
                                "ORA-01031: insufficient privileges"

                                How do I research that error?
                                start [url http://lmgtfy.com/?q=ora-1031]here

                                Edited by: EdStevens on Mar 7, 2013 10:43 AM

                                Edited by: EdStevens on Mar 7, 2013 10:44 AM