Tuesday 31 March 2009

Oracle : Empty listener log

http://boomslaang.wordpress.com/2007/11/07/ooops/

Temporarily stop logging
  • lsnrctl
  • set current_listener <ListenerName>
  • set log_status=off
Move and recreate log file
  • mv <logfile> <logfile>.old
  • touch <logfile>
Restart logging
  • lsnrctl
  • set current_listener <ListenerName>
  • set log_status=on

Check entries re-appearing in logfile

Fini

Oracle : Stop listener logging

http://lc.leidenuniv.nl/awcourse/oracle/network.920/a96581/listener.htm

add following to listener.ora
  • LOGGING_<ListenerName>=OFF

Check with
  • lsnrctl reload <ListenerName>

Confirm via
  • lsnrctl
  • set current_listener <ListenerName>
  • show log_status

Fini  

Wednesday 25 March 2009

11g : Errors using exp as it is de-supported

Got some errors running exp on an 11G cluster due to missing perms

Met*link stated that exp/imp are actually desupported in 11G in favour of data pump

Work around fix was to grant the following directly to the exp-orting user

GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO <user_name>;
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO <user_name>;

Fini


Thursday 5 March 2009

identifying trace files in 11g (RAC)

SELECT pid, program, tracefile
FROM gv$process
where pid in (37,84)