Wednesday, December 07, 2011

Two faced dual?

Anyone witnessed this before?

SQL> select * from dual;

ADDR INDX INST_ID D
-------- ---------- ---------- -
03A00074 0 1 X

SQL> desc dual
Name Null? Type
----------------------------------------- -------- -----------
DUMMY VARCHAR2(1)

SQL> select * from dual;

D
-
X

SQL>

Happened during startup of the instance. 10GR2 EE on MS Win XP.

Friday, December 02, 2011

deconfig.pl - oh yeah!

Ended up restoring databases, the other day, due to:
If the tool deconfig.pl runs successfully, the two tables
orasso.wwsso_papp_configuration_info$ and orasso.wwsec_enabler_config_info$
will not be empty.
However, there are cases when deconfig.pl does not complete successfully and
hence leaving these two tables not populated.
In these case, restore the two tables from a orasso schema DB backup.


Well, I ended "in these case". And those two tables empty means no OC4J_SECURITY starting, no SSO.
OID works, though...

By the way - if you think restoring the ORASSO schema undoes all changes made by deconfig.pl, think again. See metalink Your Oracle Support Doc ID 435483.1