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

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

Local connect to database (default connection)

From: VirVit <virvit_at_prodtorg.udm.net>
Date: Wed, 19 Nov 2003 20:39:55 -0800
Message-ID: <F001.005D7330.20031119203955@fatcity.com>


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: http://www.orafaq.net
-- 
Author: VirVit
  INET: virvit_at_prodtorg.udm.net

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 Wed Nov 19 2003 - 22:39:55 CST

Original text of this message

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