Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Friday, December 28, 2012

Oracle Application Express


What is Oracle Application Express?


Oracle Application Express (Oracle APEX) is a declarative, rapid web application development tool for the Oracle database. It is a fully supported, no cost option available with all editions of the Oracle database. Using only a web browser, you can develop and deploy professional applications that are both fast and secure.
Whether you are an experienced SQL and PL/SQL developer or a power user used to writing reports, wizards allow you to quickly build Web applications on top of your Oracle database objects. Enhancing and maintaining these applications is done using a declarative framework, all of which increases your productivity.
Oracle Application Express is database-centric and suited to building a vast array of applications. You can start with webifying a spreadsheet to facilitate collaboration or dive right into extremely complex applications with numerous external interfaces such as the Oracle Store. Because Oracle APEX resides within the Oracle Database and can easily integrate with authentication schemes (such as Oracle Access Manager, SSO, LDAP, etc.) you can build secure applications that can scale to meet your largest user communities.

Tuesday, December 18, 2012

Steps to uninstall Oracle11g from windows 7


Recently I got the strange work of deleting Oracle 11g from a windows 7 box. [Yeah, I know its a bad job :-) ]


I used the OUI program to remove Oracle. However it gives a bad command line option to run the deinstall.bat file. I ran the bat file and I got some strange exception stack trace.

So its at this point that I decided to go the ‘hard way’ [manual un-installation]

Steps:

Phase 1
Stop all Oracle services first.
1) START -> RUN -> Services.msc
2) Locate all Ora* services & click on STOP
Phase 2
1) Start -> RUN -> Regedit
2) Locate HKEY_LOCAL_MACHINE folder in the registry
3) Open Software folder
4) Delete the Oracle folder under Software
5) Open System folder in HKEY_LOCAL_MACHINE
6) Open CurrentControlSet folder within the System folder
7) Open Services
8 ) Delete all keys related to Oracle. Every key starts with “ORA..”
9) Close the regedit
10) Delete ORACLE_HOME folder
11) Delete the Oracle folder in Program Files
12) Reboot
At this point your machine should be free from Oracle.
I wish if Oracle could streamline this process …