Forum OpenACS Q&A: Re: Notes on reinstall of developmental computer

Collapse
11: Re: Notes on reinstall of developmental computer (response to 1)
Posted by Jade Rubick on 02/13/03 10:14 PM
Good point, Don 😊 I guess practice makes perfect. I think I've installed Oracle about 10 times now, most of it a couple of years ago, when it was truly a horrific experience. I think it will be interesting to compare my Oracle install with my Postgres install. (Rolling up the sleeves).

I'm installing both ACS 3.4 and OpenACS 4.6 on this computer. The ACS uses Oracle, the OpenACS installation will use Postgres. I figure I might as well do all my porting at once..

Finish up Oracle install

  • Downloaded acceptance test
  • cp /tmp/acceptance-sql.txt /tmp/acceptance.sql
  • svrmgrl
  • SVRMGR> connect internal
  • SVRMGR> startup
  • SVRMGR> exit
  • sqlplus system/manager This doesn't work, because I copied the /ora8 directory, hence the username and password have already been changed. So I ignore the next few lines.
  • SQL> select sysdate from dual;
  • SQL> @ /tmp/acceptance.sql
  • SQL> exit
  • cd /tmp
  • wget https://openacs.org/doc/openacs-4/files/dbstart.txt
  • cp /tmp/dbstart.txt /ora8/m01/app/oracle/product/8.1.6/bin/dbstart
  • chmod 755 /ora8/m01/app/oracle/product/8.1.6/bin/dbstart
  • I edited the /etc/oratab file, set N to Y.
  • wget https://openacs.org/doc/openacs-4/files/oracle8i.txt
  • (as root) cp /tmp/oracle8i.txt /etc/rc.d/init.d/oracle8i
  • chown root.root /etc/rc.d/init.d/oracle8i
  • chmod 700 /etc/rc.d/init.d/oracle8i
  • I had to edit the oracle8i file and change 8.1.7 to 8.1.6
  • I tested the script and it works.
  • cd /etc/rc.d/init.d
  • chkconfig --add oracle8i
  • chkconfig --list oracle8i
  • su - oracle
  • Downloaded the three scripts.
  • Copied them to /ora8/m01/app/oracle/product/8.1.6/bin/ and chmod them to 700.
  • exit
  • cp /tmp/listener8i.txt /etc/rc.d/init.d/listener8i
  • chmod 700 listener8i
  • When I tested the listener8i script, it didn't work, because I am using Oracle 8.1.6. I had to edit each of the scripts and change 8.1.7 to 8.1.6.
  • I started the listener back up, and then tested it out, per the directions. Seems to work fine.
  • chkconfig --add listener8i
  • chkconfig --list listener8i
  • shutdown -r now

Installing Postgres

  • Downloaded Postgres 7.2.3
  • cd /usr/local/src
  • tar xzf /tmp/postgresql-7.2.3.tar.gz
  • groupadd web
  • useradd -g web -d /usr/local/pgsql postgres
  • passwd postgres
  • su - postgres
  • edited my .bash_profile
  • exit
  • su - postgres
  • echo $PATH (looks good)
  • Oops I forgot to add in the directories and everything...
  • (as root) mkdir -p /usr/local/pgsql
  • chown -R postgres.web /usr/local/pgsql /usr/local/src/postgresql-7.2.3/
  • su - postgres
  • cd /usr/local/src/postgresql-7.2.3/
  • ./configure
  • make all
  • make install
  • cd contribut/tsearch
  • make
  • make install
  • cd
  • /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
  • /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l /usr/local/pgsql/data/server.log start
  • I think I'll create another user instead of joeuser, I'll call it joeuser here though.
  • (as root) useradd -g web joeuser
  • (as postgres) createlang plpgsql tempate1
  • createlang -l template1
  • createuser joeuser y and y
  • Ran through the mytestdb tests. Works fine.
  • wget https://openacs.org/doc/openacs-4/files/postgresql.txt
  • su -
  • cp /tmp/postgresql.txt /etc/rc.d/init.d/postgresql
  • chown root.root /etc/rc.d/init.d/postgresql
  • chmod 700 /etc/rc.d/init.d/postgresql
  • /etc/rc.d/init.d/postgresql stop
  • chkconfig --add postgresql
  • We're done installing Postgres. I think it took less than an hour, compared to most of yesterday for Oracle...