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

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

identifying trace files in 11g (RAC)

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