Intralink 3.4 - the next chapter... M060

You may have seen my posts last year about struggles with Intralink 3.4 installation and more notes on Intralink 3.4 M040 - well, I'm pleased to report the next step in that process is much simpler!

Upgrading M040 to M060 is a stroll in the park... I've had 100% success on 3 runs, though Windows 2000 Server isn't supported with this version (something I found out the hard way on our old test server, yet to be upgraded to Win2003).

I followed my previous method - and created a batch file to put all the steps together - makes it much easier to repeat the process for many servers. Here are some notes:

1 - Get a secure backup of your existing Intralink database - including dump file and "cold backup" of all the dbs files (as security)
2 - Uninstall the current versions using Add/Remove Programs:
- a) Fileserver
- b) Dataserver
- c) OSA
3 - Remove traces of Oracle (there's usually something left behind) - including program files, registry, path, etc.
4 - Reboot

5 - Install Fileserver + start with port parameter
6 - Install OSA, including:
- a) Oracle 10g DVD
- b) Oracle 10.2.0.3 patch
7 - Install Dataserver

8 - Then import your dump file:
- a) Set some things

set PROI_SYS_PWD=dschangeme
set ORA_SYS_PWD=manager
set FS_SYS_PWD=fschangeme
set DATASRV=dataserver_loadpoint
set DUMP=dump file location

- b) Autoextend on (see below)

- c) Import

cd %DATASRV%\intralink\export\
call ilink_import manager %DUMP%

- d) Run Patches...

cd %DATASRV%\intralink\
copy example_intralink.new intralink.new /y
cd %DATASRV%\intralink\dbs\ilink_patches\tools
call ilink_patches all ilnk INTRALINK

- e) Autoextend off (see below)
- f) Run proimgr (DSMU) - and check/set your database tables & server read/write status


Autoextend... run these SQL lines against the database - with "ON" at start, and "OFF" when you're done:

alter database datafile 'dataserver\INTRALINK\DBS\ILNK_DEVELOPMENT_1.DBF' autoextend on;
alter database datafile 'dataserver\INTRALINK\DBS\ILNK_PDM_INDEX_1.DBF' autoextend on;
alter database datafile 'dataserver\INTRALINK\DBS\ILNK_PDM_TABLE_1.DBF' autoextend on;
alter database datafile 'dataserver\INTRALINK\DBS\SYSTEM_01.DBF' autoextend on;
alter database tempfile 'dataserver\INTRALINK\DBS\TEMP_01.DBF' autoextend on;
alter database datafile 'dataserver\INTRALINK\DBS\UNDOTBS1_01.DBF' autoextend on;