Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-07318: smsget: open error when opening sgadef.dbf file

ORA-07318: smsget: open error when opening sgadef.dbf file

From: <chowg_at_spawar.navy.mil>
Date: 1997/10/02
Message-ID: <875820842.12827@dejanews.com>#1/1

I'm having a problem logging in remotely to an Oracle database. When I try to login using SQL*Plus I get the following error:

  ERROR: ORA-01034: ORACLE not available   ORA-07318: smsget: open error when opening sgadef.dbf file.   HP-UX Error: 2: No such file or directory

Also, when starting the listener on the server, I also notice the following message:

  Connecting to (ADDRESS=(PROTOCOL=TCP ...   smux connect failure: Connection refused

I am however, able to get a response when I PING and TNSPING the Oracle server and I have no problems connecting to the database (or a remote one) from the server itself. Any help would be greatly appreciated.

Regards, Glen Chow

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Thu Oct 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US