15
Connecting to an Oracle Database in DCE

This chapter explains how to connect to an Oracle database after having installed Oracle DCE Integration and having configured both DCE and Oracle to use Oracle DCE Integration.

This chapter covers the following topics:

• Starting the Listener

• Connecting to an Oracle Database Server in the DCE Environment

Starting the Listener

Perform the following steps to start the listener.

1. Enter the following commands:

   % dce_login principal_name password 
   %  lsnrctl start listener_name
   
   

   For example, if the listener name is LSNR_DCE in the listener.ora file, enter the following to start the listener:

   % dce_login oracle orapwd
   % lsnrctl start LSNR_DCE
   
   

2. Verify that the server has registered its binding handler with rpcd as follows:

   % rpccp show mapping
   
   

   Look for the line that includes the dce_service_name that is part of the listener address.

3. Verify that the service has been created by searching for the dce_service_name as follows:

   % cdscp show object "/.:/subsys/oracle/service_registry/dce_service_name"
   
   

   For example, enter the following:

   % cdscp show object "/.:/subsys/oracle/service_registry/dce_svc"
   
   

   This shows you the mapping in the CDS namespace that the listener has chosen for the endpoint. For example:

               SHOW
             OBJECT    /.../subsys/oracle/service_registry/dce_svc
                 AT   1995-05-15-17:10:52
   RPC_ClassVersion = 0100
            CDS_CTS = 1995-05-16-00:05:01.221106100/aa-00-04-00-3e-8c           
            CDS_UTS = 1995-05-16-00:05:01.443343100/aa-00-04-00-3e-8c 		  
          CDS_Class = RPC_Server
   CDS_ClassVersion = 1.0
         CDS_Towers = :
              Tower = ncacn_ip_tcp:144.25.23.57[]
   
   

Connecting to an Oracle Database Server in the DCE Environment

Connect to an Oracle server in the DCE environment using one of the following methods.

Method 1

After externally-identified accounts have been set up, you can take advantage of DCE authentication to log into Oracle without providing any user name/password information. To use this single sign-on capability, just log in to DCE using a command like the following:

% dce_login principal_name password

For example:

% dce_login oracle orapwd

Note: You only need to enter the dce_login command once. If you are already logged into DCE, you do not need to log in again.

You can now connect to an Oracle server without using a user name or password. Enter a command like the following:

% sqlplus /@net_service_name

where net_service_name is the database service name.

For example:

% sqlplus /@ORADCE

More Information: See Oracle8i Distributed Database Systems.

.

Method 2

From a client, you can still connect with a user name/password:

% sqlplus username/password@net_service_name

where net_service_name is the Net8 net service name.

For example:

% sqlplus scott/tiger@ORADCE