Re: Setting up OS authentication

From: <yeungj16_at_gmail.com>
Date: Thu, 21 May 2009 11:35:27 -0700 (PDT)
Message-ID: <f0b1b1a2-48e4-46a7-9f99-613586b728cb_at_y7g2000yqa.googlegroups.com>



On May 21, 2:15 pm, ddf <orat..._at_msn.com> wrote:
> On May 21, 12:38 pm, yeung..._at_gmail.com wrote:
>
>
>
>
>
> > Hi,
>
> > I'm trying to setup Oracle 10g to use OS authentication but are
> > getting the following errors.
>
> > SQL*Loader-951: Error calling once/load initialization
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-01738: missing IN keyword
>
> > Oracle IDs are working fine it's just when I use OS authentication.  I
> > tried googling this but the solution is to "Place the keyword IN and
> > lock mode directly after the table name in the LOCK TABLE statement
> > and retry the statement."  Not sure where to put it in the test case
> > below.
>
> > Below is the simple Oracle test case I used.
>
> > Thanks,
>
> > Create test table:
>
> > create table test (i number, s varchar2(3));
>
> > Control file:
>
> > OPTIONS (DIRECT=TRUE)
> > LOAD DATA
> > INFILE test.dat
> > APPEND
> > INTO TABLE test
> > FIELDS TERMINATED BY "|"
> > (i, s)
>
> > Data file:
>
> > 1|foo
> > 2|bar
> > 3|baz
>
> Can you connect to the database through sqlplus using OS
> authentication?  What is your os_authent_prefix and how is
> remote_os_authent set?  You should be able to:
>
> SQL> connect /
>
> and successfully login to your Oracle database provided the currently
> connected OS user is valid in this Oracle database.
>
> Until we know how you've set  your OS authentication parameters it's
> difficult to say what may be the issue.
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

Thanks for the reply.

My OS_AUTHENT_PREFIX is OPS$ and yes I'm able to connect successfully with sqlplus /
My REMOTE_OS_AUTHENT is set to TRUE.

Thanks again. Received on Thu May 21 2009 - 13:35:27 CDT

Original text of this message