Showing posts with label xe. Show all posts
Showing posts with label xe. Show all posts
Monday, February 01, 2010
Thursday, April 24, 2008
Developing own program using Oracle XE and APEX
Steve Hall method:
1) Fresh install of Oracle XE to default location on new machine,
2) Run backup.bat script on my development machine (ApEx 3.1, my app etc),
3) Copied these files / folders from the development machine to the new installation :
flash_recovery_area\XE\AUTOBACKUP\*
flash_recovery_area\XE\BACKUPSET\*
product\10.2.0\server\database\SPFILE2INIT.ORA
4) Run the restore.bat script on the target machine.
Voila! ApEx 3.1 and my app on the target machine. It needs more testing and automating but it certainly seems to work 'in the lab'.
Suggestion: You can try the COMPRESS option in backup.
Andre method:
Basically the steps are as follows.
1. Create your schema.
2. Create a workspace using that schema.
3. Create your underlying db objects.
4. Import the application into the workspace.
This is pretty basic and there may be some other steps required to complete the job, such as importing images and workspace users but overall, once you do it once, its not that hard.
1) Fresh install of Oracle XE to default location on new machine,
2) Run backup.bat script on my development machine (ApEx 3.1, my app etc),
3) Copied these files / folders from the development machine to the new installation :
flash_recovery_area\XE\AUTOBACKUP\*
flash_recovery_area\XE\BACKUPSET\*
product\10.2.0\server\database\SPFILE2INIT.ORA
4) Run the restore.bat script on the target machine.
Voila! ApEx 3.1 and my app on the target machine. It needs more testing and automating but it certainly seems to work 'in the lab'.
Suggestion: You can try the COMPRESS option in backup.
Andre method:
Basically the steps are as follows.
1. Create your schema.
2. Create a workspace using that schema.
3. Create your underlying db objects.
4. Import the application into the workspace.
This is pretty basic and there may be some other steps required to complete the job, such as importing images and workspace users but overall, once you do it once, its not that hard.
Tuesday, October 23, 2007
Tuesday, July 17, 2007
Building pages with APEX using spatial data
All about using Oracle Spatial with Google Maps.
- The Official Guide to using Oracle Spatial with Google Maps
- HTML DB and MapViewer: A Perfect Match
- Integrating APEX with Oracle AS 10g
- Oracle APEX/Spatial How to's
- Integration of Google Maps, Oracle Maps, ... into APEX
- Oracle Application Server MapViewer Sample Code and Demonstrations
-(Great tutorial) Google Maps in APEX on XE with spatial data
- The Official Guide to using Oracle Spatial with Google Maps
- HTML DB and MapViewer: A Perfect Match
- Integrating APEX with Oracle AS 10g
- Oracle APEX/Spatial How to's
- Integration of Google Maps, Oracle Maps, ... into APEX
- Oracle Application Server MapViewer Sample Code and Demonstrations
-(Great tutorial) Google Maps in APEX on XE with spatial data
Friday, December 22, 2006
How to stop Oracle XE from starting up with your computer
Eddie Awad blogs about "How to Give Your System a Break from Oracle XE".
---
There was a question on OraQA about how to stop Oracle XE from starting up with your computer. When you install Oracle XE on Windows, it creates a service called ?OracleServiceXE? with a startup type of ?Automatic? which means that the service starts automatically when the computer boots.
One way to prevent Oracle XE from starting up automatically is to change the startup type of the Oracle service to ?Manual?. You can do that by navigating to your Control Panel -> Administrative Tools -> Services, double click on the Oracle service and change the Startup type to Manual.
Another way to prevent Oracle XE from starting up automatically when Windows starts is to use the ORADIM command-line tool that is available with the Oracle database. From the DOS command line execute the following:
oradim -edit -sid XE -startmode manual
Now, when you want to use Oracle XE, you start it up like this:
oradim -startup -sid XE
And you shut it down like this:
oradim -shutdown -sid XE
Or you can use the ?Start Database? and ?Stop Database? shortcuts installed with Oracle XE. Navigate to Start -> All Programs -> Oracle Database 10g Express Edition ->Start/Stop Database
Now you know how you can squeeze out a bit of extra performance from your computer when you are not using Oracle XE :)
Sources and Resources:
- Eddie Awad's Blog
- ORADIM documentation
- Related AskTom thread
---
There was a question on OraQA about how to stop Oracle XE from starting up with your computer. When you install Oracle XE on Windows, it creates a service called ?OracleServiceXE? with a startup type of ?Automatic? which means that the service starts automatically when the computer boots.
One way to prevent Oracle XE from starting up automatically is to change the startup type of the Oracle service to ?Manual?. You can do that by navigating to your Control Panel -> Administrative Tools -> Services, double click on the Oracle service and change the Startup type to Manual.
Another way to prevent Oracle XE from starting up automatically when Windows starts is to use the ORADIM command-line tool that is available with the Oracle database. From the DOS command line execute the following:
oradim -edit -sid XE -startmode manual
Now, when you want to use Oracle XE, you start it up like this:
oradim -startup -sid XE
And you shut it down like this:
oradim -shutdown -sid XE
Or you can use the ?Start Database? and ?Stop Database? shortcuts installed with Oracle XE. Navigate to Start -> All Programs -> Oracle Database 10g Express Edition ->Start/Stop Database
Now you know how you can squeeze out a bit of extra performance from your computer when you are not using Oracle XE :)
Sources and Resources:
- Eddie Awad's Blog
- ORADIM documentation
- Related AskTom thread
Saturday, July 01, 2006
Ruby on Rails on Oracle XE
As you may have noticed, Oracle recently published an article about Ruby on Rails on Oracle. This articles introduces the Ruby on Rails framework and explains how to use it to access an Oracle database (Oracle Database 10g Express Edition (XE), to be precise).
If you are not familiar with Ruby on Rails, it is important to note that it has nothing to do with Java; it is a Ruby-based framework. Ruby on Rails is really interesting, powerful.
If you have nothing to do :) - check this 3 links:
Ruby on Rails on Oracle: A Simple Tutorial
Grails on Oracle for Java Developers
HR Schema on Rails
If you are not familiar with Ruby on Rails, it is important to note that it has nothing to do with Java; it is a Ruby-based framework. Ruby on Rails is really interesting, powerful.
If you have nothing to do :) - check this 3 links:
Ruby on Rails on Oracle: A Simple Tutorial
Grails on Oracle for Java Developers
HR Schema on Rails
Monday, June 12, 2006
Oracle Database 10g Express Edition (XE) Installation Issues Roundup for Windows
After installing XE, one of the first things you'll do is to go to the database homepage. If something went wrong with the installation, you will see a generic error message...
More on Sergio's Blog
More on Sergio's Blog
Tuesday, June 06, 2006
Installing Oracle XE under Debian/(K)Ubuntu - it is easier than Windows by Jeroen van Wilgenburg
Yesterday I installed Oracle XE at my Ubuntu Linux server at home. I wanted to do this for a long time but was a bit scared because installing non open source applications under Linux can be really painful. I searched on google and found a tutorial on OTN. That's a promising START.
Subscribe to:
Posts (Atom)