Tutorial: Oracle 11g OCP path (3): Network Configuration

Oracle status before Network Configuration

1. Information in the Registry

ORACLE_BASE: ORACLE_HOME:

2. Oracle-related service information

Modified Configuration

3. Text path of Network Configuration

4. sqlnet. ora content

# This file is actually generated by netca. But if MERs choose
# Install "Software Only", this file wont exist and without the native
# Authentication, they will not be able to connect to the database on NT.

SQLNET. AUTHENTICATION_SERVICES = (CNT)Configure listeners

Click Net Manager to open the configuration Network.

Follow the instructions on the image.

Let's configure the listening service.

Configure the listening location

Configure Database

Don't tell me where you can't find the file? Let's take a look at this directory, and there is an extra file.

File Content

# Listener. ora Network Configuration File: F: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ listener. ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = F: \ Oracle \ product \ 11.2.0 \ dbhome_1)
(SID_NAME = TEID)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = PC201304011949) (PORT = 1521 ))
)

ADR_BASE_LISTENER = F: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ log

It is not hard to understand, that is, what we just configured. Run the following command on the console:

Let's look at the service.

Configuration Service name

Configure the network service name

Select Protocol

Configure Host Name

Configure service name

Test

Click Save. Let's look at a directory again.

Another file, you guess. The content is as follows:

# Tnsnames. ora Network Configuration File: F: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ tnsnames. ora
# Generated by Oracle configuration tools.

GP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = PC201304011949) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)

Let's look back.

What is the first file corresponding? You should have guessed it. Now, this article is over. In the next article, I would like to thank common Oracle tools. Enable EM by the way.