What are the steps in oracle 11g DBREFRESH

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Gurpal,

Thank you for your valuable reply

Do I need to do your mentioned steps after below steps

RECOVER DATABASE USING BACKUP CONTROL FILE UNTIL CANCEL;

AUTO.

once recovery is done CANCEL.

Alter database open resetlogs.

status is open.

AS YOU MENTIONED

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 )

or Any table spaces need to be create ???? PSAPTEMP ??? or any.

Thanks & Regards

RJ

[Former Member · Accepted solution]

Hi Raz,

You can check with below command DB is open mode or not.

SQL> select name,open_mode from v$database;

If it is shows read and write after that you can perform which i have mentions above steps.

No need to create PSAPTEMP if is throwing any error add one data file in PSAPTEMP tablespace

Add datafiles to tablespace PSAPTEMP through brtools

Regards,

Gurpal

[Reagan · Accepted solution]

If you are using the OPS$ mechanism then follow the SAP note 50088 - Creating OPS$ users on Windows NT/Oracle and run the script attached. The script wont drop the source system OPS$ users, instead you need to do them manually.

If you are using the SSFS mechanism these check this SAP note 1639578 - SSFS as password storage for primary database connect

You will need to recreate the PSAPTEMP tablespace.

Eg: ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/SID/sapdata1/temp_1/temp.data1' SIZE 10000M REUSE AUTOEXTEND OFF;

Start the Oracle listener and switch to sidadm user and run R3trans -d. You should get RC 0000.

If OK then continue with the post operations like SAP License installation, TMS, BDLS and the rest.

Regards

RB

[Former Member · Accepted solution]

Dear Benjmin,

Thanks for your reply,

I have done DB-REFRESH on oracle 11g in AIX 7.1 environment.

I got below error in

R3trans -d

0012

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = ' SID'"

ORA-01017: invalid username/password; logon denied

Please help me on this.

Thanks

Regards

RJ

[Reagan · Accepted solution]

Change the password using BRTools.

Eg: brconnect -u / -f chpass -o SAPR3 -p whatever

You need to replace SAPR3 with the right schema name and "whatever" with the password of your choice.

Regards

RB

[former_member182657 · Accepted solution]

Hi RJ,

Please follow SAP Note  400241 - Problems with ops$ or sapr3 connect to Oracle

Regards,

Gaurav

[Former Member · Accepted solution]

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