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