Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01031
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 GroupReceived on Wed Sep 27 2006 - 12:11:27 CDT
![]() |
![]() |