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: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 27 Sep 2006 10:11:27 -0700
Message-ID: <1159377088.56814@bubbleator.drizzle.com>


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
Received on Wed Sep 27 2006 - 12:11:27 CDT

Original text of this message

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