Skip to Content
Former Member
Jun 10, 2007 at 11:05 PM

How to change the owner of the database from SAPSR3 to SAP<SID>



I was Installaing ECC 6.0 SR1 on Oracle 10.2 and HP UX 11.23 . The Installation stopped in between due to some errors.I was in ABAP Import Phase.

After That I found that theENV varaibles were point the Schema to SAPSR3 but my SID was EC6 . I change the Environment variable dbs_oracle_Schema = SAPEC6 and then restarted but still the Owner of the database is SAPSR3 .

I confirmed this as all the table's owner is SAPSR3 (when I run the SQL Select Owner , Table_Name from DBA_TABLES;)

I have checked the Listenaer.ora , sqlnet and tnsnames files and have the entries as EC6 . Listener Status also shows Ssystem as EC6.

Even when i run BRTOOLS it gives me the Error that -

BR0824E Owner SAPEC6 not found in database or not SAP owner

Please help me to change the Owner of the database.