oracle ohs是什么,oracle ohs修改https端口

oracle ohs默认是开启https服务,证书使用自签名证书,端口是4443不是https默认的443。关于如何导入第三方证书前面的文章已经介绍过了,详细步骤参考oracle ohs导入第三方ssl证书下面介绍如何将ohs的https服务端口修改为https默认的443端口,使用默认端口在浏览器访问的时候就不用在地址栏中指定端口号。

写在前面

假设你的ohs安装在/u01/app/Oracle/Middleware/Oracle_WT1目录下,下文变量$OHS_HOME表示你ohs的安装目录也就是/u01/app/Oracle/Middleware/Oracle_WT1

步骤

修改$OHS_HOME/instances/instance1/config/OHS/ohs1/ssl.conf文件

# OHS Listen Port

Listen 4443

修改为

# OHS Listen Port

Listen 443

##

## SSL Virtual Host Context

##

修改为

## SSL Virtual Host Context

##

保存退出.

重启ohs服务器

cd $OHS_HOME/instances/instance1/bin/

./opmnctl stopall

./opmnctl startall

如果此时不是root用户启动,将启动失败,错误信息:

[2017-06-15T10:08:32.9826+08:00] [OHS] [INCIDENT_ERROR:32] [OHS-9999] [worker.c] [host_id: api.smec-cn.com] [host_addr: 10.1.30.64] [pid: 22180] [tid: 47858836813968] [user: oracle] [VirtualHost: main] (13)Permission denied: make_sock: could not bind to address [::]:443

这是由于linux限制非root用户无法使用1024以下端口

切换到root用户

cd $OHS_HOME/ohs/bin

ll -a

该目录下有两个文件

-rwxr-x--- 1 oracle oinstall 12105 Nov 19 2011 apachectl

-rwxr-x--- 1 oracle oinstall 13278 Nov 19 2011 .apachectl

.apachectl是隐藏文件需要 ll -a才能看到

对这两个文件对权限做些修改(修改前最好做好备份)

[root@api bin]# chown root apachectl

[root@api bin]# chown root .apachectl

[root@api bin]# chmod 6750 apachectl

[root@api bin]# chmod 6750 .apachectl

修改后文件权限如下

-rwsr-s--- 1 root oinstall 12105 Nov 19 2011 apachectl

-rwsr-s--- 1 root oinstall 13278 Nov 19 2011 .apachectl

使用root重启服务器

cd $OHS_HOME/instances/instance1/bin/

./opmnctl stopall

./opmnctl startall

查看ohs状态

[root@api bin]# ./opmnctl status -l

baa6957dc500

image.png

4.访问https://host测试https是否正常

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
为什么下面的sql语句会输出重复的结果:SELECT tp.parent_production_orders AS parent_production_orders, tp.production_orders AS production_orders, tp.work_order AS work_order, tp.contract AS contract, tp.sbbh AS sbbh, tp.batch_num AS batch_num, tp.product_code AS product_code, tp.product_number AS product_number, tp.product_name AS product_name, to_char( middle.create_date, 'yyyy-mm-dd' ) AS issued_date, to_char( to_timestamp( tp.delivery_time / 1000 ), 'yyyy-mm-dd' ) AS delivery_time, middle.line_code AS work_area_code, middle.line_name AS work_area_name, tp.workorder_number AS workorder_number, tp.complete_number AS complete_number, tp.part_unit AS part_unit, middle.work_time_type AS work_time_type, middle.process_time AS process_time, CASE WHEN sc.totalSubmitHours IS NULL THEN 0 ELSE sc.totalSubmitHours END AS submit_work_hours, CASE WHEN middle.process_time > 0 AND sc.totalSubmitHours IS NOT NULL THEN round( ( sc.totalSubmitHours / middle.process_time ), 2 ) * 100 ELSE 0 END plan_achievement_rate, CASE WHEN sc.totalSubmitHours IS NULL THEN 0 ELSE round( CAST ( sc.totalSubmitHours AS NUMERIC ) / CAST ( 60 AS NUMERIC ), 1 ) END AS submit_work_hours_h, round( CAST ( middle.process_time AS NUMERIC ) / CAST ( 60 AS NUMERIC ), 1 ) AS process_time_h, pinfo.material_channel AS material_channel FROM hm_model_work_order_report_middle middle LEFT JOIN hm_model_trc_plan tp ON middle.work_order = tp.work_order LEFT JOIN ( SELECT oro.work_order AS orderNo, oro.work_area_code AS lineCode, SUM ( submit_work_hours ) AS totalSubmitHours, '自制' AS workHourType FROM hm_model_trc_order_report_operation_u orou LEFT JOIN hm_model_trc_order_report_operation oro ON orou.work_order_process_id = oro.ID WHERE orou.work_order_process_id IS NOT NULL AND oro.work_area_code IS NOT NULL GROUP BY oro.work_order, oro.work_area_code UNION all SELECT ohs.work_order_no AS orderNo, ohs.line_code AS lineCode, SUM ( receiving_hour ) AS totalSubmitHours, '外委' AS workHourType FROM hm_model_outsourcing_hour_statistics ohs GROUP BY ohs.work_order_no, ohs.line_code ) sc ON middle.work_order = sc.orderNo AND middle.line_code = sc.lineCode AND middle.work_time_type = sc.workHourType LEFT JOIN hm_model_part_info AS pinfo ON tp.product_number = pinfo.part_code WHERE middle.process_time > 0 AND tp.delivery_time IS NOT NULL AND tp.production_orders LIKE'FJ2023051100286' ORDER BY to_char( to_timestamp( tp.delivery_time / 1000 ), 'yyyy-mm-dd' ) DESC, tp.parent_production_orders DESC, tp.node_level ASC
最新发布
06-06

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值