Skip to Main Content
Forums

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

prctl -n project.max-shm-memory -i process $$

user3240461Sep 6 2012 — edited Sep 23 2012
Hi all,
when i execute the following command "prctl -n project.max-shm-memory -i process $$"
its output is
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 5.85TB - deny

5.85TB while RAM is only 32GB.
How i can change it for oracle user.

Comments

2810868

What aim do you want to achieve?

gao.feng

I want to see the output which is simlar to the following:

C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-OCT-2017 17:43:03

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date                19-OCT-2017 16:30:58

Uptime                    11 days 1 hr. 12 min. 9 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   D:\app\Administrator\product\11.2.0\grid\network\admin\listener.ora

Listener Log File         d:\app\administrator\diag\tnslsnr\WIN-P269HP3NG00\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-P269HP3NG00)(PORT=1521)))

Services Summary...

Service "+asm" has 1 instance(s).

  Instance "+asm", status READY, has 1 handler(s) for this service...

The command completed successfully

AndrewSayer

That listener is on port 1522... do you really want/need that? Why?

If you want it to support a service then you need to register an instance with it.

SUPRIYO DEY

alter system register.

You have created listener on non default port.

EdStevens 
gao.feng wrote:
I installed Oracle Database 11gR2 and created the orcl database,then installed Grid Infrastructure on a standalone windwos 2008 R2 server.
I have always been able to connect to my database and asm instance using SQL*Plus. But I'm facing an issue when typing the command lsnrctl status,it reports
'The listener supports no services'
My grid's listener.ora file:
# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\grid\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.78)(PORT = 1522))
 )
 )
ADR_BASE_LISTENER = C:\app\Administrator
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
My grid's tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\grid\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_+ASM =
 (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-G48DNRS1396)(PORT = 1522))
When typing lsnrctl status,I get the following:
C:\Users\Administrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-OCT-2017 15:56:32
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 30-OCT-2017 14:41:43
Uptime 0 days 1 hr. 14 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Administrator\product\11.2.0\grid\network\admin\listener.ora
Listener Log File c:\app\administrator\diag\tnslsnr\WIN-G48DNRS1396\listener\alert\log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.78)(PORT=1522)))
The listener supports no services
The command completed successfully
I can connect the asm instance:
C:\Users\Administrator>set oracle_sid=+asm
C:\Users\Administrator>set tns_admin=C:\app\Administrator\product\11.2.0\grid\NETWORK\ADMIN
C:\Users\Administrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 30 15:49:05 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys as sysasm
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
SQL> select path,os_mb from v$asm_disk;
PATH OS_MB
------------------------------- -----------------
\\.\ORCLDISKDATA0 10240
\\.\ORCLDISKDATA1 10240
\\.\ORCLDISKDATA2 10240
\\.\ORCLDISKDATA3 10240
And i tried to use 'srvctl add listener -l listener_+asm -o C:\app\Administrator\product\11.2.0\grid -p 1522',i got the following:
PRCR-1070 : Failed to check if ora.LISTENER_+ASM.lsnr is registered
Invalid resource name
How can i solve this issue?

Your listener is on the NON-default port of 1522.  Unless you modify your ASM and db instances accordingly, they will try to register themselves on the default port of 1521.

So why do you have your listener on port 1521?  Please don't say it's for "increased security".  Would you change the port for ftp?  for ssh? for http?  Then why for the oracle listener?

The reason you can connect anyway is because your connection is a BEQ connection -- an inter-process connection.  It is not going through the tns network stack, and thus does not use the listener.

As far as that goes, why does your ASM instance need to be serviced by the listener at all?

And if you were planning on using ASM, why did you create your database before you had an ASM instance?

And while we're on the subject, why do you have your listener configured for a hard-coded IP address instead of a dns-resolved host name?

1 person found this helpful
John Thorton 
gao.feng wrote:
I want to see the output which is simlar to the following:
C:\Users\Administrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-OCT-2017 17:43:03
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 19-OCT-2017 16:30:58
Uptime 11 days 1 hr. 12 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\Administrator\product\11.2.0\grid\network\admin\listener.ora
Listener Log File d:\app\administrator\diag\tnslsnr\WIN-P269HP3NG00\listener\alert\log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-P269HP3NG00)(PORT=1521)))
Services Summary...
Service "+asm" has 1 instance(s).
 Instance "+asm", status READY, has 1 handler(s) for this service...
The command completed successfully

Realize & understand that the ASM instance never really goes ONLINE.

ASM instance only ever goes to MOUNT stage.

ASM never registers with any listener.

What problem are you really trying to solve?

EdStevens 
John Thorton wrote:
Realize & understand that the ASM instance never really goes ONLINE.
ASM instance only ever goes to MOUNT stage.
ASM never registers with any listener.

Au contraire!

oracle:+ASM$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 30-OCT-2017 07:38:03
Copyright (c) 1991, 2014, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                06-JUL-2017 06:26:17
Uptime                    116 days 1 hr. 11 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0.2/grid/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/<myserver>/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGISTER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<myserver>.<myorg>.org)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "<mydb1>" has 2 instance(s).
  Instance "<mydb1>", status UNKNOWN, has 1 handler(s) for this service...
  Instance "<mydb1>", status READY, has 1 handler(s) for this service...
Service "<mydb1>XDB" has 1 instance(s).
  Instance "<mydb1>", status READY, has 1 handler(s) for this service...
Service "<mydb2>" has 2 instance(s).
  Instance "<mydb2>", status UNKNOWN, has 1 handler(s) for this service...
  Instance "<mydb2>", status READY, has 1 handler(s) for this service...
Service "<mydb2>XDB" has 1 instance(s).
  Instance "<mydb2>", status READY, has 1 handler(s) for this service...
The command completed successfully

Though I've never understood the purpose.

What problem are you really trying to solve?

Agreed.

GregV 
EdStevens wrote:
oracle:+ASM$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 30-OCT-2017 07:38:03
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 06-JUL-2017 06:26:17
Uptime 116 days 1 hr. 11 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0.2/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/<myserver>/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGISTER)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<myserver>.<myorg>.org)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
 Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "<mydb1>" has 2 instance(s).
 Instance "<mydb1>", status UNKNOWN, has 1 handler(s) for this service...
 Instance "<mydb1>", status READY, has 1 handler(s) for this service...
Service "<mydb1>XDB" has 1 instance(s).
 Instance "<mydb1>", status READY, has 1 handler(s) for this service...
Service "<mydb2>" has 2 instance(s).
 Instance "<mydb2>", status UNKNOWN, has 1 handler(s) for this service...
 Instance "<mydb2>", status READY, has 1 handler(s) for this service...
Service "<mydb2>XDB" has 1 instance(s).
 Instance "<mydb2>", status READY, has 1 handler(s) for this service...
The command completed successfully
Though I've never understood the purpose.

Hi Ed,

I have a connection setup in SQL Developer where I login as SYSASM to my +ASM instance, so I can query the v$asm views directly from SQL developer. Wouldn't it be then one purpose of this service?

EdStevens 
GregV wrote:
EdStevens wrote:
oracle:+ASM$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 30-OCT-2017 07:38:03
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 06-JUL-2017 06:26:17
Uptime 116 days 1 hr. 11 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0.2/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/<myserver>/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGISTER)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<myserver>.<myorg>.org)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
 Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "<mydb1>" has 2 instance(s).
 Instance "<mydb1>", status UNKNOWN, has 1 handler(s) for this service...
 Instance "<mydb1>", status READY, has 1 handler(s) for this service...
Service "<mydb1>XDB" has 1 instance(s).
 Instance "<mydb1>", status READY, has 1 handler(s) for this service...
Service "<mydb2>" has 2 instance(s).
 Instance "<mydb2>", status UNKNOWN, has 1 handler(s) for this service...
 Instance "<mydb2>", status READY, has 1 handler(s) for this service...
Service "<mydb2>XDB" has 1 instance(s).
 Instance "<mydb2>", status READY, has 1 handler(s) for this service...
The command completed successfully
Though I've never understood the purpose.
Hi Ed,
I have a connection setup in SQL Developer where I login as SYSASM to my +ASM instance, so I can query the v$asm views directly from SQL developer. Wouldn't it be then one purpose of this service?

I guess that makes sense.  I'm such a committed command line guy I just never thought of using SQL Dev to work with the ASM instance, even though I do like it for some ad-hoc queries against the database.

gao.feng 
I have a connection setup in SQL Developer where I login as SYSASM to my +ASM instance, so I can query the v$asm views directly from SQL developer. Wouldn't it be then one purpose of this service?

Agreed.

John Thorton 
gao.feng wrote:
I had never change the listener port at all.I would hazard the default option for the database listener port is 1521, which is why the asm is listening on 1522.
One port could't be occupied by two differrent instance,isn't it?

single listener can service multiple instances so no need for port 1522.

gao.feng 
Your listener is on the NON-default port of 1522.  Unless you modify your ASM and db instances accordingly, they will try to register themselves on the default port of 1521.

I had never change the listener port at all.I would hazard the default option for the database listener port is 1521, which is why the asm is listening on 1522.

One port could't be occupied by two differrent instance,isn't it?

EdStevens 
gao.feng wrote:
Your listener is on the NON-default port of 1522. Unless you modify your ASM and db instances accordingly, they will try to register themselves on the default port of 1521.
I had never change the listener port at all.I would hazard the default option for the database listener port is 1521, which is why the asm is listening on 1522.
One port could't be occupied by two differrent instance,isn't it?

Neither the database nor the ASM "listen" on ports at all.   It is strictly a listener issue.  The only concern the instances have with ports is in knowing (via the LOCAL_LISTENER parameter) what port the listener is using, so that they may contact it (just like any client) and register themselves.  If LOCAL_LISTENER is not configured, they will try to contact the listener on its default port of 1521.

If your listener is listening on anything other than 1521, then someone made the conscious decision to specify that in the listener.ora. Full stop.  End of story.   And if the database or ASM instances don't know that, they will try to contact the listener on the default, 1521.

gao.feng

I  had changed the asm listener port back to 1521 like following.

# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\grid\network\admin\listener.ora

# Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.78)(PORT = 1521))

    )

  )

ADR_BASE_LISTENER = C:\app\Administrator

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent

When typing 'lsnrctl status',i get the following:

C:\Users\Administrator>set oracle_sid=+asm

C:\Users\Administrator>set tns_admin=C:\app\Administrator\product\11.2.0\grid\NETWORK\ADMIN

C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-OCT-2017 22:45:51

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                    LISTENER

Version                  TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date                30-OCT-2017 22:43:22

Uptime                    0 days 0 hr. 2 min. 31 sec

Trace Level              off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File  C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Listener Log File        c:\app\administrator\diag\tnslsnr\WIN-G48DNRS1396\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-G48DNRS1396)(PORT=1521)))

Services Summary...

Service "CLRExtProc" has 1 instance(s).

  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "orcl.xcsc.com" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB.xcsc.com" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

There is something lacking in the output which is simlar to 'Service "+asm" has 1 instance(s).

  Instance "+asm", status READY, has 1 handler(s) for this service...'

EdStevens

Show us

set ORACLE_SID=+ASM

sqlplus / as sysasm

SQL>  show parameter local_listener

SQL> exit

lsnrctl status

gao.feng

It seems to be poor performance of machine.I wait a moment,typing the 'lsnrctl status' command again,and this time the report seems to be in line with predictions。

C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-OCT-2017 23:53:40

copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date                30-OCT-2017 23:32:01

Uptime                    0 days 0 hr. 21 min. 40 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Listener Log File         c:\app\administrator\diag\tnslsnr\WIN-G48DNRS1396\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-G48DNRS1396)(PORT=1521)))

Services Summary...

Service "+asm" has 1 instance(s).

  Instance "+asm", status READY, has 1 handler(s) for this service...

Service "CLRExtProc" has 1 instance(s).

  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "orcl.xcsc.com" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB.xcsc.com" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

I have another question,how can i therefore ensure, through operating system utilities,that the ASM instance starts before the RDBMS instances that are dependent upon it.

Thanks a lot.

John Thorton

sleep 10

EdStevens
Answer 
gao.feng wrote:
It seems to be poor performance of machine.I wait a moment,typing the 'lsnrctl status' command again,and this time the report seems to be in line with predictions。

Not necessarily "poor performance".  If you start the listener before the db, it will take several seconds - up to a minute or so - for the instance to come back around from the rest of the work it is doing and perform a registration.  This is normal and to be expected.

I have another question,how can i therefore ensure, through operating system utilities,that the ASM instance starts before the RDBMS instances that are dependent upon it.
Thanks a lot.

That's what Oracle Restart is all about.  That's why I mentioned earlier about installing and configuring GI and ASM before you create a database.

The normal sequence is

1) install GI

2) create your ASM disks

3) create the database

When you do things in the normal sequence, all dependencies are correctly registered with Oracle Restart.  Then all you have to do to start the entire stack is

set ORACLE_HOME=<GI HOME>

set ORACLE_SID=+ASM

set PATH to start with %ORACLE_HOME%/bin

crsctl start resource -all

And to stop the entire stack

crsctl stop resource -all

Marked as Answer by gao.feng · Sep 27 2020
gao.feng 
sleep 10

could you please demystify it?

1 - 19
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 21 2012
Added on Sep 6 2012
#oracle-solaris, #solaris-10
2 comments
490 views