RE: License high water mark

Ask your SA to check unix level parameters for unix kernal are OK. You may get those current parameters by using command 'sysdef' and check with your platform specific oracle installation guide param suggested in that.....

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Mon, 25 Jun 2001 08:46:31 -0800

Re-booting the server worked. But I still need to know what caused the database to shut itself down. I'll let the list know what Oracle says.

Thanks,

Dave

-----Original Message-----
Sent: Monday, June 25, 2001 10:28 AM
To: Multiple recipients of list ORACLE-L

Dave,
Error 12540 can be raised due to a number of issues. If you have access to Metalink you will get quite a few documents describing it. Are there any other databases on the server. If so, and if it is possible to shutdown any on those, please do that, and then try to start your database. If it starts, then the problem is related to kernel resources on the server. And those documents from Metalink would of help.
License High Water mark shows the max number of concurrent connections the database had before it was shutdown. It is also reported by the v$license view.
HTH, Regards,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Farnsworth, Dave [SMTP:DFarnsworth_at_Ashleyfurniture.com]
> Sent: Monday, June 25, 2001 9:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject: License high water mark
>
> My database is down!! In my <SID>Alert file is the following entries
>
> Fri Jun 22 19:00:00 2001
> Restarting dead background process EMN0
> EMN0 started with pid=18
> Fri Jun 22 19:00:00 2001
> Shutting down instance (immediate)
> License high water mark = 9
> Fri Jun 22 19:00:04 2001
> ALTER DATABASE CLOSE NORMAL
> Fri Jun 22 19:00:04 2001
> SMON: disabling tx recovery
> SMON: disabling cache recovery
> Fri Jun 22 19:00:04 2001
> Thread 1 closed at log sequence 438
> Fri Jun 22 19:00:05 2001
> Completed: ALTER DATABASE CLOSE NORMAL
> Fri Jun 22 19:00:05 2001
> ALTER DATABASE DISMOUNT
> Completed: ALTER DATABASE DISMOUNT
> archiving is disabled
>
> I would think that the high water mark is the culprit. What exactly is
> the
> high water mark?? When I type in svrmgrl I get the following error
>
> ORA-12540 TNS: internal limit restriction exceeded.
>
> Any help or hints would be greatly appreciated.
>
> Thanks,
>
> Dave
> --
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
   INET: kirti.deshpande_at_verizon.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
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
   INET: DFarnsworth_at_Ashleyfurniture.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
also send the HELP command for other information (like subscribing).

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.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
also send the HELP command for other information (like subscribing).