Tag: Oracle XE
What to do when Oracle XE is not starting after a reboot
When you install Oracle Xe on a windows machine (mainly server OS’s like Windows 2003) you may notice that the database is not always starting after a reboot. This ussualy happenes when the Oracle XE was installed under a different user than the one you are currently logged in as.
It is easy to start the [...]
Posted: June 4th, 2010 under Uncategorized.
Tags: ora-01031, Oracle XE, oradim
Comments: none
How to Configure the ODBC on Oracle XE Client
Even Oracle veterans may encounter some challenges when it comes to setting an odbc using the Oracle XE Client. As every DBA will tell you, you will need to configure the tnsnames.ora (using net configuration Assistant or by going to oracle home\network\admin and edit it manually). After that, theTNS Service name in the ODBC [...]
Posted: February 11th, 2009 under Oracle.
Tags: Connection, ODBC, Oracle, Oracle Client, Oracle XE, Oracle XE Client
Comments: 2
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