Blackboard Upgrade
From LeonWiki!
Contents |
Oracle Install on XP
Preliminary
Had oracle already installed on XP and wanted to install another oracle database instance...
- First had problems because the database configuration assistant never completed and I had to kill it, which meant that I was never prompted for sys and system user accounts.
- So, I deleted the new instance and tried again. On the second attempt kept getting error something about a key the GetValue couldn't get because it was already used. Have no idea what this was about. So I killed any processes running for oracle and logged out and back in and ran again. This time it installed but didn't like the SID I was using (was the same as the second database install but Oracle doesn't get rid of everything when you perform a remove) so the database configuration assistant wouldn't run. Deleted this install also.
- Now installed again and the db conf assistant spun its wheels again so never got to a sys,system user name prompt again.
- Update: got Oracle installed and running ok.
- Found out that Blackboard does not support Oracle on XP, only on Linux. So onto installing it on White Box 4 Linux
Oracle Install on White Box Linux
- Ran into problem immediately: Unable to load native library:
- /tmp/OraInstall2006-11-29_07-39-06AM/jre/lib/i386/libjava.so:
- symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
- Found the answer to this one at [[1]here] about half-way down the page where he describes how to make your own patch. Don't forget the export statement below the C code!
- Now there is a problem with running the scripts: getting the error : Can't invoke target install for file ins_plsql.mk. This error seems to be caused by the gcc compiler when the version is not correct. Googling it turns up a reference from which the following commands worked: (believe it or not there really is a gcc296 and gcc323)
# mv /usr/bin/gcc /usr/bin/gcc323
# mv /usr/bin/g++ /usr/bin/g++323
# ln -s /usr/bin/gcc296 /usr/bin/gcc
# ln -s /usr/bin/g++296 /usr/bin/g++
Now you should be able to relink the oracle binary again.
Once you are done, make sure to revert back the changes you've made above:
# mv /usr/bin/gcc323 /usr/bin/gcc
# mv /usr/bin/g++323 /usr/bin/g++
This page is located [[2]here] Clicking on retry on the error dialog continued the install.
- The next problem was some Apache files that needed to be written to were created with only read permission, so changing to read/write and clicking the retry continued the install.
- The next problem was with the Apache part of the install again. The install was looking for a variable in ports.ini named s_jservPort and was claiming that there wasn't a non-empty variable by that name. An inspection of the file found that there was two "Ports" sections containing identical information except that the second one had the variable defined whereas the first didn't have any reference to it. Deleting the first Ports section and clicking retry continued the install.
- Everything seemed to be installing fine until the end when the tool configurations are run. The agent service failed with message:
Parameter "orahome" = /oracle/product/9.
Parameter "nodeinfo" = NO_VALUE
- Trying to figure that out now....didn't get it working so going to try to uninstall/reinstall Blackboard and hope it works. First login to sqlplus and run the stella scripts...
Oracle Server Start/Stop Procedures
- To start Oracle server: goto /u01/app/oracle/product/9.2.0/bin and run ./lsnrctl start...
- a better one I just found:
lsnrctl start
export ORACLE_SID=sid_name
sqlplus "/ as sysdba" <<EOF
startup
EOF
Blackboard Install
- Preliminary: Have to start with 6.1 and apply a whole round of application packs and hotfixes to get to 6.3
- After the Oracle install on Linux I uninstalled the previous Blackboard instance and re-installed.
