ops$ oracle数据库用户,非标准systemcopy安装SAP更改SID重建oracle数据库用户

使用rman备份或者冷拷贝PRD的数据库出来，作为测试系统数据库用途

并没有通过SAP标准的systemcopy方式在安装过程中删除orasid相关用户，可以通过下面SQL语句重建用户，再使用SWPM分布式安装方式安装SAP即可

CREATE USER "OPS$DOMAIN\SIDADM" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

CREATE USER "OPS$DOMAIN\SAPSERVICESID" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

GRANT CONNECT, RESOURCE, SAPDBA TO "OPS$DOMAIN\SIDADM";

GRANT CONNECT, RESOURCE, SAPDBA TO "OPS$DOMAIN\SAPSERVICESID";

CREATE TABLE "OPS$DOMAIN\SIDADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

INSERT INTO "OPS$DOMAIN\SIDADM".SAPUSER VALUES ('', '');

CREATE SYNONYM "OPS$DOMAIN\SAPSERVICESID".SAPUSER FOR "OPS$DOMAIN\SIDADM".SAPUSER;

CONNECT /

GRANT SELECT, UPDATE ON "OPS$DOMAIN\SIDADM".SAPUSER TO "OPS$DOMAIN\SAPSERVICESID";

CONNECT /as sysdba

GRANT CONNECT, RESOURCE TO "OPS$DOMAIN\SAPSERVICESID";

GRANT CONNECT, RESOURCE TO "OPS$DOMAIN\SIDADM";