on 11-04-2010 1:23 AM
I'm receiving an error when doing a system load when the install reaches the abap import phase:
I get this in the "R3load -testconnect" output.
bSl Trace: CONNECT failed with sql error '1017'
So I went and tried a "R3trans -d/x" and found the
ORA-01017: invalid username/password; logon denied
When I do an "sqlplus /nolog" and try to do a "conn / as sysdba"
I still get the same
ERROR:
ORA-12547: TNS:lost contact
error.
When as <sidadm> I do a 'sqlplus / as sysdba'
I get the "ORA-12547: TNS:lost contact"
TNSPING works fine, the listener log shows connections as fine.
I just get the :
RA-12547: TNS:lost contact.
tnsping <SID> works fine.
I've recreated the "SAPUSER" table as in Note 400241 and used the default password of "sap" but I still get a password error on connection. I am using the default password of "sap" per the note so I don't know why it won't work.
This query works:
conn SAPSR3/sap@<SID>
So I know that I've met the condition in 400241?
It must be related to the "TNS lost contact" problem.
The weird thing is that it eventually locks the SAPSR3 user. What sense does that make?
Any help is appreciated.
Yes it makes sense, I believe you have corrected the error for the sapsr3 user. But this TNS error can be because of a number of reasons, please check this sap note rigorously:
505630 - Composite SAP Note ORA-12547
- Regards, Dibya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I was also facing the same issue.
my Solution:
In addition to permissions recommended by Joshen I had to give the below permission to make it work.
/oracle/XYZ/11202/bin # ls -ls oracle
oraxyz 58> chmod 6751 oracle
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.