Installing iAS 10.1.3.3 on CENTOS 5

Yes it works no problem; When selecting what bits of CentOS to install, select Server.

Then use the Metalink Note for RHEL5 564174.1 ; you will need an old libdb library as well because Apache will not start without it; Do not do as I did and try and find an ancient compat-db - instead read the above note and get the library from Metalink.


Of course you should immediately patch to 10.1.3.4 as well.

More later.

generating all tablespace ddl from a database

So if you want to get the DDL for tablespaces :


SQL*Plus: Release 10.2.0.4.0 - Production on Fri Sep 12 16:40:54 2008

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set long 32000
SQL> set linesize 32000
SQL> set pagesize 0

SQL> exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',true);

PL/SQL procedure successfully completed.

SQL> select dbms_metadata.get_ddl('TABLESPACE',tbs.tablespace_name) from dba_tablespaces tbs;


spool it to a file

et voila

vmware ISO mounting from a datastore

So : On to vmware, where you want to set up an OS

most people will look for the DVD's and mount them up via the console but instead you can upload the images for future use.

If you have DVDs you can use MagicISO or any such tool to make an ISO of the DVD, an ISO being an image of the DVD. Once you have all the ISOs made, you can now carry on and upload them to a VMWARE store for easy use.

In Virtual Center , click on Inventory/Datastores.

Right-Click on your datastore, then click Browse Datastore [ select the datastore with some space, you'll be hiding ISOs in here ]
On the icons at the top, there's a little green up arrow, click it, then Upload File or Folder.
Select the file or folder you want to put up, then click OK. It will take a few minutes for your files to be uploaded but once they are there you are done.

Now when installing a new VM [ not from a clone ] you can click oh the VM settings, then CD/DVD drive. now you can click Select Datastore ISO file and browse to the needed ISO file.

Once there you can connect the DVD drive to any DVD you like; this is also much fast ter when installing a new OS since it does not have to travel all the way across a possibly slow network

when getting a new test system provisioned to allow new application servers or new database servers in is your goal then this will help - any time spared is useful, and you can reuse the software images again and again

first post

Hi everyone, chris here, this hopefully will be a blog about all the things I do with Oracle etc.