Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01031

Re: ORA-01031

From: Robbert van der Hoorn <reply_at_forum.only>
Date: Thu, 28 Sep 2006 11:02:42 +0200
Message-ID: <451b8fbb$0$4517$e4fe514c@news.xs4all.nl>


See below (don't TOP POST please)
"calms" <calmsqurill_at_gmail.com> schreef in bericht news:1159432617.293840.127680_at_m7g2000cwm.googlegroups.com...
> Thanks for your Information. Finally i manged to run the application.
> But still have one last issue.
> I can run the applicaiton only when i logon as domain administrator. If
> i logon as Domain user who have administrator privilege, i get the
> ORA-01031.
>
> Plz help me to solve this.
>
> thks
>
>
> DA Morgan wrote:
>> calms wrote:
>> > hi Daniel Morgan,
>> >
>> > 1. SQL*Plus succeeds.
>> > 2. In the client machine i dont have any environment variable as
>> > ORACLE_SID.
>> > In the Server, In the "Init.ora" file, parameter db_name = FLAgDB.
>> > 3. ORACLE_HOME = c:\instantclient10_1
>> >
>> > Thks a lot for your advice...
>> > thks
>> > Prasad
>>
>> init.ora is irrelevant. What matters is tnsnames.ora.
>>
>> PS: Most Oracle installations no longer use an init.ora ... they
>> use, instead, the spfile which you can not edit directly.
>> --
>> Daniel Morgan
>> University of Washington
>> Puget Sound Oracle Users Group
>

Reminds me of a problem seen before: looks like some temp-file is created in a directory you do not have access to, like C:\ (root). OR: some config points to the administrators local settings directory, which you may not be able to read/write as an other user. Try using some file monitoring utility to see what happens. Received on Thu Sep 28 2006 - 04:02:42 CDT

Original text of this message

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