oracle ohs是什么,怎么更改OHS端口为80

一般在实施项目时,客户都希望域名和地址简单明了。但是OHS为了安全起见是不允许使用端口号小于1024,小于1024端口号是属于root,常见的OHS都是有自己的安装用户(Oracle)。因此如果想要使用小于1024的端口,需要修改.apachectl的控制权。

步骤:

1.关闭OHS

2.重新设置监听端口

3.改变 . apachectl的权限

4.重启OHS

关闭OHS

代码如下

# assuming your MW_HOME is /u00/app/oracle/product/fmw-11.1.1

export MW_HOME=/u00/app/oracle/product/fmw-11.1.1

cd $MW_HOME/Oracle_WT1/instances/instance1/bin

./opmnctl stopall

重新设置监听端口,在这里我们设置为80

代码如下

# assuming you are still connected as oracle user to your sevrer

cd $MW_HOME/Oracle_WT1/instances/instance1/config/OHS/ohs1

cp httpd.conf httpd.conf.save

vi httpd.conf

# Now go to the line with Listen <portnumber> (normally 777x)

# and replace the port number to port 80

Listen 80

# save the changes

修改权限

代码如下

# assuming you are connected to the server as root user

# use the MW_HOME from step 1

cd $MW_HOME/Oracle_WT1/ohs/bin

# be aware, we have to modify the hidden file .apachectl (the dot is correct)

ls -la .apachectl

-rwxr-x--- 1 oracle oinstall 13278 Dec 17 03:54 .apachectl

chown root .apachectl

chmod 6750 .apachectl

ls -la .apachectl

-rwsr-s--- 1 root oinstall 13278 Dec 17 03:54 .apachectl

注意:在Linux以”.”开头的文件默认为隐藏。

最后重启OHS

代码如下

cd $MW_HOME/Oracle_WT1/instances/instance1/bin

./opmnctl startall

# Then check the status with the option -l

# to see if your Oracle HTTP Server is up and

# the option -l display the used ports (see picture below)

./opmnctl status –l

  • 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、付费专栏及课程。

余额充值