Oracle tips and tricks

How to send SMS from ORACLE forms 10g

Here's how to send sms message from Oracle application.

Explain:

Say we are subscribed to msegat.com service with the following credentials:

User Name : OMAR

Password : 123

User Sender : ThreeM ( you got it from your sms site)

Text we'll send : My_Test_Message

Phone we'll send message to : 966123456789

Here's how the code will run:

/*Start of SMS code*/

SET serveroutput ON

SET Define OFF

DECLARE

    HTTP_REQ      UTL_HTTP.REQ;

    HTTP_RESP     UTL_HTTP.RESP;

    URL_TEXT      VARCHAR2(32767);

    URL VARCHAR2(2000);

     SMS_MSG VARCHAR2(160) := 'Congratulations! Your database has been configured propoerly for sending SMS through a 3rd party SMS Gateway';

BEGIN

    DBMS_OUTPUT.ENABLE(1000000);

--Based on your service provider, the following link format may differ from

--What we have specified below!    

URL := 'http://msegat.com/gw/?userName=OMAR&userPassword=123&numbers=966123456789&userSender=ThreeM&msg=My_Test_Message&By=Link&msgEncoding=UTF8'||

UTL_URL.Escape(SMS_MSG,TRUE); 

--UTL_URL.Escape manages escape characters like SPACE between words in a message.

    HTTP_REQ  := UTL_HTTP.BEGIN_REQUEST(URL);

    UTL_HTTP.SET_HEADER(HTTP_REQ, 'User-Agent', 'Mozilla/4.0');

    HTTP_RESP := UTL_HTTP.GET_RESPONSE(HTTP_REQ);

    -- Process Request

    LOOP

        BEGIN

            URL_TEXT := null;

            UTL_HTTP.READ_LINE(HTTP_RESP, URL_TEXT, TRUE);

            DBMS_OUTPUT.PUT_LINE(URL_TEXT);

            EXCEPTION

                WHEN OTHERS THEN EXIT;

        END;

    END LOOP;

    UTL_HTTP.END_RESPONSE(HTTP_RESP);

END;

/*End of SMS code*/

If you got an error , you can remove :

SET serveroutput ON
SET Define OFF

"و فوق كل ذي علم عليم"

Installing WebLogic 11g

Oracle Weblogic 11g is the new generation of Oracle Forms10g.

FMW (Oracle Fusion MiddleWare ) is newer than Forms10g.

I found Weblogic more easier to run Oracle Application over network and internet also.

Here's my steps I did to install both of Weblogic 11g and FMW.

Windows Server 2003 is recommended

1# Install Oracle DB 10g or 11g here's my howto

2# Download and Install Weblogic 10.3.6.0 (Direct link...)

3# Download FMW (Links in attached PDF...)

4# Install FMW first part (file consists of 4 parts)

While installing ...make sure to check option :Install software-Do not configure

5# Install FMW Patchset file (file consists of 3 parts)

6# Copy tnsnames.ora file

from: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora

To C:\oracle\Middleware\as_1

7# Configure Software :

Oracle Classic11g-Home1 then Configure Classic Instance

While installing ...make sure to Uncheck option :Oracle Portal and Oracle Discoverer

Make sure to save configuration in text file as you need it later.

8# Run both of NodeManager and wait until the word port appears

9# Run both of Start WebLogic and wait until the word Running mode appears

10# Login to Weblogic Web interface ( It's always PC-Name:7001/console)

from the left corner select Environment then Servers then choose Control tab ,then select WLS_FORMS and WLS_REPORTS then press Start button.

11# If Forms don't run well , then you can :

download Java J8u92

edit Formsweb.cfg to adapt with java

Add exception for forms site in Java application

Thanks to :

mojtaba from ArabOUG

m Tarik

Install Microsoft Loopback Adapter in Microsoft Windows Server 2003

You may need to make your IP static , to make sure reports run well .

So you should install the Microsoft Loopback Adapter by using the Hardware Wizard, follow these steps:

In Control Panel, double-click Add Hardware, and then click
Next

Click Yes, I have already connected the hardware, and then click
Next.

At the bottom of the Installed hardware list, click Add a new hardware device, and then click Next.

Click Install the hardware that I manually select from a list, and then click Next

In the Common hardware types list, click Network adapters, and then click Next.

In the Manufacturers list box, click Microsoft.

In the Network Adapter list box, click Microsoft Loopback Adapter, and then click Next.

Click Next to start installing the drivers for your hardware.

Click Finish.

Click Start, click Settings, and then click Network Connections to verify that the Microsoft Loop-back Adapter has been installed.

Here's How to install Loop-back adapter on other windows and how to install Oracle ArabOUG

Source : How to install the Microsoft Loopback Adapter in Microsoft Windows Server 2003

Restore Oracle Application Server ias_admin password ?

Just go to the directory $ORACLE_HOME/sysman/j2ee/conf. In this directory you'll find the configuration file jazn-data.xml. Inside this configuration file you'll find the definition of the ias_admin user including his encrypted password:

Here's my own ORACLE_Home Path : c:\oracle\FRHome_1\sysman\j2ee\config\jazn-data.xml

snippet from jazn-data.xml
<users>
...
<user>
<name>ias_admin</name>
<credentials>{903}YdvTMA...</credentials>
</user></users>

Inside the tag <credentials> you see the encrypted password of the ias_admin. To reset the password, just change the value inside the tag <credentials> as follows:

snippet from jazn-data.xml

<users>
...
<user>
<name>ias_admin</name>
<credentials>!mynewpassword1</credentials>
</user></users>

The new password you have to provide in clear text has to start with a "!". Be aware that the new password must match the password rules: minimum 6 signs and one sign must be a number. After your changes, stop the ASC and restart it with following commands:

emctl stop iasconsole

emctl start iasconsole

Now you can login with your new password and inside the jazn-data.xml the provided password in clear text is automatically changed into an encrypted password.

Thanks to Dirk Nachbar

ora - 12514 and ora - 12505 tns listener error fixed

Here's how to fix this ora.

Open SQL Plus

run SYS/SYS as SYSDBA

then write the following lines :

show parameter local_listener

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=LOCALHOST)(PORT=1521))' scope=both;

alter system register;

show parameter local_listener

enjoy watching video...

Windows Server 2003 external drives

After installing Microsoft Windows Server 2003 .

I found when attaching USB hard disk , it shows USB icon but does not mount Disk itself.

Here's how to fix it :

C:\>diskpart
diskpart>automount          
diskpart>automount enable   
diskpart>automount scrub    
diskpart>exit
C:\>exit

Source : ServerFault

Battery icon missing in Windows 10 - Microsoft Community

For those who lost Battery Icon in the task bar here is how to fix it :

Device manager,Batteries

disabled/ re-enabled AC Adapter

disabled/ re-enabled ACPI Compliant Control Method Battery.

The battery icon should appear almost immediately after doing so and it is still there after restarting computer.

Battery icon missing in Windows 10 - Microsoft Community: