This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Oct 7, 2012 11:04 AM by user13445377 RSS

Error while connecting the rman target

user13445377 Newbie
Currently Being Moderated
I am getting the below error message when i am trying to connect the rman target .. Please check the below issue and let us know how we can resolve the issue..

$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Oct 2 15:18:06 2012

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-12001: could not open channel default
RMAN-10008: could not create channel context
RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE for parameter remote_dependencies_mode, must be from among MATERIALIZE, OPTIMIZER
RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature
$
  • 1. Re: Error while connecting the rman target
    Fran Guru
    Currently Being Moderated
     RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE for parameter remote_dependencies_mode, must be from among MATERIALIZE, OPTIMIZER
    RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature [/code]
    
    alter session set remote_dependencies_mode=MATERIALIZE [or OPTIMIZER] scope=both;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
  • 2. Re: Error while connecting the rman target
    user13445377 Newbie
    Currently Being Moderated
    I have changed the parameter value as per your suggestion. But still i am getting the same error message.. Please find the details below.

    Cna you please help me in resolving the issue...

    SQL> show parameter remote_dependencies_mode

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    remote_dependencies_mode string MATERIALIZE
    SQL> exit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
    With the Partitioning, Data Mining and Real Application Testing options
    $rman target /

    Recovery Manager: Release 10.2.0.5.0 - Production on Tue Oct 2 15:50:33 2012

    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-12001: could not open channel default
    RMAN-10008: could not create channel context
    RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE for parameter remote_dependencies_mode, must be from among MATERIALIZE, OPTIMIZER
    RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature
    $
  • 3. Re: Error while connecting the rman target
    EdStevens Guru
    Currently Being Moderated
    user13445377 wrote:
    I have changed the parameter value as per your suggestion. But still i am getting the same error message.. Please find the details below.

    Cna you please help me in resolving the issue...

    SQL> show parameter remote_dependencies_mode

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    remote_dependencies_mode string MATERIALIZE
    SQL> exit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
    With the Partitioning, Data Mining and Real Application Testing options
    $rman target /

    Recovery Manager: Release 10.2.0.5.0 - Production on Tue Oct 2 15:50:33 2012

    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-12001: could not open channel default
    RMAN-10008: could not create channel context
    RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE for parameter remote_dependencies_mode, must be from among MATERIALIZE, OPTIMIZER
    RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature
    $
    "error running SQL statement: alter session "

    suggest to me you might have an on logon trigger creating some mischief.
  • 4. Re: Error while connecting the rman target
    vlethakula Expert
    Currently Being Moderated
    can you paste the output of:

    SQL> select conf#,name,value from v$rman_configuration;
  • 5. Re: Error while connecting the rman target
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    also check if this found
    $ORACLE_HOME/lib/libobk.a
  • 6. Re: Error while connecting the rman target
    user13445377 Newbie
    Currently Being Moderated
    Hi,

    Please find the requested output below...

    SQL> select conf#,name,value from v$rman_configuration;

    no rows selected
  • 7. Re: Error while connecting the rman target
    user13445377 Newbie
    Currently Being Moderated
    I could find the below file, Please find the details below,...

    $ ls -ltr /usr/lib/libobk64.a
    lrwxrwxrwx 1 bin bin 46 Feb 22 2010 /usr/lib/libobk64.a -> /usr/tivoli/tsm/client/oracle/bin64/libobk64.a
  • 8. Re: Error while connecting the rman target
    Virendra.K1.Yadav Newbie
    Currently Being Moderated
    Can you please check the remote_dependencies_mode parameter again?
    And try with ALTER SYSTEM instead of ALTER SESSION, if it is not set properly.

    Regards,
    Virendra
  • 9. Re: Error while connecting the rman target
    user13445377 Newbie
    Currently Being Moderated
    Hi Virendra,

    Currently the value of the remote_dependencies_mode parameter set as MATERIALIZE.. I have used the alert system set commands when i am chaging this parameter ..

    Please let me know what else i need to verify to fix the issue...


    SQL> show parameter remote_dependencies_mode

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    remote_dependencies_mode string MATERIALIZE
  • 10. Re: Error while connecting the rman target
    asktemdba Newbie
    Currently Being Moderated
    would you please try to connect as folowing

    rman target sys/passwd
  • 11. Re: Error while connecting the rman target
    user13445377 Newbie
    Currently Being Moderated
    Its not working ....

    $ rman target sys/password

    Recovery Manager: Release 10.2.0.5.0 - Production on Wed Oct 3 15:21:32 2012

    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-12001: could not open channel default
    RMAN-10008: could not create channel context
    RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE for parameter remote_dependencies_mode, must be from among MATERIALIZE, OPTIMIZER
    RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature
    $
  • 12. Re: Error while connecting the rman target
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Please try to relink Oracle Binary Again
    relink -all
  • 13. Re: Error while connecting the rman target
    user13445377 Newbie
    Currently Being Moderated
    I have done it, still the same issue i am getting.......

    $ORACLE_HOME/bin/relink all

    $ rman target /

    Recovery Manager: Release 10.2.0.5.0 - Production on Wed Oct 3 16:14:52 2012

    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-12001: could not open channel default
    RMAN-10008: could not create channel context
    RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE for parameter remote_dependencies_mode, must be from among MATERIALIZE, OPTIMIZER
    RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature
    _$
  • 14. Re: Error while connecting the rman target
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
     RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE for parameter remote_dependencies_mode, must be from among MATERIALIZE, OPTIMIZER
    did you to Choose a value as indicated by the message
    alter system set remote_dependencies_mode=MATERIALIZE scope=spfile 
    OR
    alter system set remote_dependencies_mode=OPTIMIZER scope=spfile 
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points