How to uninstall a managed extension in Google Chrome?

Under Settings – Extensions ; you get an error that says “This extension is managed and cannot be removed or disabled”

Removing it is pretty straight forward; although not through Google Chrome

  • Note the ID of the Extension that you wish to remove; appears as junk alphabets (eg: lmnoplmnopsatlyu)
  • Close Google Chrome
  • Open Windows Explorer
  • Ensure you have access to all hidden files – Organise – Folder and Search Options – View
  • Navigated to C:\users\<username>\Appdata\Local\Google Chrome\User Data\Default\Extensions
  • Delete the Folder that matched the Extension ID
  • Restart Google Chrome

Delete Duplicate Rows in an Oracle Table

How to delete duplicate records in Oracle Table

I would consider that the duplicated columns appear one after the other in the table

If yes; below SQL Query will take you through. You may add or remove additional column conditions in your where clause to satisfy the specific scenario

 

DELETE TABLE A WHERE ROWID >(
select min(rowid) from TABLE b
where a.<table.column1>=b.<table.column1>
and a.<table.column2>=b.<table.column2>)

But if your duplicated columns do not appear in the continuous order; I would recommended you create a temporary table that stores the data in the intended ordered format and the proceed with the above operation. You can then later replace the rows of your original table with rows from the Temporary Table

CREATE TABLE TABLE_TEMP AS SELECT * FROM TABLE ORDER BY <table.column1>

Microsoft Outlook Error – Cannot add to the Server Junk Email Lists

300x75_52930061bbfad.gif

This applies to Exchange Email Setups running under the Exchange Server 2010 Setup

Before you go in and try to reach your exchange admins to look at this issue.

Kindly first check your contacts folder in outlook. Do you have more than 1000+ contacts? The error may seem to be cropping from this; though its not your fault.

Under Options – Click Junk Email – Under Safe Senders Tab – Remove the Tick Mark against “Also Trust e-mail from my contacts”

With this option enabled, Outlook attempts to add all of the email addresses for your contacts to the Safe Senders list. So if you are having thousands in your contacts folder; your limit on the exchange server for such information which is by default 510kb is exhausted.

If this option was unticked and you still continue to face the problem; it is time to get in touch with the Exchange Administrators

If you are an exchange admin yourself; below post would be helpful

http://support.microsoft.com/kb/2669081/en-gb

300x75_52930061bbfad.gif

Log into Oracle using (Easy Connect) EZConnect

You can use Third Party Tools like Toad or Navicat which have excellent GUI to get you logged into Oracle

But if you want to go the traditional way; find below instructions

  • Open Command Prompt
  • Type:  sqlplus sys/password@<hostname>/<global service name> as sysdba
  • Typing the password in this manner is never recommended; instead use below option
  • Type: sqlplus sys@”<hostname>/<global service name>” as sysdba
  • It will then prompt to enter password
  • An alternate way is to log into SQL initially without a user
  • sqlplus / nolog
  • Now under SQL Prompt; type connect sys@”<hostname>/<global service name>” as sysdba

Oracle Forms6i Installation Error on Windows 7 64-bit

468x60_530dc0b31d88d.gif

When you try installing forms you may get the error: forms60.vrf(78):OS_ERROR while getting value Path

This error has got to do with the character length of Path Environment Variable Field. For Forms6i installation to happen; the character length in the field should be less than 1000. You can definitely cant keep counting to check this. So best is to temporarily cut a portion of the Environment Variable until the installation is completed.

If you are an Oracle Professional; I need not tell you where the environment variable is; for the rest please find below instructions

  • Right Click My Computer – Properties
  • Advanced System Settings
  • Under Advanced Tab; Click Environment Variables
  • Under System Variables; look for variable named Path
  • Select Path and click Edit
  • Copy the contents in the Variable Value to any text editor like notepad
  • Copy and replace a small portion of the variable value back into the field
  • Start your forms6i installation and once done revert back the Variable Value from your notepad file

468x60_530dc0b31d88d.gif