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

 

 

              

 

 

  

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值