Re: ORA-01034: ORACLE not available

From: <dponeleaf_at_my-deja.com>
Date: Wed, 01 Dec 1999 13:45:04 GMT
Message-ID: <8238ov$agq$1@nnrp1.deja.com>

Toni,

Thanks for taking the time to respond to my post. Below are the contents of my listener.ora file, and much to my dismay, everything appears to be in order.

I also copied the output of 'ps -ef' and it plainly shows that _<SID> instances are indeed running, along with tnslsnr. I did try your tnsping suggestion, and I did get a "TNS: no listener" error, but as soon as I changed the port from 1526 to 1521, I then got an expected "OK (40 msec)" response.

This is most frustrating! One thing I have yet to find in the volumes of Oracle documentation is a standard startup procedure "checklist" which IMHO would be incredibly valuable.

Kindest regards,
Dave Palmer

• listener.ora file --------------------------- # # Installation Generated Net8 Configuration # Version Date: Jun-17-97 # Filename: Listener.ora # LISTENER =(ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= LEAF)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL=TCP)(Host=e250a)(Port= 1521))) SID_LIST_LISTENER = (SID_LIST = (SID_DESC =
  (GLOBAL_DBNAME= e250a)
  (ORACLE_HOME= /local/oracle/)
  (SID_NAME = LEAF)
  ) (SID_DESC =
  (SID_NAME = extproc)
  (ORACLE_HOME = /local/oracle/)
  (PROGRAM = extproc)
  ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = support

  ---

• relevant output from: ps -ef ----------------

oracle 349 1 0 Nov 19 ? 0:01 /local/oracle/bin/tnslsnr LISTENER -inherit

oracle   400     1  0   Nov 19 ?        0:00 /local/oracle/bin/cmgw
dbauser   532     1  0   Nov 19 ?        0:00 ora_reco_LEAF
oracle   370     1  0   Nov 19 ?        0:00 /local/oracle/bin/names
names.ctlstart=yes
dbauser   530     1  0   Nov 19 ?        0:01 ora_smon_LEAF
dbauser   522     1  0   Nov 19 ?        0:00 ora_pmon_LEAF
dbauser   524     1  0   Nov 19 ?        0:00 ora_dbw0_LEAF
dbauser   526     1  0   Nov 19 ?        0:00 ora_lgwr_LEAF
dbauser   528     1  1   Nov 19 ?       126:11 ora_ckpt_LEAF
oracle   398     1  0   Nov 19 ?        0:14 /local/oracle/bin/cmadmin
------------------------------------------------------

In article <301119991435089713%dischner_at_klch.med.uni-muenchen.de>,   Anton Dischner <dischner_at_klch.med.uni-muenchen.de> wrote:

> [[ This message was both posted and mailed: see
>    the "To," "Cc," and "Newsgroups" headers for details. ]]
>
> Hi,
>
> did you double-check your
>
> listener.ora for
>
> ORACLE_HOME= /oracle/product/....
> SID_NAME = LEAF
>
> BTW. ORACLE_HOME must not point to a soft-link
>
> Just an idea,
>
> kind regards,
>
> Toni
>
> tnsping is OK ? hmmm :-|
> Try tnsping
'(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=<yourhost>)
>        (Port=1526))'
>
> Do not forget the surrounding '' otherwise the shell mock up.

>
> In article <8147gf$3t5$1_at_nnrp1.deja.com>, <dponeleaf_at_my-deja.com> wrote:

>
> > Hello,
> > I have Oracle8 running on a Solaris box. I am plagued by this 01034
> > error message. I've read through all of the posts regarding this

issue

> > and have not found a resolution.
> >
> >
> > Regards,
> > Dave Palmer
> >
> >
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 01 1999 - 07:45:04 CST