When initializing a Cognos 8 or Cognos Reportnet content store which is located on a Windows-based Oracle server, the connection tests OK in Cognos Configuration, but when the service is started, no tables are created. This can be caused if the Windows server with Oracle has not been rebooted since Oracle was installed.
In ordre to resolve this issue you should try to reboot the system before the database will be fully operational. There are registry entries, and environment variables that don't become fully visible to the system until this is done. Testing the connection will work, but you will not see any tables created.
