非标准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";
页:
[1]