Home » RDBMS Server » Server Administration » Oracle Processes
Oracle Processes [message #55430] Thu, 23 January 2003 21:07 Go to next message
jim
Messages: 74
Registered: July 2000
Member
I'm running oracle 8.1.6 on W2K Server.
The other day I got TNS-12500 errors stating I'm out of processes.
This value is set to 500 and when I query the v$resource_limit view I see my max and current utilization are 387, well below my 500 limit.
I heard something about ghost processes?
What else could cause this error?
Any help would be great...

Report message to a moderator

Re: Oracle Processes [message #55440 is a reply to message #55430] Fri, 24 January 2003 06:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
can u post the exact message?
becuase tns-12500 does not directly deal with process errors / resource errors.
and
MAKES SURE , that ther oracledatbase service and listener service is always started by a user with FULL ADMINISTRATIVE RIGHTS and in dba group

Report message to a moderator

Re: Oracle Processes [message #55442 is a reply to message #55430] Fri, 24 January 2003 06:37 Go to previous messageGo to next message
jim
Messages: 74
Registered: July 2000
Member
Mahesh,

Here is a bit of the listener log.
Our system is W2K Server 2-cpu, 2G memory.
At the time of this error the values in the v$resource_limit view where:
Name:processes,Current:447,Max:497,Initial:700,Limit:700
Other init values for session, transaction, enqueue_resources where defaulted based on the processes value 700

16-JAN-2003 14:49:07 * (CONNECT_DATA=(SID=LXTN)(CID=(PROGRAM=Policy Manager.exe)(HOST=PRODTSE04)(USER=lexy-kforgett))) * (ADDRESS=(PROTOCOL=tcp)(HOST=.20.20.154)(PORT=4507)) * establish * LXTN * 0
16-JAN-2003 14:49:08 * (CONNECT_DATA=(SID=LXTN)(CID=(PROGRAM=Policy Manager.exe)(HOST=PRODTSE04)(USER=lexy-kforgett))) * (ADDRESS=(PROTOCOL=tcp)(HOST=.20.20.154)(PORT=4509)) * establish * LXTN * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
16-JAN-2003 14:49:08 * (CONNECT_DATA=(SID=LXTN)(CID=(PROGRAM=DOCPRINT.exe)(HOST=PRODTSE06)(USER=lexg-gbibbins))) * (ADDRESS=(PROTOCOL=tcp)(HOST=.20.20.144)(PORT=1042)) * establish * LXTN * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error

Report message to a moderator

Re: Oracle Processes [message #55445 is a reply to message #55430] Fri, 24 January 2003 06:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are u in Dedicated server or MTS?
increase the value of PROCESSES in initsid.ora
or
reduce the size of sga ( mostly becuase of unwanted huge large_pool_size)
or enable tracing to check whether there is an issue with DCD

Report message to a moderator

Re: Oracle Processes [message #55448 is a reply to message #55445] Fri, 24 January 2003 07:09 Go to previous messageGo to next message
jim
Messages: 74
Registered: July 2000
Member
Dedicated
large_pool_size = 614400

Is there some formula I shuld use to set the processes? or just increase as needed?

Report message to a moderator

Re: Oracle Processes [message #55452 is a reply to message #55445] Fri, 24 January 2003 07:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
u can just increase it (NOT TOOO HIGH).
But i have second thoughts about this as a solution.
this error
32-bit Windows Error: 8: Exec format error
is becuase of unavailablity of system resources.
We have manipulate the parameters that influence the resources
or make sure the resources are available.
so try
AUTOMATIC_IPC = OFF in your sqlnet.ora
and
WHAT IS THE UPTIME OF WIN2K server.
People are not happy with windows, IT WILL CREATE problems when UPTIME is prolongated.
try to reboot the system

Report message to a moderator

Re: Oracle Processes [message #55455 is a reply to message #55452] Fri, 24 January 2003 08:11 Go to previous message
jim
Messages: 74
Registered: July 2000
Member
the device is booted nightly.
the db is shutdown, backed up, and rebooted so the database comes up clean.

What will automatic_ipc=off do for me?

Report message to a moderator

Previous Topic: Successfully processed row count.
Next Topic: system hangs while running this query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:01:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.