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: so my boss insists on using oracle on NT sp6

RE: so my boss insists on using oracle on NT sp6

From: Toepke, Kevin M <ktoepke_at_cms.cendant.com>
Date: Tue, 19 Dec 2000 15:10:14 -0500
Message-Id: <10715.124961@fatcity.com>


Joe,

I think it has to do with his tnsnames.ora and listener.ora files... I think changing my files to the following fixed my problem (I'm connected to the nework right now, so I can't check :) I think adding the IPC lines was what solved the problem

Hope this helps.
Kevin

listener.ora
LISTENER =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = PLAY))
(ADDRESS = (PROTOCOL = TCP)(Host = ktoepke-tp)(Port = 1521)
     )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = PLAY)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = PLAY)

    )
  )

tnsnames.ora
PLAY.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = PLAY))
(ADDRESS = (PROTOCOL = TCP)(HOST = ktoepke-tp)(PORT=1521))
    )
   (CONNECT_DATA = (SID = PLAY)
    )
  )

> -----Original Message-----
> From: Joseph S. Testa [mailto:teci_at_oracle-dba.com]
> Sent: Tuesday, December 19, 2000 2:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: so my boss insists on using oracle on NT sp6
> 
> 
> and when he's not connected to the network(while at work or 
> at home), he
> tries to connect and gets a 3113 error, i'm sure its a 
> networking thing
> but since i'm remote(and its NT) i can't exactly logon and 
> check things
> out.
> 
> i'm sure one you all have dealt with this, any help would be greatly
> appreciated.
> 
> thanks, joe
> 
> -- 
> Joe Testa  http://www.oracle-dba.com
> No you can't fix an ORA-600 error, call Oracle Support.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Joseph S. Testa
>   INET: teci_at_oracle-dba.com
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Tue Dec 19 2000 - 14:10:14 CST

Original text of this message

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