Re: Urgent DBA Assistance needed

Hi!
It's a nonsense! sgadef.dbf is a file which is used to map SGA (through mmap) to a disk file. It is recreated each time instance is restarted. If you are missing sgadef.dbf, you should restart your database. Kindest regards!
On Feb 19, 9:31am, Duraikannu Rudra Murthy wrote:
> Subject: Re: Urgent DBA Assistance needed
> Hi Chris,
>
> Somebody must have deleted the db file sgadef.dbf. Restore that file
> from the system backup and try starting again. It'll be ok.
>
> Regards,
> Rudramurthy.
>
> >From owner-oracle-l_at_CCVM.SUNYSB.EDU Mon Feb 19 08:19 GMT 1996
> >Date: Sun, 18 Feb 1996 21:23:26 EST
> >Reply-To: "ORACLE database mailing list." <ORACLE-L_at_ccvm.sunysb.edu>
> >From: Chris McDevitt <mcdevitt_at_ISC.UPENN.EDU>
> >Subject: Urgent DBA Assistance needed
> >X-To: oracle-l_at_ccvm.sunysb.edu
> >X-Cc: Christine McDevitt <mcdevitt_at_nextb.dccs.upenn.edu>
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_ccvm.sunysb.edu>
> >Content-Type: text
> >
> >Our db is down and we get the following error:
> >
> >ORA-07318: smsget:open error when opening sgadef.dbf file
> >HP UX Error: 2 : No such file or directory
> >
> >I'm trying to locate our DBA, but thought I'd try the list
> >in the meantime. Any help is much appreciated.
> >
> >Chris
> >
> >Programmer/Analyst
> >NJCIP, Univ Of Penn
> >
>-- End of excerpt from Duraikannu Rudra Murthy

--
Mladen Gogala
ASTER Ljubljana

Tel  : ++386 61 1683-511                 Snail-mail:
FAX  : ++386 61 1683-165                 ASTER Ljubljana
Email: gogi_at_aster.si                     Nade Ovcakove 1
WWW  : www.aster.si                      61000 Ljubljana
                                         Slovenia