cancel
Showing results for 
Search instead for 
Did you mean: 

OPS$, Schema Owner and dbs_ora_schema env variable.

Former Member
0 Kudos

HI All.

Have a situation where we've copied a system from one location to another using an online backup. The database is up and running (open) and lookin good.

However, when I goto start SAP, I get a ORA-1403 and ORA-1017 error on startup. As best as I can tell, the OPS$ mechanism created for the base system (before the online restore) is using SAPSID as the owner. However, the schema owner from the database we used for the recovery is SAPR3.

Now when the system goes to logon, OPS$ is looking to fetch SAPSID as the schema owner, but the effective schema owner is SAPR3. Rerunning the oradbusr. sql script as per note 361641 does not change anything.

<b>Issue is related to the environment variable "dbs_ora_schema" - it is currently set to SAPSID, but I need to change it to SAPR3. Can someone offer the proper syntax to change this value in AIX 5.3?</b>

Thanks,

Tim

Thanks!!

Message was edited by:

Tim Hild

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Tim,

What i apprehend is that the SAP<SCHEMA-ID> or the password for the same has changed. When u have copied the db of another SID the SAP<SCHEMA-ID> will be according to the earlier SID so it may required to be renamed as per the new SID and so also the naming services might have changed for which the listner may not work properly. Try to rename the SAP<SCHEMA-ID> and reset the password via brtools. The SQL wont work in case of changing the password of SAP<SCHEMA-ID> . First do it from SQL then reset the password again using Brtools.

Comparing tns.ora and listnr.ora files of both the systems will give u a fair idea on the prob.

In the sap server run BRTOLS from cmd prompt then proceed as follows

Brtools----->Choose Additional Functions--->Choose Change Password of DB user

Enter choice 2(Database User/Password)

In user prompt give sapc11 and in password prompt put the password u had changed earlier ie abc123.

Then enter c (for continue) u will be prompted for the new password

When u put the new password it wont be displayed in the prompt just type

Complete the entire guided process.

Hope this resolves your prob.

Regards.

Former Member
0 Kudos

On AIX, you would need to check all of the environment files in /home/<SID>adm and you should check those in /oracle/<SID>. This would include the .dbenv... and .sapenv... files with .csh and .sh suffix. You could fgrep for the 'dbs_ora_schema' string in all files to make sure you pick them all up.

Answers (5)

Answers (5)

Former Member
0 Kudos

I have changed the dbs_ora_schema in the envionment variable and sap is up. But I have changed through my computer> Properties>Advanced> ....and set the dbs_ora_schema to SAPBOS. bcos I donot know what is the other option to change the dbs_ora_schema ?

Also I have kept the old sid to dbs_ora_schema i.e: SAPBOS, so will this have any effect on my system??

Former Member
0 Kudos

please read and check these SAP Notes very <b><u>carefully</u></b>, they can help you.

<u><u><b>400241</b></u></u> - Problems with ops$ or sapr3 connect to Oracle

<b><u>361641</u></b> - Creating OPS$ users on UNIX

Former Member
0 Kudos

I have system copy( OS level data files). Now the SID in the source "BOS" is different in the target "WS1".

ran the scripts oradbusr.sql. no use.

the db_ora_Schema is set to SAPWS1. ( check in the os command C:> set )

the check as per note 400241 select owner from dba_tables where table_name='T000' shows me SAPBOS.

It should be SAPWS1 so my sap to connect.

Please suggestion...

Former Member
0 Kudos

Everyone. Thanks for your help. Changed the environment variable dbs_ora_schema from SAPSID to SAPR3. System starts just fine now. Thanks to all for your help!

Former Member
0 Kudos

hi Tim, Is your source and target database names are same or you renamed the database after copy ??

try with this -- download sapdba_role_ora9.SAR script from sap market place, run the script like SQL>@<path>/sapdba_role.sql SAPR3 this should fix your issue.

If you renamed your target DB then let me know more need to do.

Regards

Manohar

Former Member
0 Kudos

Hi Tim,

If you believe the error is related to enviroment variable 'dbs_ora_schema'. Change the enviroment variable in AIX before you run 'startsap' script.

User <sid>adm uses C shell in AIX, to change the enviroment variable:

>setenv dbs_ora_schema <New schema name>

To check the changed enviroment variable, run:

>echo $dbs_ora_schema

Hope it helps.

Cheers,

Nischal