Prospect® for Motorola CDMA/EVDO 8.0.7
Interim Fix 9
(8.0.7.9)
Description
Prospect®
for Motorola CDMA/EVDO 8.0.7.9
is an Interim Fix for Prospect® for Motorola CDMA/EVDO 8.0.7. It is a cumulative
interim fix and includes all of the content from previous Prospect® for
Motorola CDMA/EVDO 8.0.7
interim fixes.
Check you have installed on
your system one of the versions required as prerequisite, by running the show_installed command. You should be at least on version 8.0.7.1
before applying this interim fix.
This patch introduces the solutions for IZ95610, IZ95945, IZ91662, IZ96340, IZ95489, IZ96004, IZ96959
and IZ99042.
This is documented in the
Prospect® Administration Guide available on the IBM
Tivoli Netcool Information Center.
Readme
file for: Prospect®
for Motorola CDMA/EVDO 8.0.7
Interim Fix 9
[Server: Build 3]
Product/Component Release: 8.0.7
Update Name: 8.0.7
Interim Fix 9
(8.0.7.9)
Fix ID: 8.0.7-PROSPECT-IF0009
Publication Date: 3
June 2011
Last Modified Date: 02 June 2011
Contents
Installation
Privileges Required
Pre Upgrade
Installation Steps
Post-Upgrade
Installation Instructions
Installing the
Prospect® Client
Setting
limit/restriction on historical data for BH computation
Reporting on the Server Status
Stopping Database
Activity to Enable Upgrade
Dataloading on
Multi Instance Installation
Installing the Prospect client on Microsoft Windows 7
How-to install the Prospect client with Windows 7 UAC
security option disabled.
Copyright and
Trademark Information
Download Prospect® for
Motorola CDMA/EVDO 8.0.7
Interim Fix 9
from the following location:
ftp://ftp.software.ibm.com/software/tivoli_support/patches/patches_8.0.7/8.0.7-PROSPECT-IF0009/
or access the fix from the table below.
Below is a list of
components, platforms, and file names that apply to this readme file.
Product/Component Name: |
Platform: |
File: |
Prospect Server |
Solaris |
|
Prospect Client |
Windows |
Network Timeouts
If your system has a security policy in place such that a session is
disconnected after a lengthy period of inactivity, you should disable this
setting before the upgrade starts.
There is a
possibility that the upgrade can take a while to run. Since there is no user
input required during the upgrade, this can make the session appears idle. If
timeouts are not disabled, the upgrade terminal could be disconnected during
the upgrade.
Please find the latest supported platforms in below:
·
Prospect® for Motorola CDMA/EVDO 8.0.7.1 or later[1]
·
Java SDK 1.5.0_17
·
Oracle 10g 10.2.0.4 or Oracle 11g 11.2.0.1
Note:
Ensure that you have sufficient file system free space to download, extract and
install the patch.
Prospect®
for Motorola CDMA/EVDO 8.0.7
Interim Fix 9
from cannot be uninstalled. Back up the Prospect® for Motorola CDMA/EVDO system,
including the Oracle schema before you proceed with the upgrade.
Privilege |
Required |
Oracle flexpm user DBA role |
No |
Root privilege required |
No |
Oracle sys user password set to default (change_on_install) |
No |
UNIX flexpm account is part of dba group |
Yes |
This
interim fix is installed via the wminstall command.
Note: By
default, during a product upgrade, wminstall performs the ps-mgr stop all
command, which allows all currently running reports, maintenance jobs, loader
jobs to complete before shutting down. To shorten the amount of time that the
Prospect® for Motorola CDMA/EVDO server is down for an upgrade, you can specify
for wminstall to perform the ps-mgr halt command instead, which forces the
middleware to shut down immediately, and causes any currently-running reports,
maintenance jobs, and loader jobs to fail. In this case, the user is
responsible for ensuring the correct termination of processes and the release
of shared resources.
To request
that only a “halt” is performed, move the spec.xml file to a local
directory and change the following statement in the spec.xml file, which is
currently set to “stop all”:
<PRE_INSTALL
language="java">middleware_down_up -e</PRE_INSTALL>
to the
following:
<PRE_INSTALL
language="java">middleware_down_up -h</PRE_INSTALL>
In either
case, the upgrade process automatically restarts the product.
Version 4.0.5-GA of JBoss is a
prerequisite for this upgrade. Download
the JBoss installation zip file from the following location: http://www.jboss.org/jbossas/downloads[2] (but do not extract the files). You need to know the directory name
where the JBoss zip file is located, as this is used as the JBOSS_ZIP_DIR when running the upgrade.
If the
Prospect® for Motorola CDMA/EVDO Instance is accessed via prospect web disable
access to its remote datasource in Prospect® for Motorola CDMA/EVDO Web using
the Prospect® Web Admin Tool.
The upgrade
may abort due to database activity, i.e., open Oracle sessions other than the
upgrade session. This is normal intended behaviour and will leave the system in
a consistent pre-upgrade state. Partition Maintenance jobs will give rise to
this. Stopping Database
Activity to Enable Upgrade describes how to deal with Database Activity prior
to an upgrade.
Install Oracle 10g (Version 10.2.0, 32-bit)
Client software. When installing Oracle Client, use
the following directories:
ORACLE_BASE
-> /u01/apps/oracle_client
ORACLE_HOME
-> /u01/apps/oracle_client/product/10.2.0
Download the Oracle 10g client
installation file from My Oracle Support (formerly
OracleMetaLink) at https://support.oracle.com/
10gr2_client_sol.cpio
Note: Perform the
installation using oracle user permissions. Do not run the Oracle Universal Installer (OUI)
as root.
To install Oracle 10g Client, perform
the following procedures:
1.
Install
Oracle 10g Client
2.
Install
Oracle 10g Client Patches
3.
Post
Installation Oracle 10g Client
Before You Begin
This installation procedure assumes that you have already prepared the server as described in the preceding sections:
Install Oracle 10g Client
The Installer is a Java-based
interface that uses the X Window system. Use a workstation with an X Window
display, not a console. Start the Installer according to the following
procedure.
To start the
Oracle Installer
1. Use the following commands on the X session host to enable access to the X Window server.
$ xhost +
Note: Please make sure that the xhost command is available in your PATH environment variable. For Solaris, include /usr/openwin/bin in the PATH.
2. Use telnet or rlogin to log on to the database server host. Use the IBM Prospect Oracle logon account:
$ rlogin
'hostname' -l oracle
Substitute
the appropriate server name for hostname.
3. Set the DISPLAY variable so that the
Installer can access the X Window server:
$ export
DISPLAY ; DISPLAY='hostname':0.0
Substitute
the appropriate display hostname.
4.
Copy the install package 10gr2_client_sol.cpio into a
temporary directory, not the one that oracle is going to be installed in. For
example, /u01/oinstall
5. Unpack the installation package:
cpio
-icvdu < 10gr2_client_sol.cpio
6. Export ORACLE environment variable
export
ORACLE_BASE=/u01/apps/oracle_client
export
ORACLE_HOME=/u01/apps/oracle_client/product/10.2.0
7. Run the Installer in the background by using the ampersand (&).
./runInstaller
&
This
allows the command shell to accept additional commands. After running some
initial checks, the Java client launches which configures and begins the
installation.
8.
On the WELCOME screen, click NEXT.
9.
On the SELECT INSTALLATION TYPE window, select the ADMINISTRATOR option and click NEXT.
10. The SPECIFY HOME DETAILS window appears. Enter the following details:
Name: client_10g
Path: /u01/apps/oracle_client/product/10.2.0
Click
NEXT.
11. Correct any reported errors on the PRODUCT-SPECIFIC PREREQUISITE CHECKS window, and click NEXT.
12. On the
SUMMARY window, click INSTALL.
13. On the next
ORACLE NET CONFIGURATION ASSISTANT window, select PERFORM TYPICAL CONFIGURATION check box and click NEXT.
14. Click
NEXT on the WELCOME window.
15. Click FINISH after the ORACLE NET CONFIGURATION ASSISTANT: DONE window is displayed.
16. Log in as root and verify that the following environment variables are set:
ORACLE_OWNER =
oracle
ORACLE_HOME =
/u01/apps/oracle_client/product/10.2.0
Then, execute the following script:
/u01/apps/oracle_client/product/10.2.0/root.sh
Choose Y if the prompt displays “dbhome”, “oraenv” or “coraenv” already exist.
17. Click
OK,
after
running
the above script.
18. Click
EXIT when the installation is
complete.
Install Oracle 10g Client Patches
This section details changes that must be made at the client
level to apply the Oracle supplied
10g patch for 10.2.0.4.
Download below 10g patch file for
Solaris from My Oracle Support (formerly OracleMetaLink) at https://support.oracle.com/
p6810189_10204_Solaris-64.zip
To
start the Oracle Installer
1.
Use the following commands on the X session
host to enable access to the X Window server.
$ xhost +
Note:
Please
make sure that the
xhost
command is available in your
PATH environment variable. For Solaris, include /usr/openwin/bin in the PATH.
2.
Use telnet or rlogin to log on to the database server host. Use
the IBM Prospect Oracle logon account:
$ rlogin
'hostname' -l oracle
Substitute the appropriate server name for hostname.
3. Set the DISPLAY variable so that the Installer
can access the X Window server:
$
export DISPLAY ; DISPLAY='hostname':0.0
Substitute the appropriate
display hostname.
4.
Copy the install package p6810189_10204_Solaris-64.zip into a temporary directory, not the one
that oracle is going to be installed in. For example, /u01/oinstall
5.
Unpack the installation package:
$
unzip p6810189_10204_Solaris-64.zip
6.
Export ORACLE environment variable
export
ORACLE_BASE=/u01/apps/oracle_client
export
ORACLE_HOME=/u01/apps/oracle_client/product/10.2.0
export
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
7.
Run the Installer
$ cd Disk1
$ ./runInstaller
8.
On the WELCOME screen, click NEXT.
9.
On the SPECIFY HOME DETAILS screen, select the name of the Oracle home
that you want to update, or select the Path that you
want to update, and then click
NEXT.
10. Correct
any reported errors on the
PRODUCT-SPECIFIC PREREQUISITE CHECKS screen, and click
NEXT.
11. On
the
REGISTRATION screen, click NEXT.
12. On
the
SUMMARY screen, click INSTALL.
13. Click EXIT when finished.
Post Installation Oracle
10g Client
Create symbolic link between
Oracle Database and Oracle 10g Client
If Oracle database installed is 10g,
ln -s
/u01/apps/oracle/product/10.2.0/network /u01/apps/oracle_client/network
ln -s
/u01/apps/oracle/product/10.2.0/dbs /u01/apps/oracle_client/product/10.2.0/dbs
ln -s /u01/apps/oracle/admin
/u01/apps/oracle_client/admin
cp
/u01/apps/oracle/product/10.2.0/bin/lsnrctl
/u01/apps/oracle_client/product/10.2.0/bin
If Oracle database installed is 11g,
ln -s
/u01/apps/oracle/product/11.2.0/network /u01/apps/oracle_client/network
ln -s
/u01/apps/oracle/product/11.2.0/dbs /u01/apps/oracle_client/product/10.2.0/dbs
ln -s /u01/apps/oracle/admin
/u01/apps/oracle_client/admin
cp
/u01/apps/oracle/product/11.2.0/bin/lsnrctl
/u01/apps/oracle_client/product/10.2.0/bin
Copy Database network configuration file to Oracle 10g Client
If the installed database is Oracle
11g, run the following command:
$ cp
/u01/apps/oracle/product/11.2.0/network/admin/*ora
/u01/apps/oracle_client/product/10.2.0/network/admin
If the installed database is Oracle
10g, run the following command:
$ cp /u01/apps/oracle/product/10.2.0/network/admin/*ora
/u01/apps/oracle_client/product/10.2.0/network/admin
Note:
This is important as wminstall needs this initial connection, else wminstall will fail.
Change Oracle 10g Client home
directory permission
Run the following command to change
directory permission for the Oracle 10g client:
$ chmod -R 775 /u01/apps/oracle_client
Note:
Failing to do this will make preset_oracle_paths fail.
1.
Log on as user flexpm
2. Source
the Prospect® for Motorola CDMA/EVDO Environment to be upgraded.
If the server is running multiple Prospect schemas or
the profile for the Prospect® for Motorola CDMA/EVDO instance to be upgraded is
not configured to be executed on log in as the flexpm user, then the profile
must be sourced before applying this upgrade. Go to the correct directory where
the Prospect® for Motorola CDMA/EVDO instance to be upgraded is installed and
source the environment.
For example, if Prospect® for Motorola CDMA/EVDO is
installed in /u01/apps/WatchMark/FlexPM/Motorola/ProspectBase
[flexpm] $
cd /u01/apps/WatchMark/FlexPM/Motorola/ProspectBase
[flexpm] $
. ./.profile
Alternately, if a menu system is in place to allow
selection of the Prospect® for Motorola CDMA/EVDO system to be upgraded from a
list of installed Prospect applications, then select the appropriate option to
source the environment.
3.
Create a temporary directory under $FLEXPM_HOME and copy the server
tarball to this location
[flexpm] $ mkdir
$FLEXPM_HOME/tmp
[flexpm] $ cp 8.0.7-PROSPECTMOTODIRECT-IF0009-server.tar.gz $FLEXPM_HOME/tmp
[flexpm] $ cd
$FLEXPM_HOME/tmp
4.
Untar the server tarball
[flexpm] $ gunzip 8.0.7-PROSPECTMOTODIRECT-IF0009-server.tar.gz
[flexpm] $ tar -xvpf 8.0.7-PROSPECTMOTODIRECT-IF0009-server.tar
5.
Run the upgrade command
[flexpm] $ ./wminstall -j
<JBOSS_ZIP_DIR>
Note: It is strongly
recommended to run the previous command with the –preview option before
performing installation to identify potential problems.
[flexpm] $ ./wminstall -j <JBOSS_ZIP_DIR> -preview
The installation of the upgrade
might take a while to complete .You can view the installation progress from the log
file (with filename like <YYYY>__<MM>__<DD>__<HH>__<MM>__<SS>) under /tmp or /var/tmp from
another console during the installation for the installation progress.
Note: When upgrading Prospect® for Motorola CDMA/EVDO, the installation will use the spec.xml file in the same directory as wminstall. Specify the option -spec spec.xml if you changed it (for example to halt only Prospect server before performing installation)
Note: It is also possible to fully automate the upgrade using nohup and the -r <responseFile.txt> option for wminstall.
a.
Read the license
agreement file, license.txt which will be in the $FLEXPM_HOME/tmp directory and make sure you understand the terms and
conditions of the Prospect license.
b.
Edit the response file, responseFile.txt in the $FLEXPM_HOME/tmp directory and find the entry:
LICENSE_ACCEPTANCE = false
c.
Change the entry to the following to indicate that you agree to the
terms and conditions of the Prospect license:
LICENSE_ACCEPTANCE = true
d.
Run the installation by
entering the following commands:
[flexpm]
$ nohup ./wminstall -j <JBOSS_ZIP_DIR> -r $FLEXPM_HOME/tmp/responseFile.txt </dev/null &
The output will look like:
Sending output to nohup.out
The
screen output of the wminstall command will go to $FLEXPM_HOME/tmp/nohup.out. In
addition, the usual install log will be generated in the /var/tmp
directory.
e.
At this point wminstall
is running via nohup. It is now safe to exit the console if you wish to. Type
exit twice to quit from the console:
[flexpm] $
exit
You have running jobs.
[flexpm] $
exit
6.
Examine the Logs
After wminstall has completed, please examine the detail.log under the directory of $FLEXPM_HOME/audit/< YYYY>_<MM>_<DD>_<HH>_<MM>_<SS>_<PID> for any error messages.
Log out and log back in as user flexpm and
re-source the environment using the appropriate procedure as per the Upgrade
Installation Steps above.
Verify that
the middleware started:
[flexpm]
$ ps-mgr watch
If you
disabled access to the Prospect® for Motorola CDMA/EVDO server from Prospect®
Web, then use the admin tool to re-enable access to the corresponding data
source in Prospect® Web.
1.
Copy 8.0.7-PROSPECT-IF0009-client.zip
on your Windows system in a temporary directory.
2.
Unzip 8.0.7-PROSPECT-IF0009-client.zip.
3.
Go to the directory where you unzipped the file and run setup.exe
The
installer creates the necessary system and application files, updates the
system’s registry, and adds entries to Windows START menu.
To
uninstall the Prospect client, use the ADD/REMOVE PROGRAMS component of the
Windows Control Panel.
Some files may
not be removed after un-installation is complete. User is required to remove it
manually if that happens. User can browse to the Program folder usually locates
in C:\Program Files\Vallent\Prospect\Program to verify file existence and
remove it manually if there is any. Otherwise, some of the program components
would not get updated after upgrade installation.
Fixes included in Prospect®
for Motorola CDMA/EVDO 8.0.7.9:
Issue Tracking Number |
Released In |
Resolved Issue |
IZ99042 /
alm00236177 |
8.0.7.9 |
UPGRADE
FROM 807.7 TO 807.8 FAILED |
IZ95610 /
alm00227206 |
8.0.7.9 |
DELETE_INSTANCE.SH
SCRIPT'S LOG FILE CONTAINS WRONG LIST OF ENTITIES |
IZ95945 /
alm00227812 |
8.0.7.9 |
ABLE
SPACE UTILIZATION IS WRONGLY DISPLAYED |
IZ91662 /
alm00223010 |
8.0.7.9 |
WML_*_MAP
TABLES FOR SDU AND VPU ARE EMPTY. |
IZ96340 /
alm00228950 |
8.0.7.9 |
ORACLE
ERRORS WHEN USING IMPORT_DOCS.SH,ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR:
DURING SOFTALARM |
IZ95489 /
alm00227331 |
8.0.7.9 |
ORACLE
ERRORS WHEN USING IMPORT_DOCS.SH,ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR: |
IZ96959 /
alm00229385 |
8.0.7.9 |
ORACLE
ERRORS WHEN USING IMPORT_DOCS.SH, ORA-20111: CANNOT ADD TO A SET OF READ ONLY
RECORDS: DURING NON-EXISTENT USER |
IZ96004 /
alm00227809 |
8.0.7.9 |
CHARACTER
LIMITATION IN FULLKEY DISPLAY IN EXCLUDEFROMFEATURE.SH |
Fixes included in previous
Prospect® for Motorola CDMA/EVDO 8.0.7
Interim Fixes:
Issue Tracking Number |
Released In |
Resolved Issue |
IZ86801 / alm00210523 |
8.0.7.8 |
ERRORS DURING UDC TRANSLATION |
IZ86167 / alm00208047 |
8.0.7.8 |
HEALTHCHECK CONFUSING WHEN AUTO EXTEND IS ON |
IZ89824 / alm00219532 |
8.0.7.8 |
DEADLOCKS DETECTED IN ORACLE ALERT LOG. |
IZ89830 / alm00219520 |
8.0.7.8 |
ENHANCMENT NEEDED FOR THE DELETE_SOFT_ALARM.SH TO ACCEPT
ADDITIONAL OPTION "-DEPCHECK NO” |
IZ89972 / alm00219513 |
8.0.7.8 |
PROSPECT HELP THROWS ERROR FROM CLASSIC CLIENT. |
IZ80133 / alm00155787 |
8.0.7.7 |
CREATE_SCHEMA_OBJECT.SQL NEEDS AN ADDITIONAL CONDITION
WHENDETERMINING THE PAST_PART FOR NEW DBH TABLES. |
IZ81413 / alm00198907 |
8.0.7.7 |
BUSYHOUR FAILURE MESSAGE CAUSED BY DETERMINER EXPRESSION BEING
TOO LONG WHEN EXPANDED. ORA-01461 |
IZ81498 / alm00199249 |
8.0.7.7 |
FX DATA SERVER RESTARTS AFTER HITTING OUT OF MEMORY ERROR. |
IZ79776 / alm00155754 |
8.0.7.7 |
AGGREGATOR TYPE - MAX, SUMNULL AND AVGNULL |
IZ79897 / alm00155772 |
8.0.7.6 |
COVER OF HELP PAGES ON PM SERVER SHOWING EMPTY. |
IZ75091 / valnt00112440 |
8.0.7.5 |
ERRORS WHEN CREATING DEVICE INSTANCE. SYSTEMID TO LONG. |
IZ75881 / valnt00114270 |
8.0.7.5 |
UNEXPECTED ERROR MESSAGE WHEN CLOSING PM PROSPECT CLIENT WINDOW |
IZ75321 / valnt00113897 |
8.0.7.5 |
TO AVOID POSSIBLE DEADLOCKS OCCURRING DURING DELETION OF USERS. |
IZ75776 / valnt00113709 |
8.0.7.5 |
PROSPECT CORE 8.9.6.7 CLIENT DUMPS .TXT FILES WHEN .XLSX OR .CSV
EXPECTED. CLIENT DOESN'T HAVE THE SAME
ROW LIMIT. |
IZ73236 / valnt00107545 |
8.0.7.4 |
SOFTALARM IS CLEARING TOO EARLY IF CLEARED THRESHOLDS ARE USED. |
IZ72202 / valnt00104850 |
8.0.7.4 |
OMMISSION IN 8.0.7.1 RELEASE NOTES. |
IZ72126 / valnt00104741 |
8.0.7.4 |
RELEASE NOTES NEED TO SPECIFY IF NOHUP CAN BE USED WITHWMINSTALL
IN UPGRADES. |
IZ71764 / valnt00104531 |
8.0.7.4 |
8.0.7.2 AND 8.0.7.3 RELEASE NOTES ARE MISSING
INFORMATIONREGARDING JBOSS. |
IZ69697 / valnt00103064 |
8.0.7.4 |
UPDATESCENARIO.SH FAILS WITH ORA-24331. |
IZ69152 / valnt00101892 |
8.0.7.4 |
NSBH & SBH NOT IDENTICAL. |
IZ61286 / valnt00095201 |
8.0.7.4 |
WMINSTALL PROCEEDS TO INSTALL WHEN GTAR FAILS. |
IZ70753 / valnt00103919 |
8.0.7.4 |
DETAIL LOG SHOWS SUCCESS / NO ERRORS DESPITE CRITICAL ORA ERRORS. |
IZ67526 / valnt00100377 |
8.0.7.3 |
8.0.7-AEMS-MOTCM01258596-ADDITIONAL TEXT TOKENS ARE REPLACED
ATFIRST. |
IZ66906 / valnt00099989 |
8.0.7.3 |
WRONG MESSAGE DISPLAYED WHEN CREATING SOFT ALARM TEMPLATE
IFMISSED TO FILL THE ADDITIONAL-TEXT FIELD. |
IZ68023 / valnt00100745 |
8.0.7.3 |
8.0.7-AEMS-MOTCM01253172 - CLASSIC DICTIONARY UPGRADE FAILS. |
IZ66463 / valnt00097729 |
8.0.7.2 |
SNMP token $DEF_ALARM_ID is not supported in 8.0.7 |
There are no known issues in this release.
There is an optional system variable called BH_COMPUTE_DAYS that can be set to limit the days that are included in the stored summary calculations.
Rather than including data dated back to the last available or first needed dates, the computation goes back the number of days specified by BH_COMPUTE_DAYS (the value must be greater than 1 or it is ignored).
This allows restriction of the amount of historical data the BH processes if no data is loaded, so keeping the BH computation fast.
The following steps are to add and set value to
INTEGER:
1.
Log on to the database by typing the following command:
$ sqlplus $DB_CONNECT
2.
Run the following SQL:
SQL>
begin
2 exec
wm_sysval.newsysval(‘BH_COMPUTE_DAYS’,'<NO_OF_DAYS>');
commit;
3 end ;
4 /
Note: The <NO_OF_DAYS> should be replaced with desired integer value.
3.
Exit the sqlplus.
The following steps are to modify BH_COMPUTE_DAYS
value:
4.
Log on to the database by typing the following command:
$ sqlplus $DB_CONNECT
5.
Run the following SQL:
SQL>
begin
2 wm_sysval.forceSysVal(
'BH_COMPUTE_DAYS',<NO_OF_DAYS> ); commit;
3 end
;
4 /
Note: The <NO_OF_DAYS> should be replaced with desired integer value.
6.
Exit the sqlplus.
The following steps are to remove the system
variable:
1.
Log on to the database by typing the following command:
$ sqlplus $DB_CONNECT
2.
Run the following SQL:
SQL>
begin
2 wm_sysval.deleteSysVal(‘BH_COMPUTE_DAYS’); commit;
3 end ;
4 /
3.
Exit the sqlplus.
Important Note:
The
system value may be applied prior to upgrading to version 8.0.7.6. However, this takes effect after 8.0.7.6 or
greater is installed.
The healthcheck program helps
diagnose problems—and prevents loss of service—by providing a
number of concise reports about the IBM Prospect server's status. The syntax
for healthcheck is the
following:
healthcheck [-v]
[-check|-errors|-status|-desc <report>...]... [-a]
The options for healthcheck are described in the following table.
Table 53:
Options for Healthcheck
Option |
Description |
-v |
Display the
usage, including a list of reports. |
-check |
Displays only the report name and the report outcome
(OK/WARN/FAIL). Default. |
-errors |
Displays the report outcome and the problems that
caused a WARN or FAIL notification. |
-status |
Displays the report outcome and all the information
used in the report. |
-desc |
Displays the outcome of the check and suggests
changes. |
<report> |
Run only the specified report at the
current output level. See Reports for healthcheck for
more information. |
Example
$ healthcheck rep1 -s rep1
rep2 -e –a
This example runs rep1 at the check output level (the default), then rep1 and rep2 at the status output level, and then switches to errors output level and runs all the reports.
If a report has a WARN or FAIL outcome, healthcheck exits with a non-zero
exit code. This allows healthcheck to
be integrated into various automated scripts.
You may occasionally see something like
the following when you are running the healthcheck report part_maint_run (covered in Reports
for healthcheck).
part_maint_run FAIL
JOB_TYPE JOB_ID STATUS
MESSAGE
-------- ------ ------
-------
PM_DAILY 49358 OK
Completed successfully
PM_WEEKLY 49342 FAIL
Cleanup of CDSU_T1PORT_DBH failed
ORA-0000: normal,
successful completion
PM_WEEKLY 49342 FAIL
Cleanup of CARRIER_DBH failed
ORA-0000: normal,
successful completion
You can ignore this message.
Reports for
healthcheck
The following table lists the available healthcheck
reports and describes them.
Table 54:
Reports for Healthcheck
Report |
Description |
prospect_rel_patch_info |
Displays the IBM Prospect release and patch information. |
prospect_config |
Displays the IBM Prospect system configuration; for
example, the total number of entities. To display the system, add the option -s before the report name: Example: healthcheck -s prospect_config |
host_config |
Checks the host configuration including the proper
operating system release. · Returns OK if the release is 5.8. · Returns FAIL if the release is not
5.8. |
reasonable_firstneeded |
Checks whether FirstNeeded
is set to a reasonable date. · Returns OK if FirstNeeded is equal to
or greater than FirstAvailable. · Returns OK if FirstAvailable is NULL.
(NULL means that there is a new busyhour definition that has not yet been
processed by a bhupdate.sh; therefore healthcheck has no way of evaluating
it.) · Returns WARN if FirstNeeded is less
than FirstAvailable by one day. · Returns FAIL if FirstNeeded is less
than FirstAvailable by more than one day. A possible cause for failure is a
middleware shut down. |
future_partitions_create |
Checks whether current and future partitions are
created for the partitioned tables. ·
Returns
OK if future partitions are created for all tables. ·
Returns
FAIL if future partitions are not created for any tables. Possible causes of
failure are a middleware shut down or no more tablespace. The results of this report may refer to a N/A table type. The N/A table type is used for the tables that do not fall under any known table type categories; for example, 1XEV, 5ESTRIP, CPFAIL, etc. |
part_maint_run |
Checks whether partition maintenance ran
the previous night. ·
Returns OK if partition maintenance successfully ran the
previous night. ·
Returns FAIL if partition maintenance failed or did not run the
previous night. Possible causes of failure are a middleware shut down or no
more tablespace. Use the schedule_maint script
to schedule partition maintenance. See Scheduling
IBM Prospect System Maintenance in 8.0.7 Administration Guide for
information. |
past_part_set |
Checks whether past_part_maint.sh is
set for dbh/dsm tables. ·
Return OK if partition retention is set for all tables. ·
Returns FAIL if partition retention is not set for any of the
tables. Use past_part_maint.sh to
set the number of days/weeks of data retained in the tables. If data
retention is not set for a table type, then the table is going to keep the
data for unlimited days. See Maintaining Partitions in 8.0.7 Administration Guide for information about partition retention. |
failed_data |
Displays files that were not loaded. Check the Loader log files for more information. When the problem is fixed, you can move the files in the fail directory to the in directory. See Report Generation in 8.0.7 Administration Guide for more information. |
files_age |
Checks how long files have been in the in directory. ·
Returns OK if the file has been in the in directory for less than 20 minutes. ·
Returns WARN if the file has been in the in directory between 20 and 60 minutes. ·
Returns FAIL if the file has been in the in directory for more than 60 minutes. See Report Generation in 8.0.7 Administration Guide for more information. |
commander_cpu |
Checks the MAX_COMMANDER value
and number of CPUs. ·
Returns OK if the MAX_COMMANDERS value is less than or equal to the
number of CPUs: MAX_COMMANDERS <= CPUs ·
Returns WARN if the MAX_COMMANDERS value is greater than the number of CPUs
but less than twice the number of CPUs:
CPUs <
MAX_COMMANDERS < (2 x CPUs) ·
Returns FAIL if the MAX_COMMANDERS value is greater than twice the number
of CPUs: MAX_COMMANDERS > (2 x CPUs) See Parallel
Data Loading in 8.0.7 Administration Guide on
page 82 for more information about setting the MAX_COMMANDER value. |
prospect_data_availability |
Reports about IBM Prospect data availability. |
sbh_ssum_run |
Checks whether bhupdate.sh ran the previous
night. ·
Returns OK if it successfully ran the previous night. ·
Returns FAIL if it did not run the previous night. Possible
causes of failure are a middleware shut down or no more tablespace. See Traffic
Busy Hours and Summations in 8.0.7 Administration Guide for
information about bhupdate.sh. |
sbh_2300 |
Checks whether all stored busy hours are
23:00 for all days. · Returns OK if all busy
hours are not 23:00. · Returns WARN if one or
more busy hour is 23:00. · Returns FAIL is all the
busy hours are 23:00 for all days. Possible causes for failure are invalid
busy hour determiners or invalid data. See Traffic
Busy Hours and Summations in 8.0.7 Administration Guide for
information about managing busy hours. |
missing_bh_days |
Reports days that have missing busy hour
data. ·
Returns OK if there are no missing busy hour days. ·
Returns FAIL if there are missing busy hour days. Possible causes for failure include the
following: · No data for the days
reported. · bhupdate.sh
script stopped due to Oracle database
failures. · DataServer failures. See Maintaining
Stored Busy Hours and Summations in 8.0.7 Administration Guide for
information on the bhupdate.sh script. |
db_tablespace |
Checks tablespace usage. The TEMP
tablespace is not checked. ·
Returns WARN if any tablespace has less than 10 percent free
disk space. ·
Returns FAIL if any tablespace has less than 5 percent free disk
space. Problems may be resolved by either
reducing the amount of data stored in the database or increasing the size of
the tablespace. Note:
db_tablespace
reported on allocated size of tablespace instead on maximum size allowed to
the tablespace. See Maintaining
Tablespaces in 8.0.7 Administration Guide for
information about maintaining tablespaces. |
disk_usage |
Checks the disk usage for log and trace
files for both the IBM Prospect server and the Oracle database. ·
Returns OK if the free space is greater than 1024 MB. ·
Returns WARN if the free space is less than 1024 MB but greater
than 500 MB. ·
Returns FAIL when the free space is less than 500 MB. A possible solution is to archive the
log files. See Working With Log Files in 8.0.7
Administration Guide for more information. |
ds_logging |
Checks the DataServer log settings. Searches for a ds.trace file in the $FLEXPM_HOME/ds
directory and subdirectories. Also searches for any .trace file in the $FLEXPM_HOME/pm
directory and subdirectories. ·
Returns
OK if logging is not set anywhere. ·
Returns
FAIL if logging is set. DataServer logging is generally used for diagnostic
purposes. You can turn logging off by setting the *.trace files to no. |
The upgrade
asserts that there are no other active Oracle sessions for the instance being
upgraded.
Scenarios
that may give rise to this include the following,
This
appendix describes how to deal with each of these scenarios.
Partition
maintenance jobs may cause the upgrade to abort, this is normal. Upgrade may be
postponed until partition maintenance is completed or partition maintenance may
be stopped and prevented from restarting using the following procedure.
Note that
this procedure may also stop partition maintenance session on other instances
on a multi instance installation.
1.
Log on as user flexpm
2.
Using the system administrator password, connect to sqlplus as the
sysdba user
[flexpm] $ sqlplus sys/<SYSPASSWD>
as sysdba
3.
Run the following SQL,
-- Kill off part_maint jobs before upgrade
DECLARE
BEGIN
FOR indx1 IN (SELECT job
FROM user_jobs
WHERE what LIKE '%part_maint.part_session%') LOOP
dbms_job.remove(indx1.job);
END LOOP;
COMMIT;
END;
/
-- Remove any part_maint sessions that may
still be running for partition maintenance.
DECLARE lv_session_info VARCHAR2(100);
lv_sqlstr VARCHAR2(300);
BEGIN
FOR indx1 IN (SELECT sid,
serial#
FROM v$session
WHERE module LIKE 'Part%') LOOP
BEGIN
lv_session_info := '''' || indx1.sid || ',' || indx1.serial# || '''';
lv_sqlstr :=
'ALTER SYSTEM KILL SESSION ' || lv_session_info ||
' IMMEDIATE';
EXECUTE IMMEDIATE lv_sqlstr;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
END LOOP;
COMMIT;
END;
/
If there is
extensive data loading ongoing in another instance that shares the same
database host as the upgrade target instance it is possible that there will be
Row exclusive table locks that will cause the upgrade to abort. This is normal
behaviour for the upgrade process. The upgrade may be postponed until the data
loading has completed or data loading may be suspended in the instances until
the upgrade has completed.
To suspend
data loading in other instances use the following procedure:
1.
Log on as user flexpm
2.
Suspend the sentry
[flexpm] $ ps-mgr suspend sn
3.
Run ps-mgr watch and wait for all loaders to finish
[flexpm] $ ps-mgr watch
4.
Proceed with the upgrade.
5.
Resume data loading by resuming the sentry
[flexpm] $ ps-mgr resume sn
This section describes how to upgrade an existing Oracle database from version 10.2.0 (with 10.2.0.4 patch set) to 11.2.0. Oracle upgrades should be performed by an Oracle Database Administrator (DBA). This document assumes that expertise.
Before starting the Oracle upgrade,
it is recommended that you read the Oracle
Database
Upgrade Guide 11g Release 1 (11.1) B28300-02 on My Oracle Support (formerly OracleMetaLink) at https://support.oracle.com/. You can use the Database Upgrade Assistant (DBUA), but it is useful to read the manual to gain an awareness of the issues.
The system should contain enough disk space to allow for a full backup of the database. If the backup is done by means of the Database Upgrade Assistant (DBUA), then the space needed for the backup is equal to the current size of the database data files. To save space, you can also manually back up the database before the upgrade.
The following tasks involve backing up the Oracle database and Prospect files, then installing Oracle 11g.
1.1 Set Up the Prospect Server
Make sure you have followed the instructions in the Server Preparation Guide, chapter Installing and Configuring Solaris, including disk setup, user creation, and system patches.
1.1.1 Pre-requisites
Solaris 10 U6 (5.10-2008.10), or later
To determine the distribution and version of Solaris installed, enter the following command:
# uname -r
Sample output: 5.10
In this example, the version shown is Solaris 10 (5.10). If necessary, refer to your operating system documentation for information about upgrading the operating system.
$ cat /etc/release
Note: Make sure that the Solaris update level is
upgrade patch 6, or higher.
Solaris 10 10/08
s10s_u6wos_07b SPARC
Copyright 2008 Sun
Microsystems, Inc. All Rights Reserve
Use is subject to
license terms.
Assembled 27
October 2008
The following packages (or later versions)
are required for Oracle Database 11g Release 2 (11.2.0) for Solaris Operating
System:
SUNWarc
SUNWbtool
SUNWhea
SUNWlibC
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWi1of
SUNWi1cs (ISO8859-1)
SUNWi15cs (ISO8859-15)
SUNWxwfnt
SUNWcsl
Verifying Packages
# pkginfo -i
SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibms SUNWsprot SUNWtoo SUNWi1of
SUNWi1cs SUNWi15cs SUNWxwfnt
Install packages
that are currently not installed in your system. Refer to your operating system
or software documentation for information about installing packages.
Executing the
pkginfo -i command will display results similar to following output:
system SUNWarc
Lint Libraries (usr)
system SUNWbtool
CCS tools bundled with SunOS
system SUNWhea
SunOS Header Files
system SUNWi15cs
X11 ISO8859-15 Codeset Support
system SUNWi1cs
X11 ISO8859-1 Codeset Support
system SUNWi1of
ISO-8859-1 (Latin-1) Optional Fonts
system SUNWlibC
Sun Workshop Compilers Bundled libC
system SUNWlibms
Math & Microtasking Libraries (Usr)
system SUNWsprot
Solaris Bundled tools
system SUNWtoo
Programming Tools
system SUNWxwfnt X
Window System platform required fonts
Table 7: Required Patches for Solaris
Installation Type
or Product |
Requirements |
All installations |
Patches for Solaris 10: • 120753-06: SunOS
5.10: Microtasking libraries (libmtsk) patch • 139574-03: SunOS
5.10 |
Pro*C/C++, Pro*FORTRAN, Oracle Call Interface, Oracle C++ Call Interface, Oracle XML
Developer’s Kit (XDK) |
Patches For Solaris 10: • 119963-14: SunOS
5.10: Shared library patch for C++ • 124861-15: SunOS
5.10 Compiler Common patch for Sun C C++. Note:
This
patch is optional depending on your server requirements. Ignore this warning
when you install Oracle 11g. |
Database Smart Flash Cache
(An |
The following patches are
required for Solaris Operating System (SPARC 64-Bit) if you are using the
flash cache feature: • 125555-03 • 140796-01 • 140899-01 • 141016-01 • 139555-08 • 141414-10 • 141736-05 |
Verifying Patches
Install patches
that are currently not installed in your system. Refer to your operating system
or software documentation for information about installing patches.
Run the following
command to check the patch availability:
#
/usr/sbin/patchadd -p | grep patch_number (without version
number)
For example,
executing this command:
/usr/sbin/patchadd
-p | grep 120753
Will display
results similar to the following output:
Patch:
120753-07 Obsoletes: Requires: Incompatibles: Packages: SUNWlibm SUNWlibmsr
1.2 Shut Down IBM Prospect and Oracle
Before you can perform a backup, you
must first shut down the IBM Prospect software and the Oracle instance.
To shut down the IBM Prospect
software
ps-mgr halt
ps -ef | grep perl
| grep $prodname | cut -c10-14 | xargs kill -9
To stop Oracle
[oracle] $ sqlplus
/nolog
SQL> connect
sys/<password> as sysdba
where <password> is the password for the sys user.
SQL> shutdown
immediate;
SQL> exit;
[oracle] $ lsnrctl
stop
1.3 Back Up the Oracle 10g Database and IBM Prospect Files
To perform the backup
·
When
Oracle is in NOARCHIVELOG mode, back up the database in cold backup mode.
·
When
Oracle is in ARCHIVELOG mode, back up the database in either cold backup or hot
backup mode.
Back up the files
under $FLEXPM_HOME.
1.4
Oracle 11g Naming Conventions
The Prospect client expects the installation to follow the
Optimal Flexible Architecture (OFA) standards concerning naming conventions.
The software also expects Oracle to be installed into the directory /u01/apps/oracle/product/11.2.0. If it is installed in another location, you
must create a symbolic link from
/u01/apps/oracle/product/11.2.0 to the directory.
The Oracle 11.2.0 upgrade involves two major steps as follows:
It is recommended that you perform the upgrade in this order;
however, your setup may have special requirements.
Consult the Oracle 11g Upgrade Companion, Note 601807.1, on the Oracle Metalink Web site for the
latest information provided by Oracle.
2.1 Install Oracle 11g Software
Install Oracle 11g (Version 11.2.0.1, 64
bit) database software, including partition licenses.
When installing Oracle, use the
following directories:
ORACLE_BASE
-> /u01/apps/oracle
ORACLE_HOME
-> /u01/apps/oracle/product/11.2.0
Note: Perform the installation using oracle user permissions. Do
not run the Oracle Universal Installer (OUI) as root.
Download 11g installation files for
Solaris from My Oracle Support (formerly OracleMetaLink) at https://support.oracle.com/
2.1.1 Before
You Begin
This installation
procedure assumes that you have already prepared the server as described in the
preceding sections:
·
Install
the appropriate version of Solaris and its patches
·
During
the installation, some scripts need to be run as the root user. If you do not
have access to root, have someone from your IT department available during the
installation to run these scripts.
2.1.2 Start the
Installer
The Installer is a
Java-based interface that uses the X Window system. Use a workstation with an X
Window display, not a console. Start the Installer according to the following
procedure.
To start the
Oracle Installer
1.
Use
the following commands on the X session host to enable access to the X Window
server.
$ xhost +
Note: Make sure that the
xhost command is available in your
PATH environment variable. For Solaris, include
/usr/openwin/bin
in
the PATH.
2. Use telnet or
rlogin to
log on to the database server host. Use the IBM Prospect Oracle logon account:
$ rlogin
'hostname' -l oracle
Substitute the appropriate
server name for hostname.
3. Set the DISPLAY variable so that the Installer
can access the X Window server:
$ export
DISPLAY ; DISPLAY='hostname':0.0
Substitute the appropriate
display hostname.
4. Copy the install packages
solaris.sparc64_11gR2_database_1of2.zip and
solaris.sparc64_11gR2_database_2of2.zip into a temporary directory, not
the one that oracle is going to be installed in. For example,
/u01/oinstall
5. Set two variables for installation parameters.
$
export ORACLE_BASE; ORACLE_BASE=/u01/apps/oracle
$
export ORACLE_HOME; ORACLE_HOME=/u01/apps/oracle/product/11.2.0
6. Unpack the installation packages:
unzip
solaris.sparc64_11gR2_database_1of2.zip
unzip
solaris.sparc64_11gR2_database_2of2.zip
7. Run the Installer in the background by using the ampersand (&).
./runInstaller
&
This allows the command shell
to accept additional commands.
After running some initial
checks, the Java client launches which configures and begins the installation.
A typical Oracle installation
takes about an hour.
2.1.3 Select and enter
Installation Parameters
Select installation parameters
such as product components, component locations, and authentication methods.
To
select installation parameters
1. On the first installation screen, enter your email address and
your My
Oracle Support password
Click
NEXT.
2. Select the
INSTALL DATABASE SOFTWARE ONLY option.
Click
NEXT.
3. Select SINGLE INSTANCE DATABASE INSTALLATION and click
NEXT.
4. Select English as
SELECTED LANGUAGES. Click
NEXT.
5. Select the ENTERPRISE EDITION option and click
NEXT.
6. On the
SPECIFY INSTALLATION LOCATION screen,
enter
/u01/apps/oracle for
the ORACLE
BASE DIRECTORY and
/u01/apps/oracle/product/11.2.0
in
the SOFTWARE LOCATION section. Click
NEXT. “The ORACLE
BASE LOCATION IS IN THE HOME DIRECTORY. ARE
YOU SURE YOU WANT TO CONTINUE?” dialog box opens.
Click
YES to
continue.
7. On the next installation screen, leave DBA as the Database
Administrator Group and
Database Operator Group and click NEXT.
8. Make sure all installation requirements are fulfille Click NEXT.
9. Make sure all summary values are correct and click FINISH.
The installation
begins.
The installation log can be viewed in the /u01/apps/oracle/oraInventory/logs/ path on
the server, for example:
/u01/apps/oracle/oraInventory/logs/installActions2010-10-08_08-26-22PM.log
10. Exit the installer when the installation is complete.
2.2
Upgrade to 11g using dbua
The DBUA provides a graphical user interface (GUI) that guides a
user through an in-place upgrade of a database. It is the recommended method
for performing either a major release upgrade or patch release upgrade.
The DBUA automates the upgrade process by performing all of the
tasks that would otherwise need to be performed manually. It can be launched as
a standalone tool at any time after installation is complete.
Note: Do not launch DBUA during Oracle 11g
installation.
The DBUA is a very useful tool because it evaluates the current
database and makes appropriate recommendations for configuration options such
as tablespace sizes, cluster checks, initialization parameters, and Oracle Automatic
Storage Management (ASM) upgrades.
The following procedure includes a step that backs up your
current database. If you want the database upgrade utility to back up your
database, be prepared to supply a directory capable of holding a full backup of
your database.
Note: The following is just an example; choose
your own preferred upgrade method
export
ORACLE_BASE=/u01/apps/oracle
export
ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export
ORACLE_SID=flexpm
export PATH
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export
LD_LIBRARY_PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export TNS_ADMIN
TNS_ADMIN=$ORACLE_HOME/network/admin
dbua &
Note: You need to input the password for the DBSNMP, and SYSMAN users.
DBSNMP
password: dbsnmp
SYSMAN
password: manager
If the
PASSWORD
ENTERED DOES NOT SATISFY ORACLE RECOMMENDED PASSWORD
COMPLEXITY POLICY dialog box
appears, click YES.
2.3 Perform Post Upgrade Steps
Note: To set system performance parameters, refer to Oracle
documentation to enable Automatic Shared Memory Management. The following steps
are other 11g post-upgrade related actions.
export
ORACLE_BASE=/u01/apps/oracle
export
ORACLE_HOME=$ORACLE_BASE/product/11.2.0
*:/u01/apps/oracle/product/10.2.0:N
Comment out this line, as follows:
#*:/u01/apps/oracle/product/10.2.0:N
Edit
$ORACLE_BASE/admin/flexpm/pfile/initflexpm.ora
Then change:
log_archive_format="LOG_%t_%s.ARC"
to:
log_archive_format="LOG_%t_%s_%r.ARC"
cd
/u01/apps/oracle
rm network
ln -s
./product/11.2.0/network network
exit
4.
Log on to Oracle as sysdba
$ sqlplus / as
sysdba
SQL> ALTER
SYSTEM SET open_cursors=1000 SCOPE=SPFILE;
SQL> ALTER
SYSTEM set recyclebin=off scope=spfile;
SQL> purge
recyclebin;
Recyclebin purge
SQL> select *
from recyclebin;
No rows selected
SQL> exit
SQL> ALTER
SYSTEM SET COMPATIBLE= '11.2.0' SCOPE=SPFILE;
SQL> ALTER
SYSTEM SET "_optimizer_connect_by_cost_based"=false
scope=spfile;
SQL> ALTER
SYSTEM SET log_archive_format='LOG_%t_%s_%r.ARC' scope=spfile;
SQL> shutdown
abort
SQL> startup
SQL> shutdown
immediate
SQL> quit
Note: If Oracle ORA errors 119 and / or 132 are
encountered, refer to Metalink ID: 415362 for instructions on how to restore
Oracle.
$ORACLE_BASE/product/11.2.0/network/admin/
First, check if the tnsnames.ora and listener.ora files are in the $ORACLE_BASE/product/11.2.0/network/admin/ directory. If the files are not in the directory, run
the following command:
$ cp
/u01/apps/oracle/product/10.2.0/network/admin/*ora
/u01/apps/oracle/product/11.2.0/network/admin
Edit the files to conform to the following
network configuration file details.
Note: The flexpm entry may differ from the example below
(protocol may be IPC, for example), but you must make sure that the hostname
and port are define Hostname may be either the server name or the IP address.
On a split server environment, the
tnsnames.ora file resides on the Oracle server.
# tnsnames.ora
Network Configuration File: /u01/apps/oracle/product/
11.2.0/network/admin/tnsnames.ora
# Generated by
Oracle configuration tools.
#.
# @(#)
tnsnames.ora = Oracle 'tnsnames' configuration for FLEXPM
# NOTES:
# can be
'generated' by Oracle Net8 Assistant
#
# @(#) %M% ;
%I%.%B% %E% %U%
flexpm =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL =
TCP)(HOST = <hostname>)(PORT = <port #>)
(KEY = flexpm))
(CONNECT_DATA =
(SID = flexpm)
(SERVER =
DEDICATED))
)
EXTPROC_CONNECTION_DATA
=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
)
The file
listener.ora should look like the following; replace <hostname> with the
name of your server:
# @(#)
listener.ora = Oracle 'listener' configuration for FLEXPM
# NOTES:
# can be
'generated' by Oracle Net8 Assistant
#
# @(#) %M% ;
%I%.%B% %E% %U%
LOG_DIRECTORY_LISTENER
= /u01/apps/oracle/network/log
LOG_FILE_LISTENER
= listener.log
TRACE_LEVEL_LISTENER
= NONE
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = <hostname> )(PORT = 1521))
(ADDRESS =
(PROTOCOL = IPC) (KEY = EXTPROC))
)
SID_LIST_LISTENER
=
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME =
flexpm )
(ORACLE_HOME =
/u01/apps/oracle/product/11.2.0 )
(SID_NAME = flexpm
)
)
(SID_DESC =
(ORACLE_HOME =
/u01/apps/oracle/product/11.2.0 )
(SID_NAME =
PLSExtProc)
(PROGRAM =
extproc32)
(ENVS =
"EXTPROC_DLLS=ANY,LD_LIBRARY_PATH=<FLEXPM_HOME>/pm/lib/wm:
<FLEXPM_HOME>/pm/lib/tp:
<FLEXPM_HOME>/pm/lib/ln/ora:/u01/apps/oracle/product/10.2.0/
lib32")
)
)
#.
Before restarting the listener, enter the
following commands:
$ sqlplus /nolog
SQL> conn / as
sysdba
Connected to an
idle instance.
SQL> startup
ORACLE instance
started
Note: The sga_target parameter enables or disables Automatic Shared Memory
Management (ASMM). In order to enable the ASMM feature, this must be set to a
non-zero value following the Oracle 11g upgrade and before any report groups
are
submitte sga_max_size can have approximately 25% of RAM (for example,
if you have 10 GB of RAM,
sga_max_size =2G) and
sga_target (about 85% to 95% of sga_max_size)
less than sga_max_size.
The following values within <> are
examples only. Note that values must only be entered as integers, for example
1G = 1024M, where either value can be use When sga_target is set to non-zero, the parameter shared_pool_size must also
be non-zero, and the parameter
statistics_level must be set to TYPICAL
or ALL.
SQL> ALTER
SYSTEM SET sga_max_size=< 1200M > SCOPE=SPFILE;
SQL> ALTER SYSTEM
SET sga_target=< 1000M > SCOPE=SPFILE;
SQL> ALTER
SYSTEM SET shared_pool_size=<400M> SCOPE=SPFILE;
SQL> ALTER
SYSTEM SET statistics_level=<TYPICAL OR ALL>
SQL> SHUTDOWN
IMMEDIATE;
SQL> EXIT;
Restart the listener by issuing the
following command:
$ lsnrctl start
Restart the database
$ sqlplus '/ as
sysdba'
SQL> startup
SQL> quit
The installation of Oracle is now complete.
13.
Run preset_oracle_paths
Log on as flexpm and source
the profile:
$ . ./.profile
$ cd
$PM_HOME/sw/oracle
$
preset_oracle_paths -f
The upgrade of Oracle from 10.2.0 to 11.2.0
is successful after these tasks are complete
The upgrade is complete. Exit the server.
Sample output of preset_oracle_paths:
: flexpm@perftest1
; preset_oracle_paths
Oracle
installation is 10.2.0 Client
Linking commander10g
to commander
Linking
controlLogLoader10g to controlLogLoader
Linking loader10g
to loader
Linking sentry10g
to sentry
Linking sescfg10g
to sescfg
Linking
/u01/apps/oracle_client/network to /u01/apps/oracle/product/11.2.0/network
Linking
/u01/apps/oracle_client/product/10.2.0/dbs to
/u01/apps/oracle/product/11.2.0/dbs
Linking
/u01/apps/oracle_client/admin to /u01/apps/oracle/admin
Copying
/u01/apps/oracle/product/11.2.0/bin/lsnrctl to /u01/apps/
oracle_client/product/10.2.0/bin
oracle@perftest1$
pwd
ls -ltr
/u01/apps/oracle_client
lrwxrwxrwx 1
flexpm dba 39 Sep 22 06:12 network -> /u01/apps/
oracle/product/11.2.0/network
lrwxrwxrwx 1
flexpm dba 22 Sep 22 06:12 admin -> /u01/apps/oracle/admin
ls -ltr
/u01/apps/oracle_client/product/10.2.0
lrwxrwxrwx 1 flexpm
dba 35 Sep 22 06:12 dbs -> /u01/apps/
oracle/product/11.2.0/dbs
ls -ltr
/u01/apps/oracle_client/product/10.2.0/bin
-rwxr-x--x 1
flexpm dba 152096 Sep 22 06:12 lsnrctl
You might note some differences when using
the sqlplus
Oracle
tool after upgrading to Oracle 11g database software. You will be directed to
different sqlplus
versions
when you log in as oracle or flexpm
user.
However, you will still be connected to the 11g database server regardless of
the sqlplus
version
being use
The following can be observed when you log
in as oracle. With this profile, you will
be using the 11g version of sqlplus.
$ id
uid=10021(oracle)
gid=600(dba)
$ env | grep
ORACLE
ORACLE_FLAG=Y
ORACLE_BASE=/u01/apps/oracle
WM_ORACLEVERSION=ORACLE10
ORACLE_SID=flexpm
ORACLE_VERS=1120
ORACLE_HOME=/u01/apps/oracle/product/11.2.0
$ env | grep PATH
PATH=/u01/apps/oracle/product/11.2.0/bin:/usr/bin:/usr/sbin:/usr/openwin/bin:/usr/dt/bin:/usr/ccs/bin:/opt/SUNWspro/bin:/usr/ucb:/usr/local/bin:/usr/bin/nsr
LD_LIBRARY_PATH=/pm/lib/ln/ora:/u01/apps/oracle/product/11.2.0/lib:/usr/lib:/usr/openwin/lib:/usr/dt/lib:/usr/ccs/lib:/opt/SUNWspro/lib:/usr/local/lib
$ sqlplus /nolog
SQL*Plus: Release
11.2.0.1.0 Production on Wed Oct 13 05:16:23 2010
Copyright (c)
1982, 2009, Oracle. All rights reserve
SQL> conn
system/manager
Connecte
SQL> set lines
150
SQL> select
instance_name, host_name, version, startup_time, database_status from
v$instance;
INSTANCE_NAME
HOST_NAME VERSION STARTUP_TIME DATABASE_STATUS
----------------
---------- ----------------- ---------------- ---------------
flexpm whale
11.2.0.1.0 2010-10-11 00:27 ACTIVE
The following can be observed when you
log in as flexpm. With this profile, you will be using the 10g client version
of sqlplus, but it will still direct you to the 11g database.
$ . ./.profile
$ id
uid=10020(flexpm)
gid=600(dba)
$ env | grep
ORACLE
ORACLE_BASE=/u01/apps/oracle_client
WM_ORACLEVERSION=ORACLE10
ORACLE_SID=flexpm
ORACLE_VERS=1020
ORACLE_HOME=/u01/apps/oracle_client/product/10.2.0
$ env | grep PATH
PATH=/usr/perl5/5.6.1/bin:<FLEXPM_HOME>/pm/adm:<FLEXPM_HOME>/pm/run:<FLEXPM_HOME>/pm/bin:<FLEXPM_HOME>/wm/bin:<FLEXPM_HOME>/vendor/Common/NE/1.3/scripts:<FLEXPM_HOME>/vendor/Common/NE/1.3/../part_maint:<FLEXPM_HOME>/vendor/Common/NE/1.3/bin:.:<FLEXPM_HOME>/pm/adm:<FLEXPM_HOME>/pm/run:<FLEXPM_HOME>/pm/bin:<FLEXPM_HOME>/wm/run:<FLEXPM_HOME>/pm/pas/bin:/usr/java/bin:::/u01/apps/oracle_client/product/10.2.0/bin:/usr/bin:/usr/sfw/bin:/usr/sbin:/usr/openwin/bin:/usr/dt/bin:/usr/ccs/bin:/opt/SUNWspro/bin:/usr/ucb:/usr/bin/nsr:<FLEXPM_HOME>/sw/oracle:<FLEXPM_HOME>/db/Oracle8i/scheduler/sched:/u01/apps/WatchMark/FlexPM/motR23t//MotorolaSplash/vendor/MotorolaSplash/bin:/u01/apps/WatchMark/FlexPM/motR23t//MotorolaSplash/vendor/MotorolaSplash/bin/sso:<FLEXPM_HOME>/pm/pas/bin/perf:/usr/sfw/bin:/u01/apps/WatchMark/FlexPM/bin
LD_LIBRARY_PATH=<FLEXPM_HOME>/sw/perl/lib:<FLEXPM_HOME>/pm/lib/wm:<FLEXPM_HOME>/pm/lib/tp:<FLEXPM_HOME>/pm/lib::<FLEXPM_HOME>/pm/lib/wm:<FLEXPM_HOME>/pm/lib/tp:<FLEXPM_HOME>/pm/lib::<FLEXPM_HOME>/pm/lib/ln/ora:/u01/apps/oracle_client/product/10.2.0/lib32:/usr/lib:/usr/openwin/lib:/usr/dt/lib:/usr/ccs/lib:/opt/SUNWspro/lib
$ sqlplus /nolog
SQL*Plus: Release
10.2.0.4.0 - Production on Wed Oct 13 05:23:57 2010
Copyright (c)
1982, 2007, Oracle. All Rights Reserve
SQL> set lines
150
SQL> conn
system/manager@flexpm
Connecte
SQL> select
instance_name, host_name, version, startup_time, database_status from
v$instance;
INSTANCE_NAME
HOST_NAME VERSION STARTUP_TIME DATABASE_STATUS
----------------
---------- ----------------- ---------------- ---------------
flexpm whale
11.2.0.1.0 2010-10-11 00:27 ACTIVE
In addition to the above sqlplus
logins, when flexpm connects with the Prospect flexpm login, it clearly
indicates the 10.2.0.4.0 sqlplus binary usage, and the 11.2.0.1.0 database.
: flexpm@whale ;
sqlplus $DB_CONNECT
SQL*Plus: Release
10.2.0.4.0 - Production on Wed Oct 13 11:02:25 2010
Copyright (c)
1982, 2007, Oracle. All Rights Reserve
Connected to:
Oracle Database
11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the
Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
The Prospect client can be installed on Microsoft Windows 7 with Win7 User Account Control (UAC) security feature disabled. Follow instructions below to install the Prospect client on Windows 7.
If UAC is not disabled it can be disabled using the following steps.
·
Start Menu -> Control Panel
-> User Accounts and Family Safety -> User Account.
·
In the section, "Make changes to your User
Account", select the link "Change User Account Control
settings".
·
Move the Slider to Never Notify.
·
Click OK to make the change effective.
·
Reboot.
Continue to install the
client as below:
·
Go to the client installer folder and run the
setup.exe
http://www.ibm.com/legal/copytrade.shtml
Notices
INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS
IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY
OR FITNESS FOR A PARTICULAR PURPOSE. Some jurisdictions do not allow disclaimer
of express or implied warranties in certain transactions, therefore, this
statement may not apply to you.
This information could include technical inaccuracies or typographical errors.
Changes are periodically made to the information herein; these changes will be
incorporated in new editions of the publication. IBM may make improvements
and/or changes in the product(s) and/or the program(s) described in this
publication at any time without notice.
Microsoft, Windows, and Windows Server are trademarks of Microsoft Corporation
in the
Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel
Centrino logo, Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are
trademarks or registered trademarks of Intel Corporation or its subsidiaries in
the
Other company, product, or service names may be trademarks or service marks of
others.
THIRD-PARTY LICENSE TERMS
AND CONDITIONS, NOTICES AND INFORMATION
The license agreement for this product refers you to this file for details
concerning terms and conditions applicable to third party software code
included in this product, and for certain notices and other information IBM
must provide to you under its license to certain software code. The relevant
terms and conditions, notices and other information are provided or referenced
below. Please note that any non-English version of the licenses below is
unofficial and is provided to you for your convenience only. The English
version of the licenses below, provided as part of the English version of this
file, is the official version.
Notwithstanding the terms and conditions of any other agreement you may have
with IBM or any of its related or affiliated entities (collectively
"IBM"), the third party software code identified below are
"Excluded Components" and are subject to the following terms and
conditions:
The Excluded Components are provided on an "AS IS" basis
IBM DISCLAIMS ANY AND ALL EXPRESS AND IMPLIED WARRANTIES AND CONDITIONS
WITH RESPECT TO THE EXCLUDED COMPONENTS, INCLUDING, BUT NOT LIMITED
TO, THE WARRANTY OF NON-INFRINGEMENT OR INTERFERENCE AND THE IMPLIED WARRANTIES
AND CONDITIONS OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
IBM will not be liable to you or indemnify you for any claims related to
the Excluded Components
IBM will not be liable for any direct, indirect, incidental, special,
exemplary, punitive or consequential damages with respect to the Excluded Components.
Created/Revised By: |
Date of Creation/Update: |
Summary of Changes: |
Tommy Shum Kiat Hoe |
26 Jan 2011 |
First Draft – QA Drop 1 |
Tommy Shum Kiat Hoe |
31 Mar 2011 |
Final Draft – QA Drop 2 |
Tommy Shum Kiat Hoe |
25 May 2011 |
Final Draft – QA Drop 3 |
|
|
|