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.