OraFAQ Forum: Client Tools » connect external DB (merged)

Home » Other » Client Tools » connect external DB (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connect external DB (merged) [message #412692]

Fri, 10 July 2009 12:09

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?

Report message to a moderator

Re: connect external DB (merged) [message #412695 is a reply to message #412692]

Fri, 10 July 2009 12:14

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Remove and reinstall your Oracle client.

Regards
Michel

Report message to a moderator

Re: connect external DB (merged) [message #412696 is a reply to message #412692]

Fri, 10 July 2009 12:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: connect external DB (merged) [message #412698 is a reply to message #412692]

Fri, 10 July 2009 12:35

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:

Report message to a moderator

Re: connect external DB (merged) [message #412699 is a reply to message #412692]

Fri, 10 July 2009 12:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: connect external DB (merged) [message #412701 is a reply to message #412699]

Fri, 10 July 2009 12:48

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

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: connect external DB (merged) [message #412723 is a reply to message #412706]

Fri, 10 July 2009 15:29

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.

Report message to a moderator

Previous Topic:	IN PL/sql Deloper not able to debug
Next Topic:	Securoty Reporting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:18:30 CDT 2024