connect external DB (merged) [message #412692] |
Fri, 10 July 2009 12:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #412701 is a reply to message #412699] |
Fri, 10 July 2009 12:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 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.
|
|
|
|