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

Home -> Community -> Usenet -> c.d.o.server -> LRM-00109 and ORA-01078 while starting up database remote

LRM-00109 and ORA-01078 while starting up database remote

From: P. van der Ven <google_at_pven.tmfweb.nl>
Date: 9 Apr 2002 05:08:57 -0700
Message-ID: <39bfb0cd.0204090408.19a8674b@posting.google.com>


Hi!

I am using SQL*plus to do 'connect internal' while working on a client; this is useful so I don't have to go to the server every time I need to change something. Shutting down the database remote is working without problems, but starting up remote is not working.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
LRM-00109: could not open parameter file
'%ORACLE_HOME%\DATABASE\INIT%ORACLE_SID%.ORA'
ORA-01078: failure in processing system parameters SQL> startup pfile=d:\services\orabase\admin\lgtb\pfile\initlgtb.ora LRM-00109: could not open parameter file
'd:\services\orabase\admin\lgtb\pfile\initlgtb.ora'
ORA-01078: failure in processing system parameters SQL> While starting SQL*plus the SID on the client is set to LGTB; the SID on the server is not set. Oracle_home on the server is also set. The pfile is in d:\services\orabase\admin\lgtb\pfile\initlgtb.ora on the server. I also tried to use the network-path, but that is showing the same rrors.
In %ORACLE_HOME%\database I created initgtb.ora with one ifile-line in it that is pointing to
d:\services\orabase\admin\lgtb\pfile\initlgtb.ora.

Can anyone tell me what I forget? TIA!

Met vriendelijke groet / Regards,
P. van der Ven

---
http://contact.pven.com
Received on Tue Apr 09 2002 - 07:08:57 CDT

Original text of this message

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