Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus works, isqlplus gives ora-27101
On Mon, 12 Jul 2004 20:24:19 -0700, Daniel Morgan wrote:
> E wrote: >
> > Changes to init.ora are meaningless unless compiled into the spfile. > http://www.psoug.org/reference/library.html > and search for SPFile
Thanks for your response. I did that and it doesn't seem to have
had any affect:
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile from pfile='initORCL.ora';
SQL> show parameter spfile
NAME TYPE VALUE
--------- ------- ------------------------------spfile string /usr/local/oracle/product/10.1.0/db_1/dbs/spfileORCL.ora
SQL> startup
ORACLE instance started.
Total System Global Area 96468992 bytes
Fixed Size 777576 bytes Variable Size 95429272 bytes Database Buffers 0 bytes Redo Buffers 262144 bytesDatabase mounted.
Any other pointers are greatly appreciated! Eric Received on Mon Jul 12 2004 - 23:05:53 CDT