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
Post Reply
Júnior Cirqueira
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Sun, 27 Jun 2004 11:59 pm
Location: Sertãozinho - SP

Hi everyone.
The problem appears to be in the machine name that can not have special characters to connect to Oracle. Well, a friend got me a description and I'm going to pass on you, it follows below.

even more ....

Select all

---------------------------------- 
"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 a 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 reserve 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 a Sqlnet.log (using wordwrap for  
display purposes), showing the connect failure using "ALPHA (TEST)" as  
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: 14-OCT-99 23:23:49  
 
Tracing not turned on.  
 
***********************************************************************  
 
Note1: The actual 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: Couldn't 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.  
"
Hahu
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 147
Joined: Thu, 16 Mar 2006 11:26 am
Location: São Paulo
O mundo gira muito!!

Speak Junior Cirqueira,

Good morning,

Is this problem solved in your machine?

abs hahu
Post Reply
  • Information
  • Who is online

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