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

On 9 Apr 2002 05:08:57 -0700, google_at_pven.tmfweb.nl (P. van der Ven) wrote:

>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

The pfile is on the server. If you don't have a network drive to the server's drive, you'll never succeed as your sql*plus session runs locally.
There is no other option than to copy the pfile. I would strongly urge you to use OEM, as OEM has mechanism to manage this situation and sql*plus simply doesn't have those.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 09 2002 - 11:18:38 CDT