| Listener related problem [message #62583] |
Fri, 30 July 2004 23:48  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi,
We have Oracle 9i installed on Sun Solaris. An VB appliaction is accessing the 9i. Since yesterday users are getting errors, after checking the logs i noticed the error is TNS-12500 TNS:listener failed to start a dedicated server process and ORA-03113 end-of-file on communication channel.
I checked the Oracle doc also but was unable to find the possible resolution. I tried to change the values for PROCESSES to 250 in init.ora file which is rite now 150 but while startup it gave me OS related errors so i changed it back to 150 and started the db.
If anyone could help me for the same i will be very thankful
with regards
Vivek
|
|
|
|
| Re: Listener related problem [message #62590 is a reply to message #62583] |
Mon, 02 August 2004 01:25  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
First of all tell us the system configuration and the db size and workload of your db.
Actually this error means your system is unable to allocate as much resources which are required to allocate a dedicate session.
Try to free as much resources as you can. Stop unwanted services. Check the number of concurrent sessions when the users were getting that error. If increasing resources is not a better option for you than go for the multithreaded architecture instead of dedicated.
As a quick workaround just restart your system if possible.
Best Regards
Daljit Singh
|
|
|
|
| Re: Listener related problem [message #62609 is a reply to message #62583] |
Mon, 02 August 2004 22:33 |
Thomas
Messages: 67
Registered: September 1999
|
Member |
|
|
You have to adjust your Solaris kernel parameters if you want to run more Oracle Processes. The parameters are in /ext/system.conf
Here's a reasonable way to set the semaphore settings:
semmsl >= PROCESSES from init.ora
semmni >= # instances on machine (+ other programs using semaphores)
semmns = semmni * semmsl
semmap >= semmns * 1.10
On my system I have:
set shmsys:shminfo_shmmax=268435456
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set shmsys:seminfo_semmsl=110
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=210
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
And changes take place after OS reboot....
Hope that helps,
clio_usa - OCP DBA 8/8i/9i
Oracle DBA Resources
Oracle DBA Forums
USENET Oracle newsgroups
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
