ORACLE.NET : Configuration oracle 11g

Oracle SQL developer is free and is very powerful more. We can compare it to sql server management studio. To launch sqldeveloper under linux :


A panel to create a connexion to sqldeveloper using tnsnames connectors like below is necessary :


To see the content of an .ORA file we can make the cat instruction like below :


How to configure a tnsname correctly ?





To connect to sqlplus with a tnsname:
type under test base (export ORACLE_SID=test):

sqlplus demo/demo@production1


Some useful SQL requests to see which sessions are online. Be connected as (sys/test) as sysdba on base test.

SQL>select s.osuser, s.username, s.sid, s.serial#, s.program "Prog. Client", p.program "Prog. server",s.server, s.terminal from v$session s, v$process p where s.paddr = p.addr and type <> 'BACKGROUND' and s.username not in ('SYSMAN','DBSNMP');

we can use this request too

SQL>select username, terminal, serial#, sid, to_char(logon_time, 'DD-MM-YYYY hh24:mi:ss') "Connect time" from v$session where type <> 'BACKGROUND' and username not in ('SYSMAN','DBSNMP');

Alter system kill session ‘sid,serial#’;

alter system kill session '154,46';

– Do never kill an internal session where username is not null;
– Netmgr program is like tsadim and allow to manage all tns connections.




Since 20 years I work on Database Architecture and data migration protocols. I am also a consultant in Web content management solutions. I am an experienced web-developer with over 10 years developing PHP/MySQL, C#, VB.Net applications ranging from simple web sites to extensive web-based business applications. When not writing code, I like to dance salsa and swing and have fun with my little family.

You may also like...