Alias LISTENER
Version TNSLSNR for Solaris: Version 8.1.7.0.0 - Production Start Date 12-JAN-2001 16:37:15
Uptime 0 days 0 hr. 0 min. 0 sec Trace Level admin
Security OFF SNMP OFF Listener Parameter File
/ultra1/app/ora817/product/8.1.7/network/admin/listener.ora Listener Log File
/ultra1/app/ora817/product/8.1.7/network/log/listener.log Listener Trace File
/ultra1/app/ora817/product/8.1.7/network/trace/listener.trc Services Summary...
ora817 has 1 service handler(s) The command completed successfully
Net8 Client installation and configuration
To make a direct connection to an Oracle instance, Oracle Client must be installed on your client machine. Oracle Client is shipped with the Oracle Enterprise Edition. Oracle Client includes the installation of the Oracle Net8 software, which is necessary to connect to an Oracle server.
After you start the Oracle Universal installer and complete the preliminary panels, choose the Oracle Client radio button from the Available Products panel and click Next.
From the ‘Installation Types’ panel select the Custom radio button and click Next.
From the ‘Available Product Components, Oracle 8i Client’ panel you need to check at least the Net8 Products and Net8 Client boxes to enable a direction connection to an Oracle instance. Click Next to proceed to the Installation Summary panel and click Next again to install the Net8 products of the Oracle Client. Immediately following the installation of the software, the Net8 Configuration Manager appears, which allows you to configure the net service name needed to connect to a remote Oracle database.
When the ‘Net8 Configuration Assistant Welcome’ panel appears, check ‘Perform typical configuration’ and click Next to add the net service name. Alternatively, you can click Cancel to defer the configuration of the net service name. Clicking Cancel returns control to the Oracle Universal Installer installation summary panel.
On Windows NT you can launch the Net 8 Configuration Assistant by clicking
Programs>Oracle> OraHOME>Net8 Configuration Assistant. On UNIX systems you can launch the Net8 Configuration Assistant by running $ORACLE_HOME/bin/netca.
On the ‘Net8 Configuration Assistant Welcome’ panel that follows, click the ‘No, I will create net service names myself. I would like to create the first one now.’ radio button.
From the ‘Net8 Configuration Assistant: Welcome’ panel, choose the ‘Local Net Service Name configuration’ radio button and click Next to proceed to the 'Net Service Name Configuration, Database Version' panel.
Choose the ‘Oracle database or service’ radio button. Click Next and continue to the ‘Net Service Name Configuration, Service Name’ panel.
Although the service name can be anything you want it to be, for some Oracle applications such as Advance Replication it is required to be the global database name. By convention, you should use the global database name as it is easier to keep track of. The global database name is formed by concatenating the DB_NAME (database name) and the DB_DOMAIN (database domain) together and separating them by a period. In this example the database name, bruno, and the database domain, esri.com, concatenate to form the global database name bruno.esri.com. Click Next to continue to the Net Service Name Configuration, Select Protocols panel.
In the previous section we created a listener that listens on the TCP/IP protocol. Select the TCP protocol and click Next to proceed to the ‘Net Service Name Configuration, TCP/IP Protocol’ panel.
Enter the host name of the computer that the database is running on. The host name should be listed in your NIS hosts file. You can also enter the computer’s IP address, although you should set up and use the host name since it is easier to recognize. Choose the ‘Use the standard port number of 1521.’ radio button unless you were forced to use a different port number when you configured the listener. Click Next to continue to the Net Service Name Configuration, Test.
You should test the connection of the service name that you have just created. You can return later to test the connection, but if you are ready to test it now, choose the ‘Yes, perform a test’
radio button and click Next. The ‘Net Service Name Configuration, Connecting’ panel will appear with the results of the connection test. If the Details dialog box does not contain
‘Connecting…Test successful.’, there is a problem with the connection. The first thing to look at is the username and password used to make the connection. By default, the Net8 Configuration Assistant defaults to scott as the username and tiger as the password. If necessary, click Change Login to use a different username and password. When you click OK on the 'Change Login' panel, Net8 Configuration Assistant will attempt the connection again. If you are still unable to connect to the listener, contact Oracle Technical Support for help.
Following a successful connect test, click Next to proceed to the 'Net Service Name Configuration Done' panel. Click Next on this panel to return to the 'Welcome' panel. Click Finish. The tnsnames.ora file has been updated and can now be referenced by an Oracle client software product to make a connection to an Oracle database.
The entry made to the tnsnames.ora file by the Net* Configuration Assistant should look something like this:
BRUNO.ESRI.COM = ( DESCRIPTION = ( ADDRESS_LIST =
( ADDRESS = ( PROTOCOL = TCP )( HOST = bruno )(PORT = 1521 )) )
( CONNECT_DATA =
( SERVICE_NAME = bruno.esri.com ) )
)