view / show Compilation error messages

What if you too many invalid objects how do get the errors messages for these objects




 
run the query against dba_errors and the text column holds the error message.






run the utlrp.sql to compile all the objects


SQL> @?/rdbms/admin/utlrp.sql

see it made any difference  if not then view the error messages from above and start troubleshooting..

OBIEE --Presentation services No Log Found

User was not able to view the contents of the Log from OBIEE presentation services.
i.e

Re producing the issue:In OBIEE.



under administrattion:

go to Mange Sessions:




 click on Manage sessions Then click on view log.



You got the error message:



Solution:

Make sure logging is turned on for the user. i.e >2 or more.





Now bounce the OBIEE services and you should be able to view the logs now.






2)
If you still have the issue then verify the session variable " Log Level"  is not set with any default value like "0"

see below:




If yes then
Remove this default value and try again by bouncing the OBIEE services.

3) If you still have issues make sure there are not custom initialization blocks defined to block the logging.

see example  below:





Remove this and bounce the OBIEE. You should be all set ..


Reference:
MOS:817010.1

Disable gather stats ( default autotask jobs) job in 11g

Disable the auto stats job in 11g.


SQL> select client_name,status from Dba_Autotask_Client;

CLIENT_NAME                                                      STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection                                  ENABLED
auto space advisor                                               ENABLED
sql tuning advisor                                               ENABLED



SQL> exec dbms_auto_task_admin.disable('auto optimizer stats collection',NULL,NULL);

PL/SQL procedure successfully completed.

SQL> exec dbms_auto_task_admin.disable(client_name =>'auto space advisor',operation => NULL,window_name => NULL);

PL/SQL procedure successfully completed.

SQL>  exec dbms_auto_task_admin.disable(client_name =>'sql tuning advisor',operation => NULL,window_name => NULL);

PL/SQL procedure successfully completed.

Related views related to automated database maintenance tasks:
DBA_AUTOTASK_CLIENT
DBA_AUTOTASK_CLIENT_HISTORY
DBA_AUTOTASK_CLIENT_JOB
DBA_AUTOTASK_JOB_HISTORY
DBA_AUTOTASK_OPERATION
DBA_AUTOTASK_SCHEDULE
DBA_AUTOTASK_TASK
DBA_AUTOTASK_WINDOW_CLIENTS
DBA_AUTOTASK_WINDOW_HISTORY

SQL Profiles- ENABLE, DISABLE and DROP

SQL> exec dbms_sqltune.alter_sql_profile('SYS_SQLPROF_0236d8f37a490001','STATUS','DISABLED');

PL/SQL procedure successfully completed.

SQL> exec dbms_sqltune.alter_sql_profile('SQL_PROF_FOR_DELETE','STATUS','ENABLED');

PL/SQL procedure successfully completed.


SQL> EXEC DBMS_SQLTUNE.DROP_SQL_PROFILE('SYS_SQLPROF_02384d2b5e320000');

PL/SQL procedure successfully completed.


SQL> COMMIT;

Commit complete.

Exadata Documentation

Exadata and Storage cell documentation will be installed by default on the below path on the storage cell server.


[celladmin@cellserver]$ pwd
/opt/oracle/cell/doc

[celladmin@cellserver ]$ ls -lrt
total 42884
drwxr-xr-x  3 root root     4096 Jun  6 15:08 Japanese
-rwxr-xr-x  1 root root     5957 Jun  6 15:08 welcome.html
drwxr-xr-x 10 root root     4096 Jun  6 15:08 doc
-rw-r--r--  1 root root 43829040 Jun 11 22:43 doc.zip