Ever get this error when using Oracle XE with SpringFramework JDBC Template? SORA-12519, TNS:no appropriate service handler found You can get around it by executing the following commands: ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE; ALTER SYSTEM SET SESSIONS=100 SCOPE=SPFILE; Then stop and start database (Oracle XE service) and you’re good to go! Remember: needs to be [...]
Blog Archives
Getting Ruby to talk to Oracle with Cygwin
I need to be able to use Ruby to talk to Oracle databases to help us easily build scripts for maintenance and support. So, I started doing some googling and found ruby-oci8. Excellent! I’m also mainly PC bound so I needed to get this working on my cygwin installation. My entire Ruby environment is running [...]
About Me
My name is Trent McClenahan. I'm passionate about the web and establishing high performance teams. After 15 years in Sydney I am now based in Newcastle, Australia.
