tomclegg.net


Diary
Examples
    256-router
    adzap
    apache-double-reverse
    cacti-adodb-php4
    debian-quota
    diskonmodule
    dollarsperbyte
    dynip
    ezmlm-linux
    fbsdhabits
    freebsdclone
    macbook-quantal-sound
    maildirpop3d-awfulhak
    mandy
    md
    mrtg
    net-snmp
    nodefaultroute
    oracle9i
    oracle9i-bsd5
  >oracle9i-client<
    oracle9i-nat
    php-cgi
    php-commandline
    php-image
    php-kics
    php-mini_httpd
    pinouts
    pizzaperdollar
    plesk-symlink-php
    pxe
    qmail-linux
    qmail-qfilter
    racoon-sonicwall
    redundant-vpn
    rewriterule
    seahorse-workaround
    setting-locale-failed
    smalldog
    snmpv3-cacti
    spamassassin
    squid-tproxy
    supfile
    suse73
    svc-nmbd
    svc-smbd
    svc-smtpd
    switch-virtualbox-virsh
    toyotastereo
    vm
    vn-file
    wmp-invalid
    xcode-remote-install
    xen-eth0-renamed
    xen-monowall
    xen3-ubuntu-dapper
    zz-update-grub-fail
Hire Tom
Mostly Mozart
Patches
School
Scrapbook
Software
Telephones




colocation
comments
davidireland
edsgranola
faq
funsites
goodlooking
goodmovies
google-earth-saucy-amd64
houserules
liberating
resume
resume2
scratch
shopping
snacks
todo
university
warisbogus

Oracle 9i Client
Posted August 13, 2003

Installing Oracle 9i client software on Windows 2000, connecting to a database called planb, which is running on a FreeBSD 5.1 machine called bsd5...

  • "Service name" is bsd5.cis2.selkirk.bc.ca.
  • "Host name" is bsd5.cis2.selkirk.bc.ca.
  • "SID" is planb.cis2.selkirk.bc.ca.

Choose the "runtime" package and everything works fine.

Choose the "administrator" package and you get an error message about Microsoft Transaction Services (omtsrv.exe or something like that). Close the Windows error box, then click "Ignore" on the oracle installer error box.

When you restart your machine, you'll get that MTS error message again. To get rid of it:

  • Open Start / Programs / Oracle Installation Products / Universal Installer.
  • Click "Deinstall products."
  • Expand "OraHome92" (or whatever your home is called).
  • Expand "Oracle9i Client 9.2.0.1.0".
  • Expand "Oracle Windows Interfaces".
  • Select "Microsoft Transaction Services".
  • Click "Remove..."

Reconfiguring the client for planb

  • Start / Programs / Oracle - OraHome92 - Configuration and Migration Tools / Net Configuration Assistant
  • Local Net Service Name configuration / Next
  • Reconfigure / Next
  • PLANB / Next
  • Oracle8i or later database or service
  • Service Name: planb.cis2.selkirk.bc.ca / Next
  • Protocol: TCP / Next
  • Host name: planb.cis2.selkirk.bc.ca / Next
  • Yes, test it / Next
  • If the test does not succeed because of invalid username/password, then you are probably doing fine.
  • Next
  • Net Service Name: planb.cis2.selkirk.bc.ca / Next
  • Configure another? No. / Next
  • Net service name Configuration Complete! / Next
  • Welcome. / Finish

See also

Installing Oracle 9i on FreeBSD 5.1