Err in RMAN
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Err in RMAN

  1. #1
    Join Date
    Jan 2007
    Posts
    231

    Err in RMAN

    Hi

    I have Oracle9.2,RHlinux.(two separate system test & test1)

    When i tried to connect to target database it shows as

    rman target sys@test

    Recovery Manager: Release 9.2.0.4.0 - Production

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    target database Password:

    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-04005: error from target database:
    ORA-01031: insufficient privileges


    then i tried with sql to connect to that target DB(test) from test1
    scott/tiger@test
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory

    then i tried $ tnsping test
    it works properly
    If i log into test DB(logged directly into that machine)everything is working properly.
    everything in the sense it is open and working.
    Last edited by ams-jamali; 03-12-2008 at 09:29 AM.

  2. #2
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

    hi

    create a password file
    check the remote_login_password=exclusive
    set the ORACLE_SID
    grant sysdba to RMAN user

  3. #3
    Join Date
    Jan 2007
    Posts
    231
    i would try that
    Thanks

  4. #4
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    you connect to the target database like
    rman target username/password@alias

  5. #5
    Join Date
    Jan 2007
    Posts
    231
    hi,

    SQL> grant sysdba to rman;
    grant sysdba to rman
    *
    ERROR at line 1:
    ORA-01990: error opening password file '/opt/ora9/product/9.2/dbs/orapw'
    ORA-27037: unable to obtain file status

    Is it necessary to give sysdba privilege to rman?

    i tried with rman target username/password but same error prevails.

  6. #6
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

    Hi

    It is necessary to give sysdba priviege to RMAN.

    do you have the password file in the dbs directory.
    Oracle indicate that this error is generated if the instance/SID specific password file does not exist and the init.ora parameter ‘REMOTE_LOGIN_PASSWORDFILE’ is set to ‘EXCLUSIVE’ or ‘SHARED’.

    create the password file if you dont have
    orapwd file=\PWD.ora password=oracle

  7. #7
    Join Date
    Apr 2006
    Posts
    377
    To clarify the orapwd command, you may want to ensure you are in $ORACLE_HOME/dbs directory prior to running the orapwd command and issue:

    Code:
    orapwd file=orapw<SID> password=<password> entries=<#_of_expected_SYSDBA_users>

  8. #8
    Join Date
    Jan 2007
    Posts
    231
    hi

    i have deleted old one and recreated pwd file

    $ orapwd file=orapwtest password=oracle entries=7

    then i granted permission to rman the same error repeats

  9. #9
    Join Date
    Apr 2006
    Posts
    377
    What is the output of echo $ORACLE_SID

  10. #10
    Join Date
    Jan 2007
    Posts
    231
    [oracle@dbs]$ echo $ORACLE_SID
    test

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width