Installed Oracle Warehouse Builder which broke SQL Developer

Advertisement

Version 1.5.4 build MAIN-5940
SQL Developer worked fine. I installed Oracle Warehouse Builder and now SQL Developer cannot make a connection when I click on a connetion in the connectons window. When I look at the properties of the connection they look fine and when I click the "test" button I get a success message. When I click the "connect" button it appears to connect. However, When I click a connection on the navigator window I get this error message
Invalid connection information specified.
Verify the URL format for the speicified driver.
Vendor Code 0
I reinstalled SQL Developer but no help.

Advertisement

Don't know OWB, but I asume it installs some version of client, which could be picked up by sqldev.
If the problem really is that client, here's something that usually does it: trick sqldev by changing your ORACLE_HOME within a batch file inside sqldev's folder. This would force using the supplied thin driver:
set ORACLE_HOME=%CD%
start sqldeveloper.exeHope that helps,
K.

November 30, -0001

Installed Oracle Warehouse Builder which broke SQL Developer

Version 1.5.4 build MAIN-5940 SQL Developer worked fine. I installed Oracle Warehouse Builder and now SQL Developer cannot make a connection when I click on a connetion in the connectons window. When I look at the properties of the connection they lo

Oracle warehouse builder and windows vista

Hello All, I need to install oracle warehouse builder on PC with Windows Vista but Oracle Setup close installation program because it find JavaVirtualMachine (JRE) rel.6.0 but it need max jre 5.2. How i can do for installing oracle warehouse builder

Installed Data warehouse builder.Not knowin how to proceed.intial problems

hello frds i installed Oracle datawarehouse builder of 10.2.0.1.0 and when i am clicking the Repository Assistanceit is asking me for "basic or Advanced instal" i clicked on basic install after dat it is asking me to fill many things like reposi

Oracle warehouse builder - OWB & Oracle 10g Db on SuSE

hi folks, i have Oracle 10g db on my laptop; and it runs great! but since i am trying to gain skills in data warehousing and business inteligence, and after reading about oracle warehouse builder, i decided to install it on my laptop as well. but i c

Oracle Warehouse Builder 10.1.0.4

Hi All, I am searching for Oracle Warehouse builder 10.1 release which is compatible with Oracle database 10gR2 on solaris x86 server. I have found softwares for solaris sparc but nothing seems available for oracle 10gR2 on solaris x86. OWB 10.1.0.3

Who says Oracle Warehouse Builder is a leader in ETL?

... the analyst firm Gartner does! Oracle Warehouse Builder moved into the leader quadrant in Gartner's ETL Magic Quadrant published on September 8, 2004. Please see today's press release from Oracle http://biz.yahoo.com/prnews/040916/sfth048_1.html

Oracle Warehouse Builder VS Oracle Data Integrator

Hi everybody, I have a question that wish you can help me. we have systems of x64 so we cant use Oracle Warehouse Builder (only support on system 32 bits), someone recommend us to use Data Integrator but i don't really know this application. Anyway O

Problem in DB Link creation ( Oracle warehouse builder 3i  )

I am facing a problem in DB Link creation. Backend: Oracle 8i Server on my machine DW Software: Oracle warehouse builder 3i ( client , repository asistant.....) Operating system: Windows NT 4 SERVICE PACK 6 I wants to use the scott database( default

Oracle Warehouse Builder ORA-12801

We are running Oracle Warehouse builder 9.2 and we are receiving error ORA-12801 at least once a week. We can not recreate the problem. Has anybody ever experienced this problem? If so, how was it resolved? ThanksYou will be better off posting this q

Oracle Warehouse Builder -- LinkedIn Group

Hi, I'd like to invite those who post here to join a LinkedIn Group for Oracle Warehouse Builder users. The group home page is here: http://www.linkedin.com/groups?gid=140609 This is not intended to supersede the forum for asking specific questions a

Oracle 11G Install on Win 7 With PL/SQL Developer Help Needed

Today is my first day with Oracle. I have tried to Install Ora11g from our network drive.I think the installation went fine. I also installated PL/SQL Developer when i try to log in i got the following error see below. PL/SQL Developer - (Not logged

Just install oracle 11g -  can't access SQL

hello all, I am new to this and trying to learn I install my oracle 11 g ( with great difficulties !!!) I am trying to open the sql developer and it's asking me for the full pathname for JAVA.EXE ??!!! I updated the java and give him a path for it bu

How to install oracle report builder in windows 7

Hi Team, Could you guide me to install oracle report 11g in my PC . Previously i was using 10g . OS : win 7 DATABASE : 11gFollow How to install forms builder? | Oracle Community Hope read all and give a try. HamidRead other 2 answers

Oracle Warehouse Builder vs. DataStage

I have been asked to evaluate ETL tools for a large company (1 billion+ revenue). We already own Warehouse Builder (per our Oracle licenses), but have been evaluating DataStage for the past few months. Has anyone used or evaluated both of these tools

Installing Oracle 8i on server with SQL Server 2000

We have One Server (HP with: 4 processors XEON, 100 GB HD Raid 5, 8GB RAM). And this server has SQL Server 2000 running with some databases. We NEED to install ORACLE 8i for a product that they use that DB. IS THERE a problem to install and use ORACL

Oracle Warehouse Builder 9i

Hello OWB is about to be installed and we're searching for a tutorial. A search of OTN and MetaLink has turned up no results. Can someone point me to a tutorial (if one exists)? Thanks Steve [email protected]Hello OWB is about to be installed and we'

SAP-Connector (Oracle Warehouse Builder 11 g)

Hi, I am using the SAP-Connecor with OWB 11g. I can connect to the SAP-System and import the SAP-Tables (Metadata). I can also create a mapping and deploy it. Before executing the mapping, i tested the ABAP-Code in the SAP-System. And this Code is va

Why Warehouse Builder

If the source of all my data is an Oracle DB - data is replicated from different Oracle DB's into a single Oracle DB through shareplex replication(E of ETL is done), Q1) Will Warehouse builder be of any help if my data souce is just Oracle? Q2) Will

Which 11g ojdbc?.jar driver for SQL Developer 1.5.1

OS: Linux OEL-5.2 32-bit DB: Oracle 11g 32-bit Sun jdk-1.6.0_06 SQL Developer 1.5.1.54.40 Is it normal to use Oracle ojdbc6.jar driver with SQL Developer 1.5.1.54.40 given that java version I'm running is 1.6.0_06 ? I am asking this because SQL Devel

Oracle 9i Warehouse builder...

HI, We are in the process on designing a datawarehouse. Please let me know if Oracle ware house builder provides interfaces to the follwing financial systems :- 1)Great Plains     V6.0 2)Sun     4.2.6 3)Oracle Financials     11.5.8 4)Navision     2.6