Wednesday, August 6, 2014

[ODA] ILOM (Integrated Lights Out Manager) URL



Well, recently, I'm having some experience with Oracle Database Appliance (ODA), so I will be posting some notes about that.

I was researching about ILOM (Integrated Lights Out Manager) which is the interface that you can use to manage and maintain your ODA system remotely.

First experience,  I didn't know anything about the ILOM, so I didn't have a clue what was the URL for this magic console.

Don't panic, the only thing that you need to know is the ILOM IP address in both ODA nodes (each node have their ILOM configure).

[RUEI] Upgrade Fails with Error: "ORA-00600: internal error code, arguments: [kkmmctbf:bad intcoln]"

Situation:
I'm upgrading from my current 12.1.0.X RUEI installation to the version 12.1.0.6 due to a malfunction of the TCP Diagnostic tool.
 
I followed the steps on the "Oracle® Real User Experience Insight Installation Guide 12c Release 5 (12.1.0.6) for Linux x86-64". I reached the step 13 on the section "3.11.1 Upgrading the Reporter System from RUEI 12.1.0.x" and got the following error:
[root@gualaca extra]# ./ruei-upgrade-12.1.0.6.sh rpm_post_install
____________________________________________________________

2014-08-05 14:52:18   rpm_post_install ...
____________________________________________________________

2014-08-05 14:52:18   make_processor_conf ...
2014-08-05 14:52:19   make_processor_conf done
____________________________________________________________
...
2014-08-05 16:29:47   ignore_failed_urls ...
2014-08-05 16:29:48   ignore_failed_urls done
____________________________________________________________

2014-08-05 16:29:48   fix_sesdiag_retention ...
2014-08-05 16:29:48   fix_sesdiag_retention done
____________________________________________________________

2014-08-05 16:29:48   delete_unreferenced_rules ...
    declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkmmctbf:bad intcoln], [6], [], [],
[], [], [], [], [], [], [], []
ORA-06512: at line 22
ORA-06512: at line 26


2014-08-05 16:31:27   delete_unreferenced_rules ERROR
____________________________________________________________

2014-08-05 16:31:27   convert_psesdiag_ecid ...
2014-08-05 16:31:28   convert_psesdiag_ecid done
____________________________________________________________

2014-08-05 16:31:28   migrate_interfaces ...
2014-08-05 16:31:28   migrate_interfaces done
____________________________________________________________

2014-08-05 16:31:28   drop_unused_userflow_tables ...
2014-08-05 16:31:29   drop_unused_userflow_tables done
2014-08-05 16:31:29   rpm_post_install ERROR

It seems like an error with the RUEI database.
 
Cause:
The error occurs on delete a row from a table that has a child table referenced with an ON DELETE CASCADE foreign key, and the child table contains a compound trigger.
 
Bug:
1435647.1: ORA-600 [kkmmctbf:bad intcoln] 
 
Solution:
Install this patch (13582702) on your RUEI database.
 
Note: The patch I'm sharing is for Linux x86-64. There are similar patches for other environments.

Tuesday, August 5, 2014

[RUEI] Issue with ruei-upgrade-12.1.0.6.sh rpm_pre_install: -bash: line 2: /tmp/ruei-migrate: Permission denied

Situation:
I'm upgrading from my current 12.1.0.X RUEI installation to the version 12.1.0.6 due to a malfunction of the TCP Diagnostic tool.
 
I followed the steps on the "Oracle® Real User Experience Insight Installation Guide 12c Release 5 (12.1.0.6) for Linux x86-64". I reached the step 7 on the section "3.11.1 Upgrading the Reporter System from RUEI 12.1.0.x" and got the following error:
[root@gualaca extra]# ./ruei-upgrade-12.1.0.6.sh rpm_pre_install
____________________________________________________________

2014-08-04 14:29:22 rpm_pre_install ...
____________________________________________________________

2014-08-04 14:29:22 check_markers ...
2014-08-04 14:29:23 check_markers done
____________________________________________________________

2014-08-04 14:29:23 drop_mviews ...
2014-08-04 14:29:23 drop_mviews done
____________________________________________________________

2014-08-04 14:29:23 fix_custom_dims ...
2014-08-04 14:29:23 fix_custom_dims done
____________________________________________________________

2014-08-04 14:29:23 rename_fact_tables ...
2014-08-04 14:29:24 rename_fact_tables done
____________________________________________________________

2014-08-04 14:29:24 rename_table_prefix ...
2014-08-04 14:29:24 rename_table_prefix done
____________________________________________________________

2014-08-04 14:29:24 page_stats ...
2014-08-04 14:29:25 page_stats done
____________________________________________________________

2014-08-04 14:29:25 upgrade_report ...
2014-08-04 14:29:25 upgrade_report done
____________________________________________________________

2014-08-04 14:29:25 prepare_kpi_upgrade ...
-bash: line 2: /tmp/ruei-migrate: Permission denied
2014-08-04 14:29:25 prepare_kpi_upgrade ERROR
2014-08-04 14:29:25 rpm_pre_install ERROR

As it seems like a file permission error, I gave all the permissions (777) to the /tmp/ruei-migrate file to see if it was the problem but after I execute it I got the same permission error:
[root@gualaca tmp]# ls -ld ruei-migrate
-rwxrwxrwx 1 root root 1761546 Aug 4 14:51 ruei-migrate
[root@gualaca ~]# /tmp/ruei-migrate
-bash: /tmp/ruei-migrate: Permission denied
Then I created a script (in the /tmp directory) that echoes the string "Hello World" but when I execute it a permission error appears (like ruei-migrate script). So I pointed the problem to the /tmp filesystem. I review the /etc/fstab file and found that the /tmp filesystem does not have the exec option:
[root@gualaca ~]# cat /etc/fstab
/dev/VolGroup00/LogVol02 /tmp ext3 defaults,nodev,nosuid,noexec  1 2

Cause:
The filesystem for the /tmp directory does not have the exec mount option. This option permits the filesystem to execute its binaries.
 
Solution:
Remount the /tmp filesystem with the proper option and try again the RUEI upgrade script:
[root@gualaca ~]# mount -o remount,exec /tmp
[root@gualaca extra]# ./ruei-upgrade-12.1.0.6.sh rpm_pre_install
____________________________________________________________

2014-08-05 10:14:07   rpm_pre_install ...
____________________________________________________________

2014-08-05 10:14:07   check_markers ...
2014-08-05 10:14:08   check_markers done
____________________________________________________________

2014-08-05 10:14:08   drop_mviews ...
2014-08-05 10:14:08   drop_mviews done
____________________________________________________________

2014-08-05 10:14:08   fix_custom_dims ...
2014-08-05 10:14:09   fix_custom_dims done
____________________________________________________________

2014-08-05 10:14:09   rename_fact_tables ...
2014-08-05 10:14:09   rename_fact_tables done
____________________________________________________________

2014-08-05 10:14:09   rename_table_prefix ...
2014-08-05 10:14:10   rename_table_prefix done
____________________________________________________________

2014-08-05 10:14:10   page_stats ...
2014-08-05 10:14:10   page_stats done
____________________________________________________________

2014-08-05 10:14:10   upgrade_report ...
2014-08-05 10:14:11   upgrade_report done
____________________________________________________________

2014-08-05 10:14:11   prepare_kpi_upgrade ...
2014-08-05 10:14:12   prepare_kpi_upgrade done
2014-08-05 10:14:12   rpm_pre_install done

[RUEI] ./ruei-migrate: error while loading shared libraries: libclntsh.so.11.1

Situation:
Attempting to run the ruei-migrate fails with this errror:
./ruei-migrate: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

Cause:
The problem was caused by the $ORACLE_HOME/lib directory not being exported on the LD_LIBRARY_PATH environment variable. It is also related to the RUEI database environment variables that are not included on the bash_profile file of the $RUEI_USER.
 
Solution:
After appending the RUEI database environment variables to the $RUEI_USER bash_profile file, add $ORACLE_HOME/lib to the LD_LIBRARY_PATH environment variable using the following command:
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Monday, August 4, 2014

[RUEI] Upgrade Missing Dependency php-soap RPM

Situation:
You are following the upgrade instructions from the "Oracle® Real User Experience Insight Installation Guide 12c Release 5 (12.1.0.6) for Linux x86-64" and you reach the step where you upgrade the php-soap module but don't have the proper RPM.
 

Solution:
Option A
- Download the RPM from this link.

Option B
- Configure the Oracle Public Yum Server and install the repository. Then, install the package with the yum command.