1 2 Previous Next 21 Replies Latest reply: Jan 10, 2010 1:50 AM by 744631 RSS

    RMAN-04004@ORA-01017

    MarGur
      Hello everybody!

      Please, help me:

      i'm trying to tune recovery catalog database. i've already built a database called RECOVERY to store the recovery catalog. I pointed to the database where the recovery database will reside. then i created the user, that will store the catalog:

      SQL> create user rman_user identified by oraclepass
      2 default tablespace data
      3 temporary tablespace temp;
      User created.


      then i granted those permissions:

      SQL> grant connect, resource, recovery_catalog_owner to rman_user;
      Grant succeeded.
      SQL>


      and then, when i launch RMAN tool:
      C:\Documents and Settings\>rman

      and trying to:
      RMAN> connect catalog rman_user/oraclepass

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/pa
      ssword; logon denied


      i didn't get why.. there is one user "rman" with pass, that works in another tasks.. what am i doing wrong?

      thank you very much for you cooperations.
        • 1. Re: RMAN-04004@ORA-01017
          orafad
          Shouldnt you use u/pw@service for the recovery catalog instance?
          • 2. Re: RMAN-04004@ORA-01017
            498380
            Hi,
            Try this.

            rman catalog username/password@catdb.

            and make entry for Catalog DB service in tnsnames.ora.
            Hope this helps.
            • 3. Re: RMAN-04004@ORA-01017
              MarGur
              hi guys, thanks you are here.

              when i'm trying :

              RMAN> connect catalog "rman_user/oraclepass@recoverydb";

              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified


              while output from tnsnames.ora is:

              RECOVERY =
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 65.96.219.180)(PORT = 1521))
              (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = recovery)
              )
              )


              and also: ORCALE_SID is recoverydb (name, that i set during creation the database). question: why the SERVICE_NAME in the tnsnames.ora is recovery?

              thank you and sorry, i'm just studying Oracle.
              • 4. Re: RMAN-04004@ORA-01017
                MarGur
                ok, if i'm using:

                RMAN> connect catalog rman_user/oraclepass@recovery

                i've got:

                RMAN-00571: ===========================================================
                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                RMAN-00571: ===========================================================
                RMAN-04004: error from recovery catalog database: ORA-12170: TNS:Connect timeout occurred

                i still don't understand where the problem is.
                • 5. Re: RMAN-04004@ORA-01017
                  orafad
                  Are both client (rman tool) and server (recovery catalog database) running on the same machine?

                  What if you try sqlplus user/pw@recovery?
                  • 6. Re: RMAN-04004@ORA-01017
                    MarGur
                    orafad, thanx for patience:

                    yes, RMAN and recoverydb are on the same machine.

                    there is from sqlplus:

                    SQL> conn rman_user/oraclepass@recovery;
                    ERROR:
                    ORA-12170: TNS:Connect timeout occurred


                    SQL> conn rman_user/oraclepass@recoverydb
                    ERROR:
                    ORA-12154: TNS:could not resolve the connect identifier specified
                    • 7. Re: RMAN-04004@ORA-01017
                      orafad
                      No firewall blocking the connection?
                      • 8. Re: RMAN-04004@ORA-01017
                        316473
                        ok, Margur

                        try to look at the tnsnames.ora and find the service name out that point to your database. Perhaps recoverydb is not a service name inside a the tnsnames.
                        • 9. Re: RMAN-04004@ORA-01017
                          orafad
                          SQL> conn rman_user/oraclepass@recoverydb
                          ERROR:
                          ORA-12154: TNS:could not resolve the connect identifier specified
                          This tells us that the tnsnames.ora file in use does not have the entry:
                          recoverydb = (description = ... )
                          • 10. Re: RMAN-04004@ORA-01017
                            MarGur
                            nothing at all.
                            also, i wanted to reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values, but there are no such parameters.. only

                            SQLNET.AUTHENTICATION_SERVICES= (NTS)

                            NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

                            entries. should i write them manually may be?
                            • 11. Re: RMAN-04004@ORA-01017
                              MarGur
                              hi, thank you. you know what, my tnsnames.ora shows me:

                              # tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
                              # Generated by Oracle configuration tools.

                              PRACTICE =
                              (DESCRIPTION =
                              (ADDRESS = (PROTOCOL = TCP)(HOST = 65.96.219.180)(PORT = 1521))
                              (CONNECT_DATA =
                              (SERVER = DEDICATED)
                              (SERVICE_NAME = practice)
                              )
                              )

                              RECOVERY =
                              (DESCRIPTION =
                              (ADDRESS = (PROTOCOL = TCP)(HOST = 65.96.219.180)(PORT = 1521))
                              (CONNECT_DATA =
                              (SERVER = DEDICATED)
                              (SERVICE_NAME = recovery)
                              )
                              )

                              EXTPROC_CONNECTION_DATA =
                              (DESCRIPTION =
                              (ADDRESS_LIST =
                              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
                              )
                              (CONNECT_DATA =
                              (SID = PLSExtProc)
                              (PRESENTATION = RO)
                              )
                              )

                              i wonder, if you could explain me, why the second entry is RECOVERY instead of RECOVERYDB (the name of catalogDB). and anyway, why i get the ORA-ORA-12170, when trying the RECOVERY service name accordingly to the tnsnames.ora.

                              thank you all again.
                              • 12. Re: RMAN-04004@ORA-01017
                                orafad
                                Do

                                c:\> tnsping recovery


                                The service_name of the tnsnames entry should match a listener service name, not a database name.
                                • 13. Re: RMAN-04004@ORA-01017
                                  MarGur
                                  Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 65.96.219.180)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = recovery)))
                                  TNS-12535: Operation timed out
                                  • 14. Re: RMAN-04004@ORA-01017
                                    MarGur
                                    hah, it's very strange.
                                    do you know, from where the IP settles down? because, my IP is NOT 65.96.219.180, and also

                                    C:\Documents and Settings\Dmitry>ping 65.96.219.180

                                    Pinging 65.96.219.180 with 32 bytes of data:

                                    Request timed out.
                                    Request timed out.
                                    Request timed out.
                                    Request timed out.

                                    Ping statistics for 65.96.219.180:
                                    Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)

                                    i suspect, here is the problem.

                                    now, what should i do to change the IP? my IP is 24.147.***.**

                                    thank you.
                                    1 2 Previous Next