Database Administration (MOSC)

MOSC Banner

Maximum number of Dedicated SQLP*Plus sessions test fails

edited May 20, 2014 9:42AM in Database Administration (MOSC) 3 commentsAnswered ✓

Hi,

I'm on 11.2.0.1.0.

[ocm@dg1 ~]$ lsnrctl status


LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-MAY-2014 07:47:01


Copyright (c) 1991, 2009, Oracle.  All rights reserved.


Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                20-MAY-2014 04:24:23
Uptime                    0 days 3 hr. 22 min. 38 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /oracle/u01/app/ocm/product/11.2/db_1/log/diag/tnslsnr/dg1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg1.rnd.local)(PORT=1521)))
Services Summary...
Service "ORCLXDB" has 1 instance(s).
  Instance "ocm", status READY, has 1 handler(s) for this service...
Service "sales" has 1 instance(s).
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center