Monthly Archives: October 2012

Shared Folder Is Not Accessible

Problem:

After sharing folders on Windows 2003, unable to access them from Windows XP. XP does not prompt for the Windows 2003 login. The following message appears:

\APPSWINDOWS11gR2 is not accessible. You might not have permission 
to use this network resource. Contact the administrator of this 
server to find out if you have access permissions. 
Access denied

Solution:

Manually map network drives to the Windows 2003 shared folders from XP machine using the NET USE command, adding the /USER switch to include the user name.

Read more »

Basic RMAN Commands

Here is a list of some RMAN commands I frequently use:

1. To connect to RMAN without a repository:

rman target /

2. To crosscheck backups:

crosscheck backup;

3. To list expired backups:

list expired backup;

4. To delete expired backups:

delete expired backup;

5. To set a disk destination for backups:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT¬†¬† ‘E:backupDEV1%U’;

6. To include a maximum size of 2GB for backupset pieces:

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G FORMAT ‘E:backupDEV1%U’;

7. To execute a backup to the default location:

backup database;

8. To restore and recover datafile 30:

run {

restore datafile 30;

recover datafile 30;

}

Internet Explorer cannot display the webpage When Connecting to OEM

Problem:

After applying latest OS updates (October 9, 2012) on Windows XP SP3, Internet Explorer 7 (IE7) can no longer connect to Oracle Enterprise Manager (11g) via SSL (https). Firefox is able to connect to OEM.

Solution:

Update for Windows XP (KB2661254-V2) affecting certificates. Quick fix: from Add/Remove Programs, check ‘Show updates’, remove Update for Windows XP (KB2661254-V2) and reboot.

Note that removing Windows updates may affect your computer’s security. Proceed at your own risk.

*** UPDATE: Oracle has fixed the issue in MOS ID: 1489557.1 (EM Grid Control 11g Console Not Accessible Via Internet Explorer After Applying Microsoft Security Patches On Client PC)

Reference:

Microsoft Security Advisory (2661254): Update For Minimum Certificate Key Length
http://technet.microsoft.com/en-us/security/advisory/2661254

Microsoft Security Advisory (2749655): Compatibility Issues Affecting Signed Microsoft Binaries
http://technet.microsoft.com/en-us/security/advisory/2749655
Read more »