(0 comments, 75 posts)
This user hasn't shared any profile information
Posts by admin
With all those fancy plug-ins for Microsoft tools release 2 of Oracle Grid Control 10g seems to be a must-have. However, according to many postings on the internet, installation on SuSE Linux is quite a job and release 2 is not (yet?) available for Windows. So, there’s a challenge that I couldn’t resist and I decided to try and install it on SuSE Linux 9.3 (SLES9). The result after a couple of times installing, removing and re-installing was a nice working grid control.
Here’s how I did it. (more…)
Some time ago a customer of AMIS asked me to setup the automatic deployment of the software for their application. Till then this was done manually, took an awful lot of time and was rather error-sensitive.
The application itself is a multi-tier application with an Oracle database, a Micro Focus COBOL application server and an Oracle Application server for OC4J and Oracle Reports. The deployments contains -among others- SQL-scripts, RDF-files, COBOL binaries, JAR- and EAR files etc. After examining the requirements I remembered ANT. Originally created to ‘make’ JAVA code, but evolved to much more than that, it is capable to run SQL-files against the database, to copy, ftp, remove files on a file system, execute other (system)programs, zip and unzip and interface with several CVS applications.
Great article about ASM on the website of Howard Rogers: http://www.dizwell.com/oracle/articles/desktop_asm.html For both Linux and Windows.
After the announcement of Oracle XE I got really curious about the possibilities of a free Oracle10g database. OK, it is limited to 4GB and it doesn’t allow things like partitioning but still… very usefull for smaller companies and web applications. So, I downloaded the Win32 version from OTN to my laptop (1.1GHz cpu, 512MB memory) and started playing with a DBA point of view.
First thing to notice is the fact that Oracle doesn’t use the well known Universal Installer but a simple Install Shield Wizard instead which makes the installation process quite easy. The Linux version is an RPM so I guess installation won’t be a problem there either. Haven’t tried it…. yet.
The installation wizard creates an entire OFA-tree so just follow its suggestion to use ‘c:\oraclexe’ as the oracle home directory. At first I used an existing oracle home directory which ended up in rather long pathnames. Besides a password for the SYS and SYSTEM account no other user input is required, the wizard is taking care of the services, the listener, the configuration of the webserver and it creates a default database with ‘XE’ as SID… it’s the Express Edition. After the installation has finished you can go to More >
We all know partitioning for performance issues or for storing historical data. But partitioning can also be used for functional purposes such as creating a savepoint in batchrun. Such a savepoint can be used to undo a specific part of a batch without the use of home made software. Lets say that we have a payroll system for multiple companies:Company ----------- Company_id number(9) Name varchar2(100) Addres varchar2(100) Place varchar2(100) Last_date date Total_salary number(13) Employee ------------ Employee_id number(9) Emp_comp_id number(9) Name varchar2(100) Address varchar2(100) Place varchar2(100) Salary varchar2(100) Last_date date
The table â€˜Companyâ€™ contains several companies and each company has several entries in the table â€˜Employeeâ€™. Now we have to pay and calculate the salaries for all the employees from all the companies. (more…)