Windows / .NET :: ODBC Administrator Has Stopped Working
Dec 8, 2012
I installed the Oracle instant client version 10.2.0.3 and the corresponding ODBC driver. When I try to add a DSN in ODBC Manager using the Oracle driver, it crashes and I get this message:
"ODBC Administrator has stopped working"
"Windows is checking for a solution to the problem..."
Trying to isolate this problem, I ran odbcad32.exe under DependencyWalker and it worked correctly without crashing. According to the Dependency Walker FAQ, this can be due to a "buffer overrun, stray/bad/freed pointer, etc.". They have a switch to set SET NODEBUG_HEAP=1 to check for this. When I did this, it crashes insider DependencyWalker also.
View 0 Replies
ADVERTISEMENT
May 19, 2011
jrew.exe has stopped working when iam trying to install oracle8i on WINDOWS 2008 SERVER.
View 1 Replies
View Related
Nov 25, 2012
I have an oracle application (Froms 6i) that is being accessed from a PC client running Windows 7 Professional. Whenever I try to access the the application I get a "Oracle Forms Runform has stopped working" error. I tried installing the runtime over and over again withn no use. This is not the first problem I encounter with "Windows 7- Oracle 6i" combination.
View 1 Replies
View Related
Mar 21, 2012
Im not able to open the oracle reports 10g under Oracle Developer Suite Using win 7 enterprise version It gives me no error but unable to see the reports opening.It is running in the task manager but it is not opening.
View 2 Replies
View Related
Jun 28, 2011
When i run my reports on Windows 7 i receive the following error Reports Background engine Stopped working
When i view the detail of the error it shows
Problem Event Name APPCRASH
Application name RWRBE60.EXE
Application Version 3.0.0.0
Application Timestamp 38a27e49
Fault Module Name rwlib60.dll
Fault Module Version 0.0.0.0
I think it is sufficient information for you experts to resolve this issue reports are designed in developer 6i please view the attached image for report error detail.
View 8 Replies
View Related
Mar 20, 2011
I'm having some trouble with iSQL*Plus.I instaled oracle database and at first it worked fine, but then I installed client on the same maschine and all products that come with client, and somewhere in the meantime iSQL*Plus stopped working.
Then I uninstalled client and products that go with him (Policy Manager, Oracle Wallet...) because I thought that they have "broken" iSQL*Plus, but it still doesn't work. Finally, I re-installed iSQL*Plus, but that didn't work either. Interesting thing is that when I type in command line
" c:/miljana/bin/isqlplusctl start "
it says that iSQLPlus is started, but when I go to browser there is an error:
" Firefox can't establish a connection to the server at miljana.localhost.com:5560. "
Also from Administrative tools/Services if a try to start iSQL*Plus there is an error:
" Could not start the OracleOraDb10g_home1iSQL*Plus service on Local Computer.
Error 1067: The process terminated unexpectedly. "
I know that there is a lot of topics for this, but most of solutions where for Linux, and didn't work for me.I'm using Oracle 10g Enterprise Edition on WindowsXP
View 1 Replies
View Related
Dec 20, 2012
Database: oracle 9i sitting on a 32 bit machine.
Client: windows7 64 bit computer
installed oracle 11gr2 client
Is there a way to connect to oracle 9i database from C:WindowsSysWow64odbcad32.exe on windows 7 machine? or what is the possible way to connect to Oracle 9i database?What we need is to run crystal reports from windows 7.
View 4 Replies
View Related
Jan 14, 2012
I am using DataBase Express 11g as a development site.I have developed a Delphi GUI to run with it. (32bit). All runs as expected!My associate has a Windows 7 (64bit) machine. Express installation does not supply an ODBC driver. DataBase Express installs without problem, but it is the connectivity that is the problem
I understand that 11g(full) supplies both 32 & 64 OBDC drivers.I do not want to install the full 11g database if it can be avoided.
This is going to be more of a problem the more 64bit machines get into the workplace.Is there an alternative connection method available?
View 1 Replies
View Related
Nov 12, 2012
Using Server 2008 Standard Edition 64 bit. We have been running full client (admin) version 10.2.0 and just installed full client (admin) 11.2.0. Both homes are in my path variable with 11.2 first.
From ODBC Administrator, I can can create new system data sources using the 11.2 client driver and the testing widget built into the data source creator says my connection is good to both 10.2 dbs and 11.2 dbs. So the 11.2 odbc driver would seem to be working.
However, from MS Access, I can only see 10.2 drivers and 10.2 data sources, which fail unless I put the 10.2 home in first place in my path.
I cannot find a way to "access" the 11.2 drivers from MS Access. If I try to create a new data source from inside MS Access, I only see the old 10.2 driver.
View 3 Replies
View Related
Jan 4, 2013
i want to use Oracle database client 10g ODBC driver but i don't have it.
I want the driver for setup.
View 0 Replies
View Related
Sep 13, 2012
the need to use 9i Oracle ODBC drivers with 11g? What issues might be raised with this? Our application is using a very old technology and has issues, in certain functional areas, with 11g ODBC, and we found by reverting the driver to 9.0.0.2 it works.
View 6 Replies
View Related
Sep 17, 2002
I am attempting to connect to an Oracle 8i database via the Oracle 9.02 ODBC driver and I am receiving the following error message upon testing the connection in WinXp's ODBC Data Source Administrator dialog box: "Unable to connect SQLState=IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" .
I am running Oracle Client 9.2 on a P4 machine running winXP.
View 28 Replies
View Related
Jul 16, 2012
I'm using following connection string: +connectionString="Driver={Oracle ODBC Driver};Server=someDb;Uid=useruidr;Pwd=password"+
when I call method "Open" on "OdbConnection" I get following exception: +ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified+
"someDb" is specified correctly in tsnames.ora,
"...client" and "...clientin" are added to PATH environmental variable
ORACLE_HOME is set to "...client"
I have Oracle Client 11.2.0.3.0 installed
Operating system is Windows 7 32 bit
When I change Driver to "Microsoft ODBC for Oracle" it works fine. However I want to use Oracle ODBC Driver.
View 2 Replies
View Related
Sep 5, 2012
I'm trying to setup ODBC connection for my Oracle client while installing BO. Following are the steps I followed.
1. Downloaded the Oracle Client from the link [URL] . From that downloaded two zip files. “Instant Client Package – Basic Lite" and “Instant Client Package – ODBC”. Extracted the Zip Files to the folder I created under C: as C:Oracleinstantclient_11_2.
2. Since I'm setting up in ODBC in windows 2008 64-bit R2. I was advised to install 32 bit . So in cmd prompt, from the location C:Oracleinstantclient_11_2, ran odbc_install.
3.Created the Environment variables as
i) *TNS_ADMIN - C:Oracleinstantclient_11_2*
ii) *Oracle_Home - C:Oracleinstantclient_11_2*
iii) *Edited the PATH variable with ;C:Oracleinstantclient_11_2*
4. Created the tnsnames.ora file in C:Oracleinstantclient_11_2. Its content are as follows.
clarity_dev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = claritydev.vip.its.ebay.com )(PORT = 1521))
)
(CONNECT_DATA =
(SID = clarity)
)
)
5. From the folder %windir%sysWOW64odbacd32.exe, Opens ODBC Data Source Adminsitartor. In that I found my Oracle in instantclient_11_2 and added following details.
Data Source Name : claritydev.vip.its.com
TNS Service Name : clarity_dev
User Id: clarity1
When I test connect it, I get error *ORA-12154:*
* TNS:could not resolve the connect identifier specified*
I've seen FAQs for this error, but couldn't find anything which solves. Is there any steps I'm missing? I've checked in DB properties. It uses SID not the Service Name.
View 3 Replies
View Related
Sep 9, 2013
I installed the Windows 7 64-bit ODBC drivers, but the install does not seem to have made the drivers available to all users, but rather only the installing user. This install is for an image that will be cloned as a virtual machine, so the drivers, client, settings, etc. will need to be available to anyone who logs in.
Is there a way to do the install so that all the settings and files put in by the installer will apply to all users? And if so, how do you do that?
View 0 Replies
View Related
Feb 1, 2013
Windows 7
Oracle XE 11gR2
From Windows, I can successfully create and connect with a system data source using an user Oracle account.But when doing then same configuration process I can not create or connect using the 'SYS' account.
i get the error 'ORA-2009: connection as SYS should be as SYSDBA or SYSOPER'.
What is the solution to creating an ODBC DSN for the user 'SYS'?
View 6 Replies
View Related
Jan 9, 2013
I work in a large bank in a department that produces reports for different areas of the bank. By and large, we use Microsoft Office products to interface with our Oracle databases.Recently, we had two new databases come online that use Oracle 11g - we were not using any 11g databases before this point. We have two other databases that we use that run on Oracle 10g.
Up until the two new databases were brought in, our reporting was done from systems that used 10g and 9I. We all ran the Oracle 9I driver to connect to them, and it worked very well without issue. With the addition of the 11g databases to our reporting pool, we have been forced to upgrade our ODBC connections to the 11g driver, and it has not gone well at all. I had one query that typically ran in 30 minutes take +13 hours+ to run yesterday. Speed is not the only issue, either; we have sporadic ODBC call fails, crashes, and other general failures to deal with.
Our Oracle DBAs have been trying to solve the issue, but have not yet found a solution, and each day that this goes on we fall further and further behind, as I have daily time-sensitive reports to send out that depend on this data.
One of our DBAs said she read somewhere that Oracle had not included MS Access support in the 11g driver, and that the errors were due to the imperfect connection that the driver created. I don't know of there's any truth to that, but it would provide an explanation for our troubles. We have to use Access for our reporting, as over 90% of our existing reports and processes use Access, and having to change over everything at once is just not feasible.
Is there any way to force the 9I and 11g ODBC connections to coexist, so that we don't have to use the 11g driver for our 10g databases? Or is there a better 11g driver available?
View 2 Replies
View Related
Aug 6, 2012
I am creating a cross platform database application using Mono. It uses oracle database as back end. I used ODBC drive to connecting database. I can connect to database using this following connection string in my windows machine
Driver={Oracle in OraDb11g_home1};Server=localhost;Uid=system;Pwd=manager
For Linux I uses Linux Oracle OS for Database server. I installed oracle client in my fedora OS. and cofigure the client using net cofiguration assistant tool with oracle client. client connection working OK. Then I try to connect with my mono application using the following connection string
Driver={Oracle ODBD Drive};Server=orcl;Uid=system;Pwd=manager
but the above connection string not worked.I am using Oracle 11g version. Do I need to install any other ODBC driver to access oracle database
View 1 Replies
View Related
Sep 25, 2013
I am developing an 64bit And-In software. My OS is windows7 64bit Ultimate. Developer tool is Microsoft Visual Studio 2010 Ultimate 64bit any-CUP.Server is SUN server and Oracle database 10.2.0.5 64bit enterprise edition.I have installed instantclient-odbc-win64-10.2.0.5 on my computer.I am able to connect through the command line sqlplus user/pass@server.In date source(c:windowssystem32odbcad32.exe), ODBC Driver connection successful.But in VS2010 C#, use Tools -> Connect Database,I get an error 193 (Oracle in instantclient10_2,c:ora10_64SQORA32.dll) cann't be loaded.SQORA32.dll is 32bit ODBC Driver or 64bit ODBC Driver?How can I connect database with vs2010 64bit?
View 2 Replies
View Related
Jun 23, 2012
I'm having great difficulty connecting to two separate databases on my PC. Here are the details.
c:>echo %TNS_ADMIN%
C:TNS_ADMIN
#C:TNS_ADMIN nsnames.ora
XE =
(DESCRIPTION =
[code]...
View 22 Replies
View Related
May 25, 2012
Is it possible to install Oracle SOA 11 in a Windows2008R2 as a power user or it is mandatory to create a Local system administrator account?
View 2 Replies
View Related
May 25, 2013
I am trying to write a script to create a table with the author column default value as "Administrator" I use this execute immediate statement1;
Why does it create the table successfully with ',AUTHOR VARCHAR2(30) DEFAULT 1' and NOT with ',AUTHOR VARCHAR2(30) DEFAULT Administrator' ?
I want to set the COLUMN DEFAULT have to "Administrator" when I create the table.
When I try character I get this error "ORA-00984: column not allowed here"
statement1:='CREATE table TEST_ID2'
||'(TEST_ID NUMBER(6)'
||',test_name VARCHAR2(40)'
||notnull||
',date_created DATE DEFAULT SYSDATE '
[code]....
View 13 Replies
View Related
Apr 22, 2009
I have a refresh group that will refresh several materialized views at 4:00am. Sometimes the job failed. We need to enter to the enterprise manager to check the status of the refresh group.
Our target is that notification email is sent to our email once the refresh job failed. I have found some software that can do that. However, we need to handle ourselves. I would like to ask whether we can do that using enterprise manager.
View 7 Replies
View Related
Aug 23, 2012
We are having 10g 2Node RAC on Windows 2003. I cannot stop services by using command ""crsctl stop crs/ srvctl stop database "" without administrator permission through my OS user. Is it possible to stop the services without Administrator permission on OS level.? What kind of OS level permission need to access the ""crsctl/srvctl etc"".
View 6 Replies
View Related
Aug 26, 2010
Have an issue where after several months, our Oracle database has stopped choosing an index.
Here's some background information:
For the sake of simplification, the table has two key fields, SITE and ID, and the table is partitioned by SITE. Since the query is doing an ORDER BY ID DESC, we had to create a function-based DESC index as well as a regular index to convince the database to choose the index:
INDEX_1: SITE Asc, ID Asc
INDEX_2: SITE Desc, ID Desc
So when the index is chosen the showplan displays INDEX RANGE SCAN DESCENDING on INDEX_1
Now, after several months where the index was being chosen for all 4 SITEs, the index only works for 3 of the 4 SITEs.
And for 1 of the SITEs it shows 'TABLE ACCESS FULL'.
Strangely, we created another instance of the database (a byte for byte image) for troubleshooting purposes, with the same database engine version (but different OS version) and the index is being chosen for that new instance. Of course there's an explaination for this, but it's beyond my comprehension as to why you have an exact image with a different behavior.
Here's what Oracle version:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
PL/SQL Release 9.2.0.7.0 - Production
CORE9.2.0.7.0Production
TNS for Solaris: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production
By the way, HINTS are not an option since the application that executes this query doesn't allow us to modify the SQL.
View 9 Replies
View Related
Jul 30, 2013
I have Windows 7 Enterprise, 64 bit operating system. I downloaded Oracle 12c for 64 bits. I downloaded both zipped files in one folder that I created and un-zipped in the same folder as well.Once I start setup.exe,
I got three times File not found message as follows:
File not found C:app....admindr0ulib.sql.sbsFile not found C:app...installsbs rcsess.batFile not found C:app...schemamk_dir.sql.sbs
On all of the above situations, I clicked "Continue" since I have no idea where to find these files.At 59% installation, it is in the process of setup and displaying the message "updating registry key "HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_OraDB12Home1" At this point it pretty much hangs up for ever.
View 11 Replies
View Related
Feb 19, 2011
I have a dba_job that is scheduled to run every hour and for the past couple of weeke it is behaving strangely. It fails running every alternate hour. I have checked the alert log whenever it fails but nothing is reported in the alert log. The job is not broken.
View 4 Replies
View Related
Nov 29, 2011
We are using Discoverer 10g, apps mode EUL. I have assigned administrator privileges to System Administrator responsibility using EUL_US as well as SYSADMIN (re-did with SYSADMIN, just in case). I have 2 Business Areas in EUL and gave access to both of them to System Administrator responsibility and the userid TESTER (this user already has System Administrator responsibility assigned to it). But when I login to Administrator using TESTER and System Administrator, I don't see any business Areas available to select.
View 3 Replies
View Related
Apr 1, 2013
Below is the sample code working fine in 10g and not working now in 11g.
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS
import java.sql.SQLData;
import java.sql.SQLException;
import java.sql.SQLInput;
import java.sql.SQLOutput;
import java.util.List;
[code]....
we got the below error: ORA-00932: inconsistent datatypes: expected an IN argument at position 1 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class
Current Oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit and the version we are upgrading is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
View 3 Replies
View Related
Feb 1, 2013
What are the steps required to change an ORACLE stored procedure (on a AIX/UNIX machine) using OTG to connect to a DB2 database, to an ORACLE stored procedure that uses ODBC or JDBC connectivity?
All I need to do in the stored procedure is a simple insert statement into a DB2 table.
What kind of ODBC/JDBC driver do I need on the UNIX machine? unixODBC?
What would be different in the ORACLE stored procedure for it to use ODBC connectivity rather than OTG.
View 1 Replies
View Related
