O10g Install Notes
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
the definition is that a partition without formating and write the disk directly through operation system.
the ASM builded on it.
[oracle@station3 network]$ du -sh
7.2M .
[oracle@station3 network]$ pwd
/u01/app/oracle/product/10.2.0/db_1/network
has the session layer and presentation layer.
the naming rule is 8 characters and begin with a letter.
[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
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.
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?
SQL> conn /as sysdba;
Connected.
SQL> show parameter db_name
NAME TYPE VALUE
db_name string orcl
SQL> show parameter db_domain
NAME TYPE VALUE
db_domain string oracle.com
SQL> show parameter service_names
NAME TYPE VALUE
service_names string orcl.oracle.com
@@@when you install a oracle just.you can see below port is used by oracle.
@@@check the services you have after you install a oracle database.
[oracle@station3 ~]$ ps aux | grep :1158
oracle 8342 0.0 0.0 4124 604 pts/1 R+ 03:06 0:00 grep :1158
[oracle@station3 ~]$ ps aux | grep :5560
oracle 8357 0.0 0.0 4124 604 pts/1 R+ 03:06 0:00 grep :5560
[oracle@station3 ~]$ ps aux | grep :1521
oracle 8362 0.0 0.0 4124 604 pts/1 R+ 03:06 0:00 grep :1521
[oracle@station3 ~]$ ps aux | grep :3938
oracle 8380 0.0 0.0 4124 604 pts/1 R+ 03:06 0:00 grep :3938
[oracle@station3 ~]$ isqlplusctl start| stop
http://192.168.0.3:5560/isqlplus/
[oracle@station3 ~]$ emctl status dbconsole
http://192.168.0.3:1158/em
8)the global database name(service_name) relative parameter.
7)custom database
6)the different filesystem between OMF and OFA
5)hostname related
4)sid
it is so small.because the oracle network is base on the TCP/IP,it just
3)network
2)rawdevice
