Re: init.ora file

newsgroup list trimmed.

log in as sysdba or system
run show parameter spfile at the prompt. If there is a value returned then you are using an spfile and not the init.ora (most likely if you used dbca). If you are using the spfile you will need to use the alter system command to update the spfile with the new values for these parameters.

If there is no value then you are using an init.ora and you need to find out which one. To do this type show parameter pfile at the sqlplus prompt.

Almost certainly the file you edited was the wrong one.

Niall
"hiroko" <bentenkids_at_yahoo.com> wrote in message news:5265c4f2.0311260348.62fe396b_at_posting.google.com...
> Hi, I am studying Oracle Database Administration.
>
> When I was setting automatic archivelog mode, I noticed I had trouble
> setting up init.ora file.
>
> I am using Oracle9 on Win2k.
>
> I modified init.ora file by adding;
> log_archive_start=true
> log_archive_dest=%Oracle%\admin\%SID%\arch
> log_archive_format=archorc_%s.log.
> Then, I shutdown, startup mount, alter database archivelog, alter
> database open.
> When I run alter system switch logfile for 3 times (I have 3 Redolog
> files), SQLPLUS hang.
> When I checked the book I had (OCP text book), it says this occurs
> when init.ora is not modified but alter database archivelog is run.
>
> So init.ora that was located on %Oracle%\admin\%SID%\spfile\ is not
> affecting database.
>
> Init.ora file for this database has a numeric extension like
> init.ora.10020039830 and so Window Explorer displayed file type as
> 10020039830.file (it wasn't read as Ora file.) I am not sure if this
> is the reason.
> Why this init.ora file has numeric extension? How can I make this
> file to be effective?
>
> Any helps or advices to solve this is appreciated.
>
> hiroko
Received on Wed Nov 26 2003 - 07:33:08 CST