Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Incorporating Oracle start/stop script into SMF

9 views
Skip to first unread message

SunnyDays

unread,
Nov 18, 2009, 5:55:33 AM11/18/09
to
Hi Gurus

I have a question about incorporating startup and shutdown of multiple
oracle instances into SMF. Is there a straight forward way of doing
this and is there some sort of template available to do this?

I have taken a look at ora-smf.1.5.1.pkg and it des look like the sort
of tool I need, but i am unsure how to implement it for multiple
oracle instances on the same box.

Has anybody done this and is there any information on implementing
this package on multiple oracle instances.

much appreciated and thanks in advance.

rgds
dean

John D Groenveld

unread,
Nov 18, 2009, 10:16:15 AM11/18/09
to
In article <3558fc5f-e968-4310...@j24g2000yqa.googlegroups.com>,

SunnyDays <trian...@googlemail.com> wrote:
>I have a question about incorporating startup and shutdown of multiple
>oracle instances into SMF. Is there a straight forward way of doing
>this and is there some sort of template available to do this?

Your SMF bits can invoke dbstart and dbstop scripts in ORACLE_HOME.
su - oracle -c "ksh $ORACLE_HOME/bin/dbstart"

dbstart and dbstop will parse /var/opt/oracle/oratab to handle
multiple instances.

John
groe...@acm.org

0 new messages