Home » Other » Client Tools » problems with servers (tns:protocol adapter error) (windows server 2003 and 2008)
problems with servers (tns:protocol adapter error) [message #687927] Sun, 23 July 2023 07:08 Go to next message
Alish_999
Messages: 2
Registered: July 2023
Junior Member
hello, sorry for my bad english, just i can try to write without translate.
i working system administration in little internet provider company, and all old employees dont give me information, about this problems.
we have old programm in virtual server with ip address 192.168.100.112 and physical server with ip 192.168.100.50.
in first server have a programm "rebus monitor" for adsl link phone numbers, and how i opened programms and write log/pass, i have a error: "wrong username and password. /forum/fa/14725/0/ Alias:crossdb" and in the folder of this program have a "sqlnet.ora" logs file and in him writing to next info: ***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Rebus\tech\tm\Monitor.exe)(HOST=BIK-VPN)(USER=administrator))))

 VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
 Time: 23-ИЮЛ-2023 17:05:19
 Tracing not turned on.
 Tns error struct:
   nr err code: 0
   ns main err code: 12560
   TNS-12560: TNS:ошибка адаптера протокола
   ns secondary err code: 0
   nt main err code: 530
   TNS-00530: Ошибка адаптера протокола
   nt secondary err code: 126
   nt OS err code: 0


and in second server 192.168.100.50 have a database, just this problem was a 2-3 time in last 2-3 years, but he fixed himself. please you can help to me.


  • Attachment: 33333.png
    (Size: 27.02KB, Downloaded 2261 times)
Re: problems with servers (tns:protocol adapter error) [message #687928 is a reply to message #687927] Sun, 23 July 2023 08:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Windows server 2003/2008 and Oracle 9.2 is not a supported configuration, you will have to bear with these errors.
You can activate a trace maybe you can find a reason but you won't do anything against it.

Re: problems with servers (tns:protocol adapter error) [message #687929 is a reply to message #687928] Sun, 23 July 2023 08:58 Go to previous messageGo to next message
Alish_999
Messages: 2
Registered: July 2023
Junior Member
but this error was in the course of the last 5 years and was fixed by itself, how can I see from the logs what has changed on the PC?
Re: problems with servers (tns:protocol adapter error) [message #687930 is a reply to message #687929] Sun, 23 July 2023 09:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You won't find anything in the logs, only trace may give you a hint.

Many things change in a PC and the first one is time.

Re: problems with servers (tns:protocol adapter error) [message #687931 is a reply to message #687927] Sun, 23 July 2023 12:07 Go to previous message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
The "Fatal NI connect error 12560" is (probably) not the problem. It is probably unrelated and of no significance. More probably the issue is exactly the error returned:
C:\Users\john>oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:     An invalid username or password was entered in an
//             attempt to log on to Oracle. The username and password must be
//             the same as was specified in a GRANT CONNECT statement. If the
//             username and password were entered together, the format was:
//             username/password.
// *Action:    Enter a valid username and password combination in the
//             correct format.

C:\Users\john>
Can you connect with the username/password from any tool? Such as SQL*Plus?
Previous Topic: SQLdeveloper Query Hangs
Next Topic: Need help to setup NLS_LANG when my PLSQL Developer executes
Goto Forum:
  


Current Time: Thu Apr 18 00:08:53 CDT 2024