Re: Oracle 7.1.4 problem with TWO_TASK

Setting REMOTE_OS_AUTHENT to TRUE should be done only with extreme care. Setting it to true means that the database will trust that the username passed by the client over SQL*Net is valid.

My guess, without additional information, is that the SQL*Net listener is not up or that TWO_TASK is pointing to an address which no longer exists. Your DBA will have to determine what the problem is.

                                Rick
                                Rick Wessman
                                Network Management Products
                                Server Techologies
                                Oracle Corporation
                                rwessman_at_us.oracle.com

In article <3l51a4$53b_at_deagol.pad.otc.com.au> hup_at_nms.otc.com.au (Peng Hu) writes:

>Path: dcsun4.us.oracle.com!gatekeeper.us.oracle.com!decwrl!pa.dec.com!decuac.dec.com!haven.umd.edu!news.umbc.edu!europa.chnt.gtegsc.com!howland.reston.ans.net!agate!msunews!harbinger.cc.monash.edu.au!news.uwa.edu.au!nodecg.ncc.telecomwa.oz.au!netbsd08.dn.itg.telecom.com.au!orca1.vic.design.telecom.com.au!news.tansu.com.au!otcgpo.isg.otc.com.au!tbird2.pad.otc.com.au!deagol.pad.otc.com.au!not-for-mail
>From: hup_at_nms.otc.com.au (Peng Hu)
>Newsgroups: comp.databases.oracle
>Date: 27 Mar 1995 10:36:20 +1000
>Organization: Telstra, Network Management Systems, Paddington, Australia
>Lines: 38
>References: <3kff1o$eji_at_newsbf02.news.aol.com>
>NNTP-Posting-Host: deagol.pad.otc.com.au
>X-Newsreader: NN version 6.5.0 #2 (NOV)
>
>danielkm_at_aol.com (Daniel K M) writes:
>
>>Our DBA recently upgraded our Oracle version to 7.1.4, and ever since,
>>I've been having to set the TWO_TASK environment variable to null in order
>>to run SQL*ReportWriter of SQL*plus. I know this turns off the
>>multi-threaded server, but why won't these tools come up properly with the
>>multi-threading turned on? BTW, we use SCO Unix.
 

>>I'd ask our DBA, but he's in meetings all the time...
>
>
>The upgrade has obviously changed the customised INIT.ORA file originally
>used by the users.
>
>Set the following parameter
>
> REMOTE_OS_AUTHENT = TRUE
>
>and this will fix your TWO_TASK problem.
>
>Regards.
>
>
>Peng Hu
>Database Consultant
> -------------------------------------------------------------------------
>| International Network Systems | Mid Range Group |
>| Telstra OTC Australia | IBM Australia |
>| 363 Oxford Street | PO Box 400 |
>| Paddington, NSW 2012 | Pennant Hills, NSW 2120 |
>| Australia | Australia |
>| Tel: +61-2-3393886 | Tel: +61-2-3547749 |
>| Fax: +61-2-3393985 | Fax: +61-2-3547766 |
>|-------------------------------------------------------------------------|
>| Email: Peng.Hu_at_pad.otc.com.au |
>| Pager: 016 020 quoting 267 675 |
> -------------------------------------------------------------------------
>
Received on Tue Mar 28 1995 - 17:08:59 CEST