EPM 11.1.2 - R&A DATABASE CONNECTIONS DISAPPEAR FROM THE "DATABASE CONNECTION MANAGER

Posted by Powder on Oracle Blogs See other posts from Oracle Blogs or by Powder
Published on Tue, 29 Nov 2011 18:40:07 -0600 Indexed on 2011/11/30 1:59 UTC
Read the original article Hit count: 485

When accessing the database connection panel through Reporting and Analysis all previously entered database connection do not appear. This is due to a bug in the Windows SMB2 protocol. To work around this bug you have to disable the protocol. On Windows 2008 the protocol is automatically enabled. This needs to be done on both the servers and the clients.

Note that “server” is the server which hosts RAF repository service and RM1 folder, “client” – server which hosts replicated Repository service that accesses repository files via network i.e. \\<server_host>\RM1 

In order to disable SMB 2.0 on the server side, follow these steps: 

1. Run "regedit" on Windows Server 2008 based computer. 

2. Expand and locate the sub tree as follows. 

HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters 

3. Add a new REG_DWORD key with the name of "Smb2" (without quotation mark) 

Value name: Smb2 

Value type: REG_DWORD 

0 = disabled 

1 = enabled

4. Set the value to 0 to disable SMB 2.0, or set it to 1 to re-enable SMB 2.0. 

5. Reboot the server. 

To disable SMB 2.0 for Windows Vista or Windows Server 2008 systems that are the “client” systems run the following commands: 

sc config lanmanworkstation depend= bowser/mrxsmb10/nsi 

sc config mrxsmb20 start= disabled 

Note there's an extra " " (space) after the "=" sign. 

To enable back SMB 2.0 for Windows Vista or Windows Server 2008 systems that 

are the “client” systems run the following commands:

sc config lanmanworkstation depend= bowser/mrxsmb10/mrxsmb20/nsi 

sc config mrxsmb20 start= auto 

Again, note there's an extra " " (space) after the "=" sign. 


© Oracle Blogs or respective owner

Related posts about /EPM/Installs and Config