Skip to Content
avatar image
Former Member

What are the steps in oracle 11g DBREFRESH

Dear Techies,

Please help me on below. I followed all steps in db refresh

I have done till


Alter database open resetlogs

status is open



what are the steps remaining in oracle 11g dbrefresh from PRD to QTY. is there any post steps to drop old ops$users.

Please let me know.



Thank you


Best Regards

RJ

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 06, 2014 at 06:03 AM

    Hi Raz,

    Please follow the below steps after restore DB.

    Make sure listener and DB should be up.

    Determine Schema Owner

    SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'T000';

    Check the OWNER of “SAPUSER”

    SQL>SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

    Create OPS$ User

    Use the oradbusr.sql script. This script is attached to the note 50088. The script is valid for Oracle and UNIX. Use the following syntax

    SQL> @ORADBUSR.sql SAPR3 UNIX (SID) X

    Check the OWNER of “SAPUSER" after exceute command

    SQL>SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

    If the system returns an owner <owner> other than OPS$<sid>ADM (OPS$SIDADM) of PRD, you must

    delete the relevant SAPUSER tables:

    SQL> DROP TABLE “OPS$SIDADM".SAPUSER;

    and after that check the output of (R3trans -d)

    set the value in profile parameter

    To ensure no background jobs after the start (Rdisp/wp_no_btc =0)

    (Login/no_automatic_user_sapstar =0 )

    Hope is will help you.

    Regards,

    Gurpal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Raz,

      Follow the below steps to check schema and reset the password of schema.

      Execute below command and check the schema name.

      SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'T000';

      and then change the password of schema.

      brconnect -u system/(password) -f chpass -o (schema) -p (password)

      Regards,

      Gurpal