Re: Oracle 9.2 on Solaris.

spam.sink_at_volcanomail.com wrote:
> Thanks for your guidence. I will apply that knowledge and see how
> things go.
> Perhaps I should have phrased that message differently..
> It should have read most books in my local bookshop are Windows
> centric.
> I did not mean answerbook type books..
>
> Thanks.
>
> Regan.

Here is what I get from a test system. I did basically a " ps -ef | grep knora " and got back a list of unix processes running that belong to this database instance.

• This system gets restored from an EMC BCV everynight then restarted at just after midnight that's what the 00:35 column means ... oracle has been running since then.

  oracle 29507     1  0 00:35:02 ?         0:13 ora_pmon_knora1
  oracle 29515     1  0 00:35:05 ?         0:54 ora_lms0_knora1
  oracle 29519     1  0 00:35:05 ?         0:04 ora_dbw0_knora1
  oracle 29527     1  0 00:35:06 ?         0:00 ora_reco_knora1
  oracle 29513     1  0 00:35:02 ?         1:30 ora_lmd0_knora1
  oracle 29523     1  0 00:35:05 ?         0:22 ora_ckpt_knora1
  oracle 29517     1  0 00:35:05 ?         0:49 ora_lms1_knora1
  oracle 29531     1  0 00:35:06 ?         0:14 ora_qmn0_knora1
  oracle 29533     1  0 00:35:06 ?         0:00 ora_arc0_knora1
  oracle 29521     1  0 00:35:05 ?         0:09 ora_lgwr_knora1
  oracle 29535     1  0 00:35:06 ?         0:00 ora_arc1_knora1
  oracle 29509     1  0 00:35:02 ?         1:37 ora_diag_knora1
  oracle 29511     1  0 00:35:02 ?         1:19 ora_lmon_knora1
  oracle 29538     1  0 00:35:07 ?         0:11 ora_lck0_knora1
  oracle 29529     1  0 00:35:06 ?         0:13 ora_cjq0_knora1
  oracle 29525     1  0 00:35:06 ?         0:06 ora_smon_knora1

Before you try to connect into oracle you want to know if you have any thing running.

If you see things running ... check the setting of your ORACLE_SID and other things like your PATH variable so see if you are prepared to connect.

What do your results of a "ps -ef" return you? Received on Wed Aug 24 2005 - 18:30:48 CDT