on 09-08-2015 12:56 PM
Hello Friends,
While taking online backup from hp data protector we are getting below
error
CONNECT system/********* AT PROF_CONN IN SYSOPER MODE'
ORA-01017: invalid username/password; logon denied
BR0303E Determination of Oracle version failed
I Can take backup using brtools from sap no issue with that, and also i
can connect to database using user (system) with same password which is
mention in HP Data protector, but when i am trying to run backup from
hp data protect i am getting error ORA 01017.
I have checked note 400241 - Problems with ops$ or sapr3 connect to Oracle
And verified all the steps as mention and everything seems to be fine.
SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';
OWNER
OPS$HOSTNAME\SIDADM
SQL> SELECT OWNER, TABLE_OWNER, TABLE_NAME FROM DBA_SYNONYMS WHERE SYNONYM_NAME
= 'SAPUSER';
OWNER TABLE_OWNER
------------------------------ ------------------------------
TABLE_NAME
------------------------------
OPS$HOSTNAME\SAPSERVICESID OPS$HOSTNAME\SIDADM
SAPUSER
Also updated the password with below command
brconnect -u system/<password> -f chpass -o <sapowner> -p <password>
but I did not perform
Alternatively, change the password in the table SAPUSER:
DELETE FROM "OPS$<sid>ADM".SAPUSER;
INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');
Also in sqlnet.ora we have this enrty SQLNET.AUTHENTICATION_SERVICES = (NTS)
But in initsid.ora we do not have the parameter os_authent_prefix = ops$ do I need to maintain this?
OS: Win 2008
Db:oracle 11.2.0.4.0
From brtools I have no issues backup is running fine but in hp data protector I am getting this error ORA-01017: invalid username/password; logon denied
Kindly help to solve this issue.
Thanks
Tabrayz
Dear All,
Apologies for late reply issue is solved after running below commands.
Grant sysoper to system;
Grant sysdba to system:
Issue was with user system permissions, but HP dp was giving error as invalid user id and password which was misleading, actually it should give error as ORA 01031 but it was giving ORA-01017 which was wrong, luckily i tried giving permissions to user system and problem solved.
Thank you all for your support.
Thanks
Tabrayz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is the DP server reaching the correct database service name? Maybe you can try tnsping <SID> from DP client server to verify that you are connecting to your target database. Also try creating a new database user for DP, then use this user instead of SYSTEM.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is no surprise here as you are updating the SAP schema user password but the backup is scheduled to run under the SYSTEM user.
You need to update the Oracle SYSTEM user password for the backup to run.
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tabrayz,
Regarding this issue/question, you can check the
- Section "SYSTEM" in point 7 of SAP Note 56286 - "FAQ: Logon mechanisms"
- Section "HINT" in Scenario A of SAP KBA 1576837 - "ORA-01017: invalid username/password"
Regards,
Bíborka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Biborka,
I have checked the note 1576837 and updated the password for user SYSTEM as per note
brconnect -u system/<password> -f chpass -o <sapowner> -p
<password>
but hp dataprotecor is giving same issue i can successfully login with user system in database and also r3trans-d is 0000.
Thanks
Tabrayz
Hi Tabrayz,
Thank you for the update. Have you also checked the Section "SYSTEM" in point 7 of SAP Note 56286 - "FAQ: Logon mechanisms" ?
Since you have changed the password of SYSTEM user, please check carefully
- Section "SYSTEM" in point 7 of SAP Note 56286 - "FAQ: Logon mechanisms"
- Section "HINT" in Scenario A of SAP KBA 1576837 - "ORA-01017: invalid username/password"
Regards,
Bíborka
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
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.