ora-28547 connection to server failed probable oracle net admin error

[Former Member]

Hello guys,

At Present we are using

APPn : SAP ECC6.0 SR3

DATABASE:ORACLE 11.2.0.4

OS:Windows server  2008r2

We recently upgraded the test server with oracle 11g using system refresh method.After finishing the process db connections are not working.

when iam trying to connect to non sap systems using dbacockpit it showing ORA-28547.

we are already update the oracle client and instant client.But still same problem arising.

Please find the attachment for error screen.

Regards

K.Sandeep

HSK

Manikanta

[JamesZ · Accepted solution]

hi Sandeep,

Please test brconnect command from sap application server to FIMS

brconnect -u <usr>/<password>@FIMS db_state

By the way as you mentioned you installed the client as mentioned in note

998004, did you delete the old instant client？

Best regards,

James

[Former Member · Accepted solution]

Hi James,

Yes.we delete the old oracle instant client as per the note.but still phasing the issue...

try to help ...

Regards

K.sandeep

[JamesZ · Accepted solution]

hi Sandeep,

What is the output of "brconnect -u <usr>/<password>@FIMS db_state" as mentioned previously?

Also may I know how you updated client and delete client? The SAP note should work for your case!

Best regards,
James

[Former Member · Accepted solution]

Hi james,

Here is the  output of brconnect

C:\Users\prdadm.AMGSAPCIPRD>brconnect -u bkp/bkp@FIMS;

BR0801I BRCONNECT 7.20 (34)

BR0155E No value found for option '-f'

BR0280I BRCONNECT time stamp: 2015-03-18 09.37.54

BR0804I BRCONNECT terminated with errors

C:\Users\prdadm.AMGSAPCIPRD>brconnect -u bkp/bkp@FIMS db_state;

BR0801I BRCONNECT 7.20 (34)

BR0154E Unexpected option value 'db_state;' found at position 3

BR0280I BRCONNECT time stamp: 2015-03-18 09.37.47

BR0804I BRCONNECT terminated with errors

and we followed the 998399 note.But still we are facing the same issue.and we tried with oracle 10g it is working fine but in oracle 11g is not working.

target db version is 11g.

Regards

K.Sandeep

[JamesZ · Accepted solution]

Hi Sandeep,

please show me with output of "where brconnect", then try command:

"brconnect -u bkp/bkp@FIMS -f dbstate"

Then please temply copy brconnect to location %ORACLE_HOME%\BIN run the same command again.

So let me know three result:

1. output of "where brconnect"
2. brconnect output from current directory

3. brconnect from %ORACLE_HOME%\BIN

Still I suspect wrong client was chosen is the root cause.

Best regards,
James

[Former Member · Accepted solution]

Hello james,

Here the

D:\oracle\PRD\11204\BIN>where brconnect

D:\usr\sap\PRD\DVEBMGS00\exe\brconnect.exe

D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\brconnect.exe

D:\oracle\PRD\11204\BIN>brconnect -u bkp/bkp@FIMS -f dbstate;

BR0801I BRCONNECT 7.20 (34)

BR0156E Illegal value 'dbstate;' found for option '-f'

BR0280I BRCONNECT time stamp: 2015-03-18 10.13.24

BR0804I BRCONNECT terminated with errors

C:\Users\prdadm.AMGSAPCIPRD>brconnect -u bkp/bkp@FIMS -f dbstate;

BR0801I BRCONNECT 7.20 (34)

BR0156E Illegal value 'dbstate;' found for option '-f'

BR0280I BRCONNECT time stamp: 2015-03-18 10.12.24

BR0804I BRCONNECT terminated with errors

Regards

K.Sandeep

[JamesZ · Accepted solution]

Hi Sandeep,

Please try to remove the final ";: character in the command line.

Best regards,
James

[Former Member · Accepted solution]

Hello james,

Here the output

C:\Users\prdadm.AMGSAPCIPRD>brconnect -u bkp/bkp@FIMS -f dbstate

BR0801I BRCONNECT 7.20 (34)

BR0280I BRCONNECT time stamp: 2015-03-18 10.28.44

BR0301E SQL error -28547 at location db_connect-2, SQL statement:

'CONNECT bkp/***@FIMS'

ORA-28547: connection to server failed, probable Oracle Net admin error

BR0310E Connect to database instance PRD failed

BR0280I BRCONNECT time stamp: 2015-03-18 10.28.44

BR0804I BRCONNECT terminated with errors

Regards

K.Sandeeep

[former_member207186 · Accepted solution]

Hi Sandeep,

Could you please also explain the exact steps executed as per SAP KBA 1899432 and the results? Have you also checked that all network configuration files are ok according to SAP Note 562403 (beside the Oracle Instant Client) ?

Regards,

Bíborka

[Former Member · Accepted solution]

Hello Bíborka,

Yes we followed the above mentioned notes as per the note we install a instant client.but from db level it is connecting but  from sap level we get a error ora-28547 i,e from dbacockpit>dbconnection>

Regards

K.Sandeep

[JamesZ · Accepted solution]

hi Sandeeep,

Please provide the two brconnect output from different location.

Best regards,
James

[Former Member · Accepted solution]

Hello James,

Here the out put of brconnect

D:\usr\sap\PRD\SYS\exe\uc\NTAMD64>brconnect -u bkp/bkp@FIMS -f dbstate

BR0801I BRCONNECT 7.20 (31)

BR0280I BRCONNECT time stamp: 2015-03-19 20.54.12

BR0342I Database instance PRD is open

BR0280I BRCONNECT time stamp: 2015-03-19 20.54.12

BR0802I BRCONNECT completed successfully

D:\usr\sap\PRD\DVEBMGS00\exe>brconnect -u bkp/bkp@FIMS -f dbstate

BR0801I BRCONNECT 7.20 (31)

BR0280I BRCONNECT time stamp: 2015-03-19 21.00.18

BR0301E SQL error -28547 at location db_connect-2, SQL statement:

'CONNECT bkp/***@FIMS'

ORA-28547: connection to server failed, probable Oracle Net admin error

BR0310E Connect to database instance PRD failed

BR0280I BRCONNECT time stamp: 2015-03-19 21.00.18

BR0804I BRCONNECT terminated with errors

Regards

K.Sandeep

[JamesZ · Accepted solution]

Hi Sandeep,

I suspect the old instant client was installed D:\usr\sap\PRD\DVEBMGS00\exe, you have to check where
the old instant client is and where the new instant client is.

We can see different directories get different result.

Best regards,
James

[Former Member · Accepted solution]

Hello James

we already checked both exe and dvebmgs00 directories both folders have same instant client.

Regards

K.sandeep

[JamesZ · Accepted solution]

Hi Sandeep,

But we can see the different results from brconnect between  D:\usr\sap\PRD\DVEBMGS00\exe and
D:\usr\sap\PRD\SYS\exe\uc\NTAMD64>. The only difference would be different instant client used.


I would like suggest you to update instant client again according to SAP note 998004.

Best regards,
James

[Former Member · Accepted solution]

Hello james,

we are using oracle 10 instant client for oracle 11g.

Regards

K.sandeep

[JamesZ · Accepted solution]

Hi sandeep,

why did you use 11g instant client for 11g database?

Also as mentioned, the I seriously doubt if the client in the two directories is the same

James

[Former Member · Accepted solution]

Hello james,

Its working now.

BIG THANKS BUDDY....

Regards

K.Sandeep

[JamesZ · Accepted solution]

Hi Sandeep,

It is ok. SAP KBA 1899432 is written by me, so I am much confident for the solution.

Best regards,
James

[manumohandas82]

Hi Sandeep ,

Have you tried a tnsping <SID > from the system with DBA cockpit .

Check the following note if the tnsping fails and create a trace file . Believe the issue should be around the entries in the  tnsname/sqlnet ora files

1832888 - Creating Oracle client trace if tnsping or R3trans fails

Follow  the  following SAP Note recommendations

562403 - FAQ: Oracle Net

Thanks ,

Manu

[former_member182657]

Please follow SAP Note   1576837 - ORA-01017: invalid username/password;

  1534597 - Using such special characters as "@" in a password

Regards,

[Former Member]

hello Gaurav rana,

we have already followed this note.But no change in error.

Regards

K.Sandeep

HSK

[former_member182967]

Hello Sandeep,

Please review the followings: (output of command oerr ora 28547).

28547, 0000, "connection to server failed, probable Oracle Net admin error"

// *Cause:   A failure occurred during initialization of a network connection

//           from a client process to the Oracle server.  The connection

//           was completed but a disconnect occurred while trying to

//           perform protocol-specific initialization, usually due to

//           use of different network protocols by opposite sides

//           of the connection.  This usually is caused by incorrect

//           Oracle Net administrative setup for database links or external

//           procedure calls.   The most frequent specific causes are:

//           --  The connection uses a connect string which refers

//               to a Heterogeneous Services agent instead of

//               an Oracle server.

//           --  The connection uses a connect string which includes

//               an (HS=) specification.

//           --  Hitting Ctrl+C before connection initialization is

//               complete.

//           --  Using DRCP on Windows with SQLNET.AUTHENTICATION_SERVICES

//               set to NTS.

//           --  Connection timeout due to SQLNET.INBOUND_CONNECT_TIMEOUT

//               parameter when all shared servers are busy in

//               shared server configuration.

// *Action:  Check Oracle Net administration in the following ways:

//           --  When using TNSNAMES.ORA or an Oracle Names server, make sure

//               that the client connection to the Oracle server uses

//               the correct service name or SID.

//           --  Check LISTENER.ORA on the connection end point's host machine

//               to assure that this service name or SID refers

//               to the correct server.

//           --  Confirm in TNSNAMES.ORA or the equivalent service definition

//               that the connect string does not contain (HS=).

//           --  Set SQLNET.AUTHENTICATION_SERVICES to NONE when using DRCP

//               on Windows.

Hope it help.

Regards,

Ning Tong

[Former Member]

hello Ning Tong

If we set the

SQLNET.AUTHENTICATION_SERVICES =NONE

1. We have getting  ora-1017 invalid username/password.

2.When we Restart the sap system SAP went down.

Regards

K.Sandeep

[former_member182657]

Hi Sandeep,

Have you checked SAP Note   1899432 - ORA-28547: connection to server failed, probable Oracle Net admin error

Hope this will help you.

Good luck !!

Gaurav

[Former Member]

Hello Gaurav Rana,

we have already followed this note.But no change in error.

Regards

K.Sandeep

HSK

[former_member182967]

Hello Sandeep k,

Please check if the following document can help you (came from My Oracle Support)

APPLIES TO:

Oracle ODBC Driver - Version 10.2.0.1 and laterInformation in this document applies to any platform.***Checked for relevance on 06-Feb-2015***

SYMPTOMS

Attempting to connect to a target database with Instant Client Lite fails with:

ORA-28547: connection to server failed, probable Oracle Net admin error

CAUSE

You are using instant client lite version.

This version only supports the following characterset(s):

Single-byte character sets include US7ASCII, WE8DEC, WE8MSWIN1252, and WE8ISO8859P1.
Unicode character sets include UTF8, AL16UTF16, and AL32UTF8.

The target database is not using one of the supported characterset(s) above.

Can check using this command:

SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';

This is documented in the Oracle 11g documentation

SOLUTION

Download the Oracle Instant Client Basic bundle for support of any database character set.

And additional one with the error above: https://community.oracle.com/thread/2263004

Hope it helps.

Regards,

Ning Tong