Recommended Port Numbers

Oracle Corporations recommends the following port numbers for TCP/IP and TCP/IP with SSL protocol addresses:

Port	Description
1521	Default listening port for client connections to the listener. In future releases, this port number may change to the officially registered port number of 2483 for TCP/IP and 2484 for TCP/IP with SSL.
1575	Default and officially registered listening port for client connections to an Oracle Names server.
1630	Default and officially registered listening port for client connections to Oracle Connection Manager.
1830	Default and officially registered listening port for administrative commands to Oracle Connection Manager.

For more information, see Appendix C, Integrating Authentication Devices Using RADIUS, in the Oracle Advanced Security Administrator's Guide

Related Topics

Oracle Advanced Security: Other Params

Oracle Net Services Overview

Copyright � 1996, 2009, Oracle. All rights reserved.

Rejected

Do not turn on the security service even if the other side wants it.

My side of the connection specifies that the security service is not allowed. If the other side specifies required, the connection will terminate with error message ORA-12650. If the other side is set to requested, accepted, or rejected, the connection will continue without error and without the security service enabled.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Service Identification

This property sheet enables you to view or modify the network information for a selected net service name or database service.

Service Identification

Use the Service Identification box to view or modify CONNECT_DATA information.

Element	Description
Service Name	Enter a service name if configuring this client to connect to an Oracle8 i or later database service. Note: For a database service stored in a directory server, this field only displays the current value. Modifications are not permitted.
SID	Displays the Oracle System Identifier (SID) for an Oracle8 database.
Connect Type	From the list, select if you want this net service name to use a dedicated server, shared server, or whatever the database has been configured with. If shared server is configured in the initialization parameter file, then select Dedicated Server to force the listener to start a dedicated server to bypass shared server configuration. If shared server is configured in the initialization parameter file and you want to guarantee that this connection always uses a shared server, then select Shared Server. If Database Resident Connection Pooling is enabled on the server, you can select Pooled Server to get a connection from the pool.
Use Oracle8 Release 8.0 Compatible Identification	Select this option if you are configuring a client to connect to a pre-release Oracle8i database service. Clear this option if you are configuring for an Oracle9i or Oracle8i database service.
Advanced	Choose to configure advanced CONNECT_DATA parameters.

Address Configuration

Use the Address box to modify, add, or delete a listener protocol address .

If an address is already configured, then its protocol information displays in the fields.

Element	Description
Protocol	From the list, select the protocol for the listener address. Depending on the protocol chosen, enter information in the fields as appropriate.
Show Advanced/Hide Advanced button	Use the Show Advanced/Hide Advanced toggle to display or hide settings for specifying the I/O buffer space limit for the address. These settings are supported by the TCP/IP, TCP/IP with SSL, and SDP protocols. Total Send Buffer Size:Specify, in bytes, the buffer space for send operations of sessions. Total Receive Buffer Size: Specify, in bytes, the buffer space for receive operations of sessions. Note: Specifying these settings overrides these settings in a clientside sqlnet.ora file.
+ button	Choose to create a new protocol address. A new Address tab displays from which you can select the protocol and enter protocol information in the fields. The chosen protocol must be installed on both the client and server (where the listener resides).
X button	Choose to remove the selected Address tab and its address information.
< button	Choose to move the protocol address up in the list order.
> button	Choose to move the protocol address down in the list order.
Advanced button	Choose to configure multiple addresses options, such as connect-time failover and client load balancing.

Apply button

Choose to apply the settings.

Revert button

Choose to reset the settings to their original values.

For more information about configuring I/O buffer space, see Chapter 14, Optimizing Performance, in the Oracle10i Net Administrator's Guide.

Related Topics

Create Network Route Information for a Database Service

Create Additional Protocol Addresses

Configure Multiple Address Options

Configure Advanced Connect Data Options

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Listener Overview

Services coordinate their sessions with the help of a listener, a process on the server that receives connection requests on behalf of a client application. Listeners are configured to "listen on" protocol addresses for a database service or non-database service.

Protocol addresses are configured in the listener configuration file, listener.ora, for a database service or a non-database service. An Oracle9i or Oracle8i database service automatically registers its information with the listener, such as its service names, instance names, and load information. This feature, called service registration, does not require service configuration in the listener.ora file. Other services, including Oracle8 and Oracle7 database services, and the Oracle Enterprise Manager management tools, require service configuration in the listener.ora file.

Once the listener is configured, the listener may be managed with the Listener Control utility.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Listener Configuration Overview

Configuration During Installation

During a an Enterprise Edition or Standard Edition installation on the database server, Oracle Net Configuration Assistant configures a listener called LISTENER that has a TCP/IP listening protocol address for the Oracle database. During a Custom installation, Oracle Net Configuration Assistant prompts you to configure a listener name and a protocol address of your choice.

Additionally, a listening IPC protocol address for external procedure calls is automatically configured, regardless of the installation type.

Oracle Net Configuration Assistant also automatically configures service information for the external procedures in the listener.ora file.

Configuration with Oracle Net Manager

Oracle Net Manager enables you to:

• Create a listener

• Configure service information for Oracle8 or previous databases

• Configure service information non-Oracle database services, including external procedures and Heterogeneous Services

• Enable tracing and logging features

• Enable password authentication for the Listener Control utility

To access listener configuration:

From the navigator pane, expand Oracle Net Configuration > Local > Listeners.

For more information, see Chapter 10, Configuring and Administering the Listener, in the Oracle10i Net Administrator's Guide.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

NTS

The Windows NT native authentication method does not require additional parameters.

For more information, see Windows NT documentation.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Database Resident Connection Pooling

Database Resident Connection Pooling provides for the pooling of "Dedicated" connections across client applications or processes. A dedicated connection refers to a dedicated server along with its database session. Use Database Resident Connection Pooling when multiple client applications (like mid-tiers) need to maintain persistent connections to the database, or when server resources (such as memory) need to be optimized.

In Database Resident Connection Pooling, clients are connected to a background process called the Connection Broker that provides the pooling functionality.

Contrast with dedicated server and shared server.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Creating Net Service Alias dialog box

The Create Net Service Alias dialog box enables you to create net service aliases in a directory server.

A net service alias is an alternative name for a net service name or database service. A net service alias entry does not have connect descriptor information. Instead, it only references the location of the object for which it is an alias. When a client requests a directory lookup of a net service alias, the directory determines that the entry is a net service alias and completes the lookup as if it is the referenced entry. For example, a net service alias of db1alias can be created for a database service of db1. When db1alias is used to connect to a database service, as in CONNECT scott/tiger@db1alias , it will actually resolve to and use the connect descriptor information for db1 .

There are two main uses of net service aliases:

• Use a net service alias as a way for clients to refer to a database service or net service name by another name.

• Use a net service alias in one Oracle Context for a database service or net service name in a different Oracle Context. This enables a database service or net service name to be defined once in the directory server, but referred to by clients that use other Oracle Contexts.

Net Service Alias

Enter the name of the net service alias.

Net Service Name or Database Service

Use the Net Service Name or Database Service box to enter information about the database service or net service name:

Oracle Context: Specify the Oracle Context of the database service or net service name by selecting one from the list or entering one in the field.

Name: Specify the distinguished name (DN) of the database service or net service name by selecting one from the list or entering one in the field.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

easy connect naming

A naming method that enables clients to connect to a database server without any configuration. Clients use a simple TCP/IP address, consisting of a host name and optional port and service name:

CONNECT username/password@host[:port][/service_name]

For information about using the easy connect naming method, see Chapter 8, Configuring Naming Methods, in the Oracle10i Net Services Administrator's Guide.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Net Service Alias Details

This property sheet enables you to view the details of the selected net service alias.

Net Service Alias

View or modify the name of the net service alias.

Net Service Name or Database Service

View or modify the following information for the database service or net service name:

• Oracle Context: View or modify the Oracle Context of the database service or net service name.
• Name: View or modify the distinguished name (DN) of the database service or net service name.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.