How do I log in?

[captainpants]

Hi all,

New to Oracle, PL/SQL Developer and all that. I'm not a DBA, and don't intend to become one. I just need to connect to a database to confirm that it's connectable to... However, I can't work out what to put in the "Database" field of the "Log on..." dialog. Everything I try fails with invalid driver designation. Here's some egs of what I've been trying

host.domain.comort
@host.domain.comort
thinhost.domain.comort
oraclehost.domain.comort
thin:host.domain.comort

and others...

How am I supposed to know how to designate the driver? I can't find any doco on it, and I have skimmed the helpfiles...

rr

 

[Marco Kalter]

If you have a local Oracle database on your PC, you can leave the Database field empty to establish a local connection.

If you want to connect to a remote database, you must have Oracle Net installed. You subsequently need to configure it through the "Oracle Net Configuration Assistant". You need to define "Local Net Service Names" for each of the databases that you want to connect to. If you can connect from other PC's it may be easier to copy the \Network\Admin\tnsnames.ora file to your PC.

------------------
Marco Kalter
Allround Automations

 

[captainpants]

Thankyou -- tnsnames.ora was my missing link.