Re: Redo log files are there, why I can not start the database?

"Wendy Chin" <wchin_at_corewest.com> writes:

>I'm a new DBA in NT4.0 and Oracle 8.03. I got an alert message saying, "can
>not find archive log file". Accidentally, NT server and Oracle server are
>restarted.... Anyway, I got the following message:
>ORA-01034;ORACLE not availabe
>ORA-09243; smsget; error attaching to SGA;
>OSD-04101; invalid SGA; SGA not initialized
>my questions are
>1) How can I get my database up running?

Make sure your service is running (probably is) - check OracleServiceSID. This means you have an instance, but not necessarily a database started. Go into server manager, connect internal, and "startup", to start the database.

>2) What cause the database not be able to find the archivelog file?

Make sure the directory the archived logs are being written to exists. This will be the value of the "log_archive_dest" paramater in init.ora.ora.

>3) Why redo log files are not used, they are there in the directory and not
>lost?

Is it the redo logs or archived redo logs that are missing? You might want to startup the database mount, and check v$logfile to find out what files the database is looking for, and make sure these exist.

>4)Why I can not run server manager? got an error of ORA -12203 TNS:unable to
>connect to destination when login as system/manager

Most likely because the database is not started. See 1.

--

Nathan D. Hughes <nhughes_at_well.com>
Senior Consultant, Custom Business Solutions, Inc.