on 03-03-2015 7:08 AM
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
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
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
Hi Sandeep,
It is ok. SAP KBA 1899432 is written by me, so I am much confident for the solution.
Best regards,
James
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
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please follow SAP Note 1576837 - ORA-01017: invalid username/password;
1534597 - Using such special characters as "@" in a password
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sandeep k,
Please check if the following document can help you (came from My Oracle Support)
Oracle ODBC Driver - Version 10.2.0.1 and laterInformation in this document applies to any platform.***Checked for relevance on 06-Feb-2015***
Attempting to connect to a target database with Instant Client Lite fails with:
ORA-28547: connection to server failed, probable Oracle Net admin error
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
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
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.