VarjuOrg

Linux / Windows – what's the difference…

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

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.

, , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *