Re: SGA Errors...

Did the NT service start..Is the listener running?

If the service started did you attempt startup the instance ( after connecting internal ( or as sys/pass as sysdba ) ?

From a command prompt
svrmgrl ( or SqlPlus )
If no error messages at this point:
connect sys as sysdba ( or connect internal ) - note no tnsnames.ora alias at this time .. ( if prompted enter password)
If no errors then:
startup pfile=( whatever you r init<sid>.ora path is)

BTW, version info is often handy...

"Jennmar Corp" <here_at_work.com> wrote:

>This morning we were running an import into our test environment when the
>import errored out.
>
>A trace file was written that included the following error message:
>Fri Apr 05 07:58:44 2002
>
>*** SESSION ID:(14.549) 2002.04.05.07.58.44.546
>kgefec: fatal error 0
>Fri Apr 05 07:58:44 2002
>ksedmp: internal or fatal error
>ORA-00603: ORACLE server session terminated by fatal error
>ORA-00449: background process 'LGWR' unexpectedly terminated with error 204
>ORA-00204: error in reading (block , # blocks ) of controlfile
>ORA-00470: LGWR process terminated with error
>Current SQL statement for this session:
>INSERT /*+NESTED_TABLE_SET_REFS+*/ INTO "..........etc."
>
>After rebooting the Server and trying to log onto SQL, we received the
>following errors:
>ORA-01034: ORACLE not available
>ORA-09243: smsget: error attaching to SGA
>OSD-04101: invalid SGA: SGA not initialized.
>
>Our first step was to restore from out NT backup the ORANT directory and the
>Database drive to insure that the control files and the database were in
>sync.
>The database backup was from last night and there were no problems this
>morning before starting the import.
>
>The restore of these directories did not resolve the problem.
>When we try to log onto SQL we are still getting the above three errors
>about the SGA.
>
>What steps should we take to bring Oracle back up?
>What would have caused the SGA error and why didn't a restore from the
>backup resolve any problems caused by the import?
>
>Thanks in advance for any help!
>
Received on Fri Apr 05 2002 - 11:42:12 CST