史上最新的rhel7.5+oracle 18c安装成功

郑全 · 发表于 2018-4-13 18:17:43

本帖最后由郑全于 2018-4-13 19:13 编辑

受朋友所托,安装了rhel7.5+18c,为了方便交流,记录了部分,名字随意取的,如果你要认真,那你就输了.

2018年4月11日rhel7.5发布,赶紧下载下来,最简单的安装,server with gui.
安装上来看看,安装完成,没有看到ansible.

[root@dbserver ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.5 (Maipo)

[root@dbserver ~]# yum list ansible
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Error: No matching Packages to list

先不管了,

然后,由于是vmare中安装的,去掉virbro0,具体方法见论坛中前面写的帖子:http://bbs.cqsztech.com/forum.ph ... hlight=%CD%F8%C7%C5
,rhel7以后,启用的透明大页,存在性能问题,先关闭,具体方法,见论坛中前面写的帖子:http://bbs.cqsztech.com/forum.ph ... 8%C3%F7%B4%F3%D2%B3

其它操作系统没有管了.

郑全 · 发表于 2018-4-13 20:13:40

看到ipv6不舒服,也暂时不用,禁用掉吧:

[root@dbserver ~]# ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
   valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
   valid_lft forever preferred_lft forever
2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 00:0c:29:73:d3:0a brd ff:ff:ff:ff:ff:ff
inet 192.168.133.125/24 brd 192.168.133.255 scope global noprefixroute ens33
   valid_lft forever preferred_lft forever
inet6 fe80::3281:9854:4a6:2391/64 scope link noprefixroute
   valid_lft forever preferred_lft forever

用文本编辑器打开 /etc/sysctl.conf 然后添加以下内容：

　　# 禁用整个系统所有接口的IPv6
　　net.ipv6.conf.all.disable_ipv6 = 1
在 /etc/sysctl.conf 使这些更改生效，运行以下命令
root@dbserver ~]# sysctl -p
fs.file-max = 6815744
net.ipv6.conf.all.disable_ipv6 = 1

[root@dbserver ~]# ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
   valid_lft forever preferred_lft forever
2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 00:0c:29:73:d3:0a brd ff:ff:ff:ff:ff:ff
inet 192.168.133.125/24 brd 192.168.133.255 scope global noprefixroute ens33
   valid_lft forever preferred_lft forever
[root@dbserver ~]#

发现没有ipv6了.

郑全 · 发表于 2018-4-13 20:03:15

hr数据，默认表空间为sysaux了。

  1* select table_name,tablespace_name from dba_tables where owner='HR'

TABLE_NAME                   TABLESPACE_NAME
------------------------------ ------------------------------
COUNTRIES
REGIONS                      SYSAUX
LOCATIONS                   SYSAUX
DEPARTMENTS                   SYSAUX
JOBS                         SYSAUX
EMPLOYEES                   SYSAUX
JOB_HISTORY                   SYSAUX

SQL> select name from v$tablespace;

NAME
------------------------------
SYSAUX
SYSTEM
UNDOTBS1
USERS
TEMP

SQL>
去掉了以前的example表空间。

郑全 · 发表于 2018-4-13 19:46:58

郑全发表于 2018-4-13 19:42
加上em:

SQL> execute dbms_xdb_config.sethttpport(5501);

无图无真相:

登录/注册后可看大图

郑全 · 发表于 2018-4-13 19:42:25

本帖最后由郑全于 2018-4-13 19:48 编辑

加上em:

SQL> execute dbms_xdb_config.sethttpport(5501);

PL/SQL procedure successfully completed.

SQL> select  dbms_xdb_config.gethttpport() from dual;

DBMS_XDB_CONFIG.GETHTTPPORT()
-----------------------------
                     5501

[oracle@dbserver ~]$ lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 13-APR-2018 19:33:36

Copyright (c) 1991, 2017, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date             13-APR-2018 19:30:05
Uptime                   0 days 0 hr. 3 min. 31 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/oracle/product/18.0/db_1/network/admin/listener.ora
Listener Log File       /u01/app/oracle/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=5501))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "sztech1" has 1 instance(s).
  Instance "sztech1", status READY, has 1 handler(s) for this service...
Service "sztech1XDB" has 1 instance(s).
  Instance "sztech1", status READY, has 1 handler(s) for this service...
The command completed successfully

测试windows进行访问,发现无法访问:

应该是防火墙没有添加端口:
这个可以参见前面的帖子:http://bbs.cqsztech.com/forum.ph ... 17630&highlight=18c

[root@dbserver ~]# firewall-cmd --list-all
public (active)
  target: default
  icmp-block-inversion: no
  interfaces: ens33
  sources:
  services: ssh dhcpv6-client
  ports:
  protocols:
  masquerade: no
  forward-ports:
  source-ports:
  icmp-blocks:
  rich rules:

[root@dbserver ~]# firewall-cmd --permanent --add-port 1521/tcp
success

[root@dbserver ~]# firewall-cmd --permanent --add-port 5501/tcp
success
[root@dbserver ~]# firewall-cmd --reload
success
[root@dbserver ~]# firewall-cmd --list-all
public (active)
  target: default
  icmp-block-inversion: no
  interfaces: ens33
  sources:
  services: ssh dhcpv6-client
ports: 1521/tcp 5501/tcp
  protocols:
  masquerade: no
  forward-ports:
  source-ports:
  icmp-blocks:
  rich rules:

之后,远程可以进行sql连接,以及em的访问.

当然,你也可以简单的把防火墙关闭也行.

郑全 · 发表于 2018-4-13 19:03:26

去掉口令到期时间:
alter profile default LIMIT PASSWORD_LIFE_TIME unlimited;

郑全 · 发表于 2018-4-13 18:55:07

下面显示相关信息:

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

  1* select comp_name,version,status from dba_registry

COMP_NAME                         VERSION                      STATUS
----------------------------------- ------------------------------ --------------------
Oracle Database Catalog Views    18.0.0.0.0                   VALID
Oracle Database Packages and Types  18.0.0.0.0                   VALID
Oracle Real Application Clusters 18.0.0.0.0                   OPTION OFF
JServer JAVA Virtual Machine       18.0.0.0.0                   VALID
Oracle XDK                         18.0.0.0.0                   VALID
Oracle Database Java Packages    18.0.0.0.0                   VALID
OLAP Analytic Workspace          18.0.0.0.0                   VALID
Oracle XML Database                18.0.0.0.0                   VALID
Oracle Workspace Manager          18.0.0.0.0                   VALID
Oracle Text                      18.0.0.0.0                   VALID
Oracle Multimedia                18.0.0.0.0                   VALID

COMP_NAME                         VERSION                      STATUS
----------------------------------- ------------------------------ --------------------
Spatial                            18.0.0.0.0                   VALID
Oracle OLAP API                   18.0.0.0.0                   VALID
Oracle Label Security             18.0.0.0.0                   VALID
Oracle Database Vault             18.0.0.0.0                   VALID

15 rows selected.

郑全 · 发表于 2018-4-13 18:54:26

目前18c只提供了云平台以及exadata的安装介质,在本地linux的安装介质还没有发布,大家都知道,exadata其实就是 x86+linux,因此,使用这个介质,应该也可以在本地安装,介质下载可以参照 edelivery.oracle.com/ 去下载.

使用dbca创建实例.
由于安装介质是exadata的,所以,在创建实例时,默认会报ora-12754的错,具体解决办法,参见我前面写的帖子:http://bbs.cqsztech.com/forum.ph ... 0&highlight=18c
这个时候,我们选择,只创建脚本,不创建实例,
脚本之后创建在$ORACLE_BASE/admin/sztech1/scripts下面
然后,修改三个初始参数,添加 _exadata_feature_on=true
并执行./sztech1.sh
最后创建成功数据库.

...
SQL> startup ;
ORACLE instance started.

Total System Global Area  838856896 bytes
Fixed Size                8663232 bytes
Variable Size          322961408 bytes
Database Buffers       499122176 bytes
Redo Buffers             8110080 bytes
Database mounted.
Database opened.
SQL> spool off
SQL> exit;
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0
[oracle@dbserver scripts]$ ps -ef|grep ora

root    2808    1  0 17:57 ?       00:00:22 /u01/app/oracle/tfa/dbserver/tfa_home/jre/bin/java -server -Xms32m -Xmx64m -Djava.awt.headless=true -Ddisable.checkForUpdate=true oracle.rat.tfa.TFAMain /u01/app/oracle/tfa/dbserver/tfa_home
root    12456  12401  0 18:04 pts/1 00:00:00 su - oracle
oracle 12457  12456  0 18:04 pts/1 00:00:00 -bash
root    14901  11848  0 18:24 pts/0 00:00:00 su - oracle
oracle 14902  14901  0 18:24 pts/0 00:00:00 -bash
oracle 15804    1  0 18:28 ?       00:00:00 /u01/app/oracle/product/18.0/db_1/bin/tnslsnr LISTENER -inherit
oracle 17774    1  0 18:40 ?       00:00:00 /bin/sh ./OSWatcher.sh 30 48 NONE /u01/app/oracle/tfa/repository/suptools/dbserver/oswbb/oracle/archive
oracle 18122  17774  0 18:40 ?       00:00:00 /bin/sh ./OSWatcherFM.sh 48 /u01/app/oracle/tfa/repository/suptools/dbserver/oswbb/oracle/archive
oracle 19791    1  0 18:43 ?       00:00:00 ora_pmon_sztech1
oracle 19793    1  0 18:43 ?       00:00:00 ora_clmn_sztech1
oracle 19795    1  0 18:43 ?       00:00:00 ora_psp0_sztech1
oracle 19797    1  2 18:43 ?       00:00:02 ora_vktm_sztech1
oracle 19801    1  0 18:43 ?       00:00:00 ora_gen0_sztech1
oracle 19803    1  0 18:43 ?       00:00:00 ora_mman_sztech1
oracle 19807    1  0 18:43 ?       00:00:00 ora_gen1_sztech1
oracle 19810    1  0 18:43 ?       00:00:00 ora_diag_sztech1
oracle 19812    1  0 18:43 ?       00:00:00 ora_ofsd_sztech1
oracle 19815    1  0 18:43 ?       00:00:00 ora_dbrm_sztech1
oracle 19817    1  0 18:43 ?       00:00:00 ora_vkrm_sztech1
oracle 19819    1  0 18:43 ?       00:00:00 ora_svcb_sztech1
oracle 19821    1  0 18:43 ?       00:00:00 ora_pman_sztech1
oracle 19823    1  0 18:43 ?       00:00:00 ora_dia0_sztech1
oracle 19825    1  0 18:43 ?       00:00:00 ora_dbw0_sztech1
oracle 19827    1  0 18:43 ?       00:00:00 ora_lgwr_sztech1
oracle 19829    1  0 18:43 ?       00:00:00 ora_ckpt_sztech1
oracle 19831    1  0 18:43 ?       00:00:00 ora_lg00_sztech1
oracle 19833    1  0 18:43 ?       00:00:00 ora_smon_sztech1
oracle 19835    1  0 18:43 ?       00:00:00 ora_lg01_sztech1
oracle 19837    1  0 18:43 ?       00:00:00 ora_smco_sztech1
oracle 19839    1  0 18:43 ?       00:00:00 ora_reco_sztech1
oracle 19841    1  0 18:43 ?       00:00:00 ora_w000_sztech1
oracle 19843    1  0 18:43 ?       00:00:00 ora_lreg_sztech1
oracle 19845    1  0 18:43 ?       00:00:00 ora_w001_sztech1
oracle 19847    1  0 18:43 ?       00:00:00 ora_pxmn_sztech1
oracle 19851    1  2 18:43 ?       00:00:03 ora_mmon_sztech1
oracle 19854    1  0 18:43 ?       00:00:00 ora_mmnl_sztech1
oracle 19856    1  0 18:43 ?       00:00:00 ora_d000_sztech1
oracle 19858    1  0 18:43 ?       00:00:00 ora_s000_sztech1
oracle 19860    1  0 18:43 ?       00:00:00 ora_tmon_sztech1
oracle 19865    1  0 18:43 ?       00:00:00 ora_m000_sztech1
oracle 19867    1  0 18:43 ?       00:00:00 ora_m001_sztech1
oracle 19873    1  0 18:43 ?       00:00:00 ora_tt00_sztech1
oracle 19875    1  0 18:43 ?       00:00:00 ora_tt01_sztech1
oracle 19877    1  0 18:43 ?       00:00:00 ora_tt02_sztech1
oracle 19880    1  0 18:43 ?       00:00:00 ora_aqpc_sztech1
oracle 19882    1  0 18:43 ?       00:00:00 ora_w002_sztech1
oracle 19888    1  0 18:43 ?       00:00:00 ora_p000_sztech1
oracle 19890    1  0 18:43 ?       00:00:00 ora_p001_sztech1
oracle 19892    1  0 18:43 ?       00:00:00 ora_p002_sztech1
oracle 19894    1  0 18:43 ?       00:00:00 ora_cjq0_sztech1
oracle 19896    1  0 18:43 ?       00:00:00 ora_p003_sztech1
oracle 20069    1  0 18:43 ?       00:00:00 ora_w003_sztech1
oracle 20103    1  0 18:43 ?       00:00:00 ora_m002_sztech1
oracle 20105    1  0 18:43 ?       00:00:00 ora_m003_sztech1
oracle 20124    1  0 18:43 ?       00:00:00 ora_w004_sztech1
oracle 20143    1  0 18:43 ?       00:00:00 ora_qm02_sztech1
oracle 20147    1  0 18:43 ?       00:00:00 ora_q002_sztech1
oracle 20149    1  0 18:43 ?       00:00:00 ora_q003_sztech1
oracle 20302  18122  0 18:44 ?       00:00:00 sleep 60
oracle 20520  17774  0 18:44 ?       00:00:00 sleep 30
oracle 20731  12457  0 18:45 pts/1 00:00:00 ps -ef
oracle 20732  12457  0 18:45 pts/1 00:00:00 grep --color=auto ora
[oracle@dbserver scripts]$ ps -ef|grep ora|wc -l
63
[oracle@dbserver scripts]$ lsnrctl

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 13-APR-2018 18:45:55

Copyright (c) 1991, 2017, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date             13-APR-2018 18:28:39
Uptime                   0 days 0 hr. 17 min. 16 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/oracle/product/18.0/db_1/network/admin/listener.ora
Listener Log File       /u01/app/oracle/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "sztech1" has 1 instance(s).
  Instance "sztech1", status READY, has 1 handler(s) for this service...
Service "sztech1XDB" has 1 instance(s).
  Instance "sztech1", status READY, has 1 handler(s) for this service...
The command completed successfully

至此,在rhel7.5 上的18c 安装成功.

郑全 · 发表于 2018-4-13 18:39:29

在上面的安装中,选择只安装软件.

下面进行数据库的创建.

郑全 · 发表于 2018-4-13 18:34:29

本帖最后由郑全于 2018-4-13 19:11 编辑

接下来进行数据库的安装.
1.建立组和用户
  这个和以前没有区别吧
  groupadd oinstall
  groupadd dba
  useradd -g oinstall -G dba oracle

2.建立目录
  mkdir -p /u01/app/oracle/product/18.0/db_1
  chown -R /u01
  chmod -R 775 /u01

3.解压安装目录
  18c的安装介质是一个image,就是安装好的介质.解出来就可以用.
  $ cd /u01/app/oracle/product/18.0/db_1
  $ unzip -q /tmp/db_home.zip
4.运行.runInstaller即可.
  ./runInstaller
  选择单机即可.
  当然,18c,也提供了rpm包方式安装,我这里没有去测试.

  这里的操作系统软件包安装,和12c 版本一样,使用yum直接安装即可.
  Operating System Resource Parameter ,使用 fixed 按钮即可解决,可以不用事先设置.

注意:
1.有一个软件包: compat-libstdc++-33-3.2.3(x86_64) 在rhel7以上的版本上不存在了,可以不用管它,这个见前面发过的贴子:http://bbs.cqsztech.com/forum.ph ... hlight=compat-libst

2.另外,18c要求最低内存8g,主要是要安装cdb,我这里不安装这些,2g内存也可以.

帐号		自动登录	找回密码
密码			注册

[安装] 史上最新的rhel7.5+oracle 18c安装成功