oracle10g_installnotes
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.
相关新闻>>
- 发表评论
-
- 最新评论 更多>>