Re: Error ORA-01031

From: joel garry <joel-garry_at_home.com>
Date: 25 Sep 2006 15:14:57 -0700
Message-ID: <1159222497.904928.172660@m73g2000cwd.googlegroups.com>

calms wrote:
> Hi All,
>
> I Installed Oracle Instant Client as instructed by ORACLE in the
> following link,
>
> "http://www.oracle.com/technology/tech/oci/instantclient/index.html"
>
> I Installed only the BASIC & ODBC, so i dont have SQL installed in my
> client workstation.

It's listed as one of the optional packages on that link. Why don't you try it?

>
> I set the Environment Variables
> PATH, TNS_ADMIN, ORACLE_HOME to the appropriate Folders.
>
> If you need any further information kindly let me know,

Does your application attempt to change the user?

01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password

//         without the appropriate privilege. This error also occurs if
//         attempting to install a database without the necessary
operating
//         system privileges.
//         When Trusted Oracle is configure in DBMS MAC, this error may
occur
//         if the user was granted the necessary privilege at a higher
label
//         than the current login.

// *Action: Ask the database administrator to perform the operation or grant

//          the required privileges.
//          For Trusted Oracle users getting this error although
granted the
//          the appropriate privilege at a higher label, ask the
database
//          administrator to regrant the privilege at the appropriate

label.

jg

--
@home.com is bogus.
V: The only verdict is vengeance; a vendetta, held as a votive, not in
vain, for the value and veracity of such shall one day vindicate the
vigilant and the virtuous.
[giggles]
V: Verily, this vichyssoise of verbiage veers most verbose, so let me
simply add that it's my very good honor to meet you and you may call me
V.
Evey Hammond: Are you like a crazy person?
V: I am quite sure they will say so.

Received on Mon Sep 25 2006 - 17:14:57 CDT