When upgrading the geodatabase on Oracle, the shared session log tables owned by SDE are deleted. This has been happening ever since 10.0. If you query the sde.server_config table, the settings are all correct. I have to run the sdeconfig command and set any of the lof file parameters to equal what it already is. For example, I set the allowsessionlogfile=true. This will set off the process to recreate the tables. If it is necessary for you to delete these tables, please recreate them as a final step.