Friday, May 20, 2016

How to handle message "Expected XDB Resources are not there" when OLAP API is invalid after an upgrade

›
Background: After an upgrade, you have invalid components in you registry. To fix the OLAP components you have followed "Oracle Olap ...
Wednesday, April 20, 2016

How to solve ORA-28017: The password file is in the legacy format

›
SQL> alter user sys identified by iossS1Qwmk_kKfGHqs0UVu93xxswQ; alter user sys identified by iossS1Qwmk_kKfGHqs0UVu93xxswQ * ERROR at l...
1 comment:
Thursday, April 7, 2016

Simple sed-command for exchanging a string in multiple files

›
sed -i "s/oldstring/newstring/g" For example sed -i "s/11204/12102/g" /etc/oratab
2 comments:
Tuesday, April 5, 2016

MS word characters that have no representation in WE8ISO8859P1 and WE8ISO8859P15

›
During a globalization effort, I found the following interesting information about the difference between the WE8MSWIN1252 and the WE8ISO885...
Sunday, April 3, 2016

What are the two options XDK and XML in DBA_REGISTRY anyway?

›
What are the two options XDK and XML in DBA_REGISTRY anyway? You see them amongst other components in the DBA_REGISTRY view: select comp_...
Wednesday, March 16, 2016

How to remove a non-used option marked as INVALID in dba_registry

›
If you have invalid components in your database table dba_registry, and those options are not used, you should mark them as removed to avoid...

How to fix error ORA-04063: package body "OLAPSYS.CWM2_OLAP_METADATA_REFRESH" has errors when installing OLAP into a 11g database

›
You are installing OLAP. You receive the following error at the end of the olap.sql script: SQL> @?/olap/admin/olap.sql SYSAUX TEMP; S...