Re: 10G - editing SPFILE

From: Charlie Edwards <charlie3101_at_hotmail.com>
Date: 21 Oct 2004 10:24:52 -0700
Message-ID: <217ac5a8.0410210924.2ce898b7@posting.google.com>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4176d09a$0$22901$afc38c87_at_news.optusnet.com.au>...
>
>
> At the command prompt, you'd type:
>
> sqlplus /nolog
> connect / as sysdba
> create pfile from spfile;
>
> (And that last command needs no instance running to work).
>

Howard,
Thanks for your help

Unfortunately I got this:

---

C:\DOCUME~1\CE>sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Thu Oct 21 18:18:23 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

---

Have you got any ideas? I haven't bothered with the TNS listener as I'm only ever going to connect locally. If I startup the TNS listener I get the same error?

I'm not a DBA (I haven't been since Oracle v5 and I was rubbish then!) but I can't help feeling a bit stupid. I know 10g isn't certificated on XP home, BTW, I just want to play around.

Thanks

CE Received on Thu Oct 21 2004 - 12:24:52 CDT