Re: Connect string for local database

Try setting the environment variable ORACLE_HOME to the directory in which your database resides and the variable ORACLE_SID to be the name of your database, in this case PLSExtProc. Once that is done, you should be able to connect without specifying a connect string.

                                     Rick

"Marco" <haandm_at_yahoo.com> writes:

> I've installed an Oracle Database wich I named "oracle". Furthermore I added
> information about my professional databases at my company to my
> "tnsnames.ora".
> I'm able to connect to those remote databases using TOAD and SQL-plus by
> adding ".world" to the connect string.
>
> When I try to connect to my local database, I don't know what connect-string
> to use.
> SQL-Plus connect without giving a connect-string but when I'm using TOAD I'm
> not able to connect........TOAD wants a connect string.
> I've used the strings ":2" and "beq-local" but none of these succeeded.
>
> I think I have to add information about my local database to "tnsnames.ora"
> but don't know what.
>
> This is the infor for the local database at this moment:
> "#######################################################
> # Local database
> #######################################################
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
> "
>
>
> Please can someone help me?
>
>
 

-- 
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                rwessman_at_us.oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.