Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Local connect to database (default connection)

Re: Local connect to database (default connection)

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Wed, 19 Nov 2003 23:39:53 -0800
Message-ID: <F001.005D7337.20031119233953@fatcity.com>


Set either ORACLE_SID or LOCAL to your "default" SID in either Windows environment variables or registry.

The general difference between ORACLE_SID and LOCAL is that, with ORACLE_SID you can specify only instances in local server, but with LOCAL you can set any TNS alias (the same as TWO_TASK in Unix)

Tanel.

> Hello!
>
> I have next problem: I've setup Listener and TNS Names and I can connect
to
> database but only when SID is specified. I want to specify default
database
> to connect to.
>
> D:\Backup\oracle>sqlplus cheques/cheques
> SQL*Plus: Release 9.0.1.3.0 - Production on ? 20 08:33:55 2003
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
> ERROR:
> ORA-12560: TNS:protocol adapter error
>
> D:\Backup\oracle>sqlplus cheques/cheques_at_virvitdb
> SQL*Plus: Release 9.0.1.3.0 - Production on ? 20 08:34:56 2003
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.4.0 - Production
>
>
> virvitdb - my local DB on my machine.
> Here tnsnames.ora file:
> VIRVITDB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = virvit)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = virvitdb.prodtorg.udm.net)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> And Listener.ora:
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = virvit)(PORT = 1521))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\oracle\ora92)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = virvitdb.prodtorg.udm.net)
> (ORACLE_HOME = D:\oracle\ora92)
> (SID_NAME = virvitdb)
> )
> )
>
>
> --
> (VirVit)
> Oracle 9i DBA beginner
>
>
> --
> Please see the official ORACLE-L FAQ

httpwww.orafaq.net--AuthorVirVitINETvirvit_at_prodtorg.udm.netFatCityNetworkSer vices--858-538-5051httpwww.fatcity.zl6SanDiego,California--Mailinglistandweb

hostingservices-------------------------------------------------------------


> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Nov 20 2003 - 01:39:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US