Analyze the default port number modified by Oracle

The following articles mainly involve the change of the default port number in Oracle, including the security of the Oracle database and the related steps for modifying the port number. The following describes the specific content, I hope you will gain some benefits after browsing the following content.

Oracle Database Security consists of two parts:

1. OS Security

2. Network Security

3. Security of Oracle software

OS security depends on the technical level of the corresponding operating system and administrator. Here we only talk about Oracle Security.

The security of Oracle software I know includes:

1. Change the default listening port number of Oracle

2. Add a password to the listener

3. Oracle control ip connection

We will test and learn about these three aspects.

Oracle default listening port Oracle Change

1. Change the default listening port number of Oracle

Steps for modifying the port number

1.1. View the status of the current listener

1.2. Stop listening

1.3. Modify the port number of the listener File

1.4. Modify the initialization parameter local_listener

1.5. Restart the listener

1.6. Modified. Use the new port to log on to the test.

Practice steps:

1.1. View the status of the current listener

 
 

  
  
Documents and Settings \ skate_db> lsnrctl status
  
  
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on-2008
  
  
1: 19
  
  
Copyright (c) 1991,200 5, Oracle. All rights reserved.
 
 

Connecting

 
 

  
  
(DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 )))
  
  
LISTENER STATUS
 
 

Alias LISTENER

Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0-Produ

Ction

Start Date:-2008 11:47:59

Normal operation time 0 days 0 hours 23 minutes 19 seconds

Tracking level off

Security ON: Password or Local OS Authentication

SNMP OFF

Listener parameter file

 
 

  
  
Oracle\product\10.2.0\db_3\network\admin\listener.o  
  
  
ra  
 
 

Listener Log File

 
 

  
  
\Oracle\product\10.2.0\db_3\network\log\listener.log 
 
 

Listener endpoint overview...

 
 

  
  
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))  
  
  
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=skate)(PORT=1522)))  
 
 

Service summary ..

The Service "PLSExtProc" contains one routine.

Routine "PLSExtProc", status UNKNOWN, contains one handler of this service...

The Service "orcl" contains one routine.

Routine "orcl", status READY, contains 1 handler of this service...

The Service "orclXDB" contains one routine.

Routine "orcl", status READY, contains 1 handler of this service...

The Service "orcl_XPT" contains one routine.

Routine "orcl", status READY, contains 1 handler of this service...

Command executed successfully

1.2. Stop listening

 
 

  
  
\ Documents and Settings \ skate_db> lsnrctl stop
  
  
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on-2008 13
  
  
6: 15
 
 

Copyright (c) 1991,200 5, Oracle Change. All rights reserved.

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 )))

Command executed successfully