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 :

$ORACLE_HOME/sqldeveloper/sqldeveloper.sh

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

tnsnames.ora-01


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

tnsnames.ora


How to configure a tnsname correctly ?

netca1

 

netca2

netca3netca4

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

sqlplus demo/demo@production1

—————————————————————————
tnsnames.ora-02

—————————————————————————
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.

Cheers

 

extradrmtech

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