Home » SQL & PL/SQL » Client Tools » connect external DB (merged)
connect external DB (merged) [message #412692] Fri, 10 July 2009 12:09 Go to next message
quali74
Messages: 4
Registered: July 2009
Junior Member
hi
I need a little bit of help to connect an Oracle DB.

I have details to connect an external oracle database but I have done it before and does not seem to work. I have installed the latest version of PL/SQL.

PL/SQL comes with a Oracle login box. I fill in the details and always get:

Initialization error
SQL*Net not properly installed
OracleHomeKey:
OracleHomeDir:




I have used another software called dreamcatcher to connect the DB. I indicated the hostname, database name, username and password and that worked starightaway.


Any idea?
Re: connect external DB (merged) [message #412695 is a reply to message #412692] Fri, 10 July 2009 12:14 Go to previous messageGo to next message
Michel Cadot
Messages: 58494
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove and reinstall your Oracle client.

Regards
Michel
Re: connect external DB (merged) [message #412696 is a reply to message #412692] Fri, 10 July 2009 12:23 Go to previous messageGo to next message
BlackSwan
Messages: 22481
Registered: January 2009
Senior Member
> I have installed the latest version of PL/SQL.
I am sure you mean well, but I seriously doubt the validity of statement above.

PL/SQL is a programming language which runs/resides inside Oracle RDBMS.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: connect external DB (merged) [message #412698 is a reply to message #412692] Fri, 10 July 2009 12:35 Go to previous messageGo to next message
quali74
Messages: 4
Registered: July 2009
Junior Member
that's right sorry.
The software is called PL/SQL developper

Now, I am looking at the 'about' window. I can see it says:

OCI: not initialized
DLL:


Re: connect external DB (merged) [message #412699 is a reply to message #412692] Fri, 10 July 2009 12:40 Go to previous messageGo to next message
BlackSwan
Messages: 22481
Registered: January 2009
Senior Member
>The software is called PL/SQL developper
Hmmm, I believe the current product is called Jdeveloper. Right?

http://www.oracle.com/technology/software/products/jdev/htdocs/soft11.html

We really, really, need to know what you have & what you did in order to assist you.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: connect external DB (merged) [message #412701 is a reply to message #412699] Fri, 10 July 2009 12:48 Go to previous messageGo to next message
quali74
Messages: 4
Registered: July 2009
Junior Member
no. I am using a software called "PL/SQL developer"
www.allroundautomations.com/plsqldev.html

I am using this software because someone showed me the database using that software. Unfortunately the persons who set it all up doesn't work there anymore and nobody really knows how it was all set up.

I am now trying to connect the database from home.

If you can suggest another client to connect the DB, please let me know.

[Updated on: Fri, 10 July 2009 12:55]

Report message to a moderator

Re: connect external DB (merged) [message #412706 is a reply to message #412701] Fri, 10 July 2009 13:17 Go to previous messageGo to next message
ThomasG
Messages: 3087
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
There are not much "other clients". You need the basic Oracle client installed first for most Software to work.

Without the basic Oracle client no other programs like PL/SQL Developer will be able to connect. (The missing OCI it is complaining about is part of the Oracle client)

So install the Oracle client first, set up the Connections you need the TNSNames, and try to connect to the database with SQL*Plus.

Only if THAT is working have other programs a chance to get a connection.
Re: connect external DB (merged) [message #412723 is a reply to message #412706] Fri, 10 July 2009 15:29 Go to previous message
quali74
Messages: 4
Registered: July 2009
Junior Member
hi,

I downloaded the basic Oracle client and it worked straight away. thanks a lot for the help.
Previous Topic: IN PL/sql Deloper not able to debug
Next Topic: Securoty Reporting
Goto Forum:
  


Current Time: Wed Jul 23 03:03:36 CDT 2014

Total time taken to generate the page: 0.07556 seconds