去除oracle9i占用8080端口的一个方法

起源于装oracle9i的一台机器上还需要起个8080端口的tomcat，冲突可以用下面的方法解决。

修改结果就是oracle9i不再使用8080端口了。相应的http服务也被停止。

修改8080端口的一个方法

1。导出目前数据库参数为文本文件

[oracle@web ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.6.0 - Production on Tue Sep 6 21:59:31 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> create pfile='/oracle/1234.ora' from spfile;

File created.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

2。 编辑导出的1234.ora文件，删除 *.dispatchers="(PROTOCOL=TCP) (SERVICE=colorokXDB)" 保存退出

[oracle@web ~]$ vi /oracle/1234.ora

*.dispatchers='(PROTOCOL=TCP) (SERVICE=colorokXDB)'
*.aq_tm_processes=1
*.background_dump_dest='/oracle/admin/www/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/oracle/oradata/www/control01.ctl','/oracle/oradata/www/control02.ctl','/oracle/oradata/www/control03.ctl'
*.core_dump_dest='/oracle/admin/www/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain='colorme.com.cn'
*.db_file_multiblock_read_count=16
*.db_name='www'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='colorok'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/admin/www/udump'
~
~
~
~
~
~
~
~
~
~
"1234.ora" 29L, 918C ò?D′è?    

3。用修改后的1234.ora 启动数据库                                                            
[oracle@web ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.6.0 - Production on Tue Sep 6 22:01:37 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='/oracle/1234.ora'
ORACLE instance started.

Total System Global Area  236000476 bytes
Fixed Size                   451804 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.

4。用新的pfile创建spfile

SQL> create spfile from pfile='/oracle/1234.ora';

File created.

SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.

5。重新启动数据库使新的spfile生效
SQL> startup
ORACLE instance started.

Total System Global Area  236000476 bytes
Fixed Size                   451804 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.

6。验证结果
SQL> show parameter dispatchers;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string
max_dispatchers                      integer     5
mts_dispatchers                      string
mts_max_dispatchers                  integer     5

7。查看以前的8080端口是否还在监听

[oracle@web ~]$ lsnrctl stop

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 06-SEP-2005 22:22:21

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
The command completed successfully
[oracle@web ~]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 06-SEP-2005 22:22:24

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Starting /oracle/product/9.2.0.6/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.6.0 - Production
Log messages written to /oracle/product/9.2.0.6/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=web)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.6.0 - Production
Start Date                06-SEP-2005 22:22:24
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Log File         /oracle/product/9.2.0.6/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=web)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@web ~]$ netstat -ln | grep 8080
已经看不到8080端口了，说明修改过程成功结束。