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:

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


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


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


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


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


6. In the Manufacturers list box, click Microsoft.


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


8. Click Next to start installing the drivers for your hardware.


9. Click Finish.


10. 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:

Extract characters between specific strings in Oracle

To Extract specific characters from text we usecombination of  SUBSTR or INST functions .







SUBSTR Function :



It cuts a part of the Character from a a position we  define.







For example :



SELECT   SUBSTR ('HeIsGood', 3) FROM DUAL



The result is :



IsGood







INSTR Function :



It calculates the position of specific text we define inside Character.



For example :



SELECT   INSTR ('cocacola', 'co', 2) FROM DUAL



The result is :



5





We can use combination of INSTR and SUBSTR to extract characters between specific text as following:





SELECT SUBSTR('1/9/1438', 1 ,INSTR('1/9/1438', '/', 1, 1)-1) "DAY", SUBSTR('1/9/1438', INSTR('1/9/1438','/', 1, 1)+1,



INSTR('1/9/1438','/',1,2)-INSTR('1/9/1438','/',1,1)-1) "MONTH", SUBSTR('1/9/1438', INSTR('1/9/1438','/', 1, 2)+1) "YEAR"



FROM dual;



The result is :

1  9  1438

Thanks to PSOUG.org

Router Unable to load some websites and download apps from Google Play

After buying new ZAIN router (Saudi mobile company)  , I found that some sites does not open like portal.elm.sa/



So I found trouble was belongs to Router Firewall .



Disabling Firewall fixes it.