TOAD on Windows: ORA-06413: Connection not open.

ใช้ windows(7) 64 bits รัน toad 32 bits (ver 10)
แล้วสร้าง connection จะเจอ ORA-06413 Connection not open.
แต่ toad ver 9 ใช้ได้ เลยค้นดูสาเหตุเกิดจากอะไร
ที่น่าสงสัยคือ C:\Program Files (x86)\Quest Software\Toad for Oracle\
เพราะ software เป็น 32 bits windows จึง default ให้ที่ Program Files (x86)
ปัญหาเลยอยู่ที่ วงเล็บ()

วิธีแก้ คือ uninstall แล้วลงใหม่ โดยไม่ให้มี วงเล็บ หรือ parenthesis อยู่ในชื่อ directory ด้วย

อันข้างล่างเป็นข้อมูลที่หามา

Just install TOAD in c:\Programs\TOAD instead of the default directory (avoid any parenthesis or spaces in the folder) and IT WILL WORK! Ask no questions, just work.

I found this document on Oracle Metalink:

Subject: ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit Windows OS
Doc ID: Note:334528.1

SymptomsYou are attempting to connect to the Oracle database from a Windows platform using one of the following programmatic interfaces

ODBC
OLEDB
OO4O
ODP.NET

after installing 32-bit Oracle client software on a 64-bit Windows operating system (OS) you receive one of the following errors:

ORA-12154: TNS:could not resolve the connect identifier specified

or

ORA-6413: Connection not open. Cause64-bit Microsoft OS's install 32-bit applications into the following location

"C:\Program Files (x86)\..."
rather than the typical location of

"C:\Program Files\..."
This causes an existing networking bug to occur where the networking layer is unable to parse program locations that contain parenthesis in the path to the executable which is attempting to connect to Oracle.

The following bug has been filed to correct this behavior:

Bug 3807408 - CANNOT EXTERNALLY AUTHENTICATE USER WITH QUOTE IN USERNAME

Additional Information

The reason you receive an ORA-12154 vs. an ORA-6413 is generally due to which programmatic interface you have chosen to use to connect to Oracle.

The ORA-12154 is the typical error seen when connecting with up-to-date interfaces using the latest version of the Oracle Call Interface (OCI):

Oracle ODBC Driver
Oracle Provider for OLE DB
Oracle Objects for OLE
Oracle Data Provider for .NET (ODP.NET)
Microsoft's .NET Managed Provider for Oracle
The ORA-6413 is typical of using older interfaces which make legacy API calls such as Oracle's OCI Version 7 API:

Microsoft ODBC Driver for Oracle
Microsoft OLE DB Provider for Oracle

SolutionTo resolve this problem try either of the following solutions:

SOLUTION 1:

Use a version of the Oracle software that contains the fix for Bug 3807408.

NOTE: Currently the following patches have been released on Windows:

Windows 32-bit
9.2.0.7.0 Patch 6: Apply Patch 4928723 or later
10.2.0.1.0 Patch 4: Apply Patch 4923768 or later
10.2.0.2.0 Patch 5: Apply Patch 5383042 or later
10.2.0.3.0: Apply Patch 5337014 or later

Windows 64-bit AMD64 and INTEL EM64T

10.2.0.1.0 Patch 4: Apply Patch 4923787 or later
10.2.0.2.0 Patch 5: Apply Patch 5388871 or later
10.2.0.3.0: Apply Patch 5337014 or later

For all other versions on Windows please use SOLUTION 2 for now.

SOLUTION 2:

Find the location of the application that is generating the error. Check the path to this location and see if it contains any parenthesis. If so, you must relocate the application to a directory without any parenthesis in the path.

----

In my sqlnet.log i find the folowing lines:

***********************************************************************
Fatal NI connect error 6413, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=XE)(CID=(PROGRAM=C:\Program Files (x86)\Quest Software\Toad for Oracle\toad.exe)(HOST=OCTOPUS)(USER=Joost))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 25-JUL-2007 09:07:35
Tracing not turned on.


Solution 2 worked fine for me.

I deinstalled Toad from the following location
C:\Program Files (x86)\Quest Software\Toad for Oracle\

and reinstalled it in the following location
C:\Oracle\Quest\Toad 9.1

This path doesn't contain any parenthesis so it doesn't cause the existing networking bug.

null

ref: link



อีกวิธี
Installation:
Windows 64-bit Operating System - Oracle Client Issue


The application supports a Windows 64-bit OS. However, changes will need to be made to the installation path during installation. The default install directory for 32-bit applications on a 64-bit OS includes parenthesis as shown in the following example:

C:\Program Files(x86)\Quest Software\

According to Oracle Metalink, Doc ID 334528, there is a network error that results causing any path with a parenthesis to have an issue. Toad will have to be installed into a different folder without the parenthesis as shown in the following example: C:\Quest Software\


Workaround:
RESOLUTION 1: Create a new folder that is not under the Program Files folder, such as C:\Quest Software\ and install Toad under this new folder. The installation program allows you to change the default installation path.

RESOLUTION 2: Upgrade to an Oracle Client 11g version. The following is an 11g Oracle Client download link that we recommend. Oracle Database 11g Release 1 Client (11.1.0.6.0) for Microsoft Windows win32_11gR1_client.zip (510,809,607 bytes)

http://www.oracle.com/technology/software/products/database/oracle11g/111060_win32soft.html

ref : link

0 ความคิดเห็น:

แสดงความคิดเห็น

top