Re: Problem finding sgadef.dbf on HPUX

You don't want the sgadef.dbf file from another database. Each sgadef.dbf is tied to
as specific database. Remove the copied file and try re-starting the database. If
this does not work, shutdown the database and then re-start.

Terry Ball
Sr. DBA, CSG Systems

dongmei_cao_at_yahoo.com wrote:

> Hello,
>
> My oracle7 was working just fine yesterday. But this morning
> when I tried to log on to sqlplus, it gives the following
> error messages:
>
> ORA-01304: ORACLE not available
> ORA-07318: smsget: open error when opening sgadef.dbf file.
> HP-UX Error: 2: No such file or directory
>
> I have looked up the ${ORACLE_HOME}/dbs directory. There is no
> file called sgadef.dbf. So, I copied one from another HPUX
> machine. But it didn't work at all. I am new to oracle database.
> I have spent several hours to look up the manuals. But I still
> don't have a clue. If someone out there knows what's wrong,
> please let me know. Any help will be greatly appriciated.
>
> Thanks,
> Dongmei Cao
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Jan 22 1999 - 09:18:37 CST