- 浏览: 25824 次
- 性别:
- 来自: 北京
最新评论
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
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 849declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6761.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7491.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 842thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7061.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 760Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6511.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7101.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11161.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5321.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6131.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 701When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 556A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6511.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4101.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7551.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5371. tablespace,segment,extent,bl ... -
SQLPLUS TIPS
2011-12-09 17:51 8671.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 623ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6071.utl_file_dir: indicate the di ...
相关推荐
Oracle Net Configuration Assistant 配置步骤,简洁明了,看后很快就上手!非常完美的步骤解析,需要的小伙伴们放心下载哈!
Oracle Net Manager的配置过程
Oracle Net Manager配置截图 Oracle Net Manager配置截图
Oracle Database Net Services Administrator's Guide is intended for the following readers: ■Network administrators ■Directory server administrators ■Database administrators ■Decision makers This ...
解决Navicat Premiun 连接Oracle数据库报错 28547 connection to server failed, probable Oracle Net admin error
Oracle Net Framework Data Provider
解决使用Navicat Premium连接oracle的时候出现错误:ORA-28547:connection to server failed,probable Oracle Net admin error
谈手工配置Oracle Net8.pdf
基于目录服务器的Oracle Net应用.pdf
本篇重点给大家介绍oracle net manager 数据传输安全,具体操作步骤如下所示: oracle net manager来加密客户端与数据库之间或中间件与 数据库之间的网络传输数据 第一步:开始–>所有程序 –>oracle –> 配置和移植...
基于目录服务器的Oracle Net网络应用解决方案.pdf
用Navicat连接Oracle数据库时报错ORA-28547:connection to server failed,probable Oracle Net admin error-附件资源
Oracle 错误代码大汇总,方便大家更好查阅。
/u01/oracle/bin/netca: line 178: 11819 Aborted $JRE $JRE_OPTIONS -classpath $CLASSPATH oracle.net.ca.NetCA $* 错误 ...Oracle Net Services configuration successful. The exit code is 0
关于ORACLE在应用程序同时使用UDP与TCP 端口发现的问题的解决方案
Find out how to create databases, work with PDBs and CDBs, administer Oracle Net Services, and automate administrative tasks. Backup and recovery, security, and advanced multitenant options are ...
本文档主要讲述了Oracle_net服务端基本配置的基本配置,对一些入门级的人还是很有帮助的