Installation of Oracle 10g R2 [ 10.2.0.2 ] on Solaris10x86
2006-09-22 Dan Bikle

Frys

I went to Frys and bought a PC they call an open-box special. It's a PC which is discounted because it has been returned by another customer.

For about $500, I bought this type of PC:

HP Pavilion a1340n

It has:

Warranty-wise, the PC was brand new and I was the original owner. At the time (2006) I considered it a good deal.

Also I bought a small Hyundai flat screen monitor for $179.

Windows

The PC came with XP factory-installed. Instead of supplying a DVD, HP put a backup of XP on the first partition. Then, XP was layed out on the rest of my 250G hard-drive. I figured out how to interact with the restore mechanism in case I clobbered XP.

Here is how it is supposed to work.

The PC comes with a utility to backup the XP-backup to DVD.

I discovered that the utility does not work.

In reality, it does work if you choose to backup the XP-backup to CDR.

So, I backed up the XP-backup to 16 (sixteen!) CDRs.

Linux

My HP PC does not like Linux:

  • Fedora Core 5 installed but kernel panicked after I loaded a CDR into either of the DVD trays.
  • Centos 4.4 kernel panicked during initial boot-off-cd.
  • Suse 10.1 died at different random places inside of Yast2.
  • I gave up on Linux.

Oh, during my Linux activities, I clobbered the 2nd disk partition containing XP.

So, I recreated it to a much smaller size and walked through the XP restore gizmo found in the land-of-F10.

It worked great. Which is good; I did not want to feed it 16 CDRs to restore windows-XP.

Now, if I want to run some native windows software (testing IE6 against one of my sites for example), I can boot the much smaller XP-partition and run XP.

FreeBSD

I installed FreeBSD 6.1 on the 3rd partition. My HP PC likes FreeBSD and now, so do I.

The install was painless and unencumbered by any documentation. All I did was feed it 2 CDRs and answer simple networking questions.

I encountered one small problem with FreeBSD on this HP-PC.

X-windows does not work on my FreeBSD console.

I suspect the problem is related to the lack of a proper video card in the PC. The hardware specs state this:

Video Graphics
Integrated with up to 256 MB of allocated video memory

I think that the verb "Integrated" means cheap, and that the PC does not have a proper video card which FreeBSD would have drivers for.

If however, I want to run X-windows on my FreeBSD box and display it on my Mac, I can do that.

This is fine; I don't want a console cluttering my desk.

The next problem with this FreeBSD install is that unfortunately, Oracle does not run natively on FreeBSD.

( If you are clever enough it can be done by fooling Oracle into thinking that it is running on Linux ).

Solaris 10 x86

While poking around on

http://www.oracle.com/technology/software/index.html

I saw that on Sep 18 2006, 10gR2 had been released for Solaris 10 X86.

So I went to sun.com and started a download.

It was just too big and my browser could not eat the whole thing.

So, I tried Sun Download Manager (SDM) on my Mac.

SDM is a Java app which means that I can't paste a URL into its URL window.

My work-around was to use an editor to copy the download URL into the SDM log file.

Then I used SDM to open the log file and then grabbed the URL with a ^c of the mouse and pasted it into the URL window with a ^v.

Eventually I pulled down 5 .iso files and burned them to CDR using my Mac.

The installation was easy; feed CDRs; answer simple networking questions.

Actually, the interface they provide to customize the disk-layout was a little confusing.

I like the FreeBSD interface.

Anyway, I got it so it was like this:


root 10gb
export/home 80gb
swap 1gb

I should have made swap 2gb so that the Oracle installer would not whine later.

During the install, Solaris seemed to recognize my console enough to run X-windows on it.

It showed me some colored ellipses and recognized that I clicked in the correct location during X-window configuration time.

Eventually installation finished.

After the first multi-user boot, Solaris tried to display an X login page on my console.

All I saw was a scramble of random color bits.

I tried to login using a terminal window on my mac.

I could not get into the root account.

So, I power-cycled the PC.

Eventually, I got a login prompt at the console and I logged in as root and added a UNIX user.

This allowed me to login and then su from my Mac if I needed to get in later.

Next, I removed this file so my console would always display a text login:

/etc/rc2.d/S99dtlogin

The only editor available was vi.

So, I added a couple of lines to /etd/dfs/dfstab

share -F nfs /export/home
share -F nfs /

Then I ran the above lines as shell commands.

I then had NFS access to my Solaris box.

This allowed me to use my favorite editor on my Mac to edit files on my Solaris box.

Next, I edited the Grub menu so I could boot FreeBSD on the PC.

I edited this:

/boot/grub/menu.lst

I added this: 

title FreeBSD 6.1
  root (hd0,2,a)
  kernel /boot/loader
The above entry corresponds to this disk layout:
  • 0 -XP backup
  • 1 -XP
  • 2 -FreeBSD 6.1
  • 3 -Solaris 10
Here is what I have now in /boot/grub/menu.lst : 
title FreeBSD 6.1
  root (hd0,2,a)
  kernel /boot/loader

#---------- ADDED BY BOOTADM - DO NOT EDIT ----------
title Solaris 10 6/06 s10x_u2wos_09a X86
root (hd0,3,a)
kernel /platform/i86pc/multiboot
module /platform/i86pc/boot_archive
#---------------------END BOOTADM--------------------
#---------- ADDED BY BOOTADM - DO NOT EDIT ----------
title Solaris failsafe
root (hd0,3,a)
kernel /boot/multiboot kernel/unix -s
module /boot/x86.miniroot-safe
#---------------------END BOOTADM--------------------

title Windows
        rootnoverify (hd0,0)
        chainloader +1

title Windows
        rootnoverify (hd0,1)
        chainloader +1
This Grub layout will affect my PC so that FreeBSD 6.1 will boot by default since it is the first OS in the list.

At this point I feel good about Solaris 10. Linux will not install on my PC and Solaris 10 will install. The Solaris x86 people at Sun.com should be proud.

To complete the install of Solaris 10 I ran this shell command: 

ln -s /export/home /h
Which should save me some typing in the future.

Oracle 10gR2 [ 10.2.0.2 ] installation on Solaris 10 x86

I downloaded the big .zip file from here:

http://www.oracle.com/technology/software/products/database/oracle10g/index.html

I unzipped it.

I created 2 groups:

  • dba
  • oinstall

I created the oracle user and listed it in the oinstall group entry.

I created a .bashrc for oracle: 

# .bashrc

umask 022

export PATH=/usr/bin:/bin:/usr/local/bin:.:/sbin:/usr/sbin:/opt/bin:/usr/X11R6/bin:/usr/ccs/bin:/etc:/usr/openwin/bin
export LD_LIBRARY_PATH=:/usr/lib:/lib:/usr/local/lib:/usr/X11R6/lib:/usr/dt/lib

export ORACLE_SID=orcl
export ORACLE_BASE=/h/oracle
export ORACLE_HOME=${ORACLE_BASE}/product/10r2

export NLS_DATE_FORMAT=YYYY/MM/DD:HH24:MI:SS
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${ORACLE_HOME}/lib
export PATH=${PATH}:${ORACLE_HOME}/bin

export TERM=vt100

# Nice bash shell prompt from google
export PS1='\s \h \u \w \# \$ '

# some aliases
alias ls='ls -CFa'
alias al=alias
alias d=date
alias cx='chmod +x'
alias grip='grep -i'
alias grp=grip
alias alg='alias|grp'
alias envg='env|grp'
alias ll='ls -l'
alias m=more
alias ltr='ls -latr'
alias psor='/bin/ps -ef |sort'
alias psorg='psor|grp'
alias dspmac='export DISPLAY=mac:0'

I looked at the installation guide.

I did this: 

bash sol oracle ~ $
bash sol oracle ~ $
bash sol oracle ~ $  /usr/sbin/prtconf|grp mem
Memory size: 960 Megabytes
bash sol oracle ~ $
bash sol oracle ~ $
bash sol oracle ~ $

bash sol oracle ~ $
bash sol oracle ~ $
bash sol oracle ~ $ /usr/sbin/swap -s
total: 104996k bytes allocated + 16720k reserved = 121716k used, 1644004k available
bash sol oracle ~ $
bash sol oracle ~ $
bash sol oracle ~ $

bash sol oracle ~ $
bash sol oracle ~ $
bash sol oracle ~ $  df -k /tmp
Filesystem            kbytes    used   avail capacity  Mounted on
swap                 1642216      36 1642180     1%    /tmp
bash sol oracle ~ $
bash sol oracle ~ $
bash sol oracle ~ $

Next, I bumped into something: 


bash sol oracle ~ $
bash sol oracle ~ $
bash sol oracle ~ $ /bin/isainfo -kv
64-bit amd64 kernel modules
bash sol oracle ~ $
bash sol oracle ~ $
bash sol oracle ~ $
I want this: 32-bit i386 kernel modules

The oracle doc says,

"If you do not see the expected output, then you cannot install the software on this system."

Not good; I decided to press on and ignore this problem.

Next... 

  /usr/sbin/patchadd -p | grep 118345
  /usr/sbin/patchadd -p | grep 119961

Passed.

Next,

As root, run this: 

projmod -sK "project.max-shm-memory=(privileged, 2G,deny)" group.dba

That is WRONG!

It is an Oracle doc bug.

Google gave me this: 

bash sol root / 6 # projmod -s -K "project.max-shm-memory=(priv,2gb,deny)" group.dba
bash sol root / 7 # cat /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
group.dba:100:Oracle default:::project.max-shm-memory=(priv,2147483648,deny)
bash sol root / 8 #
then 
shutdown -y -g0 -i6
to reboot.

Then, 

bash sol oracle ~ 1 $ id -p
uid=1000(oracle) gid=100(dba) projid=100(group.dba)

Next, on the mac, start X windows.

Then, 

ssh -X oracle@sol

cd cdrom/database
./runInstaller
It complains a lot then quits.

I tried this: 

./runInstaller -ignoresysprereqs

Installer appears on my Mac but seems injured; it can't display stuff it needs to and does not know where my mouse is.

I tried the silent install... 


bash sol oracle ~/cdrom/database 21 $ ./runInstaller -force -ignoresysprereqs -silent -responseFile /h/oracle/cdrom/database/response/enterprise.rsp ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=OH1
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be 5.10.    Actual 5.10
                                      Passed

Checking Temp space: must be greater than 250 MB.   Actual 1372 MB    Passed
Checking swap space: must be greater than 500 MB.   Actual 1709 MB    Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2006-09-21_09-38-10PM. Please wait ...bash sol oracle ~/cdrom/database 22 $ Oracle Universal Installer, Version 10.2.0.2.0 Production
Copyright (C) 1999, 2006, Oracle. All rights reserved.

You can find a log of this install session at:
 /h/oracle/oraInventory/logs/installActions2006-09-21_09-38-10PM.log
.................................................................................................... 100% Done.


Loading Product Information
................................................................................................................... 100% Done.


Analyzing dependencies
........................................................................
Starting execution of Prerequisites...
Total No of checks: 9

Performing check for CertifiedVersions
Checking operating system requirements ...
Expected result: One of 5.10
Actual Result: 5.10
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for Packages
Checking operating system package requirements ...
Checking for SUNWbtool; found CCS tools bundled with SunOS(SUNWbtool).  Passed
Checking for SUNWarc; found Lint Libraries (usr)(SUNWarc).        Passed
Checking for SUNWhea; found SunOS Header Files(SUNWhea).  Passed
Checking for SUNWlibm; found Math & Microtasking Library Headers & Lint Files (Usr)(SUNWlibm).    Passed
Checking for SUNWlibms; found Math & Microtasking Libraries (Usr)(SUNWlibms).     Passed
Checking for SUNWsprot; found Solaris Bundled tools(SUNWsprot).   Passed
Checking for SUNWtoo; found Programming Tools(SUNWtoo).   Passed
Checking for SUNWi1of; found ISO-8859-1 (Latin-1) Optional Fonts(SUNWi1of).       Passed
Checking for SUNWi1cs; found Not found.   Failed <<<<
Checking for SUNWi15cs; found Not found.     Failed <<<<
Checking for SUNWxwfnt; found X Window System platform required fonts(SUNWxwfnt).    Passed
Check complete. The overall result of this check is: Failed <<<<


Check complete: Failed <<<<
Problem: Some packages required for the Oracle Database 10g to function properly are missing (see above).
Recommendation: Install the required packages before continuing with the installation.

=======================================================================
Performing check for Kernel
Checking kernel parameters
Checking for BIT_SIZE=32; found BIT_SIZE=64.        Passed
Checking for shmsys:shminfo_shmmax=4294967295; found no entry.    Failed <<<<
Checking for shmsys:shminfo_shmmni=100; found no entry.      Failed <<<<
Checking for semsys:seminfo_semmni=100; found no entry.      Failed <<<<
Checking for semsys:seminfo_semmsl=256; found no entry.      Failed <<<<
Check complete. The overall result of this check is: Failed <<<<

Check complete: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.

=======================================================================
Performing check for TotalMemory
Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 956MB
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for SwapSpace
Checking available swap space requirements ...
Expected result: 1434MB
Actual Result: 1231MB
Check complete. The overall result of this check is: Failed <<<<


Check complete: Failed <<<<
Problem: The system does not have the required swap space.
Recommendation: Make more swap space available to perform the install.

=======================================================================
Performing check for OracleBase
Validating ORACLE_BASE location (if set) ...
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for OracleHomeSpace
Checking Oracle Home path for spaces...
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for DetectAnyInvalidASMHome
Checking for proper system clean-up....
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for CompatibilityChecks
Checking for Oracle Home incompatibilities ....
Actual Result: NEW_HOME
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
PrereqChecks complete

........................................... 100% Done.
v

-----------------------------------------------------------------------------
Summary
Global Settings
    Source: /export/home/oracle/cdrom/database/stage/products.xml
    Oracle Home: /h/oracle/product/10r2 (OH1)
    Installation Type: Enterprise Edition
Product Languages
   English
Space Requirements
   /export/home/ Required 1.39GB : Available 80.44GB
   /tmp/ Required 108MB (only as temporary space) : Available 1.19GB
New Installations (106 products)
   Oracle Database 10g 10.2.0.2.0
   Enterprise Edition Options 10.2.0.1.0
   Oracle Partitioning 10.2.0.2.0
   Oracle Spatial 10.2.0.1.0
   Oracle OLAP 10.2.0.2.0
   Oracle Enterprise Manager Console DB 10.2.0.2.0
   Oracle Net Services 10.2.0.1.0
   Oracle Database 10g 10.2.0.2.0
   Oracle Net Listener 10.2.0.2.0
   HAS Files for DB 10.2.0.2.0
   Oracle Internet Directory Client 10.2.0.2.0
   Oracle Call Interface (OCI) 10.2.0.2.0
   Oracle Programmer 10.2.0.1.0
   Oracle interMedia 10.2.0.2.0
   Enterprise Manager Agent Core 10.2.0.1.0
   Oracle JVM 10.2.0.2.0
   Database Configuration and Upgrade Assistants 10.2.0.2.0
   Oracle interMedia Locator 10.2.0.2.0
   Oracle XML Development Kit 10.2.0.2.0
   Oracle Text 10.2.0.2.0
   Oracle Database Utilities 10.2.0.2.0
   Generic Connectivity Common Files 10.2.0.2.0
   Oracle Advanced Security 10.2.0.2.0
   Enterprise Manager Repository Core 10.2.0.1.0
   PL/SQL 10.2.0.2.0
   Oracle Net 10.2.0.2.0
   Assistant Common Files 10.2.0.2.0
   Buildtools Common Files 10.2.0.1.0
   Installation Common Files 10.2.0.2.0
   Oracle LDAP administration 10.2.0.1.0
   Oracle Java Client 10.2.0.2.0
   Precompiler Common Files 10.2.0.2.0
   HAS Common Files 10.2.0.2.0
   Oracle Recovery Manager 10.2.0.2.0
   iSQL*Plus 10.2.0.2.0
   Enterprise Manager plugin Common Files 10.2.0.2.0 Beta
   SQL*Plus 10.2.0.2.0
   Oracle RAC Required Support Files-HAS 10.2.0.2.0
   Oracle Clusterware RDBMS Files 10.2.0.2.0
   Oracle Wallet Manager 10.2.0.2.0
   Enterprise Manager Minimal Integration 10.2.0.1.0
   Oracle Database User Interface 2.2.13.0.0
   Secure Socket Layer 10.2.0.2.0
   Required Support Files 10.2.0.1.0
   Oracle Globalization Support 10.2.0.2.0
   Database SQL Scripts 10.2.0.2.0
   OLAP SQL Scripts 10.2.0.2.0
   PL/SQL Embedded Gateway 10.2.0.2.0
   Oracle Locale Builder 10.2.0.1.0
   Character Set Migration Utility 10.2.0.2.0
   LDAP Required Support Files 10.2.0.2.0
   Enterprise Manager plugin Common Files 10.2.0.1.0
   Oracle JDBC Thin Driver for JDK 1.4 10.2.0.2.0
   Oracle JDBC Thin Driver for JDK 1.2 10.2.0.2.0
   Oracle interMedia Client Option 10.2.0.2.0
   Oracle Notification Service 10.1.0.3.0
   Oracle Code Editor 1.2.1.0.0I
   Perl Interpreter 5.8.3.0.2
   JDBC Common Files 10.2.0.1.0
   Oracle Help For Java 4.2.6.1.0
   Oracle Containers for Java 10.2.0.1.0
   Database Workspace Manager 10.2.0.1.0
   Oracle Core Required Support Files 10.2.0.2.0
   Platform Required Support Files 10.2.0.1.0
   Oracle interMedia Locator RDBMS Files 10.2.0.2.0
   Oracle JDBC/OCI Instant Client 10.2.0.2.0
   Oracle interMedia Annotator 10.2.0.1.0
   SQLJ Runtime 10.2.0.2.0
   Oracle interMedia Java Advanced Imaging 10.2.0.2.0
   Oracle Database 10g interMedia Files 10.2.0.2.0
   Oracle Data Mining RDBMS Files 10.2.0.2.0
   Enterprise Manager Baseline 10.2.0.2.0
   Oracle Ice Browser 5.2.3.6.0
   Oracle Help for the  Web 1.1.10.0.0
   XML Parser for Java 10.2.0.2.0
   Precompiler Required Support Files 10.2.0.2.0
   XML Parser for Oracle JVM 10.2.0.2.0
   Oracle Message Gateway Common Files 10.2.0.1.0
   Oracle Starter Database 10.2.0.2.0
   Sample Schema Data 10.2.0.2.0
   Parser Generator Required Support Files 10.2.0.1.0
   Agent Required Support Files 10.2.0.2.0
   Oracle JFC Extended Windowing Toolkit 4.2.33.0.0
   RDBMS Required Support Files 10.2.0.2.0
   RDBMS Required Support Files for Instant Client 10.2.0.2.0
   XDK Required Support Files 10.2.0.2.0
   Oracle OLAP API 10.2.0.2.0
   Oracle OLAP RDBMS Files 10.2.0.2.0
   DBJAVA Required Support Files 10.2.0.2.0
   SQL*Plus Required Support Files 10.2.0.2.0
   Oracle UIX 2.1.22.0.0
   Oracle Extended Windowing Toolkit 3.4.38.0.0
   Oracle Display Fonts 9.0.2.0.0
   Enterprise Manager Common Files 10.2.0.1.0
   Enterprise Manager Agent DB 10.2.0.2.0
   Oracle Net Required Support Files 10.2.0.2.0
   Enterprise Manager Repository DB 10.2.0.2.0
   regexp 2.1.9.0.0
   SSL Required Support Files for InstantClient 10.2.0.2.0
   Bali Share 1.1.18.0.0
   Oracle Universal Installer 10.2.0.2.0
   Oracle One-Off Patch Installer 10.2.0.2.0
   Installer SDK Component 10.2.0.2.0
   Java Runtime Environment 1.4.2.0.0
   Sun JDK 1.4.2.0.8
   Sun JDK extensions 10.1.2.0.0
-----------------------------------------------------------------------------


Installation in progress (Thu Sep 21 21:38:30 PDT 2006)
...............................................................  11% Done.
...............................................................  22% Done.
...............................................................  33% Done.
...............................................................  44% Done.
...............................................................  55% Done.
......                                                           56% Done.
Install successful

Linking in progress (Thu Sep 21 21:41:11 PDT 2006)
..                                                               56% Done.
Link successful

Setup in progress (Thu Sep 21 21:43:20 PDT 2006)
.......................                                         100% Done.
Setup successful

End of install phases.(Thu Sep 21 21:43:29 PDT 2006)
Starting to execute configuration assistants
Configuration assistant "Oracle Net Configuration Assistant" succeeded
Configuration assistant "Oracle Database Configuration Assistant" succeeded
Configuration assistant "iSQL*Plus Configuration Assistant" succeeded
WARNING:A new inventory has been created in this session. However, it has not yet been registered as the central inventory of this system.
To register the new inventory please run the script '/h/oracle/oraInventory/orainstRoot.sh' with root privileges.
If you do not register the inventory, you may not be able to update or patch the products you installed.
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root script to run
/h/oracle/oraInventory/orainstRoot.sh
/h/oracle/product/10r2/root.sh
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts

The installation of Oracle Database 10g was successful.
Please check '/h/oracle/oraInventory/logs/silentInstall2006-09-21_09-38-10PM.log' for more details.

bash sol oracle ~/cdrom/database 22 $

So, I went to a root window and ran the shell scripts.

Then, I returned... 

bash sol oracle ~/cdrom/database 22 $ psorg orac
  oracle  1879  1867   0 20:57:40 ?           0:00 /usr/lib/ssh/sshd
  oracle  1881  1879   0 20:57:40 pts/2       0:00 -bash
  oracle  1888  1881   0 20:57:42 pts/2       0:00 bash
  oracle  1894  1891   0 20:59:01 ?           0:00 /usr/lib/ssh/sshd
  oracle  1896  1894   0 20:59:01 pts/3       0:00 -bash
  oracle  1900  1896   0 20:59:04 pts/3       0:00 bash
  oracle  1970  1967   0 21:07:01 ?           0:01 /usr/lib/ssh/sshd
  oracle  1972  1970   0 21:07:01 pts/4       0:00 -bash
  oracle  1978  1972   0 21:07:03 pts/4       0:00 bash
  oracle  4109     1   0 21:43:33 ?           0:01 /h/oracle/product/10r2/bin/tnslsnr LISTENER -inherit
  oracle  4228     1   0 21:46:26 ?           0:01 ora_pmon_orcl
  oracle  4230     1   0 21:46:26 ?           0:00 ora_psp0_orcl
  oracle  4232     1   0 21:46:26 ?           0:00 ora_mman_orcl
  oracle  4234     1   0 21:46:26 ?           0:00 ora_dbw0_orcl
  oracle  4236     1   0 21:46:26 ?           0:01 ora_lgwr_orcl
  oracle  4238     1   0 21:46:26 ?           0:01 ora_ckpt_orcl
  oracle  4240     1   0 21:46:26 ?           0:01 ora_smon_orcl
  oracle  4242     1   0 21:46:26 ?           0:00 ora_reco_orcl
  oracle  4244     1   0 21:46:26 ?           0:01 ora_cjq0_orcl
  oracle  4246     1   0 21:46:26 ?           0:01 ora_mmon_orcl
  oracle  4248     1   0 21:46:26 ?           0:01 ora_mmnl_orcl
  oracle  4250     1   0 21:46:26 ?           0:00 ora_d000_orcl
  oracle  4252     1   0 21:46:26 ?           0:00 ora_s000_orcl
  oracle  4256     1   0 21:46:34 ?           0:00 ora_qmnc_orcl
  oracle  4267     1   0 21:46:44 ?           0:00 ora_q000_orcl
  oracle  4269     1   0 21:46:45 ?           0:00 ora_q001_orcl
  oracle  4371     1   0 21:47:40 pts/2       0:07 /h/oracle/product/10r2/jdk/bin/java -Djava.awt.headless=true -Doracle.oc4j.loca
  oracle  5312     1   0 22:09:59 ?           0:00 ora_j000_orcl
  oracle  5690  1888   0 22:18:21 pts/2       0:00 /bin/ps -ef
  oracle  5691  1888   0 22:18:21 pts/2       0:00 sort
  oracle  5692  1888   0 22:18:21 pts/2       0:00 grep -i orac
bash sol oracle ~/cdrom/database 23 $


bash sol oracle ~ 1 $ envg orac
USER=oracle
LD_LIBRARY_PATH=:/usr/lib:/lib:/usr/local/lib:/usr/X11R6/lib:/usr/dt/lib:/h/oracle/product/10r2/lib
ORACLE_SID=orcl
ORACLE_BASE=/h/oracle
PATH=/usr/bin:/bin:/usr/local/bin:.:/sbin:/usr/sbin:/opt/bin:/usr/X11R6/bin:/usr/ccs/bin:/etc:/usr/openwin/bin:/h/oracle/product/10r2/bin
MAIL=/var/mail//oracle
PWD=/h/oracle
HOME=/h/oracle
LOGNAME=oracle
ORACLE_HOME=/h/oracle/product/10r2
bash sol oracle ~ 2 $ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Sep 21 22:21:44 2006

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>
SQL>

The SQL prompt does not lie.

It appears that I have just installed Oracle 10gR2 [ 10.2.0.2 ] on Solaris 10 x86.

I'm worried though.

During installation, the complaint about the kernel parameters is worrisome; maybe it's an Oracle bug; maybe I need to investigate the projmod command and Solaris 10 kernel parameters.

Next, I wanted to try out OEM dbconsole.

I tried the magic URL:

http://sol:1158/em/

I found nothing there.

I tried starting it with: 

emctl start dbconsole
This time the URL sent an ugly 500 error to my browser. I shutdown OEM: 
emctl stop dbconsole
I checked the logfile: 
bash sol oracle ~/product/10r2/sol_orcl/sysman/log 46 $ tail -44 emagent.trc
I see: 
2006-09-22 22:06:41 Thread-63 ERROR engine: [oracle_database,orcl,Response] :
nmeegd_GetMetricData failed : ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)

I tried sqlplus sysman/sysman It gave me a ORA-01017 I did:

  • ALTER USER SYSMAN IDENTIFIED BY SYSMAN;
  • cd $ORACLE_HOME/host_sid/sysman/config
  • Backup the file emoms.properties
  • vi the file emoms.properties
  • Find the line beginning with: oracle.sysman.eml.mntr.emdRepPwd=
  • Enter the un-encrypted password which is SYSMAN
  • Find this line oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
  • Change TRUE by FALSE

Then, 

bash sol oracle ~/product/10r2/sol_orcl/sysman/config 7 $ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://sol:1158/em/console/aboutApplication
Agent Version     : 10.1.0.4.1
OMS Version       : Unknown
Protocol Version  : 10.1.0.2.0
Agent Home        : /h/oracle/product/10r2/sol_orcl
Agent binaries    : /h/oracle/product/10r2
Agent Process ID  : 7463
Parent Process ID : 1
Agent URL         : http://sol:3938/emd/main
Started at        : 2006-09-22 22:22:30
Started by user   : oracle
Last Reload       : 2006-09-22 22:22:30
Last successful upload                       : (none)
Last attempted upload                        : (none)
Total Megabytes of XML files uploaded so far :     0.00
Number of XML files pending upload           :       50
Size of XML files pending upload(MB)         :     4.31
Available disk space on upload filesystem    :    94.45%
Agent is already started. Will restart the agent
Stopping agent ... stopped.
Starting Oracle Enterprise Manager 10g Database Control ......................... started.
------------------------------------------------------------------
Logs are generated in directory /h/oracle/product/10r2/sol_orcl/sysman/log
bash sol oracle ~/product/10r2/sol_orcl/sysman/config 8 $

Then,

http://sol:1158/em/

It gave me a login screen.

I ran to a terminal and did this: 

ALTER USER SYSTEM IDENTIFIED BY MGR;

I entered SYSTEM/MGR in the web page.

I logged in.

Next, I navigated to the 'Monitoring Configuration' link at the bottom of the 'Database' page. There, I specified the new password of the DBSNMP user ( which I had just changed with sqlplus ).

OEM now works as I expect.

Next, I started isqlplus: 

bash sol oracle ~ 46 $
bash sol oracle ~ 46 $
bash sol oracle ~ 46 $ $ORACLE_HOME/bin/isqlplusctl start

iSQL*Plus 10.2.0.2.0
Copyright (c) 2003, 2005, Oracle.  All Rights Reserved.
iSQL*Plus instance on port 5560 is already running ...
bash sol oracle ~ 47 $
bash sol oracle ~ 47 $

I tried the URL

http//sol:5560/isqlplus

It worked great.