Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: License high water mark

RE: License high water mark

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Mon, 25 Jun 2001 08:51:17 -0700
Message-ID: <F001.00336AEA.20010625084631@fatcity.com>

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,

> -----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).
Received on Mon Jun 25 2001 - 10:51:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US