从端口8080更改Oracle端口

How do I change Oracle from port 8080? My Eclipse is using 8080, so I can't use that.

如何从端口8080更改Oracle?我的Eclipse使用8080,所以我无法使用它。

7 个解决方案

#1

226

From Start | Run open a command window. Assuming your environmental variables are set correctly start with the following:

从开始|运行打开命令窗口。假设您的环境变量设置正确,请从以下开始:

C:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 26 10:40:44 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect
Enter user-name: system
Enter password: <enter password if will not be visible>
Connected.

SQL> Exec DBMS_XDB.SETHTTPPORT(3010); [Assuming you want to have HTTP going to this port]    
PL/SQL procedure successfully completed.

SQL>quit

then open browser and use 3010 port.

然后打开浏览器并使用3010端口。

#2

From this blog post:

来自这篇博文:

XE: Changing the default http port

XE:更改默认的http端口

Oracle XE uses the embedded http listener that comes with the XML DB (XDB) to serve http requests. The default port for HTTP access is 8080.

Oracle XE使用XML DB(XDB)附带的嵌入式http侦听器来提供http请求。 HTTP访问的默认端口是8080。

EDIT:

Update 8080 port to which port(9090 for example) you like

将8080端口更新到您喜欢的端口(例如9090)

SQL> -- set http port
SQL> begin
 2    dbms_xdb.sethttpport('9090');
 3  end;
 4  /

After changing the port, when we start Oracle it will go on port 8080, we should type manually new port(9090) in the address bar to run Oracle XE.

更改端口后,当我们启动Oracle时,它将进入端口8080,我们应该在地址栏中手动键入新端口(9090)以运行Oracle XE。

#3

Execute Exec DBMS_XDB.SETHTTPPORT(8181); as SYS/SYSTEM. Replace 8181 with the port you'd like changing to. Tested this with Oracle 10g.

执行Exec DBMS_XDB.SETHTTPPORT(8181);作为SYS / SYSTEM。将8181替换为您要更改的端口。使用Oracle 10g进行了测试。

Source : http://hodentekhelp.blogspot.com/2008/08/my-oracle-10g-xe-is-on-port-8080-can-i.html

资料来源:http://hodentekhelp.blogspot.com/2008/08/my-oracle-10g-xe-is-on-port-8080-can-i.html

#4

Just open Run SQL Command Line and login as sysadmin and then enter below command

只需打开Run SQL Command Line并以sysadmin身份登录,然后输入以下命令

Exec DBMS_XDB.SETHTTPPORT(8181);

That's it. You are done.....

而已。你完成了......

#5

I assume you're talking about the Apache server that Oracle installs. Look for the file httpd.conf.

我假设你在谈论Oracle安装的Apache服务器。查找httpd.conf文件。

Open this file in a text editor and look for the line
Listen 8080
or
Listen {ip address}:8080

在文本编辑器中打开此文件,然后查找Listen 8080或Listen {ip address}:8080行

Change the port number and either restart the web server or just reboot the machine.

更改端口号,然后重新启动Web服务器或重新启动计算机。

#6

Oracle (database) can use many ports. when you install the software it scans for free ports and decides which port to use then.

Oracle(数据库)可以使用许多端口。当您安装软件时,它会扫描空闲端口并决定使用哪个端口。

The database listener defaults to 1520 but will use 1521 or 1522 if 1520 is not available. This can be adjusted in the listener.ora files.

数据库侦听器默认为1520,但如果1520不可用,则将使用1521或1522。这可以在listener.ora文件中进行调整。

The Enterprise Manager, web-based database administration tool defaults to port 80 but will use 8080 if 80 is not available.

企业管理器,基于Web的数据库管理工具默认为端口80,但如果80不可用则将使用8080。

See here for details on how to change the port number for enterprise manager: http://download-uk.oracle.com/docs/cd/B14099_19/integrate.1012/b19370/manage_oem.htm#i1012853

有关如何更改企业管理器端口号的详细信息,请参阅此处:http://download-uk.oracle.com/docs/cd/B14099_19/integrate.1012/b19370/manage_oem.htm#i1012853

#7

There are many Oracle components that run a web service, so it's not clear which you are referring to.

有许多Oracle组件运行Web服务,因此不清楚您指的是哪个。

For example, the web site port for standalone OC4J is configured in the j2ee/home/config/default-web-site.xml file:

例如,独立OC4J的网站端口在j2ee / home / config / default-web-site.xml文件中配置:

<web-site xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/web-site-10_0.xsd"
port="8888" display-name="OC4J 10g (10.1.3) Default Web Site"
schema-major-version="10" schema-minor-version="0" >

#1

226