Oracle 10G after system copy – no full backup possible OPS$ORASID missing

01/12/2012 [D_A] Kasulik, Oracle, SAP, Tehniline, 0

Just noticed that when trying to do offline/online backup of SAP systems Oracle DB on recently copied system – it fails with:
Oracle: connect / - user or password invalid
What I thought was the matter was that maybe some OPS$ user was missing privileges.
So I did a:
su orasid
connect / as SYSDBA
select username from dba_users; (which gave me all users on DB)

Then as my thoughts were correct – OPS$ORASID was missing…
So I created it and gave it rights to connect to DB:
create user OPS$ORASID identified externally temporary tablespace PSAPTEMP;
grant connect,resource,sapdba to OPS$ORASID;

Problem solved in my case.

cannot connect, missing user, OPS$, OPS$ORASID, Oracle, Oracle 10G, SAP

SAP – RFC connection for LDAP STMS (SAP) error: Request does not match component version