Solaris9iInstall.html
03-26-2002 Bikle
-----------------
Solaris 9i Install
I downloaded the software and then unloaded it into Disk1,2,3.
I used an internet utility to download the software directly to my Solaris disk:
/usr/local/bin/wget --http-user=h0m3r --http-passwd=s1mpson http://download-west.oracle.com/otn/solaris/oracle9i/901solaris_disk1.cpio.gz
/usr/local/bin/wget --http-user=h0m3r --http-passwd=s1mpson http://download-west.oracle.com/otn/solaris/oracle9i/901solaris_disk2.cpio.gz
/usr/local/bin/wget --http-user=h0m3r --http-passwd=s1mpson http://download-west.oracle.com/otn/solaris/oracle9i/901solaris_disk3.cpio.gz
You may get
wget
from
http://www.sunfreeware.com/
If you are on Solaris8, this is a handy link:
http://www.sunfreeware.com/programlistsparc8.html
You may use a browser to create a user/pass here:
http://otn.oracle.com/membership/
I created an env file and 'dotted' it.
dotX9.txt
I ran runInstaller...
$ ./runInstaller
$ Initializing Java Virtual Machine from /tmp/OraInstall/jre/bin/jre. Please wait...
Exception java.lang.NullPointerException occurred..
java.lang.NullPointerException
at sun.awt.motif.X11FontMetrics.(Compiled Code)
at sun.awt.motif.X11FontMetrics.getFontMetrics(Compiled Code)
at sun.awt.motif.MToolkit.getFontMetrics(Compiled Code)
at java.awt.Component.getFontMetrics(Compiled Code)
at oracle.sysman.oii.oiif.oiifm.OiifmSplashScreen.init(Compiled Code)
at oracle.sysman.oii.oiic.OiicInstaller.main(Compiled Code)
I fixed above error by switching the X server on my PC.
I switched to Hummingbird Exceed from X-Win32.
I picked most of the default answers during the install.
Except, for CHARACTERSET, I picked UTF8 rather than WE8ISO8859P1.
It took a couple of hours to run.
I added SET TIME ON to end of glogin.sql
I logged into scott/tiger:
$ . .X9
$ sqlplus scott/tiger
SQL*Plus: Release 9.0.1.0.0 - Production on Tue Mar 26 18:16:56 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
18:16:57 SQL> SELECT * FROM TAB;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
EMP TABLE
SALGRADE TABLE
18:17:40 SQL> EXIT
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
$
I logged into SYS:
$ sqlplus
SQL*Plus: Release 9.0.1.0.0 - Production on Tue Mar 26 18:20:41 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: sys/change_on_install as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
18:20:48 SQL>
I changed the default passwords of SYS and SYSTEM:
18:20:48 SQL> alter user sys identified by sfo2sjc;
User altered.
18:21:42 SQL> connect sys/sfo2sjc as sysdba
Connected.
18:21:54 SQL>
18:21:54 SQL> alter user system identified by sfo2sjc9;
User altered.
18:22:52 SQL>
18:22:52 SQL> EXIT
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
$
I checked the process listing:
ps -ef|grep oracle|sort
oracle 14763 14556 0 01:33:30 pts/4 0:00 /bin/sh ./X9.csh
oracle 14764 14763 0 01:33:30 pts/4 0:00 /bin/csh
oracle 23555 1 0 03:46:49 ? 0:01 /oracle/app/oracle/product/X9/Apache/Apache/bin/httpd -d /oracle/app/oracle/pro
oracle 23565 23555 0 03:46:51 ? 0:00 /oracle/app/oracle/product/X9/Apache/Apache/bin/httpd -d /oracle/app/oracle/pro
oracle 23566 23555 0 03:46:52 ? 0:00 /oracle/app/oracle/product/X9/Apache/Apache/bin/httpd -d /oracle/app/oracle/pro
oracle 23567 23555 0 03:46:52 ? 0:00 /oracle/app/oracle/product/X9/Apache/Apache/bin/httpd -d /oracle/app/oracle/pro
oracle 23568 23555 0 03:46:52 ? 0:00 /oracle/app/oracle/product/X9/Apache/Apache/bin/httpd -d /oracle/app/oracle/pro
oracle 23569 23555 0 03:46:52 ? 0:00 /oracle/app/oracle/product/X9/Apache/Apache/bin/httpd -d /oracle/app/oracle/pro
oracle 23570 23555 0 03:46:52 ? 0:00 /oracle/app/oracle/product/X9/Apache/Apache/bin/httpd -d /oracle/app/oracle/pro
oracle 23571 23565 0 03:46:54 ? 0:02 /oracle/app/oracle/product/X9/Apache/jdk/bin/../bin/sparc/native_threads/java -
oracle 23713 1 0 03:58:05 ? 0:00 ora_pmon_X9
oracle 23715 1 0 03:58:06 ? 0:00 ora_dbw0_X9
oracle 23717 1 0 03:58:06 ? 0:01 ora_lgwr_X9
oracle 23719 1 1 03:58:06 ? 6:11 ora_ckpt_X9
oracle 23721 1 0 03:58:06 ? 0:05 ora_smon_X9
oracle 23723 1 0 03:58:07 ? 0:00 ora_reco_X9
oracle 23725 1 0 03:58:07 ? 0:00 ora_s000_X9
oracle 23727 1 0 03:58:07 ? 0:00 ora_d000_X9
oracle 23729 1 0 03:58:08 ? 0:00 ora_d001_X9
oracle 23731 1 0 03:58:08 ? 0:00 ora_d002_X9
$
I attempted to bounce the Apache webserver:
$ $ORACLE_HOME/Apache/Apache/bin/apachectl
usage: /oracle/app/oracle/product/X9/Apache/Apache/bin/apachectl (start|stop|restart|fullstatus|status|graceful|configtest|help) [-f ]
start - start httpd
startssl - start httpd with SSL enabled
stop - stop httpd
restart - restart httpd if running by sending a SIGHUP or start if
not running
fullstatus - dump a full status screen; requires lynx and mod_status enabled
status - dump a short status screen; requires lynx and mod_status enabled
graceful - do a graceful restart by sending a SIGUSR1 or start if not running
configtest - do a configuration syntax test
help - this screen
-f - Specify a configuration file
$ $ORACLE_HOME/Apache/Apache/bin/apachectl stop
/oracle/app/oracle/product/X9/Apache/Apache/bin/apachectl stop: httpd stopped
$ $ORACLE_HOME/Apache/Apache/bin/apachectl start
/oracle/app/oracle/product/X9/Apache/Apache/bin/apachectl start: httpd could not be started
$
Bummer; it will not start. I'll do some reading on this. Maybe I need to
use -f to specify a config file. Also I'll look at the install log to see
if I can find the syntax which the installer (or root.sh) used to start Apache.
Also it might be related to the fact that another Apache installed under /usr/local
is already running; perhaps it is a contention issue.
Next, I bounced the DB:
$ . .X9
$ sqlplus
SQL*Plus: Release 9.0.1.0.0 - Production on Tue Mar 26 18:44:09 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: sys/sfo2sjc as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
18:44:16 SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
18:44:43 SQL> EXIT
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
$ sqlplus
SQL*Plus: Release 9.0.1.0.0 - Production on Tue Mar 26 18:45:02 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: sys/sfo2sjc as sysdba
Connected to an idle instance.
18:45:05 SQL> startup
ORACLE instance started.
Total System Global Area 235701300 bytes
Fixed Size 279604 bytes
Variable Size 167772160 bytes
Database Buffers 67108864 bytes
Redo Buffers 540672 bytes
Database mounted.
Database opened.
18:45:37 SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
$
Next, I shutdown the DB. I wanted to create a compressed tar ball
which I could burn to cdrom and then untar on another host. Rather
than tar, however, I decided to use cpio which seems to handle large
many layered directory trees better than tar. I've seen tar choke on
ORACLE_HOMEs in the past.
Here is the syntax I used:
cd /
/bin/find oracle -depth -print | /bin/cpio -oc |/bin/gzip -9c > /bikle/9i.cpio.gz
The resulting file looked like this:
-rw-r--r-- 1 oracle dba 1431916809 Mar 26 23:04 9i.cpio.gz
This little beastie is over 1GB.
Darn, a cdrom will only hold about 700MB if I'm lucky.
I'll abandon my plan to put this thing on cdrom. It's almost
as easy to install off of the three Oracle cdroms.
Next, I copied the large file to another host.
scp -p 9i.cpio.gz oracle@bikdev3.bikle.com:/u11/
I unpacked it and then attemped to start the database resident within it...
$ mkdir /u12/oracle
$ cd /
$ ln -s /u12/oracle .
$ gunzip -c /u11/9i.cpio.gz|/bin/cpio -idc
7230831 blocks
$ cd /oracle
I looked to see if any traces of the old host (bikdev2) resided in any of the files I just unpacked:
$ /bin/find . -type f -print | xargs /bin/grep -l bikdev2
I got a few hits in a variety of files:
./app/oracle/admin/X9/bdump/x9_lgwr_23608.trc
./app/oracle/admin/X9/udump/x9_ora_23623.trc
./app/oracle/admin/X9/udump/x9_ora_23648.trc
./app/oracle/admin/X9/udump/x9_ora_23672.trc
./app/oracle/admin/X9/udump/x9_ora_23733.trc
./app/oracle/admin/X9/udump/x9_ora_24088.trc
./app/oracle/product/X9/Apache/Apache/conf/httpd.conf.default
./app/oracle/product/X9/Apache/Apache/conf/httpd.conf
./app/oracle/product/X9/rdbms/audit/ora_23581.aud
./app/oracle/product/X9/rdbms/audit/ora_23602.aud
./app/oracle/product/X9/rdbms/audit/ora_23623.aud
./app/oracle/product/X9/rdbms/audit/ora_23624.aud
./app/oracle/product/X9/rdbms/audit/ora_23647.aud
./app/oracle/product/X9/rdbms/audit/ora_23648.aud
./app/oracle/product/X9/rdbms/audit/ora_23671.aud
./app/oracle/product/X9/rdbms/audit/ora_23672.aud
./app/oracle/product/X9/rdbms/audit/ora_23673.aud
./app/oracle/product/X9/rdbms/audit/ora_23674.aud
./app/oracle/product/X9/rdbms/audit/ora_23675.aud
./app/oracle/product/X9/rdbms/audit/ora_23677.aud
./app/oracle/product/X9/rdbms/audit/s000_23664.aud
./app/oracle/product/X9/rdbms/audit/ora_23703.aud
./app/oracle/product/X9/rdbms/audit/ora_23705.aud
./app/oracle/product/X9/rdbms/audit/ora_23706.aud
./app/oracle/product/X9/rdbms/audit/ora_23707.aud
./app/oracle/product/X9/rdbms/audit/ora_23709.aud
./app/oracle/product/X9/rdbms/audit/ora_23732.aud
./app/oracle/product/X9/rdbms/audit/ora_23733.aud
./app/oracle/product/X9/rdbms/audit/ora_23737.aud
./app/oracle/product/X9/rdbms/audit/ora_23749.aud
./app/oracle/product/X9/rdbms/audit/ora_23968.aud
./app/oracle/product/X9/rdbms/audit/ora_23991.aud
./app/oracle/product/X9/rdbms/audit/ora_23992.aud
./app/oracle/product/X9/rdbms/audit/ora_24062.aud
./app/oracle/product/X9/rdbms/audit/ora_24066.aud
./app/oracle/product/X9/rdbms/audit/ora_24087.aud
./app/oracle/product/X9/rdbms/audit/ora_24088.aud
./app/oracle/product/X9/rdbms/audit/ora_24093.aud
./app/oracle/product/X9/ultrasearch/admin/wk0config.sql
./app/oracle/product/X9/ultrasearch/admin/wk0install.sql
./app/oracle/product/X9/oem_webstage/oem.conf
./app/oracle/product/X9/olap/olapi/bin/olapi.sh
./app/oracle/product/X9/olap/admin/olaphost.sql
./app/oracle/product/X9/olap/admin/olap.cfg
./app/oracle/product/X9/olap/log/OLAPServicesAgent.log
./app/oracle/product/X9/olap/olap.key
./app/oracle/product/X9/olap/.olap.key
./app/oracle/product/X9/ldap/odi/samples/hragent.ldif
./app/oracle/product/X9/network/admin/listener.ora
./app/oracle/product/X9/network/admin/tnsnames.ora
./app/oracle/oraInventory/logs/installActions.log
./app/oracle/oraInventory/Components/oracle.olap.olapi.client/9.0.1.0.0/1/install.log
./app/oracle/oraInventory/Components/oracle.olap.olapi.client/9.0.1.0.0/1/context.ser
$
I used a simple grep-perl filter to batch edit the name of the host in all of the
above files from bikdev2 to bikdev3:
$ /bin/find . -type f -print | xargs /bin/grep -l bikdev2 | xargs perl -e 's/bikdev2/bikdev3/gi' -p -i.bak
Next, I set my env vars and attempted a startup:
$ . .X9
$ sqlplus
ld.so.1: sqlplus: fatal: librt.so.1: open failed: No such file or directory
Killed
Darn, my target host is running an ancient version of Solaris 2.6.
The source host is running 2.8.
I went on a quest for librt.so.1 on the 2.8 box and found it under /usr/lib.
I copied it to the target host:
$ cd /usr
$ cd lib
$ ls librt*
librt.so librt.so.1 librtld.so.1 librtld_db.so librtld_db.so.1
$ tar cf - librt.*|ssh bikdev3 "cd /oracle/app/oracle/product/X9/lib;tar xvf -"
oracle@bikdev3 password:
x librt.so symbolic link to ./librt.so.1
x librt.so.1, 41592 bytes, 82 tape blocks
$
Notice how I put it under /oracle/app/oracle/product/X9/lib rather than under /usr/lib.
I reattempted DB startup:
$ sqlplus
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Mar 27 14:29:06 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: sys/sfo2sjc as sysdba
Connected to an idle instance.
14:29:33 SQL> startup
ORACLE instance started.
Total System Global Area 235701300 bytes
Fixed Size 279604 bytes
Variable Size 167772160 bytes
Database Buffers 67108864 bytes
Redo Buffers 540672 bytes
Database mounted.
Database opened.
14:30:48 SQL>
I like how this looks!
Next, it dawned on me that I needed to create a oratab file on the target host;
I forgot to include it in the cpio file.
I ran these commands on the target host, bikdev3:
mkdir /var/opt/oracle; chown oracle /var/opt/oracle
Then on bikdev2, the source host, I ran this command:
tar cf - /var/opt/oracle|ssh oracle@bikdev3 "cd /; tar xf - "