Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> LRM-00109 and ORA-01078 while starting up database remote
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.comReceived on Tue Apr 09 2002 - 07:08:57 CDT