NOTICE: Significant community changes coming soon
The header menu and the home page on our community will be changing soon. Get more information HERE.
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..
534 views

DP9: util_sap.exe response not making sense

Jump to solution

When I tried to connect DP it get the error that it can't connect and oracle isn''t available.

s928-dbsapes1:orasnd 3> logout

(root@s928-dbsapes1)# ./util_sap.exe -CONFIG SND /oracle/SND/112_64 system/*******@SND /usr/sap/SND/SYS/exe/run /oracle/SND

*RETVAL*8100

ORA-01017: invalid username/password; logon denied

SP2-0640: Not connected

sqlcode 1017

 

BUT I can connect

s928-dbsapes1:orasnd 1> sqlplus system/*******@SND 

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 30 08:03:38 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved. 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

How might I hunt this issue down?

 

Tags (2)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Works. Now.  Dude doing SAP system upgrade took away rights of the system user.  Once I put them back all was good.

SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS

------------------------------ ----- ----- -----

SYS TRUE TRUE FALSE

SQL> grant sysdba, sysoper to system;

Grant succeeded.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

s928-dbsapes1:orasnd 7> exit

s928-dbsapes1:orasnd 8> logout

(root@s928-dbsapes1)# cd /opt/omni/lbin

(root@s928-dbsapes1)# ./util_sap.exe -CONFIG SND /oracle/SND/112_64 system/*******@SND /usr/sap/SND/SYS/exe/run /oracle/SND

*RETVAL*0

 

View solution in original post

0 Likes
2 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Works. Now.  Dude doing SAP system upgrade took away rights of the system user.  Once I put them back all was good.

SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS

------------------------------ ----- ----- -----

SYS TRUE TRUE FALSE

SQL> grant sysdba, sysoper to system;

Grant succeeded.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

s928-dbsapes1:orasnd 7> exit

s928-dbsapes1:orasnd 8> logout

(root@s928-dbsapes1)# cd /opt/omni/lbin

(root@s928-dbsapes1)# ./util_sap.exe -CONFIG SND /oracle/SND/112_64 system/*******@SND /usr/sap/SND/SYS/exe/run /oracle/SND

*RETVAL*0

 

View solution in original post

0 Likes
Highlighted
New Member.

Thanks for your feedback Vincen.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.