Re: 10G - editing SPFILE

From: Hans Forbrich <news.hans_at_telus.net>
Date: Thu, 21 Oct 2004 17:55:07 GMT
Message-ID: <%JSdd.23666$_u6.17579@edtnps89>

Charlie Edwards wrote:

> *****************************************************************
> 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
>
> *****************************************************************

(The general assumption is that you are using the OS userid that 'owns' the Oracle software, or at least is part of the 'dba' group, on the machine where the database is installed.)

Your example implies that you are using Windows, in which case try:

on the Windows machine which has Oracle database installed
call up the SQL Plus usually using something like Start >> Programs >> "Oracle - xxx" (<< Oracle Home) >> Application Development >> SQL Plus and enter /NOLOG in the username, leaving password and host blank.
that should put you into SQLPlus where you can pick up with the "connect"

HTH
/Hans Received on Thu Oct 21 2004 - 12:55:07 CDT