ORACLE Server not available

From: Stephen Miller <stepmil_at_ibm.net>
Date: 1997/05/25
Message-ID: <33888a3c.295990@news-s01.ny.us.ibm.net>#1/1

Environment: UNIX AIX 4.2

ORACLE 7.2.3 Whenever I attempt to access ORACLE I get the following errors:

  +---------------------------------------------------------------------+


  | sqldba mode=line                                                    |

  |                                                                     |

  | SQL*DBA: Release 7.2.3.0.0 - Production on Sun May 25 18:38:46 1997 |

  |                                                                     |

  | Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.  |

  |                                                                     |

  | Oracle7 Server Release 7.2.3.0.0 - Production Release               |

  | With the distributed and parallel query options                     |

  | PL/SQL Release 2.2.3.0.0 - Production                               |

  |                                                                     |

  | SQLDBA> connect internal                                            |

  | Connected.                                                          |

  | SQLDBA> shutdown immediate                                          |

  | DBA-00342: unable to complete internal login                        |

  | ORA-01034: ORACLE not available                                     |

  | ORA-07320: smsget: shmat error when trying to attach sga.           |

  | IBM AIX RISC System/6000 Error: 13: Permission denied               |

  | SQLDBA>                                                             |

  +---------------------------------------------------------------------+

It looks like my SGA has somehow gotten corrupted, but I am unable to shutdown the database. Short of a KILLing the processes, how can I bring down and restart this instance? And what is the significance of the UNIX errors?

Stephen Miller
ISM, Montreal Received on Sun May 25 1997 - 00:00:00 CDT