on 11-11-2012 9:35 AM
Hi Experts,
We are performing Unicode Conversion/migration and for which we are taking the export of the system. It is throwing an error saying Schema password should be more than 5 characters.
Our password is SAP. When we try to change this password from brtools, it is getting changed successfully and it is updating the table "OPS$<SID>ADM.SAPUSER" also.
But the system fails to start. R3trans -d throws return code 12. Our system is accepting only the default password "SAP" not anything else.
We are on Windows/Oracle 11.2
Please let me know how to change this password.
Regards,
Surendra
Hi All,
Thanks for your replies.
My issue is resolved. It was a problem with the user OPS$<domain_name>\<SID>ADM. This user is missing in our system.
1.I created this user as per the notes 400241 and 50088.
2. Dropped the existing SAPUSER table and recreated it with the above user as owner
3. Gave necessary previleges to OPS$<domain_name>\<SID>ADM and OPS$<domain_name>\SAPSERVICE<SID> users
Now the system is up and running
Thanks,
Surendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try this command with ora<sid> user:
brconnect -c -u / -f chpass -o <SAPSCHEMA> -p sap
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try updating the brtools.
after using brtools to change schema password, login via sqlplus with SAP<SID> user and new password to verify it.
Regards, Henry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Brtools become an usesfull tool and you can change it at instance management seccion.
Let me know if you find it.
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.