[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-sqlplus-l
Subject:    Re: entries required in listener.ora/sqlnet.ora and tnsnames when
From:       epierce () surewest ! net
Date:       2004-12-22 20:10:33
Message-ID: F001.005F0D6F.20041222121033 () fatcity ! com
[Download RAW message or body]

I had a TAR open with Oracle tech support over Net8 issues on Win2K 
server (database was built w/ Oracle's wizard). After I had spent days 
reading tons of Net8 documentation (mostly worthless), an unusually 
helpful guy at Oracle tech support told me to change some fairly obsure 
(to me) entry in the automatically generated Net8 configuration files, and 
everything worked fine, in the tnsnames.ora file:

  replace "service_name =" syntax with "SID ="

The tech support guy explained some Net8 internals that to be frank, went 
right over my head, about the difference between "service_name =" and 
"SID =", so in your context this issue may not apply.

Several months prior to that I had problems that were fixed by replacing 
the cabling that connects the server to the network.

On 22 Dec 2004 at 6:31, Kamal Mutneja wrote:

> I have created a database manually on windows 2000 . It has been created but
> giving errors like 12560 . Pls advise what all antires are required in
> listener and sqlnet.ora bcoz tnsnames seems to be ok .
...

Desktop 2005 - You're Virtually There! February 15-17, 2005
Visit http://www.odtug.com for details. Computer + internet required.
Keynote Speakers: Bill Inmon, Sohaib Abbasi and Thomas Kurian.
-- 
Author: 
  INET: epierce@surewest.net

Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-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).
[prev in list] [next in list] [prev in thread] [next in thread]