10 Şubat 2010 Çarşamba

SAP parola değiştirme ve os den db bağlantı

R3trans baglantisini test edilmesi
R3trans -x

sapsr3 parola degistirme
brconnect -u / -f chpass -o sapsr3 -p password
--------------------------
işletim sisteminde database bağlantı yapma;
DROP TABLE OPS$sidADM.SAPUSER CASCADE CONSTRAINTS;

CREATE TABLE OPS$sidADM.SAPUSER
(
USERID VARCHAR2(255 BYTE),
PASSWD VARCHAR2(255 BYTE)
)
TABLESPACE SYSTEM
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;


--DROP SYNONYM OPS$SAPSERVICEsid.SAPUSER;

CREATE SYNONYM OPS$SAPSERVICEsid.SAPUSER FOR OPS$sidADM.SAPUSER;


GRANT INSERT, SELECT, UPDATE ON OPS$sidADM.SAPUSER TO OPS$SAPSERVICEsid;

Hiç yorum yok:

Yorum Gönder