How to test connectivity between a server and Oracle database?

If you have a new Windows server and preparing it to host web applications, one of the first configurations you should make is to open firewall ports between your web server and database server.

In order to make sure required ports are opened, use tnsping and ODBC testing tools. These utilities can quickly tell you if the database connectivity is available.

TNSPING Utility

  1. Open a Command Prompy (Start > Run > cmd)
  2. Type tnsping <servicename>
  3. If the result is OK, database connection is successful

ODBC Test Utility

  1. Open ODBC Administrator (Start > Search > ODBC)
  2. Click “Add”. Enter a service name and user ID
  3. Click “Test Connection”
  4. Enter your password when prompted. Click “OK”
  5. You should recieve “Connection successful” message

Note: Linux users can also use TRCROUTE utility. For more information, please refer to the link below.

References:

What to do if your Facebook ads are approved but not delivering?

Facebook Ads are very powerful as it’s the most used social network. You can reach a big amount of users with a little bit of budget.

What if your ads are not displayed to anyone even though you are willing to pay and you set everything up correctly?

In my case, ads looked “Active” but all columns including “Reach“, “Impression“, and “Cost” were empty.

Solution

There might be several reasons why your ads are not displayed. Try these:

  • Make sure the status of your ads are “Active
  • Give Facebook sometime to find the audience for you and place your ads (They say up to 24 hours but I’d say wait maximum 8 hours)
  • Make sure you didn’t exceed your lifetime campaign spending budget
  • Make sure audience and budget settings for your campaign, ad set, and ad don’t overlap each other
  • Be more specific for your audience selection (select language, interests etc.)
  • Create ads or boost your posts by using another Facebook account
  • Make changes to your ad text or photo

If nothing works, send a feedback message to Facebook. They don’t guarantee to reply but they will look into it if there is a bug.

What to do if your Facebook posts are disappearing all of a sudden?

Imagine you spend time and effort to post things to your personal timeline or business page on Facebook but they are removed without any trace or notification. If you boosted these posts, you will see the errors below in your Ads Manager:

Missing Required Parameter: To generate a creative preview, ‘creative_id’, ‘ad_id’ OR ‘creative’ must be provided. (fbtrace_id: Dbl50XhjKhT)

Permission Error: Either the object you are trying to access is not visible to you or the action you are trying to take is restricted to certain account types. (fbtrace_id: BMPRBL4yuie)

Solution

Check your Activity Log. Do you see the post there? If yes, you can make it visible in your timeline by clicking the button next to it.

If the post is not displayed in your Activity Log, it means it’s gone (sorry). Try to add it again. If it disappears again, try these before giving up using Facebook:

  • Find the pattern: If there are both text and photo, try posting only text or only photo. Does it disappear?
    • If it disappears when there is only text, it means there is a link or something else that makes Facebook behave oddly. Make changes to your text and try again
    • If it disappears when there is only photo, it means the content or format of the photo breaks a logic somewhere. Try uploading another photo. Try changing to extension of the photo (PNG to JPG or JPG to PNG)
  • Use another account: If this is a page or group, try posting from another Facebook account
  • Change configuration: Go through the settings of your timeline or page. Play with privacy, location, and other settings to find a way to get around this issue

In my case, the issue was the format of the photo (I know, it sounds weird). I changed it from PNG to JPG and my posts stayed in my page!