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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Error DBA-0320: cannot open sqldba configuration file <filename>

Re: Error DBA-0320: cannot open sqldba configuration file <filename>

From: Peter Wales <paw_at_bulmer.com>
Date: 1997/03/05
Message-ID: <331D495E.738@bulmer.com>#1/1

<HTML><BODY>

Dalton M. de Andrade wrote:&nbsp;

<BLOCKQUOTE TYPE=CITE>On Sat, 01 Mar 1997 01:25:24 -0500, oracle &lt;oracle_at_nightmare.com&gt;
<BR>wrote:
<BR>
<BR><I>&gt;</I>
<BR><I>&gt;------------174C66B36B60</I>
<BR><I>&gt;Content-Transfer-Encoding: 7bit</I>
<BR><I>&gt;Content-Type: text/plain; charset=us-ascii</I>
<BR><I>&gt;</I>
<BR><I>&gt;Dalton M. de Andrade wrote:</I>
<BR><I>&gt;&gt;</I>
<BR><I>&gt;&gt; Everytime I try to start SQLDBA in full screen mode I receive

the</I>

<BR><I>&gt;&gt; follwoing error message:</I>
<BR><I>&gt;&gt;</I>
<BR><I>&gt;&gt; DBA-0320: cannot open sqldba configuration file /home/oracle/7.1.4/</I>
<BR><I>&gt;&gt;</I>
<BR><I>&gt;&gt; Due to the witdh of the screen and the length of the path,
the actual</I>
<BR><I>&gt;&gt; name of the configuration file is ommitted from the message.</I>
<BR><I>&gt;&gt;</I>
<BR><I>&gt;&gt; Anyone knows the actual name of the SQLDBA confiuration file?</I>
<BR><I>&gt;&gt;</I>
<BR><I>&gt;&gt; Any help would be appreciated.</I>
<BR><I>&gt;</I>
<BR><I>&gt;It is looking for either /home/oracle/7.1.4/dbs/init&lt;sid&gt;.ora
or</I>
<BR><I>&gt;/home/oracle/7.1.4/dbs/config&lt;sid&gt;.ora.</I>
<BR><I>&gt;</I>
<BR><I>&gt;Where &lt;sid&gt; is the value of ORACLE_SID.</I>
<BR><I>&gt;</I>
<BR><I>&gt;</I>
<BR><I>&gt;</I>
<BR><I>&gt;------------174C66B36B60</I>
<BR><I>&gt;Content-Transfer-Encoding: 7bit</I>
<BR><I>&gt;Content-Type: text/html; charset=us-ascii</I>
<BR><I>&gt;</I>
<BR><I>&gt;&lt;HTML&gt;&lt;BODY&gt;</I>
<BR><I>&gt;</I>
<BR><I>&gt;&lt;DT&gt;Dalton M. de Andrade wrote:&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt;&amp;nbsp;&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt; Everytime I try to start SQLDBA in full screen mode I receive
the&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt; follwoing error message:&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt;&amp;nbsp;&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt; DBA-0320: cannot open sqldba configuration file /home/oracle/7.1.4/&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt;&amp;nbsp;&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt; Due to the witdh of the screen and the length of the path,
the actual&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt; name of the configuration file is ommitted from the message.&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt;&amp;nbsp;&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt; Anyone knows the actual name of the SQLDBA confiuration
file?&lt;BR&gt;</I>

<BR><I>&gt;&amp;gt;&amp;nbsp;&lt;BR&gt;</I>
<BR><I>&gt;&amp;gt; Any help would be appreciated.&lt;BR&gt;</I>
<BR><I>&gt;&amp;nbsp;&lt;/DT&gt;</I>
<BR><I>&gt;</I>
<BR><I>&gt;&lt;DT&gt;It is looking for either /home/oracle/7.1.4/dbs/init&amp;lt;sid&amp;gt;.ora</I>
<BR><I>&gt;or /home/oracle/7.1.4/dbs/config&amp;lt;sid&amp;gt;.ora.&lt;/DT&gt;</I>
<BR><I>&gt;</I>
<BR><I>&gt;&lt;DT&gt;&amp;nbsp;&lt;/DT&gt;</I>
<BR><I>&gt;</I>
<BR><I>&gt;&lt;DT&gt;Where &amp;lt;sid&amp;gt; is the value of ORACLE_SID.&lt;/DT&gt;</I>
<BR><I>&gt;</I>
<BR><I>&gt;&lt;DT&gt;&amp;nbsp;&lt;/DT&gt;</I>
<BR><I>&gt;</I>
<BR><I>&gt;&lt;DT&gt;&amp;nbsp;&lt;/DT&gt;</I>
<BR><I>&gt;</I>
<BR><I>&gt;&lt;/BODY&gt;</I>
<BR><I>&gt;&lt;/HTML&gt;</I>
<BR><I>&gt;------------174C66B36B60--</I>
<BR><I>&gt;</I>
<BR>
<BR>Checked and the files are there and it is still not working.
</BLOCKQUOTE>

Try starting sqldba with&nbsp;
<BR>
<BR>sqldba lmode=y
<BR>
<BR>this should allow you to see the message more easily.
<BR>
<BR>Peter.
<BR>
<BR>--&nbsp;
<BR>+---------------------------------------------------------------+&nbsp;
<BR>| Peter Wales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|&nbsp;
 <BR>| IT Operational Services&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;
<BR>| HP Bulmer Ltd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&quot;The Worlds Largest Cider Maker&quot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;
<BR>| <A HREF="MailTo:PAW_at_bulmer.com">MailTo:PAW_at_bulmer.com</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<A HREF="http://www.bulmer.com">http://www.bulmer.com</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;
<BR>+---------------------------------------------------------------+&nbsp;
<BR>

</BODY>
</HTML>
Received on Wed Mar 05 1997 - 00:00:00 CST

Original text of this message

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