Event LOG:
[1] 12/18/06 09:53 Notice: Oracle env - ODSUP:/ODSUP/oh/102 [sp_opst_mt(pdb)/21142]
[1] 12/18/06 09:53 Notice: Oracle version 102 [sp_opst_mt(osp)/21142]
[1] 12/18/06 09:53 Notice: Post will not open more than 1990 cursors per session (OPEN_CURSORS - 10). [sp_opst_mt (for o.PRG-o.ODSUP queue oraprod)/21142]
[85] 12/18/06 10:42 Error: 12032 - OCIServerAttach failed with ORA-12549. [sp_opst_mt(osp)/21142]
[85] 12/18/06 10:42 Notice: ORA-12549: TNS:operating system resource quota exceeded. [sp_opst_mt(osp)/21142]
[85] 12/18/06 10:42 Error: Unexpected Oracle error: ORA-12549: TNS:operating system resource quota exceeded. in opo_access7.c:340 [sp_opst_mt(osp)/21142]
12/18/06 10:42 Process exited sp_opst_mt (for o.PRG-o.ODSUP queue oraprod) [pid = 21142] - exit(1)
The operating system resource quota exceeded .
Resolution 1:
Possible OS resource limits include:
The maximum number of processes allowed for a single user
The operating system is running low on paging space
RESOLUTION:
Increase the number of processes by setting the PROCESSES parameter in the database initialization file to a larger value. If this value is low.
Check the sqlnet.log or listener.log file for detailed error stack information, such as an operating system error code to help identify which quota has been exceeded.
Check the ulimit settings:
ulimit -aS
Oracle recommends to set the following OS resource parameters to unlimited:
1.- Set the ulimits to 'unlimited' with the following values:
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 1024
For more details check out this article on Metalink regarding the ORA-12549 error.
Doc ID : Note:364235.1
Resolution 2:
The ORA-12549 error is a simple system resources problem as per MOSC Note 819394.1. This is either:
1 - RAM shortage: To fix an ORA-12549, simply check for processes that you can kill/stop to free memory or acquire more memory. or pop-in a 4 gig RAM chip, adjust your PGA and you will probably be good to go.
2 - OS parms: Maladjusted kernel resource setting in /etc/system or var/opt/system in Solaris. First, check your OS kernel parameters against your OS install guide, especially maxuproc and maxtsiz_64bit :
root> cat /etc/system
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=24000
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=24000
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
set tcp:tcp_conn_hash_size=4096
Please make sure your system resource parameters are appropriate for the system and SharePlex by refering to the SharePlex for Oracle 7.5.2.3 - Installation Guide (pdf) pre-installationrequirements section for SharePlex.
1. https://support.quest.com/Search/SearchDownloads.aspx
2. click on download tab
3. Type SharePlex for Oracle and select <SharePlex version> from the drop down menu
4. Select category documentation
5. click on search
6. download the SharePlex Installation Guide (pdf)
