Tag: XE
Simple Solution to ORA-12520 on Oracle XE
If you get the following error on Oracle XE:
ORA-12520: TNS:listener could not find available handler for requested type of server
This is probably because the value for the processes parameter is too low.
For some reason, Oracle set the default value of the processes parameter on Oracle XE to 40. If your application opens many process or [...]
Posted: October 9th, 2008 under Oracle.
Tags: ORA-12520, Oracle, Oracle XE, Processes, XE
Comments: 3
How to enable Operating System authentication on Oracle XE
OS authentication is not enabled by default in Oracle XE. To allow the use of OPS$ users, open sql plus (All Programs -> Oracle Database 10g Express Edition -> Run SQL Command Line) and run the following command:
alter system set os_authent_prefix=OPS$ scope=spfile;
Restart the DB:
shutdown immediate
Startup
To Create the OS user:
CREATE USER “OPS$DOMAIN\DOMAINUSER” PROFILE
“DEFAULT” IDENTIFIED EXTERNALLY DEFAULT
TABLESPACE [...]
Posted: September 22nd, 2008 under Oracle.
Tags: Oracle, OS authentication, XE
Comments: none