{"id":1473,"date":"2013-10-13T14:00:56","date_gmt":"2013-10-13T12:00:56","guid":{"rendered":"http:\/\/www.extradrm.com\/?p=1473"},"modified":"2013-10-16T22:33:24","modified_gmt":"2013-10-16T20:33:24","slug":"oracle-net-configuration-oracle-11g","status":"publish","type":"post","link":"https:\/\/www.extradrm.com\/?p=1473","title":{"rendered":"ORACLE.NET : Configuration oracle 11g"},"content":{"rendered":"

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

$ORACLE_HOME\/sqldeveloper\/sqldeveloper.sh<\/pre>\n
.
\nA panel to create a connexion to sqldeveloper using tnsnames connectors like below is necessary :<\/p>\n
\"tnsnames.ora-01\"<\/a><\/p>\n
\n
—————————————————————————
\nTo see the content of an .ORA file we can make the cat instruction like below :<\/strong><\/p>\n
\"tnsnames.ora\"<\/a><\/p>\n
\n
How to configure a tnsname correctly ?<\/h2>\n
\"netca1\"<\/a><\/p>\n
 <\/p>\n
\"netca2\"<\/a><\/p>\n
\"netca3\"<\/a>\"netca4\"<\/a><\/p>\n
To connect to sqlplus with a tnsname:<\/strong>
\ntype under test base (export ORACLE_SID=test<\/strong>):<\/p>\n
sqlplus demo\/demo@production1<\/pre>\n
—————————————————————————
\n\"tnsnames.ora-02\"<\/a><\/p>\n
—————————————————————————
\nSome useful SQL requests to see which sessions<\/strong> are online. Be connected as (sys\/test) as sysdba on base test.<\/p>\n
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');<\/pre>\n
we can use this request too<\/p>\n
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');<\/pre>\n
Alter system kill session ‘sid,serial#’;<\/p>\n
alter system kill session '154,46';<\/pre>\n
– Do never kill an internal session where username is not null;
\n– Netmgr program is like tsadim and allow to manage all tns connections.<\/p>\n
Cheers<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
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...<\/p>\n","protected":false},"author":1,"featured_media":2845,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[240],"tags":[246,247,248],"youtube_video":null,"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/1473"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1473"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/1473\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/2845"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}