Ошибка ora 06413 соединение не открыто

Hi,

I have resolved by error after the days of searching:

Error Cause:
This error due to oracle reserved character «(«,»)» and in Windows 64 bit there is an folder «Program Files (x86)» is creation problem.

Solution:
Create a link folder for «Program Files (x86)» using below command on Window Drive path.

1).
Open cmd with administrator.
mklink /j «Program Files x86» «Program Files (x86)» ENTER
or visit link
http://www.download3k.com/articles/MKLink-Explained-Create-Symbolic-Links-that-Simplify-File-Management-in-Windows-Vista-7-and-8-00437

2).
open registry(with administrator)->Export Registry always backup a registry file before changing it.make a copy of registry file and work on copy.
Open Registry file(Copy) in text editor replace «(x86)» to «x86» Save file and import it in registry and restart you computer.

Now «ORA-06413: Connection not open» error go away.

Please rate this solution if your issue resolve.
Enjoy!

Shahzaib Zaheer
Software Engineer
shahzaibali88@hotmail.com

Источник

Hi,

I have resolved by error after the days of searching:

Error Cause:
This error due to oracle reserved character «(«,»)» and in Windows 64 bit there is an folder «Program Files (x86)» is creation problem.

Solution:
Create a link folder for «Program Files (x86)» using below command on Window Drive path.

Now «ORA-06413: Connection not open» error go away.

Please rate this solution if your issue resolve.
Enjoy!

Shahzaib Zaheer
Software Engineer
shahzaibali88@hotmail.com

Источник

Problem

This technote identifies an error that can be encountered when opening IBM Rational RequisitePro projects that are configured to use an Oracle database on a Windows 64 bit machine.

Symptom

The full error message is:
Microsoft[SQL] ODBC Error : ORA-06413: Could not open connection.

Cause

This error is seen when RequisitePro does not have the proper Oracle Client installed.

Resolving The Problem

To resolve this error apply one of the following three solutions:

Solution 1

Ensure that you are using an Oracle 32-bit client and not an Oracle 64-bit client because RequisitePro is a 32 bit application and requires the 32-bit Oracle drivers to establish a connection to the database.

Solution 2

Install RequisitePro in a location where there are no spaces or parenthesis:

Example:

C:RationalRequisitePro

Installation path for RequisitePro 7.1.x.x

C:IBMRationalSDLCRequisitePro

Solution 3

If you are using a 32-bit Oracle client and still receive the error then please apply one of the following fixes. 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:

Windows 64-bit AMD64 and INTEL EM64T:

[{«Product»:{«code»:»SSSHCT»,»label»:»Rational RequisitePro»},»Business Unit»:{«code»:»BU053″,»label»:»Cloud & Data Platform»},»Component»:»Database: Oracle»,»Platform»:[{«code»:»PF033″,»label»:»Windows»}],»Version»:»7.0;7.0.1;7.1″,»Edition»:»»,»Line of Business»:{«code»:»LOB45″,»label»:»Automation»}}]

Источник

My local environment VS2012

Using Oracle 10g XE

Dim dbConn As New OleDbConnection

Dim dbComm As OleDbCommand

dbConn.ConnectionString = "Provider=msdaora;Data Source=XE;User ID=scott;Password=tiger"

dbConn.Open()

Tip error: ORA-06413: Connection not open.

Already check the TNSNAMES.ora, SQLNET.ora, LISTENER.ora and its nothing wrong.

But why this error appear?
🙁

e_i_pi

4,4704 gold badges25 silver badges45 bronze badges

asked Apr 11, 2014 at 4:39

The error is caused by the parenthesis in the pathname.

possibly you execute VS2012 from C:program file (x86)…

workaround: create a junction link

steps:

from: command line execute

C:>mkLink /j "Program Files x86" "Program Files (x86)"

and then

fix the (or create a new) shortcut with new path (C:program file
x86…)

answered Jul 27, 2015 at 15:13

I worked a lot on this problem, I lost a lot of time. Apparently IIS Express in Visual Studio uses the Oracle provider 64 bit.

To solve this problem:

I installed IIS on my PC (Windows 10)
with .NET 4.5 or higher
I compiled the Web API application with 32-bit target.
I publish the web application on my IIS.
On IIS I set enable the apps 32 bit to true

tripleee

170k31 gold badges260 silver badges305 bronze badges

answered May 15, 2020 at 21:18

I had the same problem and I resolved the problem installing Oracle 11g Express. Before, I removed all previous Oracle client installation. I use windows 7 64 bit.

answered Apr 13, 2016 at 19:43

Create Bat file to start excel
in bat put path you can adjust to match your folders

start c:progra~2micros~1Office14Excel.exe

When you start excel just open macro and try 🙂

answered Oct 18, 2016 at 9:35

I encountered the same problem when working on my Visual studio 2013 project. I was able to run the same project from SVN on a different machine, but it just WON’T work on mine. I checked the connection string and could successfully test the connection in Oracle, but it would throw a disgusting “ORA-06413: Connection not open” error from code.

I got it fixed this way — Install Oracle 11g client -> Select «Administrator» as Type of Installation. Re-open Visual Studio and it worked. Hope it helps!

answered May 2, 2019 at 10:46

uninstall your toad or oracle
reinstall on on your window drive ex:(c/d/e) in new folder

don’t install in program files (x86)

because program files(x86) is for 32 bit applications

tripleee

170k31 gold badges260 silver badges305 bronze badges

answered Nov 6, 2018 at 6:54

I have resolved the error after the days of searching.

Error Cause:

This error is due to Oracle reserved character «(«,»)» and in Windows 64 bit there is a folder «Program Files (x86)» which is a creation problem.

Solution:

Create a link folder for «Program Files (x86)» using below command on Window Drive path.

Open cmd as Administrator.
```
mklink /j "Program Files x86" "Program Files (x86)"
```
or visit link
download3k article
Open Registry (as Administrator)->Export Registry

Always backup a registry file before changing it. Make a copy of the registry file and work on the copy.

Open Registry file(Copy) in text editor and replace «(x86)» with «x86»

Save the file and import it to your Registry and restart your computer.

Now the «ORA-06413: Connection not open» error goes away.

tripleee

170k31 gold badges260 silver badges305 bronze badges

answered Mar 28, 2016 at 7:52

Источник

Remove From My Forums

General discussion
The problem scenario: from Windows 7 (64-bit), create a link to an Oracle 10g table. Following steps 1 & 4, the dreaded «ORA-06413» dialog appears,

«Test connection failed because of an error in initializing provider. ORA-06413: Connection not open»

The problem is that MS Access 2007 on Windows 7 (64-bit version) is by default installed in the following folder: C:Program Files
(x86)Microsoft OfficeOffice12, and the Microsoft ODBC for
Oracle driver doesn’t work properly with the parentheses in the path. The solution is create a symlink to the folder Access is installed in, and then launching Access from that location.

Here’s what worked for me:
1. Create a ODBC data source using the Windows Control Panel applet, «Data Source (ODBC)», which happens to be found in %windir%syswow64odbcad32.exe
  - Select the System DSN tab
  - Click the Add button
  - Scroll to and select «Microsoft ODBC for Oracle», and hit OK
  - Fill in the Data Source Name, I chose «DanaOracle», and hit OK, and hit OK again
2. Here’s the real trick to making this all work: Set up a symlink to the c:Program Files (x86) folder without the parentheses:
  - Select the Windows button: Start -> All Programs -> Accessories
  - Scroll down to Command Prompt, and right-click and select «Run as administrator»
  - At the command prompt, enter the following: mklink /D «C:Program Files x86» «C:Program Files (x86)»
  - You should get back: symbolic link created for C:Program Files x86 <<===>> C:Program Files (x86)
3. For convenience, create a desktop shortcut to the new no-parentheses path to Access
  - Launch Windows Explorer (quick launch is Windows key, and press E), and navigate to C:Program Files x86Microsoft OfficeOffice12
  - Scroll to MSACCESS, right-click, and select «Create Shortcut»
  - A dialog will appear, saying it «…cannot create a shortcut here, and ask if you would like one placed on the desktop instead?» Click Yes.
  - Go to the desktop (quick launch is Windows key, and press D), and rename the shortcut so you can better remember why it’s there
  - Select the shortcut
  - Right-click, and select rename
  - Rename to «MSAccess for Oracle»
4. Finally, create a MS Access database with a link to an Oracle table
5. - Double-click the «MSAccess for Oracle» desktop shortcut
  - Select new blank database, and give it a name, I chose «DanaOracleDb.accdb»
  - Select External Data -> More -> ODBC Database
  - Select «Link to the data source by creating a linked table.»
  - In the «Select Data Source» dialog, select the «Machine Data Source» tab, and select the data source you just created (mine was «DanaOracle»), and hit OK
  - Another dialog will appear, Microsoft ODBC for Oracle Connect
  - Enter for the User Name: SYSTEM
  - Enter for the Password: <whatever password you chose for SYS and SYSTEM when you installed Oracle 10G>
  - Leave blank Server:
  - Another «Link Tables» dialog will appear, choose whatever is appropriate
There are probably other workarounds, like installing MS Access 2007
in a folder not containing parentheses in the path, but the above procedure worked for me — good luck!
- Moved by
  
  Wednesday, February 19, 2014 2:32 PM
  ms access related

Источник

May 24, 2021

I got ” ORA-06413 Connection not open ” error in Oracle database.

ORA-06413 Connection not open

Details of error are as follows.

ORA-06413 Connection not open.

Cause: Unable to establish connection.

Action: Use diagnostic procedures to ascertain exact problem.

Connection not open

This ORA-06413 error is related to Unable establishing connection.

Use diagnostic procedures to ascertain exact problem.

This error is caused by the parenthesis in the path of TOAD in my case

"C:Program Files (x86)/.."

To solve this error, make a link again as follows.

C:>mklink /j “Program Files x86” “Program Files (x86)”

Second case is as follows.

When attempting to configure the database connection via DBConfig.exe, the following error is encountered:

ERROR

Bad public user name or password. ORA-06413: Connection not open.

The folder path contains non-standard characters.

When the folder path contains non-standard characters, the reported error message will be received when attempting to configure the database connection via DBConfig.exe.

Examples: C:Program Files (x86)PrimaveraProject ManagementPM.exe OR C:Program Files (x86)OraclePrimavera P6P6 ProfessionalPM.exe

To correct this issue, perform the following steps:

Copy the entire “Primavera” or “Oracle” folder (depending on the P6 version) from the original location.

Examples: C:Program Files (x86)Primavera OR C:Program Files (x86)Oracle
Paste it to the root of C:.
Launch the PM.exe from the new location
Examples: C:PrimaveraProject ManagementPM.exe. OR C:OraclePrimavera P6P6 ProfessionalPM.exe
Re-create any shortcuts to PM.exe to reflect the new location.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

1,711 views last month, 2 views today

Источник

Моя локальная среда VS2012

Использование Oracle 10g XE

Ошибка подсказки: ORA-06413: соединение не открыто.

Уже проверьте TNSNAMES.ora, SQLNET.ora, LISTENER.ora и ничего плохого.

Но почему эта ошибка появляется? 🙁

Ошибка вызвана паретингом в имени пути.

возможно, вы выполните VS2012 из C:program file (x86).

обходной путь: создать соединение соединения

from: выполнить командную строку

исправить (или создать новый) ярлык с новым путем (C:program file x86. )

Создайте файл Bat, чтобы запустить excel в bat put path, который вы можете настроить в соответствии с вашими папками

Когда вы начинаете excel только открыть макрос и попробуйте 🙂

У меня была та же проблема, и я решил проблему установки Oracle 11g Express. До этого я удалил все предыдущие установки клиента Oracle. Я использую Windows 7 64 бит.

Я решил по ошибке после дней поиска:

Эта ошибка из-за зарезервированного символа оракула «(«, «)», а в Windows 64 бит есть папка «Program Files (x86)» является проблемой создания.

Создайте папку ссылок для «Program Files (x86)», используя следующую команду на пути Window Drive.

1). Открыть cmd с администратором.

mklink/j «Program Files x86» «Program Files (x86)» ENTER

или посетить ссылку

2).open registry (with administrator) → Export Registry всегда создает резервную копию файла реестра, прежде чем изменять его. Запишите копию файла реестра и работайте над копией. Открыть файл реестра (Копировать) в текстовом редакторе заменить «(x86)» на «x86» Сохранить файл и импортировать его в реестр и перезагрузить компьютер.

Ошибка «ORA-06413: соединение не открыта».

Оцените это решение, если проблема будет решена. Наслаждайтесь!

My local environment VS2012

Using Oracle 10g XE

Tip error: ORA-06413: Connection not open.

Already check the TNSNAMES.ora, SQLNET.ora, LISTENER.ora and its nothing wrong.

But why this error appear? 🙁

6 Answers 6

The error is caused by the parenthesis in the pathname.

possibly you execute VS2012 from C:program file (x86).

workaround: create a junction link

from: command line execute

fix the (or create a new) shortcut with new path (C:program file x86. )

I had the same problem and I resolved the problem installing Oracle 11g Express. Before, I removed all previous Oracle client installation. I use windows 7 64 bit.

Create Bat file to start excel in bat put path you can adjust to match your folders

When you start excel just open macro and try 🙂

1.just uninstall your toad or oracle 2. reinstall on on your window drive ex:(c/d/e) in new folder

don’t install in program files(x86) its work for me

because program files(x86) is for 32 bit application.

I got it fixed this way — Install Oracle 11g client -> Select «Administrator» as Type of Installation. Re-open Visual Studio and it worked. Hope it helps!

I have resolved by error after the days of searching:

Error Cause:

This error due to oracle reserved character «(«,»)» and in Windows 64 bit there is an folder «Program Files (x86)» is creation problem.

Solution:

Create a link folder for «Program Files (x86)» using below command on Window Drive path.

1).Open cmd with administrator.

mklink /j «Program Files x86» «Program Files (x86)» ENTER

2).open registry(with administrator)->Export Registry always backup a registry file before changing it.make a copy of registry file and work on copy. Open Registry file(Copy) in text editor replace «(x86)» to «x86» Save file and import it in registry and restart you computer.

Now «ORA-06413: Connection not open» error go away.

Please rate this solution if your issue resolve. Enjoy!

Может кто-нибудь подскажет, где собака зарыта ?:(
При коннекте к Ora PE 8.0.6 появляется subj.
Используется D5 + DOA. SQL Plus или Developer6 коннестится нормально. Другая программа, использующая D5 + DOA, только параметры коннеста system/manager@CNT, коннектится нормально.
Эта же прога никак. 🙁 (у нее другие параметры CNT/CNT@CNT) — пароль и пользователь верные.
metalink говорит, что какие то проблемы в сети и т.п., т.е. ничего конкретного и тем более, что другая прога работает.
P.S. не надо говорить, что руки кривые или ДНК не тот 🙂 — везде одна и та же строчка в D5 для коннекта — OracleLogon.Execute;

← →
Johnny Smith ( 2002-01-29 15:11 ) [1]

Во-первых, в документации Оракла указанной ошибки не нашлось.
Во-вторых, ощущение такое, что прога проваливается во время коннекта (еще до аутентификации — в противном случае Оракл ругнулся бы на username/password).
Может, все-таки не совсем корректно указан сервис? Как вообще указываются параметры соединения — в строчку (CNT/CNT@CNT) или по отдельности (вопрос не праздный)?

← →
EAlexander ( 2002-01-29 15:22 ) [2]

to Johnny Smith>
1. у меня нашлось 🙁 и в проге и doc
2. repeat : SQL Plus и developer с теми же параметрами — все коннект :(. все передает DOA — это его проблемы, как и что передать oracle

← →
EAlexander ( 2002-01-29 15:44 ) [3]

оказыватеся к ora НЕЛЬЗЯ приконектится, если прога лежит с путем, содержащие символы (, ) и др.
Век живи — век учись.

← →
Johnny Smith ( 2002-01-29 15:47 ) [4]

ммммдаааа, в натуре, век живи.

← →
Максимка ( 2002-01-29 15:59 ) [5]

Там точно — «Connection not Open» или «Сonnection is not defined»?

← →
EAlexander ( 2002-01-29 16:56 ) [6]

Источник

Fix Oracle Error ORA-6413: Connection Not Open

Receiving Oracle Error ORA-6413: “connection not open” but don’t know how to fix it?

Don’t worry this post will help you to acquire every pinch of detail regarding this Oracle Error ORA-6413. Also try the fixes to resolve this Oracle connection not open error permanently from Oracle database.

Oracle is popular database management software in database industry because of its performance factors and the precision it provides to its users. Being a relational database management system (RDBMS) it is capable of storing and managing lots of new entries simultaneously providing reliability, scalability and high performance in very low cost of ownership. All these things make Oracle one of the revolutionizing database management software.

Sometime due to wrong interpretation or some other reason the reachability of few command are inaccessible and thus error like Oracle Error ORA-6413: “connection not open” happens.

ORA-06413: ‘Connection not open’ is one such annoying bug which is caused due to internal error accused by unreachability to the database kernel.

Error Detail:

Error code: ORA-06413

Error name: Connection not open

screenshot:

ORA-06413 connection not open

Sometimes the error code is same but its arguments are different. The error declaration contains arguments stating this code and connection not open problem. This error comes differently in different Oracle database version.

How To Fix Oracle Error ORA-06413: ‘Connection Not Open’?

If you are receiving this ORA-06413 error, meanwhile running any program which requires connection with the Oracle database. In that case try the following fixes.

Method 1# Excel And Powerpivot Add-In Connecting Oracle

The stack of error that appears is somewhat like:

stack error

SSIS user may have faced this issue while launching DTSWizard.exe. But for Power Pivot users having Excel 2010 or later this may have occurred for the first time.

The cause of this error is basic and is due to unable to establish a launch path while executing this program or during connection. When you are running 32-bit Excel on 64- bit Operating system, the 32-bit causes is when the path of the application which launches the connection contains parenthesis, the provider fails to connect.

When using 32-bit Excel on a 64-bit machine, the 32-bit WOW program files (C:WindowsSysWOW64) folder has parenthesis in it “C:Program Files (x86)Microsoft OfficeOffice14Excel.exe”

How To Fix?

To workaround this is too simple. Find equivalent 8.3 short naming conventions for Excel.exe instead of the previous one. Use this convention short named to launch excels. Build a shortcut for this, so that always excel is launch from this path.

Oracle while connecting to your file has problems to relocate your folder because of same names or a lengthy name. Each systems folder name can be different so you have to check your own folders to find the right suffix without duplicating file names.

To explore your own short names use the approach mentioned below to find your short name on the drive letter where Office is installed.

Start > Run > Cmd.exe (or Start > CMD.exe if you don’t have a Run box)

Dir C: /x— look for Program Files (x86) short name

Dir C:PROGRA~2MICROS~4 /x
— Look for Office14 (short name is same as long name)

Dir C:PROGRA~2MICROS~4Office14 /x
— Look for Excel.exe (short name is same as long name)

Therefore, short-name to launch Excel can be:

C:PROGRA~2MICROS~4Office14Excel.exe

Copy the short path that you found and make a shortcut on your desktop so as to make it easy for the next time.

Isn’t it easy and better than any alternatives. When you install Office, pick a non-default folder that doesn’t contain parenthesis.

Method 2# Installing TOAD On Windows

Toad for mysql is a freeware development tool that enables you to extract, compare and search for objects, record and play back keyboard commands, trandfer data across database and much more.

Actually Toad accelerates your mysql learning curve and help in managing project more efficiently.

While installing toad you may have faced problems with an error code prompting: ORA-06413: Connection not open

How To Fix?

For this you need not do anything else, just install Toad in C:ProgramsTOAD. Instead in the default folder (avoid parenthesis or spaces in the folder).

Method 3# Stop Using Older Oracle Database Client Version

This ORA-06413 error also occurs in older Oracle database client version. Mainly when, it is called from the client installation path which is having the bracket symbol.

This happen more commonly when Windows Netprobe is installed in 32-bit default path C:Program Files (x86).

Windows Netprobe is also available in 64 bit. After installing Windows Netprobe in 64 bit Operating System you won’t get this ORA-06413 error. So if you are using the older Netprobe versions then please check the installation path and remove the bracket symbol.

Method 4# Fix Issue Of Oracle Enterprise Manager Console

ORA-06413 error also appears in Oracle Enterprise Manager Console, after the installation of 9i database in the Windows Storage Server 2003.

To fix Oracle error ORA-06413:Connection not open here we will consider one scenario:
suppose a Windows Service calling one method in the assembly which is connected to Oracle db.

In this case, two problems can arise. Let’s know what those problems are:

Problem 1:

If the service executable filename is having an extra dot then it will throw the ORA-06413 error. Example the file name is like this: Project.UpdateService.exe

So in this case you have to rename it like this ProjectUpdateService.exe. after that your Oracle database won’t throw any exception.

Problem 2:

You will encounter the exception on the development folder when the executable is within the folder having “illegal” path like this: “E:My DocumentsMy WebsProject(port 81)bin”

Well it’s not clear whether the problem is accused due to parentheses or space. But after placing the executable in the “E:Services” path ORA-06413 error has been resolved.

Wrap Up:

Carefully try all the above given fixes to resolve ORA-06413: Connection not open. If you are facing any kind of data loss or corruption issue in your Oracle database then immediately approach for Oracle repair tool.

As this software successfully recover entire database whether it is lost in any situation. With this tool you can also repair damage Oracle database file and also helps to restore tables, user names and many more stuffs.

Good luck with the fixes…!

Jacob Martin is a technology enthusiast having experience of more than 4 years with great interest in database administration. He is expertise in related subjects like SQL database, Access, Oracle & others. Jacob has Master of Science (M.S) degree from the University of Dallas. He loves to write and provide solutions to people on database repair. Apart from this, he also loves to visit different countries in free time.

Источник

Ошибка ora 06413 соединение не открыто

Problem

Symptom

Cause

Resolving The Problem

General discussion

ORA-06413 Connection not open

Connection not open

Do you want to learn Oracle Database for Beginners, then read the following articles.

6 Answers 6

Error Detail:

How To Fix Oracle Error ORA-06413: ‘Connection Not Open’?

Method 1# Excel And Powerpivot Add-In Connecting Oracle

Method 2# Installing TOAD On Windows

Method 3# Stop Using Older Oracle Database Client Version

Method 4# Fix Issue Of Oracle Enterprise Manager Console

Wrap Up:

А вот еще интересные материалы: