Bikle.com

Ajax Demo:

Plain HTML
(no Ajax here):

of URLs:

2006-09-22 Bikle ------------------------ This file contains some notes from my efforts to install 10gR2 [ 10.2.0.2 ] on Solaris10x86. 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: HP Pavilion a1340n It has 1G RAM, 250G HD, 1 R-W DVD drive and 1 R-O DVD drive. CPU: Intel(R) Pentium(R) 4 CPU 2.66GHz

Warranty-wise, the PC was brand new and I was the original owner. 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. The PC comes with a utility to backup the XP-backup to DVD. The utility does not work. It does work though if you choose to backup the XP-backup to CDR. So, I backed up the XP-backup to 16 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. During my Linux activities, I clobbered the 2nd disk partition containing XP. I recreated it to a much smaller size and walked through the XP restore gizmo found in the land of F10. It worked great. Now if I want to surf the information highway without a helmet, I can boot XP and do it. 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. X-windows does not work on my FreeBSD console. 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. 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

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 powercycled 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 had a good feeling 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:

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. ./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; I did this: 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.

Installation of Oracle 10g R2 [ 10.2.0.2 ] on Solaris10x86