DBS_ORA_SCHEMA environment variable?

[Former Member]

Hi Gurus,

I am doing a refresh from Production (P01) to Development (D01). I am having problem to start SAP in D01. I have run the OPS$ script but still unsuccessful. Based on note 534765, it advice to change environment dbs_ora_schema to SAP<SID>.

Below are my system details :

Production : SID (P01), dbs_ora_schema = SAPR3

Development : SID (D01), dbs_ora_schema = SAPSR3

Should I update dbs_ora_schema for D01 similar to P01 or should I update it to SAPP01.

Anyone have ideas on this?

Thanks,

Intan Azir

[Former Member]

Hi Intan,

In your dev system you should set dbs_ora_schema=SAPR3

Your source db's schema should always be set in your target system.

Regards,

SBK

[Former Member]

Thanks, its resolved.

[Former Member]

Not a good idea to refresh your development from production system. As you may loose the version mangement database and the development currently in progress. Have you exported the version database before you trash your dev server?

Refer note 400241 for OPS$ issue.

[Former Member]

Perform the following check via sqlplus in D01:

select username from dba_users;

If your refresh was done as described you should see the schema owner SAPR3 from P01.

In that case you need to adapt your environment variables in order to use the correct schema user.

Kind regards,