ORACLE NET

1.net_service_name:

   servive_name: The SERVICE_NAME is the global database name .=sid+domain

 

  net_service_name=
  (DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=host)(PORT=port) )
  (CONNECT_DATA=
  (SERVICE_NAME=service_name) ) )

 

2. locate port: oracle_home/install/portlist.int

 

3. jdbc oci driver: java appication call oci, connect oracle server

    jdbc thin driver: java application call thin driver ,not oci, complete connection.

 

4.

   connect identifier=net_service_name

   service name: show parameter service_names, presentation logical of the database

                          =db_domain.db_name=globalname

   connection Descriptor:location of the database

                                      name of the database service

   service register:database register information with the listener,pmon register information in the listener. 

                             services names

                             instance names

                             service handler:dispathers and dedicated servers

                             alter system register                          

   service handler:

   name method: easy connection string

                           host

                           tnsname

                           oid

 

5.listener.ora(server)

   tnsnames.ora(client)

   sqlnet.ora(client)   //Decided to name resolution method

 

   ORACLE_HOME/network/admin/  

 

6.spawns and bequeaths  connections( in dedicated server)

   hands off the connection  to a dispather(in shared server)

   redirect  the connection to a dispather or server process

 

7.service regster: static or dynamic register

               dynamic:pmon register informations

                             no listener.ora

                             db_name

                             db_domain

                             service_names

                             instance_name

                             local_listener

               static:listener.ora

                         oem

 

8.netca

   netmgr

   (static register)

   lsnrctl  start listenername

              stop

   tnsping oraclelsh

 

9.sqlplus hr/hr@//192.168.1.88:1521/lsh

   sqlplus hr/hr@oraclelsh

 

10.TNS_ADMIN

    $ORACLE_HOME/network/admin