SQL Developer & fixing missing MSVCR100.DLL Error

As salamualikum (islamic greetings), brothers and sisters.

 Huhh, Post again after a long time. I'm passing very busy time. Lot's of change around me.

Come to the topic.

When you run first time after installation or migration from any other older Oracle SQL Developer, you can heart at the very first and see the following messages...

 duhh ! :( 

How you solve the problem ?

It's easy, go to driver location of jdk for example: \sqldeveloper\jdk\jre\bin
 you will see the MSVCR100.DLL and copy it to

\sqldeveloper\sqldeveloper\bin  folder.

Now, you are done... 

Start the Team Viewer. An what you get ?


Comments to share your thoughts.. 


End for the day....

Praise to Almighty Allah(swt).  :)

Fi amanillah

 

How to get connected user session and the application name, who are using ?

As salamualikum (islamic greetings), brothers and sisters.

 Huhh, Post again after a long time. I'm passing very busy time. Lot's of change around me.

Come to the topic. And it's about database session issue.

Here we will learn how to get all the open database session (open by different application) and also the session for a particular USER.

By this information you will kill the session and also terminate any session forcefully and do you necessary works with the database.

connect database with the SYS/SYSTEM user. And run the bellow code.

SELECT s.inst_id,
       s.sid,
       s.serial#,
       p.spid,
       s.username,
       s.program,
       s.machine
FROM   gv$session s
       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND';

it will show you all the open session for the database. If you need for a particular user, then run the bellow code.

SELECT s.inst_id,
       s.sid,
       s.serial#,
       p.spid,
       s.username,
       s.program,
       s.machine
FROM   gv$session s
       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND'
AND s.username='db_user';

If you want to get just in a easy SQL, then run the bellow code,

select sid
           ,serial# 
from v$session 
where username = 'db_user';

Now, you get all the required information to terminate the specific session. How will you do this ?

You need to follow the following syntax.

alter system kill session '<sid>,<serial#>';

alter system kill session '39,1232';

You are done...!!!

Do you need to close all the session for a specific user ?

Then you will need a LOOP to close one by one. Follow the bellow example.

begin    
    for x in ( 
            select Sid, Serial#, machine, program 
            from v$session 
            where 
                username = 'db_user' 
        ) loop 
            execute immediate 'Alter System Kill Session '''|| x.Sid 
                     || ',' || x.Serial# || ''' IMMEDIATE';
            dbms_output.put_line('Connected Session Found from '||x.machine||', Via '||x.program);                   
        end loop; 
    dbms_output.put_line('Ops! No Connected Session Found.');
end;


End for the day....

Praise to Almighty Allah(swt).  :)

Fi amanillah

Error FRM-92095: Oracle Jnitiator version too low

As salamualikum (islamic greetings), brothers and sisters,

Today my topic is Error FRM-92095: Oracle Jnitiator version too low

Symtom:

After logging into application, system pop up below error message:

FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 or higher

Cause:

The JRE version is not incompatible.

Why it comes/shows ? 

When you have installed JRE version which is incompatible with your oracle form version, then you will get the above message. For example, your form version is 10.1.2.3 or 10.0.1.2 and your installed JRE version is 1.7.xx.xx, in that case you will get the message.

Cause this form version isn't certified by oracle corporation.

How to solve this ?

Open the "Java Control Panel" window.
Click the Java tab, then the View... button.

This should open a Java Runtime Environment Settings window with two tabs: User and System.
On User tab, under Runtime Parameters, enter:

-Djava.vendor="Sun Microsystems Inc."

OR

-Djava.vendor="New Oracle"

click Ok. then Apply and Ok.

 

That's it. Close the  brower and java console and retry.

Praise to Almighty Allah(swt).  :)

Fi amanillah