ORA-6413

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Mon, 28 Jun 2004 12:18 am

Hello everybody ... I had a little problem of ORA-6413 and until then I didn't even know what it was about this error, but it's something quite interesting and you might pass unnoticed by some, as occurred with me.
The problem seems to be in the name of the machine that cannot have special characters to connect to Oracle. Well, a friend got me a description and I will pass on to you, follows below.

Even more ....

----------------------------------\"Solution Description----------------------------------You need to verify that the client computer's identification does not contain reserved characters. Particularly the parenthesis symbols: ().

To check on Windows95/98/NT: 1. Right click the Network Neighborhood Icon on your desktop.
2. Select Properties.
3. Within the Network Properties window, select the Identification Tab.
4. Verify the Computer Name box does not contain any of the reserved symbols, change if necessary.
5. Check the DNS configuration.
6. On Windows NT, select the Protocols Tab, on Windows95/98 select the TCP/IP-> Network Adapter from the list under the Configuration Tab.
7. Select Properties.
8. Select the DNS Tab on NT, DNS Configuraiton on Windows98/95.
9. Verify the Host Name box does not contain any of the reserved symbols, change if necessary.

* NOTE: If you have to change the Computer Name, you will have to reboot to have the changes take affect. You may also need mount the Operating System disk for Windows95/98/NT to copy in new files.

Explanation-----------You are using reserved symbols to identify the client computer.
Sqlnet/Net8 has the character set for keyword value entries, which is restricted to single-byte characters. However certain single-byte characters are reserved symbols within Sqlnet/Net8.
These book symbols are: () = \"' # Sqlnet/Net8 passes client information, such as host, username, and program executable to the database during connection establishment as part of an ' exteneded ' connected discriptor. Using a reserved character can cause connection failures resulting in ORA-6413, Connection not open errors. In particular the open and close parenthesis symbols () being used to identify the client computer.

This would be noticeable in the Sqlnet.log where the errors are shown.

For example, here is an excerpt from the Sqlnet.log (using wordwrap for display purposes), showing the connect failure using \"ALPHA (TEST)\" the hostname.

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Fatal OSN connect error 6413, connecting to: (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = BEQ) (PROGRAM = oracle80) (ARGV0 = oracle80ORCL) (ARGS = (DESCRIPTION = (LOCAL = YES) (ADDRESS = (PROTOCOL = beq))) '))) (CONNECT_DATA = (SID = ORCL) (CID = (PROGRAM = PLUS33.EXE) (HOST = ALPHA (TEST)) (USER = Oracleuser)))) ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^ VERSION INFORMATION: TNS for 32-bit Windows: Version 2.3.4.0.0-Production Time: October 14, 99 23:23:49 Tracing not turned on.

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Note1: The current connect descriptor in Tnsnames.ora specifies TCP as the protocol, not Beq, but because the client hostname contains the parenthesis, Sqlnet/Net8 just breaks trying to setup and interupt handler and write Beq protocol to the Sqlnet.log.

In the Sqlnet trace you would see an attempt to set up an interupt handler.

Excerpt from Sqlnet.trc (level 16 trace) onstns: osntns: setting up interrupt handler ...-<ERROR>-onstns: could not connect, returning 6413 onstns: exit Note2: It is possible to have the Computer Name and the Internet host name different. If the computer name is changed in the Identification Tab, it will overwrite the host name in the DNS configuration.
\"
Júnior Cirqueira
Location: Sertãozinho - SP

Poston Thu, 12 Jul 2007 11:30 am

Junior speech good morning, Chea this problem has already been solved in your machine?

Abs Norry
Hahu
Location: São Paulo

O mundo gira muito!!



Return to PL/SQL

Who is online

Users browsing this forum: Bing [Bot] and 7 guests