Convert google map into image using longitude and latitude

Google Map Image based on Address

<img src="https://maps.googleapis.com/maps/api/staticmap?center=Brooklyn+Bridge,New+York,NY&zoom=12&size=600x400"/>

Google Map Image based on Latitude & Longitude

<img src="https://maps.googleapis.com/maps/api/staticmap?center=40.714728,-73.998672&zoom=12&size=600x400"/>

Google Map Image with Marker based on Latitude & Longitude

<img src="https://maps.googleapis.com/maps/api/staticmap?center=40.714728,-73.998672&markers=color:red%7Clabel:C%7C40.718217,-73.998284&zoom=12&size=600x400"/>

Save Google Map as an Image using PHP

<?php
    $src = 'https://maps.googleapis.com/maps/api/staticmap?center=40.714728,-73.998672&markers=color:red%7Clabel:C%7C40.718217,-73.998284&zoom=12&size=600x400';
    $time = time();
    $desFolder = 'images/';
    $imageName = 'google-map_'.$time.'.PNG';
    $imagePath = $desFolder.$imageName;
    file_put_contents($imagePath,file_get_contents($src));?><img src="<?php echo $imagePath; ?>"/>

Specify a Google API Key

Use key parameter with the URL of Google Static Maps API for specifying a Google API Key.

https://maps.googleapis.com/maps/api/staticmap?center=40.714728,-73.998672&zoom=12&size=600x400&key=YOUR_API_KEY

Reference Link: https://developers.google.com/maps/documentation/maps-static/intro

How to add sequence number within groups of repeating values

The Problem


Some Column
---------
A   B   C
1 101
2 101
3 102
4 102
5 102
6 102
7 103
8 104
9 104


and you want to apply a sequence number within each group of numbers, starting at 1 again for each instance of a new group, so your resulting data will look like this;


Some Column Sequence
------------------
A   B  C
1 101 1
2 101 2
3 102 1 )
4 102 2 ) An ascending sequence number is created
5 102 3 ) for each group of numbers e.g. '102'
6 102 4 )
7 103 1
8 104 1
9 104 2

Question.
How do we use a formulas to create the sequence number rather than typing one by one or dragging it down?


Solution:
Try this.
Say your numbers are in cell A1 down.
Copy this into another column from Row 1 down
=COUNTIF($A$1:A1,A1)

Oracle 12c form builder or form compiler not opening due to MSVCR100.dll is missing

Error raised while opening Oracle 12c form builder or form compiler

The program can't start because MSVCR100.dll is missing from your computer. Try reinstalling the program to fixthis problem.

Solution:
Download Microsoft Visual C++ 2010 x64 and install.

Download MS Visual C++2010 x64 (for MSVCR100.dll missing)
Download MS Visual C++2010 x64 (for MSVCR100.dll missing) [Direct]

Window .bat Script to compile all forms / libraries / menus

Please create a .bat file in the same folder where u have fmbs, mmb etc and if u did not create working directory please create working director first in default.env after that run the following command.

@ECHO OFF 
cls 
Echo compiling libraries 10g .... 
for %%f IN (*.pll) do frmcmp userid=User_name/pass@orcl module=%%f batch=yes module_type=library compile_all=yes window_state=minimize 
ECHO libraries compilation complete
ECHO ----------------------------------
Echo compiling menus 10g .... 
for %%f IN (*.mmb) do frmcmp userid=User_name/pass@orcl module=%%f batch=yes module_type=menu compile_all=yes window_state=minimize 
ECHO menus compilation complete
ECHO ----------------------------------
Echo compiling forms 10g .... 
for %%f IN (*.fmb) do frmcmp userid=User_name/pass@orcl module=%%f batch=yes module_type=form compile_all=yes window_state=minimize 
ECHO form compilation complete
ECHO ----------------------------------
ECHO Form Compilation complete

ORA-1017 raised after resolving ORA-28040

ORA-28040: No matching authentication protocol

ORA-1017 Invalid Username or Password

Above error raised when resolving the ORA-28040 (Connecting Oracle 12c with 11g or lower client)

Following a recent database upgrade to 12.2, an 11gR2 client might suddenly start to fail to connect to the database with an error ORA-28040.

Click to see the solution for ORA-28040 


However, once the ORA-28040 error is cleared, the client still cannot connect and a persistent ORA-1017 is returned.

Solution:

- Connect with sys user 

- Expire user password

- Reset the password
- Re-connect with client 

```

SQL> alter user scott password expire;

User altered

SQL> alter user scott identified by tiger;

User altered

```

ORA-28040: No matching authentication protocol exception

Error raised when connecting oracle 12c with 11g or lower client:

Add the following parameter in SQLNET.ora file db/network


SQLNET.ALLOWED_LOGON_VERSION=11
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

ORA-12638: Credential retrieval failed

Cause: The authentication service failed to retrieve the credentials of a user.

 

Action: Enable tracing to determine the exact error.

The original question was referring to a problem installing Oracle Designer, in which the user was thrown ORA-12638 when testing the connection, before the installation had completed.  

The ORA-12638 is an Oracle database error, indicating that the SQL*Net client was unable to connect to the database.  In Windows, the Oracle Windows client attempt to use your current Windows domain credentials to authenticate you with the Oracle server. This could fail because the Windows box is not configured to support Windows authentication or because the credentials you use to login to your local machine are not sufficient to allow you to login to the server. There are several possible resolutions for the ORA-12638 error:

1:  In on Windows, bounce the server (stop and re-start) the Windows services for Oracle.

2:  The following direction was given, and once administered, was a successful resolution to ORA-12638:

Please change the sqlnet.ora file in the $ORACLE_HOME/network/admin directory. 

Change the following entry:

Change - SQLNET.AUTHENTICATION_SERVICES= (NTS)

To: - SQLNET.AUTHENTICATION_SERVICES= (NONE)

REP-51019: System user authentication is missing

Solution:
First take a back/rename up of your rwserver.conf original file.


Some changes required in rwserver.conf
remove security tag from

You will find the rwserver.conf file from the below path.


C:\Oracle\Middleware\Oracle_Home\user_projects\domains\Classic_domain\config\fmwconfig\components\ReportsServerComponent\Your_report_server_name\rwserver.conf


C:\Oracle\Middleware\Oracle_Home\user_projects\domains\Classic_domain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\rwserver.conf


C:\Oracle\Middleware\Oracle_Home\user_projects\domains\Classic_domain\config\fmwconfig\components\ReportsToolsComponent\reptools1\rwserver.conf


<job jobType="report" engineId="rwEng" securityId="rwJaznSec"/>
to
<job jobType="report" engineId="rwEng"/>

Also,

Comment the line below from
<security id="rwJaznSec" class="oracle.reports.server.RWJAZNSecurity"/> 

to 

<!--security id="rwJaznSec" class="oracle.reports.server.RWJAZNSecurity"/-->


1) Make single signon yes
2) Add <webcommandaccess>L2</webcommandaccess> in oracle/user_projects/domains/forms_domain/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration/rwservlet.properties


Restart your Report Server….

Note: Change all path as per your configurations