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