Oracle Networking –II (Two Task) and Shared Server Architecture

                                      

TNS_ADMIN, TWO_TASK environment variable

TNS_ADMIN

Changing default location of listener and tnsname files

Syntax:

     $export TNS_ADMIN=’/u01/user18/netadmin’ 

 To make it permanent set this command in

~/.bash_profile

TWO_TASK:

To set the tns service alias one time

We can use TWO_TASK Environment Variable:

$export TWO_TASK=<tnsservice-name>

Ex:

$export TWO_TASK=toprod

$Sqlplus hasuser/hasuser    //no need of giving @tnsservice

Shared Server Architecture (SSA)

What? A shared server process, can serve multiple user sessions

* The Sessions communicate to Shared Server processes through Dispatcher process

Configuring SSA:

Shared Servers:

Sql>alter system set shared_servers=3 scope =both;

Dispatchers:

Sql>alter system set dispatchers=”(address= (protocol= tcp) (host=192.168.0.100)(port=1700))(dispatchers=3)” scope =both;

 

Clients to use the Dedicated Server Architecture, in oracle shared server environment

Tnsnames.ora 

toprod =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = haszone.dba.com)(PORT = 1700))

    (CONNECT_DATA =

      (SERVER= DEDICATED)

      (SERVICE_NAME = has)

    )

  )

Important Views:

                          V$dispatcher          

            v$shared_server

                           V$circuit

NOTE: RMAN utility (for backup, recovery) requires dedicated connections only.