不知道楼主参考的是哪个NOTE,不过ORA -1017的错误,ORA 1017错误,密码不对的解决办法:
SQL> DROP TABLE OPS$PRDADM.SAPUSER; Table dropped. SQL> CREATE TABLE OPS$QASADM.SAPUSER 2 (USERID VARCHAR2(256), PASSWD VARCHAR2(256)); Table created. SQL> INSERT INTO OPS$QASADM.SAPUSER VALUES('SAPPRD', 'i密码');
1 row created.
brconnect -u system/'数据库管理密码' -f chpass -o SAPPRD -p ‘上一条SQL插入记录的密码'
前提是你的OPS$QASADM用户是正确的
然后用qasadm用户:R3trans -d
返回的代码是0000,就应该没问题了。如果不是0,把trans.log贴上来再看
Changing Database User Passwords with BRCONNECT UseYou can use BRCONNECT to change the password of database users, such asSAPR3orSAP<SAPSID>.Donotleave the passwords for the database user set to the default values.Procedure...For more information, see-f chpass.ResultBRCONNECT stores the new password as follows: UserTableEncryption (from Release 4.5B)SAPR3"OPS$<ORACLE_SID>ADM".SAPUSERStored asSAPR3-CRYPTSAP<SAPSID>"OPS$<SAPSID>ADM".SAPUSERStored asSAP<SAPSID>-CRYPT In the case of theSAP<SAPSID>user,<SAPSID>refers to the SAP System ID. For example, if the SAP System ID isC11, theSAP<SAPSID>user isSAPC11, stored in the tableOPS$C11ADM.SAPUSER. The first character of<SAPSID>must be a letter and there is no distinction between uppercase and lowercase.Database users other thanSAPR3andSAP<SAPSID>arenotstored inSAPUSERdatabase tables.
采用drtools修改SAPsid数据库有用户密码,不过在r34.7下应该用sapdba来修改