Problem with <sidadm> connection to Oracle.

[george_hamilton]

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.

[Former Member · Accepted solution]

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

[george_hamilton · Accepted solution]

Thanks. I checked the note. I'm not getting those errors when running brbackup or brconnect as mentioned in the note. I'm on Oracle 11 and it doesn't seem to have a sqlnet.log file anymore.

I still don't understand how the "sqlplus / as sysdba" works for ora<sid> but not <sid>adm

[Former Member · Accepted solution]

Have you performed the OPS$ settings? if you search for your error you will get these notes.

Note 562863 - FAQ: Logon mechanisms

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

and note 113747 &

[Former Member · Accepted solution]

That's because the OPS$ for <sid>adm is most probably not created but the OPS$ for ora<sid> has been created.

This is known as remote authentication mechanism for Oracle & allows a o/s user to login to the database.

- Regards, Dibya

[calvin-klein · Accepted solution]

Hi George,

i have the same problem. R3trans and all tools are working. But if i want to login with <sid>asd & sqlplus i got the error

ERROR:

ORA-12547: TNS:lost contact

Did you solved the problem?

Kind regards

Jochen

[calvin-klein · Accepted solution]

Hi @ll,

my solution is

/oracle/PXP/11202/bin # ls -la oracle

-rwxr-x--x 1 orapxp dba 229617369 Jun 11 18:13 oracle

Set the SUID-Bit

/oracle/PXP/11202/bin # chmod 4751 oracle

Now it work's.

[Former Member]

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

[Former Member]

Hi

i had the same issue.

below works for me.

:orasid 13> cd /oracle/<SID>/11204/bin

:orasid 15> ls -l oracle

-rwxrwxrwx   1 orasid     dba        557239584 May 15  2015 oracle

:orasid 16> chmod 6751 oracle

:orasid 17> ls -l oracle

-rwsr-s--x   1 orasid     dba        557239584 May 15  2015 oracle

:orasid 18>

thanks

Ahmad