Re: Customised message while connecting to a database...

I am not sure on the intent of the original poster, but I COULD use this (but I wont). I run an nt oracle server, and an application server (metaframe). All my users connect to the db server via the metaframe server. I have been looking for a way to *notify* users via the metaframe server if the DB server is down for some reason (maintenance, prod fixes etc). In the past, I typically send an email to the users stating the the system will be unavailable but it would not necessarily stop people from trying to log on (thus a million support calls). I can always log on in restricted mode but we have 5 Power Users (admins) who would still be able to log on.

I'm checking out NT messaging and other means of notification. But it would be cool to pass a system down for maintenance message directly from oracle.........

But I do not think of it as a valid solution.

To the Orignal Poster: what is your purpose in needing to do this ----- perhaps there is a better way to accomplish what you need.

Hannah

John Kanagaraj <JKanagaraj_at_mfi.com> on 11/03/2000 02:10:58 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: Re: Customised message while connecting to a database...

Hi all,

> To change the message following ORA-01045 in an english version :
> - go to $ORACLE_HOME/rdbms/mesg/
> - save a copy of oraus.msg & oraus.msb
> - edit oraus.msg and change the text
> - rebuild oraus.msb with the lmsgen tool : $ORACLE_HOME/bin/lmsgen oraus.msg
> RDBMS ORA AMERICAN
> - logon to sqlplus and see what happens ...
>
> But, once more, I do not think it is advisable to change the default Oracle
> messages.

Exactly! What happens when there is a patch update or even a new version? You loose all the changes (unless you document them and re-enter them if at all possible).

> > ORA-01045: user LRDS lacks CREATE SESSION privilege;
> > logon denied.
> >
> > Is there any way to customize this message? For
> > example, 'You are not suppose to connect at this
> > time...if essential please call <phone number>'.

Don't we want Oracle to display such cryptic messages so that DBAs like us can exist to explain them!!!! :)

John Kanagaraj
http://www.geocities.com/john_sharmila
** God so loved the world that he didn't send a committee **

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
  INET: JKanagaraj_at_mfi.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may