oracle10g_installnotes

来源:网络 责任编辑:栏目编辑 发表时间:2013-07-02 01:48 点击:

oracle10g  emperor_majesty
####################################################
oracle notes1_install
oracle is a object-oriented repair-itself flashback relational database.
#######################################################
1)ports
1#####
the ports 5500-5559 are used for Real Application Culsters.
the port 5560 is used for isqlplus
$isqlplusctl start | stop
2#####
the port 1158 is used for Enterprise Managerment(EM)
http://192.168.0.1:1158/em    login your EM of the oracle
3#####
the port 3938 is used for keeping watch on the oracle users sysman and
dbsnmp.so when you installed a oracle, you can see these users account unlocked default.
the directory $ORACLE_HOME/station1.example.com_orcl is bulided for it.
the basis theory is that Operation System control the two users through the port 3938 to report information to the port 1158(EM).therefore we can
see the used cpu about computer information in the EM.
4#####
the port 1521 is used for listener
it also be used to connect your instance.
SQL>  alter system set service_names='orcl.oracle.com';
System altered.
SQL> show parameter service_n
NAME                                 TYPE        VALUE
service_names                        string      orcl.oracle.com
SQL> conn sys/oracle@192.168.0.3:1521/orcl.oracle.com as sysdba;
Connected.
5#####
check the port used.
[root@station3 ~]# netstat -lntp | grep :1521
tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN      16807/tnslsnr   
2)rawdevice
the definition is that a partition without formating  and write the disk directly through operation system.
the ASM builded on it.
3)network
[oracle@station3 network]$ du -sh
7.2M    .
[oracle@station3 network]$ pwd
/u01/app/oracle/product/10.2.0/db_1/network
it is so small.because the oracle network is base on the TCP/IP,it just
has the session layer and presentation layer.
4)sid
the naming rule is 8 characters and begin with a letter.
5)hostname related
[root@station3 ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1  station3.example.com station3 localhost.localdomain localhost
::1        localhost6.localdomain6       localhost6
6)the different filesystem between OMF and OFA
OMF(Oracle Managed File) autogenerate the name and filedirectory. it is used for flashback and ASM(Auto System Manager).the filename is ORCL.
OFA(Optimal Flexiable Architecture) the filename is orcl.
7)custom database
when you dbca the interface will be presented before you.
custom database: it format begin with blocks.the incarnation is 1.it would be take a long time to generate.
other ways create database: it create controlfile change the instance name only.the incarnation is 446075 and so on.it would be fast.
what's the different between these nature?
8)the global database name(service_name) relative parameter.
SQL> conn /as sysdba;
Connected.

    相关新闻>>

      发表评论
      请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
      用户名: 验证码:点击我更换图片
      最新评论 更多>>

      推荐热点

      • Table函数使用简介
      • Oracle数据库Constraint约束的常用操作及异常处理
      • Bulk Collect性能分析(zz)
      • export/import的使用
      • OCP043第十五讲 Database Security
      • ORACLE10gr2数据导入MySQL方案
      • oracle 让sys用户可以使用isqlplus
      • 在oracle数据库下使用iSQL*Plus DBA访问数据库
      • Oracle行列转换小结
      网站首页 - 友情链接 - 网站地图 - TAG标签 - RSS订阅 - 内容搜索
      Copyright © 2008-2015 计算机技术学习交流网. 版权所有

      豫ICP备11007008号-1